Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Regular Columnist: Brad McGehee

SQLServerCentral.com profile

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 13 years’ SQL Server experience, and over 6 years’ training experience. Brad is a frequent speaker at SQL PASS, SQL Connections, SQLTeach, SQL Saturdays, TechFests, Code Camps, SQL Server user groups, and other industry seminars, where he shares his 13 years’ cumulative knowledge. Brad was the founder of the popular community site SQL-Server-Performance.Com, and operated it from 2000 through 2006, where he wrote over one million words on SQL Server topics. In 2008, Brad attended 16 conferences/user group events, presented 26 sessions, and had 1,402 people attend them. A well-respected and trusted name in SQL Server literature, Brad is the author or co-author of more than 14 technical books and over 100 published articles. His most recent books include “How to Become an Exceptional DBA,” and “Brad's Sure Guide to SQL Server 2008: The Top Ten New Features for DBAs,” and “Mastering SQL Server Profiler.”

   Items 1 to 20 of 58    Older >>
 

SSC Clinic: Can Implementing "Optimize for Ad Hoc Queries" Boost Performance for the SQLServerCentral.com and Simple-Talk.Com SQL Servers?

With the introduction of the instance-level option “optimize for ad hoc workloads” in SQL Server 2008, DBAs have a tool to deal with a problem known as plan cache pollution, or plan cache bloat. It’s often caused when one-time use ad hoc queries are sent to SQL Server from Object-Relational Mapping (ORM) solutions, such as LINQ, NHibernate, or Entity Framework. The problem can prevent SQL Server from using its available memory optimally, potentially hurting performance.  Read more...
By Brad McGehee 2012/06/14 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 1,899 reads

SQL Server 2012 Certifications Revamped

Forget what you thought you knew about SQL Server certification, as Microsoft has completely redesigned the SQL Server 2012 certification program, making is more difficult, costly, and time-consuming to attain.  Read more...
By Brad McGehee 2012/05/21 | Source: SQLServerCentral.com | Category: certifications
Rating: |  Discuss |   Briefcase | 588 reads

When Will You Upgrade to SQL Server 2012?

Having noticed a very low rate of migration to the latest version of SQL Server, Brad McGehee asks - when will you upgrade to 2012?  Read more...
By Brad McGehee 2012/04/30 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 600 reads

DBAs and the Career-Life Balance

DBAs always tend to face many difficulties in maintaining a healthy work-life balance. Brad McGehee encourages some debate on the best strategies to make this work, in the face of long working hours, and the desire to contribute fully to the SQL Server community.  Read more...
By Brad McGehee 2012/01/16 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 370 reads

Does the Role of the DBA Need to Evolve?

With the amount of data being stored expanding exponentially, does the role of the DBA need to change from caretaker to interpreter?  Read more...
By Brad McGehee 2011/12/12 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 235 reads

What SQL Server Books Do You Recommend

Brad's noticed that there are fewer good books about SQL Server on the shelves, and asks which books you'd recommend to people who are new to SQL Server  Read more...
By Brad McGehee 2011/08/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 340 reads

SQLServerCentral.com Best Practices Clinic: Part 5

In this article, Brad McGehee takes a brief look at four resource intensive queries that are running on the SQL Server instance that runs the SQLServerCentral.com website. Don't miss out on the competition in this article.  Read more...
By Brad McGehee 2011/08/02 | Source: SQLServerCentral.com | Category: sql monitor
Rating: |  Discuss |   Briefcase | 2,144 reads

Where Do You Go for Authoritative SQL Server Best Practices?

There is now a vast amount of SQL Server information and 'best practice' advice available on the Internet, in the form of innumerable blogs, community sites and forums. Finding an answer to your question is relatively easy, but finding the right, or best, answer is harder than ever.   Read more...
By Brad McGehee 2011/06/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 408 reads

SQLServerCentral Best Practices Clinic: Part 4

In this next installment looking at implementing best practices here at SQLServerCentral, Brad McGehee looks at a few performance counters and what they tell us about the performance of our database server.  Read more...
By Brad McGehee 2011/06/06 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 4,124 reads

SQLServerCentral Best Practices Clinic: Part 3

Part 3 of the analysis of the SQLServerCentral database cluster by MVP Brad McGehee. Follow along as he talks about some SQL Server settings and gives reasons why they should or should not be changed.  Read more...
By Brad McGehee 2011/05/11 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 3,713 reads

100% Microsoft?

This week Brad McGehee asks if your company is a 100% Microsoft software shop or if you are allowed to use third party software with your SQL Server.  Read more...
By Brad McGehee 2011/05/02 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 196 reads

SQLServerCentral Best Practices Clinic: Part 2

In part 2 of our best practices clinic, Brad McGehee looks at a couple of the items that were misconfigured on the SQLServerCentral database instances.  Read more...
By Brad McGehee 2011/04/13 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 4,972 reads

SQLServerCentral Best Practices Clinic: Part 1

We exposed the SQLServerCentral cluster for monitoring with SQL Monitor. Just like other companies, we have constraints on resources, and we have more work that needs to be done. Help us configure SQLServerCentral’s database servers with your suggestions on what is the highest priority for a website database back end.  Read more...
By Brad McGehee 2012/12/25 (first published: 2011/03/07) | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 22,603 reads

Getting Up To Speed on SQL Server Denali

Now that the Denali CTP has been out for several months, Brad asks how you're planning on getting up to speed on the latest version of SQL Server  Read more...
By Brad McGehee 2011/02/21 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 467 reads

How Do You Work When You are Not at Work?

Things have evolved since the days of essential pagers and landline connections. Or have they? Brad ponders how the nature of remote working is evolving, and invites you help others learn from your experiences.  Read more...
By Brad McGehee 2010/12/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 142 reads

When Times are Tough, Do You Rise to the Occasion?

Life isn't fair, and things don't always go your way. In fact, most people hit a tough patch sooner or later. When that happens to you, how do you respond?  Read more...
By Brad McGehee 2010/10/18 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 240 reads

Please don’t Tweet this, but…

Brad worries that with the advent and growth of social media, has come an increasing concern that today's private conversation may turn into tomorrow's world-wide Tweet.  Read more...
By Brad McGehee 2010/09/06 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 144 reads

Should DBAs Be the Protectors of Data?

Brad McGehee wonders whether DBA's should take a more active role in managing their organization's data, even if it means potentially ruffling a few feathers.  Read more...
By Brad McGehee 2010/07/05 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 250 reads

Are you preparing for SQL Server 2008 R2?

With the launch of SQL Server 2008 R2 almost upon us, DBAs need to start planning in some time to see what it has to offer. Brad McGehee reviews some of the available resources.  Read more...
By Brad McGehee 2010/04/12 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 504 reads

Taking Advantage of SQL Server Tools

How many of you are taking full advantage of SQL Server tools? Brad McGehee thinks the answer is "Surprisingly few", and suggests you take the time to learn, and eventually master, the tools which already come with SQL Server.  Read more...
By Brad McGehee 2010/03/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 438 reads
   Items 1 to 20 of 58    Older >>