Driving The Database Engine

An astute member of the SQL Server community has observed the presence of SPIDs with a negative number. These anti-SPIDS were noted in SQL Server 2000 and appear to be generated by MSDTC. I'm wondering if they behave like anti-matter and cancel out...

Thanks to those of you who attended SQLSaturday and a special thanks to all the volunteers from the Atlanta.MDF user group who put on a great event! Here is the presentation I did for the SQLSaturday event in Atlanta. Please feel free to download and...

One of my colleagues, Rob Carrol, has uncovered a way to use the Performance Dashboard Reports on SQL Server 2008. Here's a link to his blog post on the topic: http://blogs.technet.com/rob/archive/2009/02/18/performance-dashboard-reports-for-sql-server...