OVERVIEW

BY NEED

BY ROLE

BY INDUSTRY

Brad McGehee

Brad McGehee

Brad M. McGehee is a MCITP, MCSE+I, MCSD, and MCT (former), and, until recently, the Director of DBA Education for Red Gate Software. He is now the editor of the SQL Server Central Stairway series. Brad is also an accomplished Microsoft SQL Server MVP, with over 16 years SQL Server experience and over 7 years training experience. Brad is a frequent speaker at User Groups and industry events (including SQL PASS, SQL Server Connections, devLINK, SQLBits, SQL Saturdays, TechFests and Code Camps), where he shares his 16 years of cumulative knowledge and experience. A well-respected name in SQL Server literature, Brad is the author or co-author of more than 15 technical books (freely available on SQLServerCentral) and over 275 published articles.

Brad McGehee
30 January 2012
Brad McGehee
30 January 2012

How to Document and Configure SQL Server Instance Settings

80
Occasionally, when you install identical databases on two different SQL Server instances, they will behave in surprisingly different ways. Why? Most likely, it is down to different configuration settings. There are around seventy of these settings and the DBA needs to be aware of the effect that many of them have. Brad McGehee explains them all in enough detail to help with most common configuration problems, and suggests some best practices.… Read more
80
Brad McGehee
13 September 2011
Brad McGehee
13 September 2011

Database Properties Health Check

63
Within an instance of SQL Server, the database settings can have a direct effect on the database's behavior, performance and availability. Sometimes, it is difficult to tie a symptom to a cause, so it is wise to routinely check and record these settings. Before you change the current setting, it pays to understand exactly what it means and the implications of any change.… Read more
63
Brad McGehee
16 September 2010
Brad McGehee
16 September 2010

Are Your Backups Really Safe?

1
Imagine for a moment if you will. As a DBA, and as the protector of your organization’s data, you have implemented many safeguards to protect your data. You have set up periodic jobs to back up your databases; you check daily to ensure that the backups were actually taken; and you periodically perform test restores … Read more
1
Brad McGehee
18 August 2010
Brad McGehee
18 August 2010

Rebuilding Indexes using the SSMS Database Maintenance Wizard

61
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 drops and rebuilds every index in a database. It is effective but an off-line activity that is resource-intensive, so it not always the best way of avoiding index fragmentation in a production database. Brad explains...… Read more
61
Brad McGehee
20 July 2010
Brad McGehee
20 July 2010

Automate and Improve Your Database Maintenance Using Ola Hallengren’s Free Script

92
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 'Ola, Ola!'. Follow your conscience. Ola Hallengren has already crafted a superb set of routines to do this for you. Why reinvent something that does it all, safely and well. Brad McGehee explains....… Read more
92
Brad McGehee
06 January 2010
Brad McGehee
06 January 2010

Database Maintenance Plans in SSMS: An Overview

28
Maintenance plans are essential. Microsoft provide two tools, the Maintenance Plan Wizard and the Maintenance Plan designer, to assist the busy DBA to get started with one, but they don't include all the likely tasks, so Custom-created T-SQL or PowerShell scripts are usually required sooner or later to provide a more comprehensive plan… Read more
28
Brad McGehee
03 September 2009
Brad McGehee
03 September 2009

A Code of Conduct for DBAs

35
Despite the fact DBAs are protectors of an organization's knowledge, and privy to much confidential information, there is no clearly defined set of rules and standards to help govern and guide their ethical conduct. Brad McGehee, in an article based on a chapter from the second edition of his book 'How to Become an Exceptional DBA', discusses a Code of Conduct for DBAs. He advises on why such a code is required, the sort of topics it should contain, and how it might be enforced. Much of this article has relevance for any IT professional.… Read more
35