In this blog, we look at the different SQL Server versions along with the corresponding end of support and the overall SQL lifecycle. The first SQL Server was released in the year 1989 as SQL Server 1.0. Since then we have seen regular releases until the latest – SQL Server 2022 which is out as release candidate 1 and due for general availability by the end of the year.
If you have been using SQL Server for some time, you may not be tracking with which SQL version you are using, when support runs out, until when extended support is offered and so on. So we are going to cover all the end-of-support dates for each SQL version here.
SQL SERVER VERSIONS
This is a full rundown of each SQL version, its release date, end of mainstream support and end of extended support, also known as end of life. You can also see easily which versions are presently covered by support.
SQL SERVER AND WINDOWS SERVER
Using unsupported SQL servers is one issue, but as SQL Server relies on Windows, another security risk is opened up if you are relying on an older out-of-support Windows version.
Here is a useful guide on which Windows Server/Windows each SQL Server version supports.
In this table, you can see each Windows Server version, its release date, end of mainstream support and end of extended support. You can also easily see which versions are presently under support.
SQL Server Update – When is it due?
Using the information above and as needed using the directions in this document (Determine the version, edition, and update level – SQL Server) you can see if you are using an out-of-support version of SQL Server or the accompanying Windows Server.
Recently passed important dates for SQL Server updates:
- 11th July 2022 end of extended support for SQL Server 2012
- 9th October 2022 end of mainstream support for Windows Server 2012
- 11th October 2022 end of mainstream support for SQL Server 2017
Forthcoming dates for SQL Server updates to be aware of:
- 10th October 2023 end of extended support for Windows Server 2012
- 9th Jan 2024 end of mainstream support for Windows Server 2019
- 9th July 2024 end of extended support for SQL Server 2014
All earlier versions are not within either support or extended support, meaning applications are at risk. Here you can see what you may be missing.
MAINSTREAM SUPPORT
This is the main life of a product, on occasion you will see cumulative updates and you can request design changes and new features. Moreover, you can open support tickets, get security updates, security support, non-security fixes etc.
EXTENDED SUPPORT
During this stage, you can open paid support tickets and get security updates. However, no non-security fixes, features or design changes will be acted upon. There are no updates during extended support.
You can read more about what the fixed lifecycle looks like at Microsoft in this policy: Fixed Lifecycle Policy | Microsoft Docs
EXTENDED SECURITY UPDATE PROGRAMME
This programme is the final recourse for organisations that need to run legacy applications past the cut-off for extended support. It is called the Extended Security Update (ESU) programme. It only consists of critical and sometimes important security updates.
This programme is only available by purchase and not offered on all products. Currently, it is available for some Windows Server versions and SQL Server 2012. You can find out more here: FAQ – Extended Security Updates | Microsoft Docs
A NOTE ABOUT SQL Server Updates
Due to the nature of SQL Server updates, you can’t always make the jump from an old SQL Server version to the most recent. Take migrating SQL Server 2008 to SQL Server 2019, for example. It requires a migration to something like SQL Server 2016 first, and then from there, the migration to SQL Server 2019 becomes possible. Alternately, at that point, making the jump to the cloud and Azure SQL would be the logical modernisation jump – making the most of available cloud capabilities.
We have explored SQL Server and Azure SQL in some recent blogs. You can get some insight into staying on SQL Server or migrating to Azure SQL here:
- Migrating off SQL Server 2012
- Tips to Migrate from SQL Server to Azure SQL
- Azure SQL Options– What to Use and When
SQL Server MIGRATIONS AT BALLARD CHALMERS
You can see an example of our SQL Server work in this case study or take a look at our SQL Server expertise at Ballard Chalmers. Do get in touch for a free consultation or to find out how Ballard Chalmers can help.