Differential Backups

My last few posts have been backup orientated, I have a post on Full Backup, a post on Transaction Log...

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

SQL Server 2008 MCM Results

SQL Server 2008 MCM Results
3 weeks of intense training, intense studying, 3 written tests, and one 6 hour lab exam....

SQL Server 2008 R2 Update for Developers Training Kit (March 2010 Update 2)

SQL Server 2008 R2 Update for Developers Training Kit (March 2010 Update 2)
15 Presentation 24 Demo13 Hands-on Labs35 Videos
The training kit...

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

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