{"id":50838,"date":"2024-08-14T09:00:00","date_gmt":"2024-08-14T16:00:00","guid":{"rendered":""},"modified":"2025-01-16T08:11:29","modified_gmt":"2025-01-16T16:11:29","slug":"modernize-microsoft-sql-server-2014-workloads-with-azure","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2024\/08\/14\/modernize-microsoft-sql-server-2014-workloads-with-azure\/","title":{"rendered":"Modernize Microsoft SQL Server 2014 workloads with Azure"},"content":{"rendered":"\n

We take pride in delivering innovation with each new version of Microsoft SQL Server. However, there comes a time when product lifecycles must conclude. As of July 9, 2024, SQL Server 2014 has reached its end of support. Many of our customers, including Scandinavian Airlines, have begun transitioning their SQL workloads to Microsoft Azure or are updating to SQL Server 2022. Their objective is straightforward: to modernize their databases and applications while accelerating innovation through using cloud technologies. <\/p>\n\n\n\n

\n

\u201cWith our migration to PaaS, we got what we wanted: greater scalability, reliability, security, agility in managing our IT infrastructure\u2014and greater peace of mind\u2014all without the cost and hassle of doing this ourselves,\u201d\u202f<\/p>\nDaniel Engberg, Head of AI, Data, and Platforms at Scandinavian Airlines System\u202f <\/cite><\/blockquote>\n\n\n

\n\t
\n\t\t
\n\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\"small\t\t\t\t<\/div>\n\t\t\t\n\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\n\t\t\t\t\t

Migrate to Microsoft Azure<\/h2>\n\n\t\t\t\t\t
\n\t\t\t\t\t\t

Boost productivity and enable innovation.<\/p>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\t

\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\tRead more<\/span>\n\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\n\t\t\t\t\t<\/div>\n\t<\/div>\n<\/div>\n\n\n\n

This blog post will guide you through several best practices our customers employed when faced with the SQL Server end-of-support moment. Customers have three choices for handling their out-of-support SQL Server workloads: moving or updating to Azure, upgrading to SQL Server 2022, or getting Extended Security Updates (ESUs) for additional preparation time. <\/p>\n\n\n\n

Migrate and modernize to Azure, a smooth path, a more powerful destination <\/h2>\n\n\n\n

Migrating to a cloud platform is an essential step on the journey to modernization, and there are many choices. What makes SQL Server and Microsoft Azure SQL unique is that it\u2019s built on the same engine, no matter where you deploy, which means you can build on your existing SQL experience while gaining the layered security, intelligent threat detection, and data encryption that Azure provides. <\/p>\n\n\n\n

Modernizing to Microsoft Azure SQL Managed Instance offers cost savings, scalability, security, seamless migration, productivity, and always up-to-date features. Some of the recent product highlights include <\/a>Azure SQL Managed Instance Next-gen General Purpose<\/a>, now in public preview, which supports twice as many Azure VMs configurations, making migration and modernization faster and easier than ever before for a larger number of customer scenarios. Customers can experience the full capabilities of managed SQL Server in the cloud at no cost for the initial 12 months with access to a General Purpose instance capable of accommodating up to 100 databases, along with 720 vCore hours of compute per month (non-accumulative) and 64 GB of storage through Azure SQL Managed Instance Free Tier,\u202f<\/a>now in public preview. <\/p>\n\n\n\n

Modernizing your SQL Server workloads to Azure also presents a chance to utilize cutting-edge innovation like Microsoft Copilot. Microsoft Copilot in Azure<\/a> has extended its capabilities to Microsoft Azure SQL Database with new skills designed to enhance the management and operation of SQL-based applications.  <\/p>\n\n\n\n

Extending end-of-support time<\/h3>\n\n\n\n

If you are ready to move to the cloud but feel 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\u202fMicrosoft Azure Virtual Machines<\/a>. Free Extended Security Updates are available for Azure Virtual Machines including Microsoft Azure Dedicated Host, Microsoft Azure VMWare Solution, Nutanix Cloud Clusters on Azure, and Microsoft Azure Stack (Microsoft Azure Stack Hub, Microsoft Azure Stack Edge, and Microsoft Azure Stack HCI). Combining Extended Security Updates in Azure with Azure Hybrid Benefit<\/a> further reduces your costs. With these pricing advantages, AWS\u202fis up to five times more expensive<\/a>\u202fthan Azure for SQL Server and Windows Server end-of-support workloads. <\/p>\n\n\n\n

In-place upgrade to SQL Server 2022 <\/h2>\n\n\n\n

Another way to stay protected is to upgrade your SQL Server to\u202fSQL 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

SQL Server 2022 is the most Azure-enabled release of SQL Server, with continued innovation across performance, security, and availability. Gain deeper insights, predictions, and governance from your data at scale. Take advantage of enhanced performance and scalability with built-in query intelligence. <\/p>\n\n\n\n

Stay protected on-premises or in multi-cloud environments with Azure Arc <\/h2>\n\n\n\n

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

We\u2019re continuing to enhance the capabilities Azure Arc offers to Extended Security Updates. Just recently, physical-core licensing<\/a> with unlimited virtualization was released for SQL Server 2012 and 2014 ESUs. For customers who need to maximize database performance or require security isolation and better resource management, physical core licensing provides a more cost-effective way to leverage Extended Security Updates via Azure Arc. <\/p>\n\n\n\n

Also, if you enabled ESU subscription in your production environment managed through Azure Arc, you can enable SQL Server ESU subscription in the non-production environment<\/a> for free, through SQL Server Developer Edition or an Azure dev\/test subscription. <\/p>\n\n\n\n

We encourage all our customers running SQL Server 2014, Windows Server 2012, and Windows Server 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

Learn More <\/h2>\n\n\n\n