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 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 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, […]