Express Yourself Clearly

Recently my son had a short paper to write for school. He’s a sixth grader, and this year is a...

Product Review: Fences

Fences is a free utility for the Windows desktop that lets you drag shortcuts into boxes you define (fences) and...

A DMV a Day – Day 5

The DMV for Day 5 is sys.dm_db_mirroring_auto_page_repair, which is described by BOL as:
Returns a row for every automatic page-repair attempt...

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

Differential Backups

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

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 4

The DMV for Day 4 is sys.dm_os_sys_memory, which is described by BOL as:
Returns memory information from the operating system. SQL...

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