Brad McGehee


Professional Experience


Brad M. McGehee is a MCSE+I, MCSD, and MCT (former) with a Bachelors’ degree in Economics and a Masters in Business Administration. Currently the Director of DBA Education for Red Gate Software, Brad is an accomplished Microsoft SQL Server MVP with over 10 years’ SQL Server experience. Having founded the popular community site SQL-Server-Performance.Com, where he now acts as the technical editor and forum moderator, Brad specializes in SQL Server Administration, Performance Tuning, and High Availability. He regularly consults with multiple clients, helping them to get the most out of SQL Server.



Community Support


Brad is a frequent speaker at SQL PASS, SQL Connections, SQL Server user groups, and other industry seminars, where he shares his 10 years’ cumulative knowledge.


A well-respected and trusted name in SQL Server literature, Brad is the author or co-author of more than 12 technical books and over 100 published articles. His most recent book (as a co-author) is Professional SQL Server 2005 Administration by Wrox Press.



Home Life


When he is not travelling to spread his knowledge on SQL Server, Brad lives in Hawaii, where he enjoys spending time with his wife and young daughter.


Brad"s personal website is
Contact him at:

Cannot drop database “%.*ls” because it is currently in use. - 11 Jul 2007

Cannot drop a default constraint by DROP DEFAULT statement. Use ALTER TABLE to drop a constraint default. - 10 Jul 2007

Conflicting locking hints specified - 08 Jul 2007

Line %d: Specified scale %d is invalid. - 06 Jul 2007

The statement BACKUP LOG is not allowed while the recovery model is SIMPLE. Use BACKUP DATABASE or change the recovery model using ALTER DATABASE. - 04 Jul 2007

Each file size must be greater than or equal to 512 KB - 03 Jul 2007

System databases master, model, msdb, and tempdb cannot be detached. - 02 Jul 2007

Error: SQL Server has encountered xxxx occurrence(s) of IO requests taking longer than 15 seconds to complete on file - 01 Jul 2007

Making the Most Out of the SQL Server 2005 Performance Dashboard - 24 Apr 2007

SQL Server 2005 Clustering Best Practices - 04 Apr 2007