MySQL – Connection Error – [MySQL][ODBC 5.3(w) Driver]Host ‘IP’ is Not Allowed to Connect to this MySQL Server

One of my clients contacted me for a linked server issue between SQL Server and MySQL Server. Since I mostly work with SQL Server, it was a fun installing and Continue ReadingMySQL – Connection Error – [MySQL][ODBC 5.3(w) Driver]Host ‘IP’ is Not Allowed to Connect to this MySQL Server

Which is Better for Performance – SELECT or SET? – Interview Question of the Week #166

Question: Which is Better for Performance – SELECT or SET? Answer: Some questions never get old. This is one of such question. Remember that SELECT is designed to return data whereas SET is designed to Continue ReadingWhich is Better for Performance – SELECT or SET? – Interview Question of the Week #166

QL SERVER – Unable to Create Listener: Msg 41009 – The Windows Server Failover Clustering (WSFC) Resource Control API Returned Error Code 5057

One of my clients contacted me for quick On-Demand consulting. They were working under close deadlines and delivering the solution on time was critical for their success. They contacted me Continue ReadingQL SERVER – Unable to Create Listener: Msg 41009 – The Windows Server Failover Clustering (WSFC) Resource Control API Returned Error Code 5057

SQL SERVER – The Report Server Cannot Open a Connection to the Report Server Database. (rsReportServerDatabaseLogonFailed)

When my clients contact me for any issue, I always try to help them or redirect them to someone who can help them better than me. Once a client contacted Continue ReadingSQL SERVER – The Report Server Cannot Open a Connection to the Report Server Database. (rsReportServerDatabaseLogonFailed)

SQL SERVER – FIX: Error 14001: The Application Has Failed to Start Because its Side-by-side Configuration is Not Correct

There are so many ways to break things in the operating system. In this blog, we would learn about fixing error “The application has failed to start because its side-by-side Continue ReadingSQL SERVER – FIX: Error 14001: The Application Has Failed to Start Because its Side-by-side Configuration is Not Correct

SQL SERVER – FIX: Msg 3231 – The Media Loaded on “Backup” is Formatted to Support 1 Media Families, but 2 Media Families are Expected According to the Backup Device Specification

While preparing for a demo for my upcoming session, I encountered an interesting error. I thought I have written a blog about it, but I was wrong. My earlier blog Continue ReadingSQL SERVER – FIX: Msg 3231 – The Media Loaded on “Backup” is Formatted to Support 1 Media Families, but 2 Media Families are Expected According to the Backup Device Specification

How to Find SQL Server Deprecated Features Used by the Application? – Interview Question of the Week #165

There are many applications which are developed using an older version of SQL Server. As there are new releases happening, there are features, command, and syntax which are marked as Continue ReadingHow to Find SQL Server Deprecated Features Used by the Application? – Interview Question of the Week #165

Declarative Programming: Is It A Real Thing?

By Federico Pereiro – Freelance Software Engineer @ TopTal. Original works can be located here. Declarative programming is, currently, the dominant paradigm of an extensive and diverse set of domains such as databases, templating Continue ReadingDeclarative Programming: Is It A Real Thing?