• [SQL 2012 query plan enhancement] I want to know why my query is not parallelized

    In the past, we have got repeated questions from customers on why a particular query is not parallelized. We didn’t have a good way to let customer know the reason until SQL 2012. Starting SQL Server 2012, XML showplan is enhanced to include ...read more
  • When is throttling in Windows Azure SQL Database really throttling….

    During the course of this year I have spoken at several customer and internal events on troubleshooting the Windows Azure SQL Database environment. As I built my presentations, one of the confusing topics I found was a term used in Azure Database called ...read more
  • Back to Basics: SQL Parameter Sniffing due to Data Skews

    In Denzil’s recent post about correlating XE query_hash he alluded to a relatively common issue.   Most of the time a proc will run just fine, but sometimes it will run very slow.   This is an issue that I tend to be seeing often as of late ...read more
  • Service status watcher in SQL Server Management Studio – How it works

    Have you ever wondered about the mechanism using which SQL Server Management Studio(SSMS) - Object Explorer shows the service status for SQL Server and SQL Agent service? We recently worked with a customer on a issue related to this and thought that this ...read more
  • System.ComponentModel.Win32Exception: A required privilege is not held by the client while Deploying SSIS Project

    My name is Archana CM from Microsoft SQL Developer Support team, we support SQL Connectivity issue along with data access technologies and SSIS. We had a scenario where one of my customer was facing an issue while deploying SSIS Project in SQL Server ...read more