Learn more about SQL Server tools



solving sql server problems for millions of dbas and developers since 2006 join MSSQLTips for free SQL Server tips
































Top SQL Server Tools



































   Got a SQL tip?
            We want to know!

SQL Server DBAs' Value to the Organization

MSSQLTips author Jeremy Kadlec By:   |   Read Comments (6)   |   Related Tips: More > Professional Development Career
Problem

In many organizations the SQL Server DBAs are among the unsung heroes in the IT Department and overall organization.  Often times their contributions are unknown and overlooked.  It this tip I would like to outline some of the value I have seen SQL Server DBAs contribute to the organization in business terms.

Solution

Before we jump into the value delivered by SQL Server DBAs, I would like to clarify that at some organizations there is a single SQL Server DBA while at other organizations there is a team.  While at other organizations, Network or Systems Administrators and/or Developers tend to SQL Server's administration.  So in this tip, the value from the SQL Server DBA is from any professional administering SQL Server, not just professionals with a "SQL Server DBA" title.  With that being said, let's dive right into some areas where I have seen SQL Server DBAs provide value to the organization:

  • Hardware savings
  • Licensing savings
  • Code maintenance savings
  • Legal cost savings
  • Reputation protection
  • Highly productive users
  • Business continuity
  • Decision making

Build high performing SQL Server systems

Don't take for granted following SQL Server development best practices because often those items can translate into a business benefit.  By designing and building efficient code, this enables the business to purchase lower cost hardware and minimal licensing then scale the hardware and licensing costs as the application needs grow.  This same code is also a significant cost savings for the business in terms of team members to maintain the code.  A well planned and written application generally requires significantly less time and budget to maintain than an application built in haste. 

Keep in mind high performance generally keeps users happy.  For internal users that can translate into high productivity, a positive attitude with external customers and confidence in the organization.  For externally facing applications, a smooth user experience generally speaks volumes for the organization.  The reality of quantifying "happy" versus "frustrated" users as well as loyal customer base is a tough calculation, but I am sure everyone can agree which side of the fence they would like to be on.

Secure SQL Server data helps to prevent data breaches

As of the publishing of this tip, there have been recent data breaches involving personally identifiable data and credit card data that have reached the main stream media in the United States.  In general, SQL Server DBAs are security conscious and have a natural affinity to protect the data online and offline.  The SQL Server DBAs value to the organization is the cost savings associated with legal remedies, lost revenue from a customer selecting a competitor and intangible costs related to your brand's reputation associated with the data breach.

SQL Server Redundancy and Uptime

99% or greater uptime is no mistake.  There is no "luck" associated with this amount of uptime year after year.  To achieve these sorts of results with 24X7 demands requires a great deal of cooperation and coordination among numerous professionals in the IT department.  Although any number of components could fail and cause downtime, the complexity of SQL Server redundancy plays a major role in the equation.  Once again the quantifiable costs associated with idle users per hour can probably be calculated, but the intangible cost related to your brand's reputation with extended or repeated downtime can be difficult to quantify.  I am sure everyone can agree that each 404 error costs more than four hundred pennies.

Extend the life of a SQL Server platform

Hardware and licensing costs are generally a significant portion of any IT department's budget.  By SQL Server DBAs tuning code, re-writing processes, archiving data, etc. these sorts of projects can extend the life of the platform yielding significant cost savings in terms of hardware and licensing costs.  In many circumstances, the SQL Server DBAs are able to single handedly resolve performance issues and deliver immediate benefits to the business not just in terms of the hardware and licensing costs, but also provide users with a better experience with the application.

Build and maintain SQL Server systems for decision making

Those dashboards, morning reports, reporting systems, analytics and more, needed to drive business decisions are sometimes built and are generally maintained by SQL Server DBAs.  At many organizations this data is the operational lifeblood to the company and the basis for numerous decisions across the organization.  Accurate and timely data is generally where the SQL Server DBAs deliver value.

Ability to recover from a SQL Server disaster

We have covered fault tolerance in a previous section.  In this section I want to cover disaster recovery.  The reality is that these two items are at times confused and the terms are used interchangeably.  In my opinion fault tolerance is related to a single point of failure causing SQL Server to no longer support the business and disaster recovery is related to numerous points of failure across the infrastructure, data center, site, campus, etc.  In these disaster recovery circumstances, the SQL Server DBAs provide value by being able to work with the remainder of the IT team to bring a separate set of systems online to support the business and minimize the data loss.  In terms of costs savings, the downtime associated with a true disaster recovery scenario sometimes relates back to the organization being able to survive the disaster and continue business operations in hours or days rather than weeks or never.

Next Steps
  • The reality is it takes a team to deliver value to the organization.  The SQL Server DBAs are just one small piece of the overall equation.  So hopefully the value outlined in this tip reflects the value of the IT department to the organization as much as it highlights the value of the SQL Server DBAs.
  • Are there other areas where SQL Server DBAs deliver value to the business?  Share your thoughts in the comments for this tip.
  • Check out all the SQL Server Professional Development tips.


Last Update: 4/27/2012


About the author
MSSQLTips author Jeremy Kadlec
Jeremy Kadlec is the CTO @ Edgewood Solutions, co-founder of MSSQLTips.com, Baltimore SSUG co-leader and SQL Server MVP since 2009.

View all my tips
Related Resources


print tip Print  
Become a paid author





join MSSQLTips for free SQL Server tips     



Comments and Feedback:
Friday, April 27, 2012 - 9:14:16 AM - Rajasekhar Read The Tip

Hi Kadlec,

I was the regular follower of yout Tips.Your Tips are awesome and thought provikings.The people who want to be settle their life as SQLServerDBA, really very usefull.Among all the tips this is the quite awesome.

Thanks for posting!!!


Sunday, April 29, 2012 - 10:14:29 PM - James Read The Tip

Hi Jeremy

 

Thanks for this great post. Just a small thing that nags me in the title which I had to reread a few times to understand. It should be 'SQL Server DBAs' value to the Organization'. Note the apostrophe.


Monday, April 30, 2012 - 10:07:51 AM - Jeremy Kadlec Read The Tip

James,

Thanks for catching that.  I have updated the tip title.

Thank you,
Jeremy Kadlec


Wednesday, May 16, 2012 - 9:36:42 AM - tcstl Read The Tip

Here is the most overlooked value any DBA should bring...........

Unserstand the proceses and data in relation to ths business.  Any decision the DBA may few as secondary could be of the highest value to the company.  WHen in a fire drill unserstand what is important to the company, not just your parochial vision of what the issues are.


Wednesday, May 16, 2012 - 10:16:10 AM - Jeremy Kadlec Read The Tip

tcstl,

Thank you for the comment.

DBAs\Developers\IT Professionals add a great deal to the organization.

Thank you,
Jeremy Kadlec


Monday, November 26, 2012 - 2:06:32 PM - tcstl Read The Tip

*** NOTE *** - If you want to include code from SQL Server Management Studio (SSMS) in your post, please copy the code from SSMS and

I agree must understand the data and processes, you can always find a technical solution on google, not going to work for data and processes



Post a Comment or Question

Keep it clean and stay on the subject or we may delete your comment.
Your email address is not published. Required fields are marked with an asterisk (*)

*Name   *Email Notify for updates



Comments
Get free SQL tips:

*Enter Code refresh code


 
Sponsor Information







Copyright (c) 2006-2014 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | about
authors | contribute | feedback | giveaways | free t-shirt | user groups | community | events | first timer?
Some names and products listed are the registered trademarks of their respective owners.