Brad McGehee Correlating SQL Server Profiler with Performance Monitor Both Performance Monitor and SQL Server Profiler provide valuable information about your server. However, if you combine the data from the two sources, then this... 16 February 2011 24 min read
Brad McGehee Brad’s Sure Guide to SQL Storage Compress SQL Storage Compress does just that, and encrypts as well, allowing the files associated with a live database to take much less file-space, and securing... 07 December 2010 27 min read
Brad McGehee Rebuilding Indexes using the SSMS Database Maintenance Wizard Index fragmentation can cause problems with query performance. Indexes therefore need to be occasionally rebuilt. the Rebuild Index task of the SSMS Database Maintenance Wizard... 18 August 2010 24 min read
Brad McGehee Brad’s Sure Guide to SQL Virtual Restore In the first of a series of in-depth software reviews, Brad investigates a newcomer, SQL Virtual Restore. What does it aim to do? How does... 05 August 2010 34 min read
Brad McGehee Automate and Improve Your Database Maintenance Using Ola Hallengren’s Free Script If you ever feel uneasy when you set about handcrafting database maintenance jobs for SQL Server, it may be the voice of your conscience saying... 20 July 2010 35 min read
Brad McGehee How to Become an Exceptional DBA, 2nd Edition A 2nd edition of Brad McGehee's popular "career guide" for DBAs, designed to help new and prospective DBAs find their feet in the profession, and... 30 July 2009 2 min read
Brad McGehee Mastering SQL Server Profiler Brad McGehee's "from the ground up" guide to SQL Server's most powerful performance diagnostic tool...… 30 January 2009 2 min read
