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

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

How to Tell When SQL Server Started?

As a consultant, I’m regularly asked to diagnose and solve problems when I have incomplete or conflicting information given to...

Social Networking and SQLSaturday

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

SQL Server Connection Strings

The purpose of this short post is to demonstrate a simple method of generating an accurate SQL Server connection string...

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

Undocumented Capabilities of Extended Event Objects

Undocumented Capabilities of Extended Event Objects
The extended event objects (objects exposed by an event package) are listed in the system...

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

BLOB Index Columns

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

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