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

Find from which file a sql query is running

Hello I can see a query using SHOW PROCESSLIST and i am wondering if it is a way to know from which .php file is coming….. ? Any way… | Read the rest of http://www.webhostingtalk.com/showthread.php?t=1705084&goto=newpost Read the entire article at Continue reading Find from which file a sql query is running

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