When you set up a multi-subnet cluster, whether it’s a Failover Cluster Instance or an Availability Group, you need to make sure you...

Five years ago the term “cloud” was still a buzzword, and there was a lot of uncertainty and misconception around it. I remember many...

This query stats script returns aggregated statistics information for every query statement in the cached plan. Use it to get details on...

The Advanced Programming in SQL Server course takes your programming in SQL Server to a new level. [table “1” not found /] Course...

The Advanced Programming in SQL Server course takes your programming in SQL Server to a new level. [table “1” not found /] Course...

This is the third post in the “Parameterization” series. In the previous post I mentioned parameter sniffing. This is a very important...

A short while ago, I was asked to create a certain report with a “Windows File Share” subscription. The client wanted the file to be...

Many times, when I perform query tuning, the problem that causes the query to perform badly is related, one way or another, to...

Introduction Many times I happen to find myself in a situation where, as a DBA, I need to write some long and cumbersome code (usually...

On Saturday, I had the pleasure to present my session, “Things You Can Find in the Plan Cache”, at SQLBits! Thanks to everyone who...