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.

01 May 2009
01 May 2009

SQL Server DBA Certifications: How Many People Have Which Certifications?

1
According to Microsoft, as of April 2009: 153,130 people have received the MCDBA: SQL Server 2000 certification 51,445 people have received the MCTS: SQL Server 2005 certification 854 people have received the MCTS: SQL Server 2008 Implementation and Maintenance Certification 3,577 people have received the MCTS: SQL Server 2005 Business Intelligence certification 333 people have … Read more
1
08 April 2009
08 April 2009

PASS Call for Speakers Deadline Extended

0
If you have been procrastinating about submitting a speaking abstract for the 2009 PASS Community Summit, you have been given a short reprieve. The Call for Speakers has now been extended until midnight on April 24, 2009. See this link for more details: www.sqlpass.org/Community/SpeakerResource.aspx.… Read more
0
13 March 2009
13 March 2009

How to Identify Blocking Problems with SQL Profiler

Many SQL Server developers and DBAs have, in the past, had their own favourite diagnostic Stored Procedures for investigating blocking issues, but since SQL Server 2005, it is a good idea to use the SQL Profiler for all but the most complex problems. This has a blocked process report which can tell you what the problem is, and give a good indication as to how to correct it.… Read more
03 February 2009
03 February 2009

How to Identify Slow Running Queries with SQL Profiler

With SQL Server Profiler, it is easy to discover all those queries that are running slowly. Once poorly performing queries are identified, there comes the harder task of speeding them up. Once again, the Profiler can provide a lot of information that can help diagnose and resolve these performance problems. Brad describes this essential part of the process of performance-tuning in an article taken from a chapter to his new book, Mastering SQL Server Profiler.… Read more
29 December 2008
29 December 2008

SQL Server 2008: Performance Data Collector

With Performance Data Collector in SQL Server 2008, you can now store performance data from a number of SQL Servers in one central location. This data is collected by a collection set on each server and stored in a shareable management data warehouse (MDW). Reports can be generated from this data using the built-in reports or generating your own with reporting Services. Brad McGehee explains more. … Read more
29 November 2008
29 November 2008

How to Hone Your DBA Skill Set

0
In this article, we examine the various ingredients that will help you establish a successful career as a DBA, and then contribute to your long-term career success. Formal Education – you don’t need a degree in database administration, but a solid computer technology background will help Getting Experience – getting experience as a new DBA … Read more
0
30 October 2008
30 October 2008

Characteristics of the Exceptional DBA

2
In this blog entry, I’d like discuss and explore the characteristics that define an Exceptional DBA. Few DBAs will have all these characteristics, but the best DBAs will have most of them. Enjoys Technology If you are reading this blog entry, then I think I can reasonably assume that you already enjoy technology, a key … Read more
2
15 October 2008
15 October 2008

Career Guidance: Become a More Successful IT Professional by Managing Your Own Personal Brand Within Your Organization

0
While you may not think of it this way, the impression you create on other people within your organization significantly affects your success as an IT Professional. In other words, how the people you work with view you as a person can make all the difference between you being an average IT Professional and being … Read more
0
28 September 2008
28 September 2008

Can Social Networking Help Your DBA Career?

0
In previous blog entries, I have talked about the importance of managing your online brand. One important part of this is participation in social networking websites. If you are not yet familiar with the term, social networking refers to websites that are designed to make it easy for people to share information about themselves, and … Read more
0
25 September 2008
25 September 2008

SQLPASS Has New Website

0
After a very long wait, SQLPASS has introduced its new website (www.sqlpass.org). If you were a previous member of PASS, you should have received an e-mail with your new username and password. If you thought you were a member, but did not receive the e-mail, you will need to register again. The website sports a … Read more
0
25 September 2008
25 September 2008

How to Script a Profiler Trace for Use as a SQL Trace Data Collection Set for the SQL Server 2008 Performance Data Collector

1
In SQL Server 2008, a new feature called the Performance Data Collector was added. It has the ability to collect SQL Server-related performance data, store it in a database called the Management Data Warehouse, and then produce various performance reports based on the collected data. By default, the Performance Data Collector includes three different data … Read more
1