SQL SERVER – Identifying Deprecated SQL Server Features with Extended Events

In this blog post with the help of Extended Events, we will learn how to identify all the deprecated SQL Server Features. This feature can be very much handy when we are changing the compatibility of SQL Server and we want to Continue reading SQL SERVER – Identifying Deprecated SQL Server Features with Extended Events

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 all have job to do. One of my clients was Continue reading SQL SERVER – FIX: Arithmetic Overflow Error in Object Execution Statistics Report in Management Studio

SQL SERVER – Upgrade Error – ALTER DATABASE Statement Not Allowed Within Multi-statement Transaction

Most of the time applying service pack for SQL Server is a child’s play. Double click on exe, keep hitting next, next and finally press update. But when it fails, you would need an expert to fix the issue. Recently, Continue reading SQL SERVER – Upgrade Error – ALTER DATABASE Statement Not Allowed Within Multi-statement Transaction

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 Seeding – Database Stuck in Restoring State While fixing above, Continue reading SQL 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 pretty much every day when I was drivers were costly. Continue reading How to Estimate Space Saved by Data Compression in SQL Server? – Interview Question of the Week #167

SQL SERVER – FIX: Backup Detected Log Corruption in database MyDB. Context is Bad Middle Sector

During my consulting, I guide my clients to have a backup plan in place. One of my clients reported that whenever they try to take a Full Backup of a database, it fails precisely after 60% completion. Here is the Continue reading SQL SERVER – FIX: Backup Detected Log Corruption in database MyDB. Context is Bad Middle Sector

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 possible cause of database mirroring Error 1456 – The ALTER Continue reading SQL 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 connecting MySQL Server. While I was trying to simulate the Continue reading MySQL – Connection Error – [MySQL][ODBC 5.3(w) Driver]Host ‘IP’ is Not Allowed to Connect to this MySQL Server