Countdown to PASS Summit 2012 – 8 to Go – What Is PASS Anyway?

Eight days to go. So after going to my first conference, I was surprised that I did not know more...

Lost in Translation – Deprecated System Tables – sysindexes

This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...

Monitor Blocking with Extented Events in SQL 2012

1. Set the "blocked process threshold (s)"
sp_configure 'show advanced options', 1 ;
GO
RECONFIGURE ;
GO
sp_configure 'blocked process threshold', 10 ;
GO
RECONFIGURE ;
GO

here we...

Last Weeks Top 10 “Reading” Links #4

Throughout the week, I like to tweet links to the things that I’ve been reading.  Since they all come out...

Geographic Failover/Redundancy (and DR)

Today we await the arrival of a 100 year storm that threatens to surge New York harbor and the Long...

Amazon Kindle Fire Released

Amazon has released the latest version of it Kindle – the Kindle Fire HD.
It seems amazon are moving away from a...

Countdown to PASS Summit 2012 – 9 to Go – My First Summit

We are less than ten days to the start of PASS Summit 2012. I thought it would be fun to...

Is PowerPivot the Next Access?

I’m impressed with the current generation of semantic modeling technology from Microsoft.  I’ve had the opportunity to use both PowerPivot...

Advanced TSQL training

Over the past few years, Ive had it on my to do list to write and deliver and full-scale SQLServer...

Microsoft Surface

I’m going to do with this what I should have done with the Piece Of Fruit (POF), blog about the...