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

PASS Board Update

Time for another update.
The minutes for the June in-person meeting have been approved and are now ready for your information....

Reminder: #SQLChat at lunch today

This is a reminder that we’ll having a #SQLChat this afternoon at 12 PM EDT. Here are the details:
SQLChat: Do...