SQL Server Connection Strings

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

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

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