A DMV a Day – Day 29

The DMV for Day 29 is sys.dm_exec_connections, which is described by BOL as:
Returns information about the connections established to this...

A Identity Bug

Someone asked an interesting question recently. If they had this code:
if OBJECT_ID('aa') is not null
   drop table aa
create table...

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

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