Why Every DBA Needs a Buddy

John Sansom, 2011-01-18

If you truly desire to be an effective SQL Server Database Administrator then you absolutely must have a buddy.

SQL Server is a huge product that is packed full of features to the extent that no one individual can be an expert in all areas. You’re going to need help!

The Incredible Value of Peer Knowledge

The fact that no one individual can master all there is to know about SQL Server to expert level means that the knowledge of “other” experts is of exceptionally high value to you, so much so in fact that you may find yourself unable to proceed with your task without it. We’re always hearing about how important and valuable experience is, particularly from the job market, and the more of it that you have and have access to, the better.

Your Data is Your Most Valuable Asset

Don’t believe me, read The Database Administrators Primary Responsibility. It should be clear to every DBA that proceeding ahead on any task without complete and absolute certainty of what’s involved and what the expected outcome is, would be putting your data at unnecessary risk. Put simply, this is something that you just do not want to be doing.

keep your data safe

“Keep your data safe”

The Power of Your Buddy

With your very own SQL Buddy or even better Buddies, each with their own areas of expertise,  you gain the potential to tap into an incredibly valuable expert knowledge resource and in turn the opportunity to take further steps towards avoiding putting your data at unnecessary risk.

Some of the powerful ways that your Buddies can work with you include:

  • As a sounding board for your ideas
  • To provide you with a valuable second opinion
  • To act as a safety net and perform peer reviews
  • Access to experience and expertise in other areas of the product

You’ve designed your latest index optimization process and tested it thoroughly in your development environment. Does that guarantee that it will work just fine in Production? Absolutely not, there are no guarantees of success short of when it actually works in Production, which is why a second pair of eyes to review your work can be an incredibly valuable asset to you. It’s inevitable that you will make mistakes and having a Buddy can be the difference between it actually costing you or being caught as a simple matter of process.

How to Get Your Own Buddy

Your choice of buddy is often determined by the colleagues and professionals you have close proximity to. Here are some of the places that you may wish to look when seeking to find your very own buddy.

Every DBA Needs a Buddy

SQL Buddy anyone?

  • Partner up with existing team members
    • This can be one of the best sources available to you. These guys already know how your business works and will already have a good understanding of what it is you need from a buddy, for example when providing peer reviews, additional testing and quality control.
  • Find a Buddy in an alternative data focused department within your organisation
    • If finding a Buddy in your existing team is not an option to you, larger organisations will often have departments and teams that provide a similar service and work with technology similar to your own. For example DBA’s that work in the Database Operations Team could partner up with their colleagues in the Datawarehousing /Reporting / Analysis or Database Development Teams.
  • Consider the possibility of a Buddy in a similar department, such as IT Operations for example. These Buddies can be brilliant for growing your knowledge and experience into similar IT disciplines, not to mention developing a greater understanding of your business operations. The types of professionals that you might want to consider could include:
    • Senior Server Administrators
    • DB Developers
    • Senior Software Developers
    • System Architects
  • The SQL Server Community is an awesome resource in itself
    • It may not be a suitable place to discuss the intricate details of your business specific case details but it can certainly be used for abstract discussion and support. There are a wealth of resources available to you including:
      • Community websites such as SQL Server Central
      • Any number of the great SQL Server Forums out there. Check out My Top 5 SQL Server Forums
      • Leverage #SQLHELP on Twitter
      • You can even ask me, seriously! I would much rather you ran an idea or a query you have past me at any time, than for you to potentially put your environment and data at unnecessary risk.

Obviously your buddy will not be able to assist you in all areas of SQL Server for the very same reasons that you are seeking a buddy in the first place. For this reason it’s important to know when to work with a particular buddy. A Senior Server Admin is probably not going to be able to assist you with performance tuning T-SQL code but could provide you with a valuable peer review/second opinion when planning for new server build for your environment.

So What Are You Waiting For?

It’s important to remember that finding a buddy and forging a good relationship is a two way street. To ensure that you get the most out of the relationship you must reciprocate the support and knowledge sharing effort. The more you put in the more you will get out. Through collaboration you can consistently produce higher quality deliverables and improve the safety of your data assets.

By now it should be clear to you that every DBA can benefit from having a buddy, so what are you waiting for? Get out there, make new connections and start investing in the protection of your data assets.





Related content

Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.

Robert Davis


1,567 reads

Networking – Part 4

You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I’d like to talk about social networking. We’ll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let…

Andy Warren


1,530 reads

Speaking at Community Events – More Thoughts

Last week I posted Speaking at Community Events – Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I’ve got a few more thoughts on the topic this week, and I look forward to your comments.

Andy Warren


360 reads