Finding DDL Triggers

Triggers are the types of objects in SQL Server that are easy to lose track of. There isn’t an obvious...

You don’t want to miss this out,Serious SQLServer training – 24 Hours of PASS event !

Back to back quality SQLServer sessions! Yes, you heard it right and that’s what 24 Hours of PASS is all...

SQL Server: String Pattern Matching

It is common scenario that, we might need to extract the data from the SQL server based on some pattern....

Yesterday I was hacked

That’s right, for all my years in IT yesterday I was the victim of a vicious and deeply distressing incident....

Winner Winner Chicken Dinner!

I have spent a lot of time on the road this year with work but over the summer I was...

Labor Day Bloopers

The raw footage of all the mistakes I’ve made since the Fourth of July.
Part 1
Part 2

Filed under: Blog Tagged: Humor,...

SQL Server: Understanding GAM and SGAM Pages

We know that SQL server stores the data in 8 KB pages. An extent is made up of 8 physically contiguous...

Interview on RunAsRadio #281 with Richard Campbell

I recently had a chance to record a 33 minute podcast interview on RunAs Radio #281 with Richard Campbell, where...

Sometimes Failure Is An Option

Wouldn’t it be nice if failure was an option?  You could go along in life, screw it all up and...

Master Data Services Terminology Overview

When moving from a data warehouse world to MDM, there is some new terminology to learn.  Each of the terms...