T-SQL Tuesday #19 - Disasters & Recovery

 When I heard Allen Kinsel’s (aka @sqlinsaneo|Twitter) Invitation to T-SQL Tuesday #19 – Disasters & Recovery, for some reason, I read it...

vCentre Useful Queries: Part I

After posting on twitter last week that I needed something to write a blog post about my good friend Christian...

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