Debbi Lyons, Author at Microsoft SQL Server Blog http://approjects.co.za/?big=en-us/sql-server/blog Official News from Microsoft’s Information Platform Thu, 19 Mar 2026 23:32:24 +0000 en-US hourly 1 http://approjects.co.za/?big=en-us/sql-server/blog/wp-content/uploads/2018/08/cropped-cropped-microsoft_logo_element-150x150.png Debbi Lyons, Author at Microsoft SQL Server Blog http://approjects.co.za/?big=en-us/sql-server/blog 32 32 Innovation spotlight: How 3 customers are driving change with migration to Azure SQL http://approjects.co.za/?big=en-us/sql-server/blog/2025/10/20/innovation-spotlight-how-3-customers-are-driving-change-with-migration-to-azure-sql/ Mon, 20 Oct 2025 16:00:00 +0000 Learn how Microsoft Azure SQL Managed Instance helps organizations move from legacy constraints to a scalable and secure AI-ready foundation.

The post Innovation spotlight: How 3 customers are driving change with migration to Azure SQL appeared first on Microsoft SQL Server Blog.

]]>
Organizations are under constant pressure to modernize their estate. Legacy infrastructure, manual processes, and increasing data volumes in silos make it harder to deliver the performance, security, and agility that today’s business landscape demands to keep pace with the competitive pressures.

Continue reading to learn about how three organizations—Thomson Reuters, Hexure, and CallRevu—each jumpstarted their transformation with migration of their on-premises workloads to Microsoft Azure. As a result, organizations were able to improve operational efficiency and accelerate AI-powered innovation. Their stories reveal how fully managed platform-as-a-service solutions like Microsoft Azure SQL Managed Instance helps organizations move from legacy constraints to a scalable and secure AI-ready foundation ready to power future possibilities.

Modernization at scale: Thomson Reuters  

For Thomson Reuters, one of the world’s most trusted providers of tax and accounting solutions, modernization was less of an option and more of a necessity. Supporting over 7,000 firms and 70,000 users during the peak of tax season required an infrastructure that was both robust and scalable. The company previously hosted more than 18,000 databases and over 500 terabytes of data on third-party servers, an approach that came with high costs, operational complexity, and challenges scaling to meet seasonal demand.  

By migrating this massive estate into Azure SQL Managed Instance from another cloud hosting environment, Thomson Reuters achieved modernization at scale. With programs like Microsoft Azure Migrate to support every step of the migration journey, and automation tools like PowerShell and Azure Resource Manager templates, they were able to streamline deployments and maintain performance while minimizing disruptions. Azure’s fully managed platform allowed Thomson Reuters to streamline database administration and automated key tasks like backups and updates. As a result, their teams could focus on delivering value to customers rather than managing infrastructure. Azure Virtual Desktop together with Windows 11 facilitated access to tax preparation applications, reducing complexity and costs.  

The benefits were immediate and significant. Thomson Reuters gained: 

  • Consistent performance during seasonal peaks.
  • Improved resiliency.
  • Reduced support overhead.
  • Optimized costs across licensing and infrastructure.  

Thomson Reuters now has a foundation for continued growth and the flexibility to scale its services as demand requires.

Operational efficiency and performance: Hexure  

While Thomson Reuters’ story highlights scale, Hexure’s migration shows the operational efficiency gains that come from moving to a fully managed platform with Azure SQL Managed Instance and Microsoft Azure App Service. Hexure provides digital solutions for insurance and financial services companies—managing sensitive customer information across many databases and applications.  

The company faced challenges with aging infrastructure that slowed down critical processes and demanded heavy manual intervention. Provisioning new customer instances, managing backups, and handling failovers was time-intensive. Processing delays made it harder to serve clients with the speed and reliability customers expect.  

Migrating to Azure SQL Managed Instance changed that equation. Hexure cut processing times by up to 97%, transforming overnight batch jobs into near-instant operations. Migration times were reduced by more than 80% thanks to built-in compatibility and automation. With Microsoft Azure Key Vault, Hexure could better manage cybersecurity and protection of their data. Features like point-in-time restore, automated backups, and geo-replication not only boosted resilience but also ensured compliance with industry regulations.  

Equally important, the move allowed Hexure to:  

  • Onboard new customers in minutes versus hours.
  • Deliver faster shipping cycles for features and platform improvements.
  • Reduce management of infrastructure—including servers.

With migration, Hexure could now focus on innovation and customer service. For an industry where trust and responsiveness are critical, this operational leap forward directly translates into stronger client relationships.

Innovation with AI and insights: CallRevu  

CallRevu’s story illustrates the next frontier: innovation. CallRevu helps automotive dealerships improve lead conversion, follow-up, and customer experience by analyzing phone calls across more than 5,000 locations. Handling this volume of conversational data requires not only advanced analytics, but scalable platform. 

With a fully managed solution built on Azure SQL Managed Instance, Microsoft Azure Kubernetes Service together with Microsoft Azure AI services, CallRevu created a platform that goes beyond storing and managing data. It ensures reliable, scalable performance for call data and transcriptions, while services like Microsoft Azure OpenAI for real-time summaries and insights. This integration allows CallRevu to surface actionable insights in real time—helping dealerships connect marketing to results, improve agent performance, and ultimately drive more sales. 

The company also benefits from the operational simplicity that Azure SQL Managed Instance delivers. By migrating from their on-premises SQL Server environment, they were able to benefit from automated backups, scaling, and monitoring to reduce administrative overhead, while built-in security helps protect sensitive customer interactions. Data is mirrored in Microsoft Fabric allowing Power BI dashboards to generate real-time insights. With a strong and agile data foundation in place, CallRevu can focus on innovating faster—bringing AI-powered capabilities to an industry where customer engagement is a critical differentiator while also:  

  • Increasing customer satisfaction by 10%.
  • Saving USD500,000 annually in labor costs.
  • Increasing lead conversion by 15%.

Take the next step in your transformation journey  

Modernization is not a one-time project—it’s a journey that is different for every organization. For some organizations, the first step is simply migrating off legacy servers. For others, it’s about rethinking how operations can run more efficiently. And for many, it’s about leveraging cloud and AI to create entirely new opportunities.  

The experiences of Thomson Reuters, Hexure, and CallRevu highlight how migration to a platform-as-a-service anchored on database solutions like Azure SQL Managed Instance supports every stage of that journey. By providing a managed, secure, and scalable cloud platform, backed by the tools and programs, organizations can migrate with confidence, operate more efficiently, and innovate faster.

Ready to get started? Here are some free tools you can start trying today: 

Join Microsoft at PASS Data Community Summit 2025 to continue your learning journey and how Azure is making it easier than ever to start your transformation journey. Learn more on our sponsorship and presence.

The post Innovation spotlight: How 3 customers are driving change with migration to Azure SQL appeared first on Microsoft SQL Server Blog.

]]>
Accelerate SQL Server Migration to Azure with Azure Arc  http://approjects.co.za/?big=en-us/sql-server/blog/2025/07/17/accelerate-sql-server-migration-to-azure-with-azure-arc/ Thu, 17 Jul 2025 21:00:00 +0000 We’re excited to announce a new migration experience in Azure Arc to simplify and accelerate SQL Server migration. This new experience, now in preview, is powered by Azure Database Migration Service.

The post Accelerate SQL Server Migration to Azure with Azure Arc  appeared first on Microsoft SQL Server Blog.

]]>
We’re excited to announce a new migration capability in Azure Arc to simplify and accelerate SQL Server migration. This new capability, now generally available, is powered by Azure Database Migration Service and it offers seamless, end-to-end migration capabilities including continuous migration assessments, simplified provisioning, and real-time database replication, assisted by Copilot in Azure. What once took months can now be accomplished in just days, with confidence, continuity, and control. 

End-to-end migration simplified

If you’ve been using SQL Server enabled by Azure Arc, you’re likely familiar with continuous migration assessments that offer target recommendations, technical readiness, and cost estimates. Now, we’re taking the next step forward by introducing automated, end-to-end migration capabilities in SQL Server enabled by Azure Arc.

Once you’ve assessed the Azure readiness of your SQL Server instances, you can now select or provision your Azure targets such as Azure SQL Managed Instance, without jumping between various tools or places in the Azure portal. This streamlined workflow eliminates context switching and simplifies provisioning. You’ll see estimated costs during the provisioning process, giving you clear visibility and confidence to plan ahead. Plus, you can take advantage of the free Azure SQL Managed Instance offer to evaluate at no cost, making it easier to get started. 

Real-time database replication is also integrated into the new migration capability. This new method, built on top of distributed availability groups, enables near real-time database replication from SQL Server to Azure SQL Managed Instance. Setting up real-time replication manually can be a complex multi-step process, but Azure Arc simplifies the entire process while providing best-in-class monitoring. If a customer decides to go back to on-premises, Azure SQL Managed Instance Link also supports seamless failback (if the source SQL Server instance is SQL Server 2022 and above). 

Migrate with confidence 

The new capability empowers customers to migrate with confidence. Before officially cutting over, you can validate that the target Azure SQL Managed Instance meets your business requirements by using the target instance as a read-only replica.  

In addition, the client connection summary feature in SQL Server, enabled by Azure Arc, automatically and continuously captures and displays which clients are connecting to each instance. This replaces the previous manual and time-consuming process of tracing applications to their databases, giving customers clear visibility and helping ensure a smooth transition to Azure.

Get started today 

If you’re looking to simplify and accelerate your migration to Azure, this new connected capability can help you get there faster—with less downtime, lower overhead, and more confidence. 

Frequently asked questions 

1. What is SQL Server enabled by Azure Arc?  

SQL Server enabled by Azure Arc extends Azure services to SQL Server instances hosted outside of Azure: in your data center, in edge site locations like retail stores, or any public cloud or hosting provider. 

Azure Arc enables you to consistently manage SQL Server instances across hybrid and multicloud environments, bringing cloud innovations such as automated updates, unified policy, best practices assessment, and advanced security to SQL Server running anywhere.

2. What’s the continuous migration assessment from Azure Arc?  

Microsoft has announced the general availability of continuous migration assessments for SQL Server enabled by Azure Arc, marking a step forward in simplifying cloud migration planning. This release introduces a redesigned assessment experience that provides deeper insights and more intuitive navigation, especially for single Arc-enabled instances. 

One of the standout features is the integration of retail pricing visibility across all Azure savings options, including Azure Hybrid Benefit (AHB), reserved instances, and Azure savings plans. These pricing insights are now available for Azure SQL Database, SQL Managed Instance, and SQL Server on Azure Virtual Machines (VMs), helping users make informed cost decisions.  

3. What is Azure Database Migration Service? 

Azure Database Migration Service is a fully managed service designed to seamlessly migrate databases to Azure with minimal downtime. It supports both homogeneous migrations (such as SQL Server to Azure SQL) and heterogeneous migrations (such as Oracle to Azure PostgreSQL).

4. What are the migration methods in the new migration capability? 

The following methods are built into the migration process. Azure SQL Managed Instance link enables near real-time database replication using distributed availability groups. Log Replay Service uses SQL Server log-shipping technology and requires a brief planned cutover. Review the Microsoft Learn page to understand the differences between these two migration methods and choose the option that best suits your needs.

The post Accelerate SQL Server Migration to Azure with Azure Arc  appeared first on Microsoft SQL Server Blog.

]]>
Protect and modernize SQL Server 2016 workloads with Microsoft  http://approjects.co.za/?big=en-us/sql-server/blog/2025/07/15/protect-and-modernize-sql-server-2016-workloads-with-microsoft/ Tue, 15 Jul 2025 15:00:00 +0000 We encourage all our customers running SQL Server 2016 to start planning for the end of support. We have migration resources, best practices, as well as a rich ecosystem of partners ready to help.

The post Protect and modernize SQL Server 2016 workloads with Microsoft  appeared first on Microsoft SQL Server Blog.

]]>
We take pride in delivering innovation with each new version of Microsoft SQL Server. However, there comes a time when product lifecycles must conclude. On July 14, 2026, SQL Server 2016 will reach its 10-year end-of-support moment. Many of our customers, including YunTech, have begun transitioning their SQL workloads to Microsoft Azure or are upgrading to SQL Server 2025. Their objective is straightforward: to modernize their databases and applications while accelerating innovation through using cloud technologies. For customers who need more time, Microsoft will offer three years of Extended Security Updates for SQL Server 2016.

“We are allowing the cloud provider to handle hardware resource allocation and maintenance so that our staff focus on program development. This strategy ensures that during system operation we no longer need to worry about hardware failures, power instability or information security issues, greatly improving the system’s operational reliability.”

—Ching-Lung Chang, CIO, Library and Information Services Office at YunTech .

Modernize to Azure, a smooth path, a more powerful destination  

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’s 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.  

Modernizing to Microsoft Azure SQL Managed Instance offers cost savings, scalability, security, seamless migration, productivity, and always up-to-date features. Now in preview, Azure SQL Managed Instance next generation general purpose delivers improved performance and scalability, making migration and modernization faster and easier across more customer scenarios.  

Azure is the destination, but we know the journey matters just as much. A new SQL Server migration experience is now under preview in Azure Arc. It is powered by Azure Database Migration Service and offers seamless, end-to-end migration capabilities including continuous migration assessments, simplified provisioning, and real-time database replication, assisted by Copilot in Azure. What once took months can now be accomplished in just days, with confidence, continuity, and control.

In-place upgrade to SQL Server 2025  

Another way to stay protected is to upgrade your SQL Server to  SQL Server 2025. Built on SQL Server’s legacy of best-in-class security, performance and availability, SQL Server 2025 empowers you to develop modern AI applications using your data. It provides built-in, extensible AI capabilities, enhanced developer productivity, and seamless integration with Azure and Fabric, all within SQL Server engine using the familiar T-SQL language. 

The upgrade experience has been streamlined. With the retirement of Azure Data Studio and Data Migration Assistant, migration capabilities are now integrated directly into SQL Server Management Studio (SSMS). This eliminates the need for separate tools, reducing complexity and effort. In SSMS 21, a new migration extension allows DBAs and partners to assess and upgrade SQL Server instances from older to newer versions, all within the same management environment. 

Stay protected on-premises or in multi-cloud environments with Azure Arc  

Extended Security Updates for SQL Server 2016 offers an enhanced cloud experience through Azure Arc. With this customer-centric approach, security updates will be natively available in the Azure portal through Azure Arc. Enabling your SQL Server with Azure Arc also unlocks Azure benefits and flexible subscription billing for SQL Server 2016 workloads on-premises or across multi-cloud environments.  

If you enable Extended Security Updates subscription in your production environment through Azure Arc, you have access to SQL Server Extended Security Updates subscription in the non-production environment for free, through SQL Server Developer edition or an Azure Dev/Test subscription.  

We encourage all our customers running SQL Server 2016 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: 

Frequently asked questions 

What does end of support mean? 

Microsoft Lifecycle Policy offers 10 years of support (five years for mainstream support and five years for extended support) for business and developer products (such as SQL Server and Windows Server). After the end of the extended support period, there are no patches or security updates, which might cause security and compliance issues, and expose your applications and business to serious security risks. 

What do Extended Security Updates include? 

Extended Security Updates include provision of security updates and bulletins rated critical by the Microsoft Security Response Center (MSRC), for a maximum of three years after the end of extended support.  

Extended Security Updates are distributed if and when available. Extended Security Updates don’t include technical support. Customers must purchase a paid support plan (Pay Per Incident, Unified, and Premier Support for Partners) to leverage technical support. Extended Security Updates don’t include new features, functional improvements, nor customer-requested fixes. However, Microsoft might include non-security fixes as deemed necessary. 

Why do Extended Security Updates only offer “critical” updates? 

For end of support events in the past, SQL Server provided only critical security updates, which meets the compliance criteria of our enterprise customers. SQL Server doesn’t ship a general monthly security update.

The post Protect and modernize SQL Server 2016 workloads with Microsoft  appeared first on Microsoft SQL Server Blog.

]]>
Enhancing reporting and analytics with SQL Server 2025 tools and services http://approjects.co.za/?big=en-us/sql-server/blog/2025/06/19/enhancing-reporting-and-analytics-with-sql-server-2025-tools-and-services/ Thu, 19 Jun 2025 16:00:00 +0000 In this blog, we’ll walk you through what’s new across these services so you can plan your upgrade holistically and unlock the full potential of SQL Server 2025.

The post Enhancing reporting and analytics with SQL Server 2025 tools and services appeared first on Microsoft SQL Server Blog.

]]>

SQL Server 2025 public preview announcement

Read the blog

At Microsoft Build 2025, we announced the public preview of SQL Server 2025. Built on a foundation of best-in-class security, performance, and availability, SQL Server 2025 empowers customers to accelerate AI using their own data. The momentum doesn’t stop there. This release also brings major updates to the tools and services that power enterprise-grade reporting, analysis and integration services. In this blog, we’ll walk you through what’s new across these services so you can plan your upgrade holistically and unlock the full potential of SQL Server 2025.

SQL Server 2025 Reporting Services

For over two decades, SQL Server Reporting Services (SSRS) has been the go-to on-premises solution for creating and managing paginated reports using Report Definition Language (RDL). With SQL Server 2025, we’re taking a step forward.

Power BI Report Server will now be the default reporting solution for SQL Server 2025. This modern platform supports both paginated and interactive reports, enabling users to build reusable data models and deliver rich, customized reporting experiences. It also offers built-in compatibility with Power BI, providing a seamless path to the cloud.

As part of this transition, we will not be releasing a new version of SSRS for SQL Server 2025. However, if you prefer to continue using SSRS, support will remain in place for both SQL Server 2025 and all in-market versions of SQL Server.

Power BI Report Server will now be the default reporting solution for SQL Server 2025. This modern platform supports both paginated and interactive reports, enabling users to build reusable data models and deliver rich, customized reporting experiences.

If you’re testing SQL Server 2025 preview, we recommend including the move to Power BI Report Server in your upgrade plan. Download the free trial of Power BI Report Server and explore the latest features to see if it meets your reporting needs. When SQL Server 2025 becomes generally available, any customer with a paid SQL Server license will have access to Power BI Report Server, which was previously limited to Enterprise edition customers with Software Assurance.

For customers currently using Enterprise edition of SQL Server 2022 or earlier with Software Assurance, migrating from SQL Server Reporting Services (SSRS) to Power BI Report Server (PBIRS) is a straightforward process. Most RDL report assets created in SSRS are fully compatible with PBIRS, making the transition less effort for the majority of users.

For more questions, review the FAQ.

SQL Server 2025 Analysis Services

SQL Server 2025 Analysis Services (SSAS) introduces several key enhancements aimed at improving performance, scalability, and modeling flexibility.

We have made significant performance improvements for Multidimensional Expressions (MDX) queries on models with Calculation Groups and Format Strings to reduce memory usage and improve responsiveness. The latest changes will greatly improve the performance and reliability of operations in Analyze in Excel on models that include Dynamic Format Strings for Measures and Calculated Items with Format Strings. For more details, refer to the Dynamic format strings documentation.

Improved parallelism in DirectQuery mode enables faster response times for complex queries. The fundamental idea is to maximize query performance by parallelizing multiple queries to the datasource for a single Data Analysis Expressions (DAX) query. This query parallelization reduces the impact of data source delays and network latencies on query performance.

For more details, refer to the Query parallelization helps to boost the Power BI dataset performance in DirectQuery mode blog post.

SSAS 2025 incorporates the latest version of Horizontal Fusion, a query performance optimization that reduces the number of SQL queries generated by DAX, improving DirectQuery efficiency. For more details, refer to the Announcing “Horizontal Fusion,” a query performance optimization in Power BI and Analysis Services blog post.

Find more about what’s new in SQL Server 2025 Analysis Services.

SQL Server 2025 Integration Services

One of the notable updates in SQL Server 2025 Integration Services (SSIS) is the improved support for ADO.NET connectivity. Historically, the ADO.NET connection manager had limitations such as the lack of ability to connect using Entra ID authentication. This posed challenges for organizations adopting modern identity solutions and cloud-first strategies.

Now, with the introduction of the Microsoft SqlClient Data Provider in ADO.NET connection manager, SSIS addresses this gap. This new capability brings the support for Entra ID authentication, enabling more secure and flexible connection scenarios.

Find more about what’s new in SQL Server 2025 Integration Services.

Explore more resources

The post Enhancing reporting and analytics with SQL Server 2025 tools and services appeared first on Microsoft SQL Server Blog.

]]>
From code to community: The collective effort behind SQL Server 2025 http://approjects.co.za/?big=en-us/sql-server/blog/2025/06/16/from-code-to-community-the-collective-effort-behind-sql-server-2025/ Mon, 16 Jun 2025 15:00:00 +0000 SQL Server 2025 is the most significant release for SQL developers in the last decade and will help streamline application development and greatly reduce complexity.

The post From code to community: The collective effort behind SQL Server 2025 appeared first on Microsoft SQL Server Blog.

]]>
At Build 2025, SQL Server 2025 officially entered public preview. As one of the world’s most popular databases, this release continues a decades-long history of innovation with features made for developers, AI, analytics, and cloud connectivity. SQL Server 2025 is the most significant release for SQL developers in the last decade and will help streamline application development and greatly reduce complexity. With built-in vector support, you can now boost search intelligence by combining semantic search alongside full text search and filtering. This will allow you to run the generative AI models of your choice with your own data. SQL Server 2025 enables zero-ETL (extract, transform, and load), real-time analytics through mirroring in Microsoft Fabric and provides cloud agility through Azure Arc.

Overview of SQL Server 2025 key innovations including best-in-class security and performance; AI built-in; Made for developers; and Cloud agility through Azure

A thriving community at the heart of SQL Server 2025

As we look back at the creation of SQL Server 2025, we want to extend our deepest gratitude to the community leaders, MVPs, partners, and Microsoft engineers who have shared their insights, expertise, and enthusiasm about this exciting release. Their passion for SQL Server and commitment to knowledge-sharing continue to inspire us.

In the resources below we showcase the expertise of our community as well as Microsoft, with blogs and videos that will help you make the most of everything SQL Server 2025 has to offer. These resources dive into key innovations that set SQL Server 2025 apart, including best-in-class security, built-in AI, developer enhancements, and Fabric mirroring.

Insights from Microsoft engineering, MVPs, and partners

SQL Server 2025 overview

We’ll get started with resources that provide an overview of key SQL Server innovations and then dive into each of the core pillars of best-in-class performance and security, AI-built in, made for developer, and cloud agility through Azure.

Best-in-class security and performance

SQL Server remains as the most secure database in the last decade, with best-in-class performance and availability. This latest release harnesses the latest innovation from Microsoft Entra and brings over 50 enhancements to the database engine.

  • Explore how to save time and reduce risk with Microsoft SQL Engineering PM Dimitri Furman’s blog on tempdb space resource governance.
  • Dimitri also shared how SQL Server 2025 has optimized Halloween protection by redesigning the way the database engine solves the Halloween problem and improves query performance.
  • HPE spotlighted SQL Server 2025 in a recent blog, underscoring its exceptional performance and availability—further validating the platform’s enterprise-grade capabilities.
  • Learn how to streamline T-SQL Snapshot backups using T-SQL REST API and  Pure Storage in the blog by MVP and partner, Anthony Nocentino: Streamlining T-SQL Snapshot Backups.

“SQL Server 2025 is an important release, delivering significant improvements in performance, reliability, security, and the developer experience for our trading platform.”

Ola Hallengren, Chief Data Platforms Engineer at Saxo Bank and a Data Platform MVP

AI built-in   

Learn how to accelerate AI apps closer to your own data using extensible tools with built-in vector capabilities.

“We are excited about the AI features in SQL Server 2025, especially the potential for text processing that can benefit companies of all sizes. AI brings new ways to process and extract insights from data, and with SQL Server being the core repository for many businesses, native AI features like embeddings, REST API support, and vector indexes are game changers.”

—Rodrigo Ribeiro Gomes, Head of Innovation, Power Tuning

Made for developers

SQL Server 2025 is the most significant release for SQL developers in the last decade. With features including native JSON support, built-in REST APIs and RegEx enablement, change event streaming plus a new Standard Developer edition and new SSMS release, SQL Server 2025 helps streamline application development and greatly reduce code complexity.

“Our initial tests have shown great results with fuzzy string matching and regex, significantly reducing the need for external coding to clean data. This improvement in development time and data quality stability is a huge benefit for our end-users. Additionally, we are exploring vector indexes, which have the potential to be a game-changer for our data management.”

—Paw Jershauge, Senior DBA and SQL Specialist, Orifarm Group A/S

Cloud agility through Azure

Powered by Azure, SQL Server 2025 enables real-time analytics with Fabric database mirroring and brings seamless cloud agility to any environment through Azure Arc.

  • Explore how Mirroring in Microsoft Fabric enables you to drive enhanced analytics and insights for your on-premise data in Microsoft SQL Engineering PM Ajay Jagannathan’s blog on Mirroring in SQL Server.
  • And for our Spanish speakers, Javier Villegas, Microsoft MVP, has created a wealth of in-depth content including his video on Mirroring in Microsoft Fabric – SQL Server.

“Change Event Streaming and Fabric Mirroring for SQL Server 2025 help MSC to build the bridge to bring our operational data into Microsoft Fabric.”

—Javier Villegas, IT Director—DBA and BI Services, MSC Technology (North America)

Keep learning about SQL Server 2025

A developer working from home on a computer

SQL Server 2025

An AI-ready enterprise database with best-in-class security, performance and availability.

The post From code to community: The collective effort behind SQL Server 2025 appeared first on Microsoft SQL Server Blog.

]]>
SQL Server Integration Services (SSIS) Microsoft Connector for Oracle deprecation  http://approjects.co.za/?big=en-us/sql-server/blog/2025/01/21/sql-server-integration-services-ssis-microsoft-connector-for-oracle-deprecation/ Tue, 21 Jan 2025 16:00:00 +0000 In July 2025, Microsoft will discontinue support for the Microsoft Connector for Oracle in SQL Server Integration Services.

The post SQL Server Integration Services (SSIS) Microsoft Connector for Oracle deprecation  appeared first on Microsoft SQL Server Blog.

]]>
In July 2025, Microsoft will discontinue support for the Microsoft Connector for Oracle in SQL Server Integration Services (SSIS). This blog provides essential details to help customers prepare for this change in advance.

The Microsoft Connector for Oracle enables data export from and import into Oracle databases within an SSIS package. This feature, available in Enterprise editions of SQL Server 2019 and 2022, will remain functional for the lifecycle of the SQL Server product. However, support for this feature will officially end on July 4, 2025. With the deprecation, future product releases will provide no further bug fixes. Additionally, it will not be supported from SQL Server 2025 and onwards.

Today, customers are leveraging the Microsoft Connector for Oracle in a variety of scenarios, including integrating Oracle data with other sources and supporting ETL (Extract, Transform, Load) processes to gain valuable insights. We recommend that customers use the SSIS ADO.NET Source and ADO.NET Destination components as the primary alternative solution to the Microsoft Connector for Oracle.

These SSIS ADO.NET components offer similar ETL capabilities for connecting Oracle databases with a .NET provider, specifically the OracleClient Data Provider, to connect, transfer, and transform your data efficiently. For further detailed instructions, please refer to the step-by-step guide.

If you need any assistance, please contact Microsoft Support.

A developer working from home on a computer

Microsoft SQL Server

Get the flexibility you need to use integrated solutions and apps with your data—in the cloud, on-premises, or at the edge.

Exploring best-in-class connectivity to Oracle with Microsoft Fabric 

The announcement of the deprecation of the SQL Server Integration Services (SSIS) Microsoft Connector for Oracle also presents an opportunity to explore new solutions for modern data integration with Oracle.

Microsoft Fabric is an end-to-end analytics and data platform designed for enterprises that require a unified solution. It encompasses data movement, processing, ingestion, transformation, real-time event routing, and report building. It offers a comprehensive suite of services including Data Engineering, Data Factory, Data Science, Real-Time Analytics, Data Warehouse, and Databases. 

Data Factory in Microsoft Fabric offers a modern data integration experience with Oracle databases, allowing reading from Oracle databases on-premises or behind a virtual network, and writing to any data destination.

Mirroring in Microsoft Fabric allows users to enjoy a highly integrated, end-to-end, and easy-to-use product that is designed to simplify your analytics needs. You can continuously replicate your existing data estate directly into Fabric’s OneLake, which can be used for all your analytical needs. This feature allows businesses to continuously integrate their existing data estate without complex ETL. 

Let’s explore the details of each of the approaches below. 

Oracle connectivity with Data Factory

Data Factory in Microsoft Fabric provides a modern data integration experience to ingest, prepare, and transform data from a rich set of data sources. It incorporates the simplicity of Power Query, and you can use more than 200 native connectors to connect to data sources on-premises and in the cloud.

One of the powerful features of Data Factory is its ability to configure and manage Oracle database connections in a copy activity. This functionality allows organizations to seamlessly integrate their Oracle databases into their data pipelines, ensuring efficient data movement and transformation. Configure Oracle database in a copy activity provides comprehensive instructions on how to perform this configuration. 

You can leverage the on-premises data gateway to securely connect to your on-premises Oracle database. This gateway acts as a bridge, enabling seamless data movement between on-premises data sources and cloud services. For detailed instructions, please refer to move data from Oracle to Fabric Lakehouse via pipeline and on-premises data gateway.

Replicating Oracle data into Fabric’s OneLake with Mirroring 

Mirroring in Microsoft Fabric offers a modern approach to seamlessly accessing and ingesting data from any database or data warehouse into OneLake in Microsoft Fabric. This feature allows businesses to continuously integrate their existing data estate without complex ETL processes. 

Open Mirroring in Fabric is extensible, customizable, and built on the open Delta Lake table format. It enables applications and data ISVs (Independent Software Vendors) to write change data directly into a mirrored database in Fabric using public APIs (Application Programming Interface). Once the data lands in OneLake, Open Mirroring handles complex data changes, ensuring all mirrored data remains continuously up-to-date and ready for analysis. 

We are thrilled to see Oracle Golden Gate streamline the delivery of mirroring solutions in Microsoft Fabric by integrating their data solution into Open Mirroring. As a key partner in our Open Mirroring ecosystem, Oracle Golden Gate offers a powerful and seamless approach to data replication, enabling continuous and efficient integration of data into Microsoft Fabric’s OneLake. This partnership highlights our commitment to providing modern, extensible solutions that simplify data integration and drive value for our customers. 

Simplifying Oracle to SQL Server Migration: Leveraging Microsoft SQL Server Migration Assistant (SSMA)

Additionally, if you are looking to migrate Oracle Database to SQL Server, Microsoft SQL Server Migration Assistant (SSMA) is a tool designed to automate database migration. SQL Server Migration Assistant (SSMA) for Oracle is a comprehensive environment that helps you quickly migrate Oracle databases to SQL Server, Azure SQL Database. The Oracle to SQL Server migration guide provides detailed instructions on how to migrate your Oracle database to SQL Server using SSMA for Oracle. This comprehensive guide ensures a smooth transition, minimizing disruptions and maximizing efficiency.

Looking forward

The deprecation of the SSIS Microsoft Connector for Oracle offers an opportunity to explore and implement more advanced and robust data integration solutions. By considering the ADO.NET components, Microsoft Fabric, or Microsoft SQL Server Migration Assistant for Oracle, organizations can ensure continued efficiency and reliability in their data integration processes. Each of these alternatives brings unique benefits, allowing businesses to choose the one that best aligns with their operational requirements and strategic goals. 

As the landscape of data integration evolves, staying informed about the latest tools and technologies will be crucial for maintaining a competitive edge and achieving seamless data connectivity. By proactively addressing the deprecation and selecting the appropriate alternative, organizations can continue to leverage their data assets effectively and drive business success. 


Resources 

Learn more about Data Factory in Microsoft Fabric and Oracle to SQL Server migration

The post SQL Server Integration Services (SSIS) Microsoft Connector for Oracle deprecation  appeared first on Microsoft SQL Server Blog.

]]>
Modernize Microsoft SQL Server 2014 workloads with Azure http://approjects.co.za/?big=en-us/sql-server/blog/2024/08/14/modernize-microsoft-sql-server-2014-workloads-with-azure/ Wed, 14 Aug 2024 16:00:00 +0000 As of July 9, 2024, SQL Server 2014 has reached its end of support.

The post Modernize Microsoft SQL Server 2014 workloads with Azure appeared first on Microsoft SQL Server Blog.

]]>
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. 

“With our migration to PaaS, we got what we wanted: greater scalability, reliability, security, agility in managing our IT infrastructure—and greater peace of mind—all without the cost and hassle of doing this ourselves,” 

Daniel Engberg, Head of AI, Data, and Platforms at Scandinavian Airlines System  
small business owner on computer

Migrate to Microsoft Azure

Boost productivity and enable innovation.

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. 

Migrate and modernize to Azure, a smooth path, a more powerful destination 

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’s 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. 

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 Azure SQL Managed Instance Next-gen General Purpose, 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, now in public preview. 

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

Extending end-of-support time

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 Microsoft Azure Virtual Machines. 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 further reduces your costs. With these pricing advantages, AWS is up to five times more expensive than Azure for SQL Server and Windows Server end-of-support workloads. 

In-place upgrade to SQL Server 2022 

Another way to stay protected is to upgrade your SQL Server to SQL Server 2022, 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. 

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. 

Stay protected on-premises or in multi-cloud environments with Azure Arc 

Just as with SQL Server 2012, Extended Security Updates for SQL Server 2014 offers an enhanced cloud experience through Microsoft Azure Arc. 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. 

We’re continuing to enhance the capabilities Azure Arc offers to Extended Security Updates. Just recently, physical-core licensing 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. 

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 for free, through SQL Server Developer Edition or an Azure dev/test subscription. 

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. 

Learn More 

The post Modernize Microsoft SQL Server 2014 workloads with Azure appeared first on Microsoft SQL Server Blog.

]]>
Announcing the retirement of SQL Server Stretch Database http://approjects.co.za/?big=en-us/sql-server/blog/2024/07/03/announcing-the-retirement-of-sql-server-stretch-database/ Wed, 03 Jul 2024 16:00:00 +0000 In July 2024, SQL Server Stretch Database will be discontinued for SQL Server 2022, 2019, and 2017.

The post Announcing the retirement of SQL Server Stretch Database appeared first on Microsoft SQL Server Blog.

]]>
Ever since Microsoft introduced SQL Server Stretch Database in 2016, our guiding principles for such hybrid data storage solutions have always been affordability, security, and native Azure integration. Customers have indicated that they want to reduce maintenance and storage costs for on-premises data, with options to scale up or down as needed, greater peace of mind from advanced security features such as Always Encrypted and row-level security, and they seek to unlock value from warm and cold data stretched to the cloud using Microsoft Azure analytics services.     

During recent years, Azure has undergone significant evolution, marked by groundbreaking innovations like Microsoft Fabric and Azure Data Lake Storage. As we continue this journey, it remains imperative to keep evolving our approach on hybrid data storage, ensuring optimal empowerment for our SQL Server customers in leveraging the best from Azure.

Retirement of SQL Server Stretch Database 

On November 16, 2022, the SQL Server Stretch Database feature was deprecated from SQL Server 2022. For in-market versions of SQL Server 2019 and 2017, we had added an improvement that allowed the Stretch Database feature to stretch a table to an Azure SQL Database. Effective July 9, 2024, the supporting Azure service, known as SQL Server Stretch Database edition, is retired. Impacted versions of SQL Server include SQL Server 2022, 2019, 2017, and 2016.  

In July 2024, SQL Server Stretch Database will be discontinued for SQL Server 2022, 2019, 2017, and 2016. We understand that retiring an Azure service may impact your current workload and use of Stretch Database. Therefore, we kindly request that you either migrate to Azure or bring their data back from Azure to your on-premises version of SQL Server. Additionally, if you’re exploring alternatives for archiving data to cold and warm storage in the cloud, we’ve introduced significant new capabilities in SQL Server 2022, leveraging its data virtualization suite. 

The path forward 

SQL Server 2022 supports a concept named CREATE EXTERNAL TABLE AS SELECT (CETaS). It can help customers archive and store cold data to Azure Storage. The data will be stored in an open source file format named Parquet. It operates well with complex data in large volumes. With its performant data compression, it turns out to be one of the most cost-effective data storage solutions. Using OneLake shortcuts, customers then can leverage Microsoft Fabric to realize cloud-scale analytics on archived data.  

Our priority is to empower our SQL Server customers with the tools and services that leverage the latest and greatest from Azure. If you need assistance in exploring how Microsoft can best empower your hybrid data archiving needs, please contact us.

New solution FAQs

What’s CETaS? 

Creates an external table and then exports, in parallel, the results of a Transact-SQL SELECT statement. 

  • Azure Synapse Analytics and Analytics Platform System support Hadoop or Azure Blob Storage.
  • SQL Server 2022 (16.x) and later versions support CETaS to create an external table and then export, in parallel, the result of a Transact-SQL SELECT statement to Azure Data Lake Storage Gen2, Azure Storage Account v2, and S3-compatible object storage. 

What is Fabric? 

Fabric is an end-to-end analytics and data platform designed for enterprises that require a unified solution. It encompasses data movement, processing, ingestion, transformation, real-time event routing, and report building. Fabric offers a comprehensive suite of services including Data engineering, Data Factory, Data Science, Real-Time Analytics, Data Warehouse, and Databases. 

With Fabric, you don’t need to assemble different services from multiple vendors. Instead, it offers a seamlessly integrated, user-friendly platform that simplifies your analytics requirements. Operating on a software as a service (SaaS) model, Fabric brings simplicity and integration to your solutions. 

Fabric integrates separate components into a cohesive stack. Instead of relying on different databases or data warehouses, you can centralize data storage with Microsoft OneLake. AI capabilities are seamlessly embedded within Fabric, eliminating the need for manual integration. With Fabric, you can easily transition your raw data into actionable insights for business users. 

What is OneLake shortcuts?  

Shortcuts in OneLake allow you to unify your data across domains, clouds, and accounts by creating a single virtual data lake for your entire enterprise. All Fabric experiences and analytical engines can directly connect to your existing data sources such as Azure, Amazon Web Services (AWS), and OneLake through a unified namespace. OneLake manages all permissions and credentials, so you don’t need to separately configure each Fabric workload to connect to each data source. Additionally, you can use shortcuts to eliminate edge copies of data and reduce process latency associated with data copies and staging. 

Shortcuts are objects in OneLake that point to other storage locations. The location can be internal or external to OneLake. The location that a shortcut points to is known as the target path of the shortcut. The location where the shortcut appears is known as the shortcut path. Shortcuts appear as folders in OneLake and any workload or service that has access to OneLake can use them. Shortcuts behave like symbolic links. They’re an independent object from the target. If you delete a shortcut, the target remains unaffected. If you move, rename, or delete a target path, the shortcut can break. 

Learn more 

Abstract image

Microsoft Fabric

Bring your data into the era of AI

The post Announcing the retirement of SQL Server Stretch Database appeared first on Microsoft SQL Server Blog.

]]>
SQL Server Integration Services (SSIS) Change Data Capture Attunity feature deprecations http://approjects.co.za/?big=en-us/sql-server/blog/2024/02/28/sql-server-integration-services-ssis-change-data-capture-attunity-feature-deprecations/ Wed, 28 Feb 2024 16:00:00 +0000 This blog provides details to help support customers in modernizing to new solutions well in advance of this change.

The post SQL Server Integration Services (SSIS) Change Data Capture Attunity feature deprecations appeared first on Microsoft SQL Server Blog.

]]>
In December 2025, Microsoft will discontinue support for the Change Data Capture (CDC) components by Attunity and Change Data Capture (CDC) service for Oracle by Attunity of SQL Server Integration Services (SSIS). This blog provides details to help support customers in modernizing to new solutions well in advance of this change. The following components for which support will be discontinued:

SQL Server Intergration Services

Learn More

Customers using these two features are encouraged to modernize to Data Factory in Microsoft Fabric or Azure Data Factory. Customers can use incremental data loading capability from Azure Data Factory. Azure Data Factory can be used for on-premises data sources with a self-hosted integration runtime and is fully compatible with all impacted versions of SQL Server.

Data Factory in Microsoft Fabric enables you to move and transform data from various sources to various destinations. It’s a managed cloud service designed specifically for handling complex hybrid extract-transform-load (ETL), extract-load-transform (ELT), and data integration projects.

If you need any assistance as you plan your CDC modernization please contact Microsoft Support.

Learn more about Data Factory in Microsoft Fabric and Azure Data Factory:

Frequently Asked Questions

What’s Data Factory in Microsoft Fabric?

Data Factory in Microsoft Fabric is the next generation of Azure Data Factory which provides cloud-scale data movement and data transformation services that allow you to solve the most complex ETL scenarios. It’s intended to make your experience easy to use, powerful, and truly enterprise-grade.  Data Factory empowers you with a modern data integration experience to ingest, prepare and transform data from a rich set of data sources (for example, databases, data warehouse, Lakehouse, real-time data, and more). Whether you are a citizen or professional developer, you will be able to transform the data with intelligent transformations and leverage a rich set of activities. With Data Factory in Microsoft Fabric, we are bringing fast copy (data movement) capabilities to both dataflows and data pipelines. With Fast Copy, you can move data between your favorite data stores blazing fast. Most importantly, Fast Copy enables you to bring data to your Lakehouse and Data Warehouse in Microsoft Fabric for analytics.

What’s Azure Data Factory?

Azure Data Factory is a cloud-based data integration service that allows you to create data-driven workflows in the cloud for orchestrating and automating data movement and data transformation. It is a fully managed, serverless data integration solution for ingesting, preparing, and transforming all your data at scale. With Azure Data Factory, you can visually integrate data sources using more than 90 built-in, maintenance-free connectors. The service enables you to create and schedule data-driven workflows, called pipelines, that can ingest data from disparate data stores. You can build complex ETL processes that transform data visually with data flows or by using compute services such as Azure HDInsight Hadoop, Azure Databricks, and Azure SQL Database.

You can use Azure Data Factory to access and integrate data from on-premises data sources. One way to do this is by using a self-hosted integration runtime, which acts as a bridge between your on-premises data sources and the cloud-based Azure Data Factory service. This allows you to create data-driven workflows that can ingest data from your on-premises data stores and move it to the cloud for further processing and transformation.

How fast can I ingest data in Fabric data pipelines?

Fabric Data Factory allows you to develop pipelines that maximize data movement throughput for your environment. These pipelines fully utilize the following resources:

  • Network bandwidth between the source and destination data stores.
  • Source or destination data store input/output operations per second (IOPS) and bandwidth This full utilization means you can estimate the overall throughput by measuring the minimum throughput available with the following resources:
    • Source data store
    • Destination data store
  • Network bandwidth in between the source and destination data stores Meanwhile, we continuously work on innovations to boost the best possible throughput you can achieve. Today, the service can move 1 TB TPC-DI dataset (parquet files) into both Fabric Lakehouse table and Data Warehouse within five minutes—moving 1 billion rows under one minute; Please note that this performance is only a reference by running the above testing dataset. The actual throughput still depends on the factors listed previously. In addition, you can always multiply your throughput by running multiple copy activities in parallel. For example, using ForEach loop.

Where can I find more training resources to get started?


The post SQL Server Integration Services (SSIS) Change Data Capture Attunity feature deprecations appeared first on Microsoft SQL Server Blog.

]]>
Protect SQL Server 2014 workloads with Azure flexibility http://approjects.co.za/?big=en-us/sql-server/blog/2023/09/28/protect-sql-server-2014-workloads-with-azure-flexibility/ Thu, 28 Sep 2023 15:00:00 +0000 Customers have multiple options for the SQL Server in their data estate that is nearing the end of support.

The post Protect SQL Server 2014 workloads with Azure flexibility appeared first on Microsoft SQL Server Blog.

]]>
Blog updated on July 11, 2024

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

“Features 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“

—Javier Villegas: IT Director for DBA and BI Service, Mediterranean Shipping Company

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, and after this time product support and regular security updates cease. SQL Server 2014 reached end of support on July 9, 2024.

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 are free for workloads running in Azure. The updates will be offered for sale to use on-premises and in multicloud environments.

Just as with SQL Server 2012, Extended Security Updates for SQL Server 2014 offers an enhanced cloud experience through Azure Arc. 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.

Your options in end of support moments

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.

Modernize to Azure for the latest database features

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 is an intelligent cloud database service combining the broadest SQL Server engine compatibility—all the way back to SQL Server 2008—with the benefits of a fully managed database as a service. SQL Server licenses with Software Assurance are eligible for Azure Hybrid Benefit to help you reduce the costs of moving to Azure SQL Managed Instance.

Migrate to Azure, and get Extended Security Updates at no additional cost

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. 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 further reduces your costs. With these pricing advantages, AWS is up to five times more expensive than Azure for SQL Server and Windows Server end-of-support workloads.

Stay protected on-premises or in multicloud environments

Another way to stay protected is to upgrade your SQL Server to SQL Server 2022, 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.

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.

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.

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—pay only for what you need. Planned pricing* of SQL Server 2014 Extended Security Updates enabled by Azure Arc* 

Monthly Rate** On-premises or across multicloud via Azure Arc On Azure***
Enterprise – 2 cores $1,080 Free 
Standard – 2 cores $277 Free 

Get started planning Windows Server 2012 and SQL Server 2014 end of support

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:


*Use United States as an example; Actual launch pricing might vary.

** For customers who sign up after the end of support dates  (July 9, 2024), you will receive a one-time bill-back charge from the start of the Extended Security Updates year to your actual start date.

*** Include workloads running on Azure Virtual Machines, Azure Dedicated Host, Azure VMWare Solutions, Nutanix Cloud Clusters on Azure, and Azure Stack Hub/Edge/HCI. Learn more about your options.

The post Protect SQL Server 2014 workloads with Azure flexibility appeared first on Microsoft SQL Server Blog.

]]>