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.