Question of the Month

As a SQL Server DBA, you often work on your own, and sometimes it’s difficult to find someone you can exchange your tips and tricks with. So I’m offering a little competition on my blog with the aim to help each other become exceptional DBAs by sharing our knowledge. Every month, I’ll ask a database administration themed question, and you’re invited to post your answer. At the end of the month, a winner will be randomly selected and you’ll have an opportunity to win a prize (for example, a license for a Red Gate SQL Server tool). All answers to the question will be linked to from this page, and we can start building a bank of solid community tips and best practices!

Get started, and find out what the prize is, by clicking below.

February 2012: If you weren’t a DBA, what would you like to do?

January 2012: What features(s) of SQL Server would you like to learn more about?

December 2011: When reflecting on this year, what has gone well, and what would you do differently?

November 2011: What is your favorite, and not so favorite hardware to run SQL Server on?

October 2011: What one thing do you feel has the greatest impact on SQL Server’s performance?

September 2011: Tell us about your DBA interview experiences: good and bad.

August 2011: How do you manage your Transact-SQL Scripts?

July 2011: What do you think are the most common DBA pain points?

June 2011: How do you monitor your SQL Servers?

May 2011: What’s your backup strategy?

April 2011: Which high availability options(s) do you employ for your SQL Server instances, and why did you choose them?

March 2011: What’s Your Biggest SQL Server Performance Headache?

February 2011: Share with us your “best” restore disaster stories.

January 2011: As a DBA, how do you manage your disk space?

December 2010: What does it mean to be a Proactive DBA?

November 2010: What steps do you include in your database maintenance?

October 2010: Tell us about your favorite experience as a participant in the SQL Server community.

September 2010: What feature is missing from SQL Server that you would most like to see included in the next release?

August 2010: What types of continuing education do you use to keep up with being a DBA?

July 2010: Tell us your story of how you happened to become a DBA.

June 2010: What is your best advice for boosting index performance?

May 2010: What is your favorite DBA joke?

April 2010: What advice would you offer a novice DBA in order to help them along in their career?

March 2010: What is the biggest mistake/problem you have ever found on a SQL Server instance, and how did you fix it?

February 2010: What is one of your best practices for making full backups and transactions log backups of your production databases?

Be Sociable, Share!


    Copyright 2009-2011 Brad M McGehee