Nested views causing query performance woes....

Just ran into an interesting issue AGAIN. It seems that when you nest views in a query you are opening...

nHibernate, First Look at TSQL

I’ve blogged in the past about the nHibernate project that has been going on at my company for the last...

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

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