Reminder: Webinar today

This is a reminder that I’ll be giving a webinar today on managing SQL Server Agents jobs in a SQL...

SA Spoof

This is nothing new but it’s still a fun idea.

The problem:
The vendor app we just purchased (and are told we...

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...