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

Are you going to SQL Saturday Denmark? #SQLSaturdayDenmark

Are you going to SQL Saturday Denmark, which is running on Saturday 17th September? If you are David Postlethwaite or @postledm...

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

Reminder: Webinar today

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

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

Recap of My 24HOP Session – From XML to JSON

Yesterday I presented my session From XML to JSON as part of the 24 Hours of PASS online event. There...

This Week in Data – Episode 3 (What is the Internet of Things (IoT)?)

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...

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

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