Service Pack 2a?

Well, I'm certainly glad I didn't bet that 3050 would be the last we'd hear about SP2.  It's like alphabet soup, I think 3152 (found at http://support.microsoft.com/kb/933097/ – Thanks Chris!) could unofficially be called SP2c or SP2d now?What an absolute mess.<…previously in this post…> Sorry, last update on SP2/SP2a/SP2b, I'm sure.  […]

SQL Server 2005 Service Pack 2 is here!

Since I probably won't be the "first post!" winner, I'll go over the highlights of what you're getting (some of which are not mentioned in the What's New document). Before I do that I'll post the links: SQL Server 2005 SP2 KB 921896: A list of the bugs that are […]

Reviewing AutoGrow events from the default trace

Since I don't have the luxury of setting up event notifications on all my servers, in SQL Server 2005 I can use the default trace to monitor autogrow events… this helps to prepare for increased disk space usage, and also lets me know if my log backups are happening frequently […]

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 not at all. But there are a couple of issues that I think should have received […]

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 at a lower build level). Since the early betas of "Yukon," which later became SQL Server […]

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 Pack 2 was available for download. I'm glad we get a chance to play with these […]

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 SQL Server 2000; long before we had seen but glimpes of upcoming features in "Yukon" like […]

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 was my "job" to share this information with the community, even though nobody had tasked me […]

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 of IT resource sites.  Unfortunately, their transition as a little slower than I expected; more recently, […]