March 18


Who uses sql database support?

By Charles

March 18, 2017

sql database support

It seems like a silly question, obviously organisations that use SQL databases but what organisations and what size are they?

SQL Server users

Since SQL Server has had an express edition (formerly Desktop Edition) available for customers to use for free its use has grown massively. More and more software has used it as the back end to store application data and settings. This has lead to the mass adoption of SQL server in businesses and organisations around the world. Once the organisation has outgrown the server there is an easy upgrade path through standard edition then enterprise edition.

What size business?

As Managed SQL Server has several different editions it caters for all size businesses so it will not come as a surprise that all businesses are likely to need SQL database support. Small businesses may just have SQL Server running one express edition instance possibly used for Backup Exec or an industry specific piece of software.

Medium sized businesses are more likely to have multiple databases possibly consisting of internally written software which needs more support. As databases change the older they get this can show up as performance issues. If processes are not setup to re-index and update statistics regularly performance can degrade over time. It is likely a part time DBA (Database Administrator) will be looking out for the database server. A developer or infrastructure engineer may also be tasked with this responsibility.

Large businesses particularly those grown by acquisition can end up with server sprawl. Dozens and even hundreds of SQL instances spread all over the place leading to massive licensing costs. Generally large enterprises have a team of DBA’s to monitor and maintain the databases.

Not my job

Occasionally you find or hear the phrase not my job or not my role in a department. First of all this is exceptionally poor to hear but it usually comes around as no one wants to get blamed for breaking anything. With training this can be removed as an excuse. The other alternative is to hire someone to fill that missing skill set or outsource the role completely.

Why outsource?

I’m not going to lie DBA’s are expensive. A simple job search can show average salaries in London of £70k even outside London average salaries are around the £50k mark.

What if we get a junior DBA? This is a possibility but I would highly recommend not hiring a skill set that you have little or no experience with internally. How would you know if they were any good or not? Think about it for a few minutes would you want to leave one of the most important roles which looks after every single piece of business critical data your business has to someone who is new to the role?

Outsourcing to an experienced Microsoft Partner is your best way to go. You can even get an out of hours service giving your business 24/7 access to DBA’s in emergencies. This is the most cost effective way to get the skills your business needs without the worry of finding someone with the right but unfamiliar skill set.

SQL Database support

For a quote to cover sql database support get in touch and we can discuss your requirements.

About the author

Microsoft Certified SQL Server DBA with over a decades experience including work for large FTSE 250 companies amongst others. The SQL Server stack has been the focus of almost all of my career in IT. I have experience designing, supporting and troubleshooting large Data Platform deployments.

You might also like

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}