SQL SERVER – FIX: Arithmetic Overflow Error in Object Execution Statistics Report in Management Studio

Many times, there are unforeseen conditions and few developers can’t predict which writing the code of a product. This is the reason we have bugs in the products and we Continue ReadingSQL SERVER – FIX: Arithmetic Overflow Error in Object Execution Statistics Report in Management Studio

SQL SERVER – AlwaysOn Automatic Seeding Failure – Failure_code 15 and Failure_message: VDI Client Failed

Recently I wrote a blog explaining a situation where taking log backup can break automatic seeding and synchronization would not work. Below is the blog reference. SQL SERVER – AlwaysOn Automatic Continue ReadingSQL SERVER – AlwaysOn Automatic Seeding Failure – Failure_code 15 and Failure_message: VDI Client Failed

How to Estimate Space Saved by Data Compression in SQL Server? – Interview Question of the Week #167

Question: How to Estimate Space Saved by Data Compression in SQL Server? Answer: It has been long since I have heard this question. I remember I used to answer this question Continue ReadingHow to Estimate Space Saved by Data Compression in SQL Server? – Interview Question of the Week #167

SQL SERVER – Mirroring Error 1456 – The ALTER DATABASE Command Could not be Sent to the Remote Server Instance

As a part of my consulting, I still get few clients who prefer to use database mirroring over Always On Availability Group. In this blog we would cover about one Continue ReadingSQL SERVER – Mirroring Error 1456 – The ALTER DATABASE Command Could not be Sent to the Remote Server Instance

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)