Microsoft SQL Server 2025, now in preview, is an enterprise AI-ready database from ground to cloud that tackles these challenges by bringing AI to customers’ data. This release continues SQL Server’s three decades of innovation in performance and security, adding new AI capabilities. With Microsoft Fabric integration, customers can bring their data into the next generation of data analytics. The release supports hybrid environments across clouds, on-premises datacenters, and edge, leveraging Microsoft Azure innovation for customers’ databases.

Over the years, SQL Server has transcended well beyond a traditional relational database. With the latest release of SQL Server, we’re enabling customers to build AI applications deeply integrated with the SQL engine. SQL Server 2025 is transforming into a vector database in its own right, using the built-in filtering capabilities along with a vector search, with great performance and is easily consumable by developers using T-SQL.

AI built-in

This new version has AI built-in, simplifying AI application development and retrieval-augmented generation (RAG) patterns with secure, performant, and easy-to-use vector support, leveraging familiar T-SQL syntax. With this new capability, you can combine vectors with your SQL data for a hybrid AI vector search.

Build AI applications with your enterprise database

SQL Server 2025 is an enterprise-ready vector database with built-in security and compliance, bringing enterprise AI to your data. It features a native vector store and index powered by DiskANN, a vector search technology using disk storage to efficiently find similar data points in large datasets. These databases efficiently support chunking and enable accurate data retrieval through semantic searching. In this latest SQL Server version, flexible AI model management within the engine using Representational State Transfer (REST) interfaces allows you to use AI models from ground to cloud.

In addition, whether customers are working on data preprocessing, model training, or RAG patterns, extensible, low-code tools offer flexible model interfaces within the SQL engine, supported by T-SQL and external REST endpoints. These tools enhance developers’ ability to create various AI applications through seamless integration with popular AI frameworks like LangChain, Semantic Kernel, and Entity Framework Core.

Boost developer productivity

When building data-intensive applications such as AI applications, it’s critical to focus on extensibility, frameworks, and data enrichment to enhance developers’ productivity. We ensure SQL will provide a best-in-class experience for developers by incorporating features such as REST API support, GraphQL integration through Data API Builder, and Regular Expression enablement. Additionally, native JSON support enables developers to more effectively deal with frequently changing schema and hierarchical data, facilitating the creation of more dynamic applications. Overall, we’re enhancing SQL development to be more extensible, performant, and user-friendly. All functionalities are underpinned by the security provided by the SQL Server engine, making it a truly enterprise-ready platform for AI.

Best-in-class security and performance

SQL Server 2025 is an industry leader in database security and performance. Support for Microsoft Entra managed identities improves credential management, reduces potential vulnerabilities, and provides compliance and auditing capabilities. SQL Server 2025 introduces outbound authentication support for MSI (Managed Service Identity) for SQL Server enabled by Azure Arc.

We’re also introducing performance and availability enhancements, extensively battle-tested on Microsoft Azure SQL, to SQL Server. In the new version you can boost workload performance and reduce troubleshooting with enhanced query optimization and query performance execution. Optional Parameter Plan Optimization (OPPO) is designed to enable SQL Server to choose the optimal execution plan based on customer-provided runtime parameter values and to significantly reduce bad parameter sniffing problems that can exist in workloads. Persisted statistics on secondary replicas prevent the loss of statistics during a restart or failover, thereby avoiding potential performance degradation. Regarding query execution, the improvements in batch mode processing and columnstore indexing further establish SQL Server as a mission-critical database for analytical workloads.   

Optimized locking reduces lock memory consumption and minimizes blocking for concurrent transactions through Transaction ID (TID) Locking and Lock After Qualification (LAQ). This capability enables customers to increase uptime and enhance concurrency and scale for SQL Server applications. 

Change event streaming for SQL Server brings real-time application integration with event driven architectures, command query responsibility segregation, and real-time intelligence. This will add new database engine capabilities to capture and publish incremental changes to data and schema to a provided destination such as Azure Event Hubs and Kafka in near real-time.

Microsoft Fabric and Azure Arc connected

In traditional data warehouse and data lake scenarios, integrating all your data involves designing, monitoring, and managing complex ETL (Extract, Transform, Load) processes to transfer operational data from SQL Server. These traditional methods do not support real-time data transfer, resulting in latency that prevents the creation of real-time analytics. Microsoft Fabric offers comprehensive, integrated, and AI-enhanced data analytics services designed to meet modern requirements of analytical workloads. Mirrored SQL Server Database in Fabric is a fully managed, resilient process that simplifies SQL Server data replication to Microsoft OneLake in near real-time. Mirroring will enable customers to continuously replicate data from SQL Server databases running on Azure virtual machines or outside of Azure, serving online transaction processing (OLTP) or operational store workloads directly into OneLake in order to facilitate analytics and insights on the unified Fabric data platform.

Azure continues to be a critical component of SQL Server. With Azure Arc, SQL Server 2025 will continue to offer cloud capabilities to enable customers better manage, secure, and govern their SQL estate at scale across on-premises and cloud. Capabilities like automatic patching, automatic backups, monitoring, and Best Practices Assessment offer customers more ways to streamline routine tasks and further enhance their business continuity. In addition, Azure Arc simplifies SQL Server licensing by offering a pay-as-you-go option, bringing flexibility and licensing visibility to our customers.

Sign up for the preview today

We’re currently onboarding customers and partners to SQL Server 2025 preview, in advance of general availability in the coming year. 

Register today to apply for the SQL Server 2025 Community Technology Preview (CTP)¹ and stay informed about SQL Server 2025 updates.

Microsoft just announced the upcoming release of SQL Server Management Studio (SSMS) 21 Preview 1. This release integrates Microsoft Copilot capabilities into SSMS. The Copilot experience streamlines SQL development by offering real-time suggestions, code completions, and best practice recommendations. If you would like to take part and have an early hands-on experience with this new capability, please use this link to indicate your interest.

¹Some of the new capabilities covered in this blog may not be available in the first CTP version.

The post Announcing Microsoft SQL Server 2025: Enterprise AI-ready database from ground to cloud appeared first on Microsoft SQL Server Blog.

By migrating their databases to Azure, customers like Ernst and Young are modernizing their data estate and leveraging cutting-edge cloud innovations. However, the migration process can be complex, whether moving within the same database management system (homogeneous) or between different systems (heterogeneous). Microsoft offers a suite of tools for migration to simplify the migration process. To further enhance the user experience, we are streamlining the Azure database migration tools ecosystem. This involves retiring certain overlapping tools to simplify finding the right tool and provide unified migration experiences across all phases of migration. As part of this effort, effective 12/15/2024 we are replacing some tools with unified experiences that offer capabilities across various migration stages in the drive to modernize their data estate and take advantage of innovation in the cloud.

Azure Database Migration Guides

Step-by-step guidance for modernizing your data assets

Learn more

With a refined set of tools, you can confidently plan, assess, and execute your database migration with minimal downtime, ensuring a smooth transition to Azure SQL. Post the 12/15/24, retirement date, Microsoft will stop supporting these tools for any issues that arise and will not issue any bug fixes or further updates. Here is the list of tools that are planned for retirement and Microsoft recommended replacement tools.

Microsoft recommended tools for migration to Azure SQL

With the retirement of Database Migration Assistant for Oracle (DMAO), Database Schema Conversion Toolkit (DSCT), Data Access Migration Toolkit (DAMT), Database Experimentation Assistant (DEA), the Azure database migration tooling ecosystem is greatly simplified. Here is Microsoft’s recommendation for database migration tools for customers moving to Azure SQL. 

Homogenous migrations (SQL Server to Azure SQL) 

If the SQL Server that will be migrated is already enabled by Azure Arc, you can use Arc capabilities to perform a migration assessment and get optimal Azure SQL Target recommendations. Additionally, SQL Server enabled by Azure Arc provides multiple Azure benefits to SQL Servers outside Azure like automated backups and patching, Microsoft Defender for SQL, inventory of instances and databases, and Entra ID support. By enabling these Arc features, you can leverage cloud automation and security for Azure SQL Server even before you migrate. 

If the SQL Server outside Azure is not inventoried yet, you can use Azure Migrate for discovery, assessment and business case to know the right Azure SQL targets for your on-premises SQL Workloads and to get the projected cost savings of migrating to Azure SQL.

To migrate SQL Server into an Azure Virtual Machine with the same configuration as the source, users can use Azure Migrate to perform lift and shift migrations. SQL Server on Azure Virtual Machines allows you to easily migrate your SQL Server workloads to the cloud, offering SQL Server’s performance and security along with Azure’s flexibility and hybrid connectivity to address urgent business needs. Later you can evaluate one of the Azure SQL PaaS targets (Azure SQL Managed Instance, Azure SQL Database) and modernize to a PaaS service for better cost and workload performance optimizations. 

If you have completed an assessment and are ready to move to Azure SQL Managed Instance or Azure SQL Database, you can start your migration journey with Azure Migrate, you can use Azure Database Migration service or Azure SQL Migration extension for Azure Data Studio can be used. 

If the SQL Server estate is already inventoried, users can use Azure SQL Migration extension for Azure Data Studio to complete the entire migration journey i.e., perform assessment, get Azure SQL Target recommendations and perform migrations.

Heterogenous migrations (non-SQL Server databases to Azure SQL) 

With the availability of Target Assessment and SKU recommendation capabilities in SQL Server Migration Assistant (SSMA) along with existing code conversion and migration capabilities, SSMA becomes a single tool that you need to use to migrate from other source database platforms like Oracle, DB2, SAP ASE, MySQL, Access to Azure SQL or SQL Server. 

Learn more about modernizing your databases with Azure

• Get step-by-step guidance for modernizing your Oracle and SQL Server databases to Azure in the Azure Database Migration Guides.
• Read about the Azure Migrate Assessment for Azure SQL to get an overview of SQL Server assessment process using Azure Migrate.
• Know how to complete end to end SQL Server to Azure SQL migration journey with Azure SQL Migration extension for Azure Data Studio. 
• Find documentation for SQL Server Migration Assistant (SSMA), a tool for assessing and automating migration from Microsoft Access, DB2, MySQL, Oracle, and SAP ASE.

The post Modernize your database with the consolidation and retirement of Azure Database Migration tools appeared first on Microsoft SQL Server Blog.

“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  

Migrate to Microsoft Azure

Boost productivity and enable innovation.

Read more

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 

• Why migrate Windows Server and SQL Server to Azure: ROI, innovation, and free offers 
• Get the full ROI and TCO reports from IDC: The Business Value of Microsoft Azure SQL Database and Azure SQL Managed Instance Workload and The Business Value of Microsoft Azure for SQL Server and Windows Server Workloads 
• Previous announcement on SQL Server 2014 End-of-Support moment: Protect SQL Server 2014 workloads with Azure flexibility – Microsoft SQL Server Blog

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

To generate a production-ready schema-only copy of a database, it’s highly recommended to utilize tools such as Microsoft SQL Server Data Tools (SSDT); the Generate and Publish scripts Wizard; or data-tier application extraction, which includes either the Extract Data-tier Application (DAC) Wizard or a PowerShell script. These tools provide a reliable way to create a copy of a database for use in production environments.

Learn more about

• DBCC CLONEDATABASE (Transact-SQL) – SQL Server
• Clone an Existing Database – SQL Server Data Tools (SSDT)
• Generate and Publish Scripts Wizard – SQL Server Management Studio (SSMS)
• Create a statistics-only database using a generated statistics script – SQL Server
• Extract a DAC from a Database – SQL Server

Frequently asked questions

What is SSDT?

SQL Server Data Tools (SSDT) is a modern development tool that integrates with Microsoft Visual Studio and provides design, debugging, and deployment capabilities for building SQL Server relational databases, databases in Azure SQL, Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS) reports. With SSDT, developers can perform necessary tasks without needing the admin-focused SQL Server Management tool on their developer computer. Essentially, Visual Studio removes unnecessary features like admin tools, and focuses on tools that are useful for developers, like database and schema comparison tools.

What is the Generate and Publish Scripts Wizard?

The Generate and Publish Scripts Wizard is a feature in SQL Server Management Studio (SSMS) that allows you to create scripts for transferring a database between instances of the SQL Server Database Engine or Azure SQL Database. You can generate scripts for a database on an instance of the Database Engine in your local network, or from SQL Database. The generated scripts can be run on another instance of the Database Engine or SQL Database. You can also use the wizard to publish the contents of a database directly to a Web service created by using the Database Publishing Services. You can create scripts for an entire database or limit it to specific objects.

What is a data-tier application (DAC)?

A data-tier application (DAC) is a logical database entity that defines all of the SQL Server objects—such as tables, views, and instance objects, including logins—associated with a user’s database. A DAC is a self-contained unit of the entire database model and is portable in an artifact known as a DAC package, or .dacpac. Tooling support for data-tier applications enables developers and database administrators to deploy dacpacs to new or existing databases. Deployments to an existing database update the database model from the existing state to match the contents of the dacpac. Developers build DACs from SQL database projects, a declarative development concept for building SQL objects that enables source control on the database schema.

A .bacpac is a related artifact that, by default, encapsulates the database schema and the data stored in the database. The primary use case for a BACPAC is to move a database from one server to another—or to migrate a database from a local server to the cloud—and archiving an existing database in an open format.

What is DBCC CLONEDATABASE command?

DBCC CLONEDATABASE creates a new database that contains the schema of all the objects and statistics from the specified source database. Cloned databases copy all schema and metadata of the source database without copying any data.

How do I use Schema Compare to compare different database definitions?

SSDT includes a Schema Compare utility that you can use to compare two database definitions. The source and target of the comparison can be any combination of connected database, SQL Server database project or snapshot, or .dacpac file. The results of the comparison appear as a set of actions that must be taken with the target to make it the same as the source. Once the comparison is complete, you can update the target directly (if the target is a project or a database) or generate an update script that has the same effect.

The differences between source and target appear in a grid for easy review. You can drill into and review each difference in the results grid or in script form. You can then selectively exclude specific differences.

You can save comparisons either as part of an SQL Server Database project or as a standalone file. You can also set options that control the scope of the comparison and aspects of the update. Then you can save the comparison so that you can easily repeat the same comparison later or use it as the starting point for a new comparison.

Why do I need to generate a schema-only clone of a database with statistics in SQL Server?

You will need to generate a schema-only clone of a database with statistics to investigate performance issues.

The query optimizer in SQL Server uses the following types of information to determine an optimal query plan:

• Database metadata
• Hardware environment
• Database session state

Typically, you must simulate all these same types of information to reproduce the behavior of the query optimizer on a test system.

Microsoft Customer Support Services might ask you to generate a schema script of the database along with statistics to investigate a query optimizer issue.

The post Update on the support of DBCC CLONEDATABASE for production use appeared first on Microsoft SQL Server Blog.

This week, we are proud to be back in front of our community at SQLBits, together with our partner AMD to share the latest innovations from ground to cloud and beyond. From SQL Server, Azure SQL, to our powerful solutions like Microsoft Fabric and Microsoft Copilot, these product enhancements are designed to help make application migration, modernization, and development easier so you can power what’s next.

Better performance with the next generation of Azure SQL Managed Instance ​ 

What sets the SQL Server family apart from other operational databases is that it’s all built on the same SQL engine. So, whether you’re running at the edge or in the cloud, the power to unlock the potential of data and AI is always there. We’re announcing the public preview of Azure SQL Managed Instance Next-gen GP, now even more powerful and performant. Accelerate your migrations and efficiently manage your unique workload demands. Enhance your productivity with superior performance and adaptable compute and storage choices. Join the preview to maximize your efficiency.  

We now have a way customers can get stated with Azure SQL Managed Instance. Our free offer gives you:

• A General Purpose instance with up to 100 databases
• 720 vCore hours of compute every month
• 64 GB of storage

Azure SQL Managed Instance

Enhance your productivity with superior performance and more

Try it now free

AI-power your Azure SQL Database experience with Copilot 

We are bringing the power of Copilot to Azure SQL Database, now in private preview. Copilot in Azure SQL Databases delivers a set of AI-enhanced experiences built to help streamline design, operation, optimization of Azure SQL Database-driven applications, and improve productivity in the Azure Portal. This new functionality introduces two new Azure portal experiences: 

• Natural language to SQL: This experience within the Azure portal query editor for Azure SQL Database translates natural language queries into SQL, making database interactions more intuitive.  
• Microsoft Copilot for Azure integration: This experience adds Azure SQL Database skills into Copilot for Azure, customers with self-guided assistance, empowering them to manage their databases and solve issues independently.  

Sign up for the preview access.

Simplify your journey to Azure with SQL Server enabled by Azure Arc 

Earlier this month, we introduced a way to streamline migration to Azure SQL with SQL Server enabled by Azure Arc. Migration assessment removes some of the complexity around cloud migration by helping you better assess your SQL Server readiness for Azure SQL. Through the Azure Arc agent, customers can get help with:

• Streamlining discovery and migration readiness assessments.
• Evaluating and measuring the readiness of SQL Server instance and databases.
• Getting best-fit recommendations.   

Learn about this assessment “SQL Server enabled by Azure Arc, now assists in selecting the best Azure SQL target.” 

Deliver better value and power AI with Flexible Server in Azure Database for PostgreSQL 

In November 2023, we announced the preview of the new Azure AI extension, enabling you to integrate Azure AI services with your operational data in Azure Database for PostgreSQL. Now, we’re sharing that Flexible Server in Azure Database for PostgreSQL is now directly integrated with Azure OpenAI Service. Learn how to use Azure AI with Azure Database for PostgreSQL.

We were excited to have our AMD partners join us to co-sponsor SQLBits to showcase how best in class technology partnerships can help customers achieve their business outcomes for both SQL Server and PostgreSQL workloads. A recently commissioned Principled Technologies report found that for customers who migrated to Azure Databases for PostgreSQL—flexible server, backed by AMD EPYC™ processors—saw significantly faster online transaction processing (OLTP) performance, in fact, 4.71 times new orders per minute when compared to single server. Customers also achieved better value, 3.88 times the performance per dollar. Read the full report.

We look forward to the week ahead and connecting with you in person. 

The post Expand the limits of innovation with Azure data appeared first on Microsoft SQL Server Blog.

We are excited to get back in front of customers at Microsoft Ignite 2023 and PASS Data Community Summit to announce powerful product enhancements across Microsoft Azure databases designed to help customers take the next step or the first step in their transformation journey, with databases that are intelligent, trusted, and ready for developers to build, without limits.   

Limitless innovation for cloud native applications

If you are an application developer looking for a flexible relational cloud database solution with performance and scalability to support your most demanding applications, you’ll want to check out Microsoft Azure SQL Database Hyperscale. Built on a unique architecture that splits the storage and compute nodes, these resources scale independently to meet the unique requirements of your apps. Plus, you can eliminate the need to pre-provision storage resources, as the storage automatically scales to meet demand, with support of up to 100 TB. We are thrilled to announce that we are introducing lower compute pricing on SQL Database Hyperscale, saving customers up to 35 percent on their compute bill. Effective December 15, 2023, customers will have competitive pricing on the resources they need to build scalable, secure, AI-ready applications. 

We’re also excited to share that the Microsoft Azure SQL Managed Instance feature wave has reached general availability. This set of features improves Azure SQL Managed Instance’s performance, reliability, and security. The latest release will deliver deeper integration with Microsoft SQL Server on-premises and the wider Azure service platform. And soon, customers will be able to start testing Azure SQL Managed Instance for free. Landing in December 2023, customers will be able to run proof of concepts, test applications or simply learn more about the operational benefits of a fully managed database-as-a-service. This is in addition to the free Azure SQL Database offer that launched in October 2023.  

Microsoft is also excited to share the newest updates for our fully managed community based open-source databases. These services help you manage your database and database infrastructure with automation, freeing you from the routine database management tasks so you can concentrate on what matters most.

Enhanced performance and scalability for Microsoft Azure Database for PostgreSQL

The latest enhancements for Azure Database for PostgreSQL deliver advanced storage and compute capabilities that enable optimal price-performance for enterprise production workloads. Customers can expect enhancements for advanced storage, compute capabilities, and flexibility for managing performance and cost.  

Azure Database for PostgreSQL extension for Azure AI

The PostgreSQL extension for Azure AI allows developers to use large language models (LLMs) and build rich PostgreSQL generative AI applications, meaning PostgreSQL queries on Azure can now power Azure AI applications. It enables calling into Microsoft Azure OpenAI Service to generate LLM-based vector embeddings that allow efficient similarity searches, which is particularly powerful for recommendation systems, as well as calling into Azure AI Language for a wide range of scenarios such as sentiment analysis, language detection, entity recognition, and more.

New performance enhancements in Microsoft Azure Database for MySQL Business Critical 

New performance enhancements in Azure Database for MySQL Business Critical service tier makes it ideal for high-performance transactional or analytical applications. In fact, a recent performance benchmark study by Principled Technologies shows that Azure Database for MySQL Business Critical service tier is up to 50 percent faster than MySQL on Amazon Web Services Relational Data Service and up to 2.26 times faster than Google Cloud Platform Cloud SQL for MySQL. These key innovations help make Azure Database for MySQL Business Critical the perfect option to run mission-critical, Tier 1 MySQL workloads.

Extend Azure to your entire data estate

For all the innovation that customers are driving in the cloud, we recognize much of the customer’s data remains on-premises. This is why Microsoft continues to invest heavily in ensuring that customers can get the most from their entire data estate with Microsoft Azure Arc. The latest monitoring capabilities from SQL Server-enabled by Azure Arc are designed to deliver critical insights across your entire SQL Server environments, optimizing database performance and delivering fast diagnostic times.  

Customers can also now improve SQL Server business continuity and consistency by viewing and managing Always On availability groups, failover cluster instances, and backups directly from the Azure portal. This capability provides better visibility and an easier, more flexible way to configure critical database operations.  

In addition, with Extended Security Updates as a service and automated patching, customers can always keep their apps secure, compliant, and up to date. Learn more about these latest features.

We look forward to the week ahead and connecting with you in person.

The post Power what’s next with limitless relational databases from Azure appeared first on Microsoft SQL Server Blog.

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* 

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:

• Azure migration and modernization center with resources for every stage of your cloud migration.
• What are Extended Security Updates for SQL Server? Covering more details on Extended Security Updates and your options.
• SQL Server and Windows Server Extended Security Updates resource page.
• Extended Security Updates enabled by Azure Arc with details on how to get started with this option.

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

Today, Microsoft is pleased to announce the release of centrally managed Azure Hybrid Benefit for SQL Server, a new Azure portal feature that helps you improve SQL Server license management at multiple levels, including at account(s) and subscription levels, so you can ensure you are making the most out of your investments with the Microsoft SQL Server platform.

Having full visibility into your SQL Server estate can help optimize your costs, as it enables the ability to track your SQL Server with Software Assurance license utilization against Azure Hybrid Benefit, so you can identify additional licenses to maximize cost savings. Just to give you an idea, you can save up to 93 percent more than SQL Server on AWS Relational Database Service (RDS) by using your Software Assurance-enabled SQL Server licenses on Azure through Azure Hybrid Benefit.¹

Azure Hybrid Benefit

Azure Hybrid Benefit is a licensing offer that helps you migrate and save to Azure.

Learn more

Overview of Azure Hybrid Benefit

Azure Hybrid Benefit is a licensing benefit that is unique to Microsoft customers. Azure Hybrid Benefit allows you to apply your existing SQL Server licenses covered by Software Assurance for discounted rates on Azure SQL Database and Azure SQL Managed Instance licenses when you decide to move to Microsoft Azure.

Now, with the new centrally managed Azure Hybrid Benefit for SQL Server you have an easier way to leverage this benefit, as you can apply Azure Hybrid Benefit to SQL Server licenses to Azure at scale. Just one administrator can spend a few minutes assigning a single block of licenses across an entire Azure subscription or billing account, just to give you an example. And proactive notifications are available when license assignments need to be refreshed, so you can apply SQL Server Enterprise and Standard Edition core licenses together to cover Azure SQL resources and continue optimizing your costs.

An administrator can monitor Azure Hybrid Benefit utilization and directly adjust licenses assigned to Azure. For example, an administrator might see an opportunity to save more money by assigning more licenses to Azure. Then they speak with their procurement department to confirm license availability. Finally, they can easily assign the licenses to Azure and start saving.

Here’s a snapshot of how the new centrally managed Azure Hybrid Benefit for SQL Server works:

With the new centrally managed Azure Hybrid Benefit for SQL Server you can also better manage costs during usage spikes, as you can easily scale up the same resource or add more resources during temporary spikes. You don’t need to assign more SQL Server licenses (for example, closing periods or increased holiday shopping). For short-lived workload spikes, pay-as-you-go charges for the extra capacity might cost less than acquiring more licenses to use Azure Hybrid Benefit for the capacity. Managing the benefit at a scope, rather than at a resource-level, helps you to decide based on aggregate usage.

As data governance becomes paramount to businesses across industries, having control over your database licenses can also help you best respond to internal audits and other compliance requirements, as it provides a comprehensive view of your SQL Server environment. The new centrally managed Azure Hybrid Benefit for SQL Server helps you gain confidence in compliance as it increases visibility into license allocation and limits the number of roles who can apply licenses to Azure Hybrid Benefit. In the resource-level Azure Hybrid Benefit model, resource owners might select Azure Hybrid Benefit when there are no licenses available. Or they might not select the benefit when there are licenses available. Scope-level management of Azure Hybrid Benefit solves this situation. The billing admins that manage the benefit centrally are positioned to confirm with procurement and software asset management departments how many licenses are available to assign to Azure. The following diagram illustrates the point.

Learn more

More control over your estate enables you to help put your organization in a good position to sustain compliance moving forward. 

This new experience is available for Microsoft customers with SQL Server Enterprise and Standard Edition core licenses with Software Assurance or core subscription licenses starting April, 26, 2023. You can access this new capability through the Azure Portal, under Cost Management, Reservations and Hybrid Benefit. First, confirm that all your SQL Server Azure Virtual Machines (VMs) are visible to you and Azure by enabling automatic registration of the self-installed SQL Server images with the Infrastructure as a Service (IaaS) extension tool. For more information, see Register multiple SQL VMs in Azure with the SQL IaaS Agent extension.

Take ownership of your investments in SQL Server and start saving with Azure Hybrid Benefit today!

Learn more about centrally managed Azure Hybrid Benefit and prepare for a successful migration plan with the Azure Migration Readiness Toolkit.

¹Price performance claims based on data from a study commissioned by Microsoft and conducted by Principled Technologies in April 2022. The study compared performance and price performance between a 16 vCore, 64 vCore and 80 vCore Azure SQL Managed Instance using premium-series hardware on the business-critical service tier and the db.m6i.32xlarge, db.r5b.4xlarge and db.r5b.16xlarge offerings for Amazon Web Services Relational Database Service (AWS RDS) on SQL Server. (Continue below)

The post Capitalize on your investments with the new centrally managed Azure Hybrid Benefit for SQL Server appeared first on Microsoft SQL Server Blog.

Azure Data Studio

A modern open-source, cross-platform hybrid data analytics tool designed to simplify the data landscape.

Learn more

Connectivity

The migration from the Active Directory Authentication Library (ADAL) to Microsoft Authentication Library (MSAL) was a significant undertaking by the team. This was necessary as ADAL support ends in June of this year, and it provides multiple benefits for those environments using Azure Activity Directory (AAD). AAD users should notice an improved and more reliable experience, particularly around token refresh and connection stability. This also helped us fix an issue in the MySQL extension for AAD. 

Additional changes include improved loading of Azure resources and new Dedicated SQL Pools and Azure Synapse Analytics nodes in the Azure tree. Azure Data Studio 1.41 also provides the ability to customize the name of firewall rules for Azure SQL and adds support for connecting to a server alias (versus a server name).

If you have applications that use ADAL, please see the Migrate applications to the Microsoft Authentication Library (MSAL) page for more information.

Object explorer

A new area of focus in this release is Object Explorer (OE), and this will continue to be an area we improve upon in the next few releases. Those with serverless Azure SQL previously reported issues with folders not expanding correctly, and with databases being brought online (thus incurring costs) when it was not expected. Other users noted that expanding OE timed out after 45 seconds. We have addressed all these issues in this release, in addition to adding support for Ledger Views.

Query results

The query results window got a fair bit of attention this release as we work through the backlog of open issues. First, we introduced a new configuration option to show or hide the action bar in the query results view. The Query Editor > Results: Show Action Bar option can be found in the command palette (CTRL + , ) if you type Show Action Bar. By default, the action bar is shown in the query results pane, as seen in the screenshot below:

There are also improvements around opening JSON files and the visibility of the horizontal scroll bar in the query results pane. Azure Data Studio 1.41 now correctly handles line breaks in cells when copying from the results grid and pasting to an editor, and the auto-resizing of columns in the output pane has been updated to better display column contents. Finally, cell selection and navigation in the results grid have been enhanced, and we introduced additional summary details when selecting multiple cells in the results window:

Extensions

Multiple teams have been working on updates to various extensions available from Azure Data Studio.  For SQL Projects, we have improved the experience of finding projects by providing a dropdown that lists saved projects, rather than requiring users to browse to their location. We had reports that differences in schema compare were not highlighted correctly, and that problem has been fixed.

Users of the SQL Migration extension will see an improvement in the migration process as we better support migrations to specific subscriptions (such as government), and the extension now includes the Premium Series Memory Optimized SQL MI SKU as a recommendation where appropriate.

MongoDB and Microsoft Azure continue to build on their partnership by introducing an extension for MongoDB Atlas and Azure Data Studio on the Azure Marketplace. This Extension is available in Public Preview as of today, Wednesday, January 25, 2023.  You already know that Azure Data Studio is a modern open-source, cross-platform hybrid data analytics tool designed to simplify your data landscape, and customers can use Azure Data Studio to work with their data sitting in one or more Azure data services. MongoDB Atlas on Azure provides a fully managed solution for MongoDB in the cloud, and you can now seamlessly connect to and query data on MongoDB Atlas right from Azure Data Studio. This allows you to interact with data on MongoDB Atlas alongside other data services and provides a unified view of your data estate.  If you are an Azure customer that is curious about building applications with MongoDB Atlas and want to amplify your integrated experience inside Azure Data Studio, try Pay-As-You-Go Atlas on the Azure Marketplace today!

With this 1.41 release, the Polyglot Notebooks extension will be removed from the Azure Data Studio Extension Marketplace. For a polyglot notebooks experience, we recommend folks use the Polyglot Notebooks in Visual Studio Code.

Odds and ends

Continuing on our path of adding support for arm64, we now include support for arm64 on Windows.  Whether you run iOS or Windows, Azure Data Studio 1.41 now provides the capability to leverage arm64, resulting in improved performance.

We are pleased to see users embracing Table Designer and Query Plan Viewer, two features that became generally available (GA) in the November release. In 1.41 we fixed an issue related to opening Table Designer for Ledger tables, and one related to creating a table when another table with the same name already exists.

There were also two requests specific to Query Plan Viewer that got attention in this release. When saving query plan files from Azure Data Studio, we now incrementally append a number to the end of the file for unique naming, and we’ve altered the default folder location when saving plans for a more consistent experience.

Lastly, we had previously announced that we were removing Big Data Cluster functionality from Azure Data Studio. This removal has been delayed until a later release.

Looking forward

We are already at work on the next release of Azure Data Studio and are making plans for what we want to accomplish in 2023. You can expect that we will continue to review backlog issues and address them as they relate to an existing area of focus. We have more changes coming related to the connection dialog and object explorer, and you will also see improvements in user management. Finally, if you see a comment on an issue you opened–whether recent or ages ago–please feel free to respond and provide more information if you are able. 

The post Azure Data Studio 1.41 release appeared first on Microsoft SQL Server Blog.

Today, we announced the general availability of SQL Server 2022, the most Azure-enabled release of SQL Server yet, with continued innovation across performance, security, and availability¹. This marks the latest milestone in the more than 30-year history of SQL Server.

SQL Server 2022 is a core element of the Microsoft Intelligent Data Platform. The platform seamlessly integrates operational databases, analytics, and data governance. This enables customers to adapt in real-time, add layers of intelligence to their applications, unlock fast and predictive insights, and govern their data—wherever it resides.

SQL Server 2022’s connections to Azure², including Azure Synapse Link and Microsoft Purview make it easier for customers to drive deeper insights, predictions, and governance from their data at scale. Azure integration also includes managed disaster recovery (DR) to Azure SQL Managed Instance, along with near real-time analytics, allowing database administrators to manage their data estates with greater flexibility and minimal impact to the end user³.

Performance and scalability are automatically enhanced via built-in query intelligence. Security innovation, building on SQL Server’s track record as being the least vulnerable database over the last 10 years, continues with Ledger for SQL Server, which uses blockchain to create a tamper-proof track record of time of all changes to the database.

Watch how one of our customers, Mediterranean Shipping Company, is already taking advantage of the new capabilities in SQL Server 2022.

Azure-enabled features

Link feature for Azure SQL Managed Instance: To ensure uptime, SQL Server 2022 is fully integrated with the new link feature in Azure SQL Managed Instance. With this new capability, you benefit from a PaaS environment applied to disaster recovery—allowing you to spend less time on setup and management even when compared to an IaaS environment. This works by using a built-in Distributed Availability Group (DAG) to replicate data to a previously deployed Azure SQL Managed Instance as a DR replica site. The instance is ready and waiting for whenever you need it—no lengthy configuration or maintenance required. You can also use this link feature in read scale-out scenarios to offload heavy requests that might otherwise affect database performance. We are working on building out more capabilities to support online disaster recovery.

Azure Synapse Link for SQL: Previously, moving data from on-premises databases, like SQL Server, to Synapse required you to use extract, transform, and load (ETL). Configuring and running an ETL pipeline is time-consuming, and insights often lag behind what is happening at any moment. Azure Synapse Link for SQL Server 2022 provides automatic change feeds to capture the changes within SQL Server and feed them into Azure Synapse Analytics. Synapse Link provides near real-time analysis and hybrid transactional and analytical processing with minimal impact on operational systems. Once the data comes to Synapse, you can combine it with many different data sources, regardless of their size, scale, or format, and run powerful analytics over all of it using your choice of Azure Machine learning, Spark, or Power BI. Because the automated change feeds only push what is new or different, data transfer occurs much faster and allows for near real-time insights, all with minimal impact on the performance of the source database in SQL Server 2022.

“Synapse Link for SQL Server 2022 helps us to seamlessly replicate operational data in near real-time to be able to have more powerful analytics.”—Javier Villegas, IT Director for DBA and BI Service, Mediterranean Shipping Company.

Microsoft Purview integration: Microsoft Purview is a unified data governance and management service. We are excited to highlight that SQL Server is also integrated with Microsoft Purview for greater data discovery, allowing you to break down data silos. Through this integration you will be able to:

• Automatically scan your on-premises SQL Server for free to capture metadata.
• Classify your data using built-in and custom classifiers and Microsoft Information Protection sensitivity labels.
• Set up and control specific access rights to SQL Server.

Additional Azure-connected features: SQL Server 2022 has a number of additional Azure-enabled features. A simple connection to the Azure Arc agent, part of the default setup process for SQL Server 2022, enables additional capabilities, including:

• Single view of all SQL Servers deployed on-premises, in Azure and other clouds.
• Fully automated technical assessment for SQL Server at no additional cost, to help you optimize your database’s performance, scalability, security, business continuity, and more.
• Protect your on-premises data using Microsoft Defender for Cloud.
• Secure identities with Single Sign-On and Azure Active Directory.
• Pay-as-you-go billing.

Continued innovation to the core SQL Server engine

Performance: Performance is critical. On the SQL Server Engineering team, our core engine feature principles are: do no harm, no app changes required. With SQL Server 2022, performance enhancements come without requiring code changes by the end user.

SQL Server continues to offer differentiated performance, with #1 OLTP performance, #1 Non-Clustered DW performance on 1TB, 3TB, 10TB, and 30TB according to the independent Transaction Processing Performance Council. In SQL Server 2022:

• With Query Store, we are adding support for read replicas and enabling query hints to improve performance and quickly mitigate issues without having to change the source T-SQL.
• With Intelligent Query Processing, we’re expanding more scenarios based on common customer problems. For example, the “parameter sensitive plan” problem refers to a scenario where a single cached plan for a parameterized query is not optimal for all possible incoming parameter values. With SQL Server 2022’s Parameter Sensitive Plan optimization feature, we automatically enable the generation of multiple active cached plans for a single parameterized statement. These cached execution plans will accommodate different data sizes based on the provided runtime parameter values.

“As a company with 24/7 availability requirements, we are looking forward to embracing all SQL Server 2022 features that can make database failover faster, such as Buffer Pool Parallel Scan, ParallelRedo and Accelerated Database Recovery (ADR) enhancements. On the development side, we expect to further utilize continuous improvements in the Intelligent Query Processing package. In an environment with a lot of servers and huge databases, even when you have people and resources to deal with performance issues, each feature that can improve performance or fix performance issues automatically or without touching the code is very valuable.” —Milos Radivojevic, Head of MSSQL Database Engineering at Entain.

Security: Over the past ten years, SQL Server has had few vulnerabilities. Building on this, the new Ledger for SQL Server feature creates a tamper-evidence track record of data modifications over time. This detects tampering by malicious actors and is beneficial for scenarios such as internal and external audits.

Availability: With Contained Availability Groups you can create an Always On availability group that manages its own metadata objects (users, logins, permissions) at the availability group level in addition to the instance level with contained availability groups. Additionally, it keeps multi-write environments running smoothly when you have users across multiple locations. With SQL Server 2022, we are automating the last-writer wins rule to ensure that when a conflict is detected, the most recent modification time will be chosen to be persisted on all replicas.

New pay-as-you-go SQL Server billing model, enabled by Azure Arc

Today, we are also excited to announce a new billing model that provides flexibility to innovate quickly and move as fast as you do.

Via a simple connection to Azure Arc, a default part of the SQL Server 2022 setup process, you now have access to a new cloud-enabled billing model for SQL Server, providing you with cost efficiency to pay only for what you use. Pay by the hour for consumption spikes and ad hoc usage without the need for upfront investment. Learn more in the announcement blog post.

Azure SQL migration offer

If you’re ready to start your journey to the cloud, Microsoft can help. Today we are announcing a new offer, the SQL + Apps Migration Factory. This program can assess and migrate qualifying low complexity SQL Server applications and databases to Azure SQL at no cost to you.⁴ Talk to your Microsoft account team or apply now at aka.ms/SQLAppsMigrationFactory to get started. 

SQL Server IoT 2022 

We are also announcing SQL Server IoT 2022, which is designed for fixed function use cases and licensed through the OEM channel under special dedicated use rights. You can read more about SQL Server IoT 2022.  

Learn more and get started with SQL Server 2022 today

• Learn more about SQL Server 2022 at the PASS Data Community Summit, including Microsoft and community-delivered keynote and general sessions.
• Visit the SQL Server 2022 website.
• Get ready for SQL Server 2022 by reading the documentation and watching SQL Server 2022 Data Exposed video series.
• Try out the Microsoft Learn SQL Server 2022 module and the SQL Server 2022 workshop.
• Get started today by deploying in Azure.
• Let us know if you have any thoughts or feedback through our SQL Server feedback portal.

Learn more about Azure SQL Managed Instance

• Learn about the November 2022 feature and other announcements at the PASS Data Community Summit.  
• Visit the Azure SQL Managed Instance website. 

^[1] SQL Server 2022 free editions (Developer edition, Express edition) are available to download starting today. SQL Server 2022 paid editions (Enterprise edition, Standard edition) will be available in Volume Licensing (Enterprise Agreement, Enterprise Agreement Subscriptions) and MPSA starting today, which represents the majority of SQL Server customers. Customers purchasing via CSP, OEM, and SPLA can begin purchasing SQL Server 2022 in January 2023.

^[2] For all Azure-connected features of SQL Server 2022, customers can optionally enable these capabilities based on business requirements.

^[3] The bidirectional disaster recovery capability of the Link feature for Azure SQL Managed Instance is available in limited public preview. Sign up for early access. General availability will occur at a future date.

^[4] Subject to the limitations described in the full SQL + Apps Migration Factory program specifications here, and provided that the SQL Server workloads are low complexity with no code changes, Microsoft agrees to assess and migrate SQL Server databases and SQL Server-associated applications from your datacenter or AWS EC2 to Azure at no cost to customer. Migrations must be completed by June 30, 2023. 

The post SQL Server 2022 is now generally available appeared first on Microsoft SQL Server Blog.