Parsing SQL for Table Names

Visual Studio Team System 2008 Database Edition (VSDB) ships with a .NET class for parsing T-SQL. I’ve previously blogged about...

Service Broker Solutions - Don't Forget the Basics

After finally getting a Service Broker solution implemented successfully, I'm really impressed with the technology, and frustrated how difficult it...

A T-SQL Holiday Message

Totally pointless, but fun.  Run it to decode the message.

DECLARE @Message varchar(20)
SET @Message = '????????????'

DECLARE @Decode Table(
DSeq tinyint,
DKey smallint
)

INSERT INTO...

A DMV a Day – Day 3

The DMV for Day 3 is sys.dm_os_sys_info, which is described by BOL as:
Returns a miscellaneous set of useful information about...

The Web 3.0 has finally arrived… It’s The Cloud

The 2008 trending topic everyone was talking about was the Web 2.0. On October 23 that same year,...

The Web 3.0 has finally arrived… It’s The Cloud

The 2008 trending topic everyone was talking about was the Web 2.0. On October 23 that same year, Amazon EC2 dropped the Beta label and the story accelerated: Less...

Winner of the March SQL Aloha Contest

The March SQL Aloha contest had a total of 25 entries, and all of them were great responses to this...

What happens when Windows is the step-child? Adventures in Ruby on Rails.

Like many of you I’ve heard the developer community going on about Rails for quite a while now. It wasn’t...

Speaking Seven Times in April

April will be a busy month for me as I will be speaking seven different times, on seven different topics,...

The Best vs. The Good Enough

When you ask a question on the forums, you'll often get responses that certain ways of doing things are inefficient...