SQLSaturday #41 - Atlanta Session Recap

Last Saturday, April 24, I presented my session, Why I Use Stored Procedures and You Should Too, at SQLSaturday #41-Atlanta, see...

When was SQL Server last restarted?

How do you tell when your SQL instance was lasted restarted?
I was reading a post by Joe Webb (Blog|Twitter) about...

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