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

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 DMV a Day – Day 2

The DMV for Day 2 is sys.dm_exec_sessions, which is described by BOL as:
Returns one row per authenticated session on SQL...

Book Review: Where Have All The Leaders Gone

It had been a long while since I listened to an audio book, found it while browsing at the library....

Goals for 2010 – Q1 Review

Here were the goals I posted for 2010 on the last day of December:
Continue managing the forums, but at a...

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

The Way - The Reason

 This is one thing outside the SQL World, but it has very strong place in every aspects, it is one...

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