Colorado Springs SQL Server User’s Group Meeting on Wednesday, May 19, 2010

The Colorado Springs SQL Server User’s Group is having their May meeting on May 19.
It will be held at the...

Denver SQL Server User’s Group Meeting on Thursday, May 20, 2010

The Denver SQL Server User’s Group will be having their May meeting next Thursday, May 20. As always, the meeting...

Some SQL Server Date and Time Examples

I had a question from a developer yesterday about how to calculate the difference between local time (on the database...

Using CPU-Z to Discover Hardware Information

I think it is very important to be able to discover exactly what type of hardware is in an existing...

Spring 2010 Hardware Recommendations

Since I am very interested in various PC-based hardware, and I make an effort to stay current on new developments,...

Recap of April 2010 DMV a Day Series

Well, I managed to finish up my series that featured a DMV query every day during the month of April....

Register For 24 Hours of PASS Event

The free 24 Hours of PASS event will be held on May 19-20, and includes 24 different one hour presentations...

A DMV A Day – Day 30

The DMV for Day 30 is sys.dm_os_buffer_descriptors, which is described by BOL as:

Returns information about all the data pages that...

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