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

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