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

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

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

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

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