T-SQL Tuesday Mirroring and SSWUG

This month’s T-SQL Tuesday is hosted by Allen Kinsel (Blog|Twitter) and covers “disasters and recovery”.  My favorite DR solution is...

Too Many Disasters To Choose From (T-SQLTuesday)

I’m ashamed to admit that somehow this months T-SQL Tuesday has completely blindsided me, which is kind of ironic really when you consider...

Hash Tag Art

I haven’t tried this, but run across a reference to hashtagart that looks pretty interesting as a way to use...

T-SQL Tuesday 19 Disasters and Recovery

This post is my contribution to T-SQL Tuesday, hosted this month by Allen Kin (blog | twitter).
A first step in any disaster recovery...

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