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
As a part of my consulting, I observed that there is a lot of interest in using AlwaysOn availability group. I have deployed many AlwaysOn solutions from start-to-finish. Recently I Continue ReadingSQL SERVER – AlwaysOn Automatic Seeding – Database Stuck in Restoring State
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
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
In this blog post, we are going to discuss how to fix high CPU Consumption on SQL Server 2016 and SQL Server 2017. One of the large multinational corporations recently Continue ReadingSQL SERVER – How to Fix High CPU Consumption on SQL Server 2017 and 2016
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)
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
The 5th cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft Downloads site. Please note that registration is no longer Continue ReadingCumulative Update #5 for SQL Server 2017 RTM
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
The 11th cumulative update release for SQL Server 2014 SP2 is now available for download at the Microsoft Downloads site. Please note that registration is no longer Continue ReadingCumulative Update #11 for SQL Server 2014 SP2
The 8th cumulative update release for SQL Server 2016 SP1 is now available for download at the Microsoft Downloads site. Please note that registration is no longer Continue ReadingCumulative Update #8 for SQL Server 2016 SP1
Many times, there are some strange requests which I heard from my clients. I try to help my client with the answers and write a blog so that others can Continue ReadingSQL SERVER – How to Download SQL Server Native Client?
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
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?
One question I always ask all of my customers before I start Comprehensive Database Performance Health Check is that if they have taken backup of their server. The answer to Continue ReadingSQL SERVER – Identify Version of SQL Server from Backup File