Recently I came across a stubborn blocking issue which led me to discover and understand something interesting about the way Nested Loops join operators work in certain specific situations. This was a production environment...

Recently I was able to harness the power of Plan Guides in a critical SQL Server environment that needed some urgent attention. A particular query was being fired thousands of times every minute on the database hosted on SQL...

The other day I was troubleshooting a production system with an issue reported by the application team. As per the application team they were getting disconnects reported in the logs and wanted this to be investigated. I put up...

In this article I am going to share a brief Extended Events script which I have used several times to track a particular query and understand its impact on the server. While the query store is getting popular and I often see it...

The other day, I got an opportunity to be a part of a conversation with a group of young professionals currently working in the field of data, specifically working on Microsoft stack. The conversation veered towards the role of...