Three New TPC-E Submissions

I just noticed three very recent new TPC-E Benchmark Submissions that I thought were quite interesting. As I have written...

vCentre Useful Queries: Part II

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

Hash Tag Art

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

How to Speak to a Tech

Hi all! I’m on vacation this week, but I’ve cleverly scheduled this blog post so you won’t miss me too...

SSAS Maestro–Redmond Day 2–Redux

Wow, what a day 2! This was our first day of lecture and it was a doozy. Stacia and I...

SSIS Configurations: When and How

Configurations in SSIS are a lovely tool that when implemented correctly can greatly reduce package maintenance.  It is very possible...

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

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

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

T-SQL Tuesday #19 – Disaster Recovery

This month Allen Kinsel hosts T-SQL Tuesday #19 with a disaster recovery theme. This is the blog party idea started...