Making SQL sense

+44 (0)20 3051 3595 info@coeo.com
coeoClose

Making SQL sense

+44 (0)20 3051 3595 info@coeo.com

Careers

We're looking for people who share our commitment to excellence in Microsoft's data platform to join us consultants working on exciting business intelligence, analytics, and SQL Server projects on-premises and in the cloud.

SQL Server 2008: The Final Countdown

The Coeo Blog

SQL Server 2008 and 2008 left Extended Support on 9th July 2019. In the latest episode of the Coeo Conversations Podcast Sales and Marketing Director James talks about the issue and explores the options available to businesses.

Rocket - Daniel Mayovskiy

What is End of Support?

All Microsoft products sold as a boxed product solution go through three stages of support:

  • Mainstream Support – the product receives bug fixes and security updates
  • Extended Support – only security updates are provided
  • End of Support – after 10 years the product no longer receives security updates

The biggest risk of running applications on an unsupported platform is security. Those choosing to use an unsupported platform will need to pay to continue to receive security updates, so many companies choose to look at the benefits of modernisation versus staying on their existing platform.

We advise that companies look at the lifecycle of their whole estate, and not just their software. Businesses may find that the point where hardware comes out of support or rent comes up for renewal is a natural opportunity to move to the Cloud.

 

Application Compatibility, Migration and Upgrading

There are two main types of application used by businesses: vendor supplied applications and applications written in-house. 

Vendor Supplied Applications

These applications normally come with some kind of pre-requisite in terms of the type of software that supports them. So, if you want to upgrade your SQL Server and operating system, you'll probably need to upgrade the application too.

Although the migration itself is tends to be fairly seamless, we often see issues involving change management crop up due to new features or user interfaces that are introduced in newer versions of the application.

Applications written in-house

Companies have control over applications that have been created in-house, as well as a greater understanding of their boundaries. For these reasons they often create less friction during a SQL Server upgrade, although some remediation work may need to be done to ensure they're running on the latest framework.

Data Platform Migration and Modernisation

There are two options for remaining on SQL Server 2008:

  • Remain on-premises and pay 75% of license fee for Extended Security updates
  • Migrate into a Virtual Machine in Azure and receive free Extended Security for three years

For those looking to upgrade, they can choose to:

  • Move to Platform as a Service (PaaS)
  • Move to Azure with minimal changes

 

You can find out more about these options and Coeo's four-step technique for modernisation by downloading our SQL Server 2008 whitepaper.

 

Licensing

Licensing is a big consideration to make, especially for organisations who are already heavily invested in it. However, you can make significant cost savings, especially if you already have licenses for On-Premises estates.

There are a number of options available when moving to Azure:

  • Pay As You Go - the most expensive and the most flexible option
  • Azure Hybrid Benefit - available for companies with an Active Enterprise Agreement or Server and Cloud Enrolment Agreement
  • Moving Licenses from On-Premises estates
  • Reserved Instances - companies can now pay in advance for continuous server usage

 

Find out more about SQL Server 2008

You can find out more information about SQL Server 2008 End of Support on the Microsoft website, as well as Coeo's SQL Server 2008 pages.

Listen to the latest episode of the Coeo Conversations Podcast on Apple Podcasts, Buzzsprout, or Spotify.

 

Subscribe to Email Updates