Stop the SQL Server 2008 panic!

By Sean
17th January 2019

Upgrades and migration are not the only way forward.

With Microsoft officially retiring one of its most commonly installed SQL Server products and ending any support or further security patches for SQL Server 2008 and 2008 R2, companies are left with what appears to be the only available solution: upgrade their SQL Server Database.

This is, in fact, Microsoft’s recommendation.

However, not all businesses are in immediate need of changing their current software version. If you are considering your options, here are a few reasons why you might not want to change, at least not yet:

  • Your application runs perfectly fine on this version and you don’t have time to run the required testing for an upgrade.
  • Upgrades require possible downtime. This might cause disruption to the business, without bringing an immediate benefit.
  • You do not have the in-house expertise required to carry out this upgrade.
  • You own the hardware that runs 2008. In this specific case, a newer version of your Database might require new hardware, with all the related additional expenses.
  • You own the license for SQL Server 2008 and do not wish to spend on further licenses.
  • A SQL Server upgrade may be part of a larger strategy in the transformation of the business, therefore a database update is not an immediate priority.

If any of the above applies to you, you might want to hold off upgrading your SQL Server for now.

Does this mean that you would have to stay without SQL Server database support?

Not necessarily.

You should in the first instance purchase extended security updates for those systems you do not intend to upgrade or migrate to Azure for free extended security updates.

At WellData we are experienced in all versions of SQL Server from 6.5 to 2017. We do not expect our existing or new clients to upgrade and will continue to support them no matter what version of SQL Server database software they use. In fact, we can also help you understand your requirements and assist in making an informed decision on whether you need to update now or not.

But what if you do want (or need) to upgrade?

Undoubtedly there are several very valid reasons to upgrade your SQL Server:

  • An overall more efficient system, with increased speed for transactions and queries.
  • Options to move to cloud services.
  • New features available, such as scalability, real-time analytics, and mobile Business Intelligence (SQL Server 2017).
  • Cross-platform compatibility, which means that SQL Server now doesn’t cover only Windows but also Linux, Mac OS and Docker (SQL Server 2017).
  • Increased security through patches and service packs. SQL Server 2017 in particular offers a new security feature known as CLR strict security

Some of the original concerns listed above, like the lack time, the lack of in-house expertise, or the risk of downtime, might still put you off from upgrading your SQL Server Database but with the right partner, this doesn’t need to be a daunting task.

When the time is right, WellData will assist in the planning and migration to a newer, more secure and up to date version.

Contact us now for SQL server database support or to upgrade your SQL Server.

 

Oracle open world
Sean Rodgers

Sean Rodgers is WellData’s Commercial Director. With over 18 years of experience in database management and IT operations, Sean supervises and mentors our Database Administrators to ensure that our clients get personalised care and cutting-edge solutions for their IT requirements.

Get in touch

<< Back to Articles

Join Our Newsletter

Contact Email  *
First Name 
Last Name 
*Required Fields
I agree to the  Privacy Policy and  Terms of Use 

Here's what other people think

Google Rating
5.0
High standard, professional service. I've worked with Welldata for a number of years and always found their DBA's to be knowledgeable and proactive. Throw any question at them and it will be resolved, it gives real peace of mind knowing you have a partner you can rely on from emergencies to general questions. They also like a challenge and we do throw a few curved balls at them.read more
Paul Miller
Paul Miller
12:34 27 Aug 21
The support I receive from Well Data is extremely responsive. Richard Parsons is my contact and keeps me informed daily on the health of our SQL Databases. Whenever I ask for assistance from Well Data it is quick and professional.read more
Kay Riley
Kay Riley
13:41 19 Aug 21
Really know their stuff and their response times are very good. They provide us with a vital service.
Andy Cole
Andy Cole
13:36 19 Aug 21
The guys at WellData really know their stuff. We wanted a quick route to doing something complex and they sorted it for us very quickly and to a high standard. Very professional, no ego, just excellent and to the point consultancy.read more
Steve Goacher
Steve Goacher
11:31 14 Nov 19
I have worked with the WellData team for many years now and they have always delivered.I would highly recommend them to any business looking for best-value outsourced Expert DBA’s.Being able to offer a rolling contract on the basis that if they don’t deliver you can leave shows their confidence and commitment.Their professionalism and knowledge is second to none.read more
Petro Bartoszyk
Petro Bartoszyk
08:51 18 Oct 19
A very dedicated team of extremely professional and knowledgeable experts
Giulia Iannucci
Giulia Iannucci
14:08 16 Nov 18
We use Welldata for SQL support and are very happy with their service.
David Sadler
David Sadler
09:40 15 Nov 18
Really know their stuff and their response times are very good.
Andy Cole
Andy Cole
11:45 06 Nov 18
Our partnership with WellData has enabled us to resolve critical database problems. Their attitude and service makes them a natural extension to our own technology team, which extends our capability in a critical area of our business.read more
Steve Fenton
Steve Fenton
10:56 05 Nov 18
Having worked with the team at Welldata for approaching 17 years, my company and I have always found them professional, reliable and generally a great firm to work with.read more
John Lynes
John Lynes
14:00 04 Oct 17
WellData provide an excellent level of support and their team are very knowledgeable and always go the extra mile. I would wholeheartedly recommend them.read more
Stefan Parrott
Stefan Parrott
13:12 19 Sep 17