DBA in the Cloud: Threat or Opportunity?

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

Parameterization Part 4: Handling Non-Uniform Data Distribution

This is the fourth post in the “Parameterization” series. In the previous post I wrote about parameter sniffing, and I...

Parameterization Part 3: Parameter Sniffing

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

Parameterization Part 2: Seven Ways to Execute Your Query

This is the second post in my series on parameterization. In the first post I wrote about plan caching and...

Parameterization Part 1: Plan Caching

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

My Visit to WPC 2014

Last week I attended WPC. This is an annual event organized by Microsoft for its partners around the world. WPC...

My Visit to Redmond

Last week, I had the pleasure of attending the EBC in Redmond. If you don’t know what EBC is, that’s...

Track Incomplete Statements

What about when statements are sitting in your server, uncompleted and not moving, just hogging resources? Use this script for...

Space Used by Database Files

Retrieve data about size and space used for all the files in the current database with this script.

Some tips on...

What I Love About SQL Server

Well, there are many things I love about SQL Server. Otherwise, I wouldn’t spend my whole career around it, would...