November 2008
Here's a stored procedure that lets you quickly and easily produce customized reports showing the poorest-performing T-SQL statements that were run against your SQL Server 2008 and SQL Server 2005 databases.
SQL Server Magazine
February 2004
When you create a SQL Server login that has the same permissions as an existing login, the process of researching the old login's permissions and reassigning them can be tedious. Here's a way to automate permissions analysis-- and save your sanity.
SQL Server Magazine
December 2002
You know you can predict future database storage needs by evaluating past usage, but how do you collect the historical statistics? Here's a 2-step process that lets you do it yourself.
SQL Server Magazine