{"id":49481,"date":"2023-09-28T08:00:00","date_gmt":"2023-09-28T15:00:00","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=49481"},"modified":"2024-07-11T13:59:16","modified_gmt":"2024-07-11T20:59:16","slug":"protect-sql-server-2014-workloads-with-azure-flexibility","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2023\/09\/28\/protect-sql-server-2014-workloads-with-azure-flexibility\/","title":{"rendered":"Protect SQL Server 2014 workloads with Azure flexibility"},"content":{"rendered":"\n

Blog updated on July 11, 2024<\/em><\/p>\n\n\n\n

SQL Server has brought reliability and security to mission-critical workloads for 30 years. SQL Server 2022<\/a>, released November 2022, delivers performance enhancements as well as Azure connectivity for disaster recovery, analytics, and governance. Now customers like Mediterranean Shipping Company<\/a> (MSC) are using SQL Server 2022 to expand their capabilities to better support a truly worldwide operation.<\/p>\n\n\n\n

\n

\u201cFeatures like Query Store hints and the next generation of Intelligent Query Processing are awesome. The possibility of improving and maintaining great performance over time without code changes is getting better on every new SQL Server version\u201c<\/p>\n\u2014Javier Villegas: IT Director for DBA and BI Service, Mediterranean Shipping Company<\/cite><\/blockquote>\n\n\n\n

We love delivering innovation with each new version of SQL Server. But all good things must come to an end: SQL Server 2014 has a ten-year product lifecycle<\/a>, and after this time product support and regular security updates cease. SQL Server 2014 reached end of support on July 9, 2024.<\/p>\n\n\n\n

The upcoming end-of-support milestones are an opportunity to evaluate your business needs and modernize your IT estate. To provide you with the flexibility to stay secure while you plan for the future, we are announcing a new option to help you manage this transition: SQL Server 2014 Extended Security Updates will offer up to three years of critical security updates. Extended Security Updates<\/a> are free for workloads running in Azure. The updates will be offered for sale to use on-premises and in multicloud environments.<\/p>\n\n\n\n

Just as with SQL Server 2012, Extended Security Updates for SQL Server 2014 offers an enhanced cloud experience through Azure Arc. <\/strong>Year 1 coverage from Extended Security Updates started on July 10, 2024. With this more customer-centric approach, security updates will be natively available in the Azure Portal through Azure Arc. This also provides Azure benefits and flexible subscription billing for SQL Server 2014 workloads on-premises or in multicloud environments.<\/p>\n\n\n\n

Your options in end of support moments<\/h2>\n\n\n\n

Customers have multiple options for the SQL Server in their data estate that is nearing the end of support. These options include migrating or modernizing to Azure, upgrading to SQL Server 2022, or purchasing Extended Security Updates if more time is needed before the upgrade or migration.<\/p>\n\n\n\n

Modernize to Azure for the latest database features<\/h2>\n\n\n\n

Modernize your SQL Server by migrating to the always up-to-date Azure SQL Managed Instance, which upgrades and patches automatically. Azure SQL Managed Instance<\/a> is an intelligent cloud database service combining the broadest SQL Server engine compatibility\u2014all the way back to SQL Server 2008\u2014with the benefits of a fully managed database as a service. SQL Server licenses with Software Assurance are eligible for Azure Hybrid Benefit<\/a> to help you reduce the costs of moving to Azure SQL Managed Instance.<\/p>\n\n\n\n

Migrate to Azure, and get Extended Security Updates at no additional cost<\/h2>\n\n\n\n

If you are ready to move to the cloud but challenged to upgrade or modernize before the end of the support timeline, Extended Security Updates are available for free in Azure for SQL Server 2014 and 2012 and Windows Server 2012. Secure your workloads for up to three more years after the end of the support deadline by migrating applications and SQL Server databases to Azure Virtual Machines<\/a>. Free Extended Security Updates are available for Azure Virtual Machines including Azure Dedicated Host, Azure VMWare Solution, Nutanix Cloud Clusters on Azure, and Azure Stack (Hub, Edge, and HCI). Combining Extended Security Updates in Azure with Azure Hybrid Benefit<\/a> further reduces your costs. With these pricing advantages, AWS is up to five times more expensive<\/a> than Azure for SQL Server and Windows Server end-of-support workloads.<\/p>\n\n\n\n

Stay protected on-premises or in multicloud environments<\/h2>\n\n\n\n

Another way to stay protected is to upgrade your SQL Server to SQL Server 2022<\/a>, the most Azure-enabled release yet. Get more out of your data with enhanced security, industry-leading performance and availability, and business continuity through Azure.<\/p>\n\n\n\n

Customers who cannot meet the end-of-support deadline and have Software Assurance or subscription licenses will have the option to buy Extended Security Updates to get three more years of security updates.<\/p>\n\n\n\n

For SQL Server 2012, Windows Server 2012\/R2, and starting this year SQL Server 2014, customers can protect their workloads with Extended Security Updates enabled by Azure Arc. With Azure Arc, organizations will be able to activate and seamlessly deploy Extended Security Updates in on-premises or multicloud environments, right from the Azure portal.<\/p>\n\n\n\n

Extended Security Updates for SQL Server enabled by Azure Arc provide visibility of your entire SQL estate, automate repeatable updates and patches, and can enhance security and data governance with Azure services. It is offered as a monthly subscription which will automatically stop when you migrate or upgrade\u2014pay only for what you need. Planned pricing* of SQL Server 2014 Extended Security Updates<\/strong> enabled by Azure Arc* <\/p>\n\n\n\n

Monthly Rate** <\/td>On-premises or across multicloud via Azure Arc <\/td>On Azure***<\/td><\/tr>
Enterprise \u2013 2 cores <\/td>$1,080 <\/td>Free <\/td><\/tr>
Standard \u2013 2 cores <\/td>$277 <\/td>Free <\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Get started planning Windows Server 2012 and SQL Server 2014 end of support<\/h2>\n\n\n\n

We encourage all our customers running SQL Server 2014, Windows Server 2012, and 2012 R2 to start planning for the end of support. We have migration resources, best practices, and more as well as a rich ecosystem of partners ready to help. To get started, please visit the following pages to learn more:<\/p>\n\n\n\n