Speaking at IT/Dev Connections 2016

I’m happy to announce that I’m speaking at this year’s IT/Dev Connections conference held at the ARIA Resort in Las Vegas...

SQL Sentry Does It Again–Plan Explorer 3.0

Being in a shop that utilizes Plan Explorer it was awesome to hear of the news release from SQL Sentry...

Sql Server - Finding Duplicate Indexes

If you are reading this article, I assume
that you have basic knowledge of Index, its types and usage.

Over the...

Sql Server Special Table Types

Special
Table Types

Objective of this post is to provide a list of special
tables available in Sql Server and brief description of...

Statistics with T-SQL and R – the Pearson’s Correlation Coefficient

In this post I will attempt to explore calculation of a very basic statistic based on linear relationship between two...

The art of possible with the cloud

One thing I try to do in my role with Microsoft is to get clients to think of possible use...

The Non-Replicated Backup Mystery

I recently configured a backup job to run on the principal server of a mirrored pair. The idea was to backup...

Defending your data

Which of these is more secure?

shilmar / Pixabay
Nicolas Chadeville / 500pxIt’s a trick question – the correct answer is “neither”.
Both castles and vaults...

Join me and Kalen Delaney today for 24HOP

I’m excited to be monitoring Kalen’s session on concurrency. The session is today and is titled “Locking, Blocking, Versions: Concurrency...

Kilt Day! PASS Summit 2016, Thursday

Thursday at the PASS Summit is Kilt Day.
This means you should wear a kilt. Whether you do it in support...