Monthly Archive: December 2006

Dynamic Management Objects are nice, but…

Dynamic Management Objects are nice, but…

Don't get me wrong, I really like the catalog views and dynamic management objects. There is so much information revealed to us now; previously, only available through PSSDiag, obscure or unsupported/undocumented DBCC commands, or...

A custom report for Management Studio : Show Blocking

A custom report for Management Studio : Show Blocking

Note that the techniques described in this post require the latest CTP of Service Pack 2 for SQL Server 2005 on the client (but the custom reports can run against a server that is...

December CTP of SQL Server 2005 SP2 is available

December CTP of SQL Server 2005 SP2 is available

The SQL Server team is keeping quite busy (and keeping us busy as a result). Today Paul Mestemaker II announced in the SQL Server Manageability Team Blog that a brand new CTP of Service...

Take the high road to middle ground

Take the high road to middle ground

A long, long, time ago, I wrote an article on calculating the median in a table. (I've removed the link, since aspfaq.com has been taken over by malware slimeballs.) Of course, this was against...

Some SQL Server 2005 builds you may have missed (update: 2006-12-20)

Some SQL Server 2005 builds you may have missed (update: 2006-12-20)

Now that SQL Server 2005 is over a year old (what a big boy you are!), the beta builds are irrelevant, but the post-RTM builds fix some issues that may be quite important to...

Some SQL Server 2000 builds you may have missed

Some SQL Server 2000 builds you may have missed

I used to stay on top of all the hotfixes that were released for SQL Server 2000, because our databases in that environment were victims of various bugs. But soon I felt that it...

Leaving aspfaq behind

Leaving aspfaq behind

You may or may not know that I was the primary author over at aspfaq.com. Earlier in 2006, I allowed another entity to take on the web site and incorporate it into their grander scheme...