SQL University Post Coming Tomorrow

This is a short note to say that the SQL University post will arrive tomorrow. Today we're dealing with the...

Social Networking and SQLSaturday

I think we do a pretty good job of delivering technical content, but not such a great job at getting...

Backup Compression in SQL Server 2008 – The Complete Presentation

From the PASS 2010 Summit Survey: 29% of people want a presentation on backup compression. OK, here it is.

Turn it...

A DMV a Day – Day 28

The DMV for Day 28 is sys.dm_io_pending_io_requests, which is described by BOL as:
Returns a row for each pending I/O request...

BLOB Index Columns

For the April T-SQL Tuesday, I blogged about a report to find information on the BLOBs in a database.  I...

SQL Server 2008 and 2008R2 Diagnostic Information Queries

Since SQL Server 2008 R2 has gone RTM, and will be available on MSDN Subscribers on May 3, I thought...

The PowerShell and XML Corollary

Girl Property Surrounded by Geek Objects
I’ve just started watching The Big Bang Theory so I figured I’d borrow a naming...

In, Exists and join – a roundup

Over the last several months I’ve had a look at IN, Exists, Join and their opposites to see how they...

A DMV a Day – Day 27

The DMV for Day 27 is sys.dm_tran_locks, which is described by BOL as:
Returns information about currently active lock manager resources....

PASS Summit, Kilt Wednesday

Last year at the PASS Summit we held a silly little event called Kilt Wednesday. Only three people took part,...