AZ579359 - Public Preview: Azure SQL updates for mid-November 2026

Azure Updates

Discussionpowered by zap.ms

Published

Nov 17, 2026

Status

In preview

Timeline

  • November 2026
    Preview

Product

Azure SQL Database
Azure SQL Managed Instance

Tag

Microsoft Ignite
Feature

Category

Databases
Hybrid + multicloud

Description

In mid-November 2026, the following updates and enhancements were made to Azure SQL:  

  • In SSMS, the new Create and Apply wizards make it simpler to create and use .dacpac and .bacpac files. The new feature consolidates and replaces the various data-tier application-related wizards with a modern, guided experience.
  • With Transparent Data Encryption (TDE), you can now temporarily halt the encryption scan on a database (suspending) and subsequently re-enable it (resuming) from the point of suspension. Suspend and resume help reduce the resource load of the TDE encryption scan, minimizing its impact on user workloads, database maintenance, and other operations. You can suspend the scan during periods of high activity and resume it when sufficient resources are available
  • Configure and lock time-based immutability for your Azure SQL Managed Instance LTR backups. Additionally, you can enable or remove legal holds on existing LTR backups to apply immutability for legal or audit purposes.
  • AI assisted query performance tuning helps you find and fix slow SQL queries. The Agent analyzes query plans and recommends query rewrites, query hints, and missing indexes, backing each recommendation by evidence and validation. 
  • Bring your own model (BYOM) to GitHub Copilot in SQL Server Management Studio (SSMS). Connect to a Microsoft Foundry deployment or another supported provider to use models that fit your workflow and organizational requirements, without leaving SSMS.
  • GitHub Copilot in SQL Server Management Studio (SSMS) 22.12.1 introduces a new chat experience powered by the GitHub Copilot SDK, the same foundation used in GitHub Copilot in Visual Studio and other GitHub Copilot experiences. 
  • Preserve your open query tabs and unsaved edits when you close SQL Server Management Studio (SSMS) and restore them the next time you open it.

Learn more: