T-SQL Enhancement: THROW

When bulding solid T-SQL solutions, it is often necessary to implement some level of error handling. One of the most...

'Topping and Tailing' strings in database tables

/*

When you are having to extract just part of a string in TSQL, there are a number of techniques you...

SQL Server Instant File Initialization (PQW)

Bluntly put, this is something that you always want to be taking advantage of.
As a Database Administrator I’m always on...

SSAS Maestro - Day 1 - Redux

Well it’s been an exciting couple of weeks leading up to this course. We have tweaked what we could in...

Speaking at SALSSA June 15th 2011:Understanding Storage Systems and SQL Server

I am very exicted to be speaking at the San Antonio PASS chapter SALSSA! It’s been way to long and...

SSAS - Understanding KeyColumns Dimension Property

For many Analysis Services developers building dimensions with many attributes and hierarchies is something that comes as second nature to...

SSIS Fuzzy Lookup Error

A Fuzzy Lookup Task in SSIS that I was working on was bombing out, and I had a heck of...

PASS Update #56-SQLRally 2012 Site Selection

Note: This is a good, bad, and ugly post. We took some chances, got some things right, got more than...

What’s a Disaster?

In working on my Preparation for Disaster presentation and doing research, one of the questions that came up early for...

Time for a Little PD

No, PD doesn’t stand for PowerShell Development. It stands for Professional Development. Sharks either swim or die (and yes, I...