What's new in Azure SQL Managed Instance? (Archive)
Applies to: 
Azure SQL Managed Instance
This article summarizes older documentation changes associated with new features and improvements in the releases of Azure SQL Managed Instance. To learn more about Azure SQL Managed Instance, see the overview.
Return to What's new in Azure SQL Managed Instance?
2023
| Changes | Month | Details |
|---|---|---|
| Database copy and move GA | November | Perform an online database copy or move operation across managed instances. This feature is now generally available. Review Database copy and move to get started. |
| Ledger GA | November | Ledger in Azure SQL Managed Instance allows you to cryptographically attest to other parties, such as auditors or other business parties, that your data hasn't been tampered with. This feature is now generally available. Review Ledger to learn more. |
| Link from SQL MI to SQL Server 2022 preview | November | Configure a link from Azure SQL Managed Instance to SQL Server 2022. This feature is now in preview. Review Managed Instance link overview to learn more. |
| SQL Server DR to SQL MI preview | November | In the event of a disaster, you can recover your SQL Server 2022 database by failing over to SQL Managed Instance, and then failing back to SQL Server 2022 online by using the Managed Instance link. This feature has moved from a limited public preview that required signing up to an open public preview available to everyone. Review Online disaster recovery for SQL Server 2022 to learn more. |
| Hybrid failover benefit | October | The failover rights benefit has been extended to include a license-free DR replica when you configure your passive DR SQL managed instance with the link feature. Review License-free replicas to learn more. |
| Microsoft Entra ID rebrand | September | Azure Active Directory has been rebranded to Microsoft Entra ID. |
| Private endpoints GA | August | Establish secure and isolated connectivity between Azure SQL Managed Instance and multiple virtual networks without exposing the entire network infrastructure of your service by using a private endpoint. This feature is generally available. Review Private Link and private endpoints to learn more, or review these blog posts on Scenarios with private endpoints and Advanced scenarios with private endpoints to Azure SQL Managed Instance. |
| TDS 8.0 GA | August | Azure SQL Database now supports TDS 8.0 for strict encryption of data in transit. |
| XML compression GA | August | XML compression for Azure SQL Managed Instance is now generally available. You can use ALTER INDEX to apply XML compression to existing XML indexes. |
| Configure tempdb | June | Configure your tempdb settings for Azure SQL Managed Instance. Review tempdb to learn more. |
| Azure SQL bindings for Azure Functions GA | May | Azure Functions supports input bindings, and output bindings for the Azure SQL and SQL Server products. This feature is now generally available. Review Azure SQL bindings for Azure Functions to learn more. |
| Azure SQL triggers for Azure Functions preview | May | Azure Functions supports function triggers for the Azure SQL and SQL Server products. This feature is currently in preview. Review Azure SQL triggers for Azure Functions to learn more. |
| Ledger preview | May | The ledger feature allows you to cryptographically attest to other parties, such as auditors or other business parties, that your data hasn't been tampered with. This feature is now in preview for Azure SQL Managed Instance. To learn more, review Ledger. |
| License-free standby replica GA | May | Save on licensing costs if your failover group geo-secondary instance is designated as Standby and used for disaster recovery purposes only. Thanks to the Failover Rights benefit, you don't need licenses for your geo-secondary instance if you don't use it for reporting or other read-only workloads. The benefit is available regardless of the licensing model used for by the primary instance. This feature is now generally available. Review License-free standby replica to learn more. |
| CREATE EXTERNAL TABLE AS SELECT (CETAS) GA | April | CETAS is now generally available. You can use CETAS to create an external table on top of Parquet or CSV files Azure Blob storage or Azure Data Lake Storage (ADLS) Gen2. CETAS can also export, in parallel, the results of a T-SQL SELECT statement into the created external table. There is potential for data exfiltration risk with these capabilities, so CREATE EXTERNAL TABLE AS SELECT (CETAS) is disabled by default for Azure SQL Managed Instance. To enable, see CREATE EXTERNAL TABLE AS SELECT (CETAS). |
| Managed Instance link GA | April | Online replication of SQL Server databases hosted anywhere to Azure SQL Managed Instance. One-way replication is now generally available for SQL Server 2016 and SQL Server 2019. Review Managed Instance link to learn more. |
| Approximate Percentile GA | March | Support has been added to quickly compute percentiles using approximate percentile aggregate functions for large datasets with acceptable rank-based error bounds. This feature is now generally available. To learn more, review Approx_Percentile_Cont and Approx_Percentile_Disc. |
| Shrink Database / Shrink File with Low Priority GA | March | This feature solves the concurrency issues that can arise from shrink database and shrink file commands, especially during active maintenance or on busy OLTP environments. In WAIT_AT_LOW_PRIORITY mode, necessary tasks to shrink database files can be completed without negatively affecting application query performance. Review Shrink Database and Shrink File with Low Priority. |
2022
The following changes were added to SQL Managed Instance and the documentation in 2022:
| Changes | Details |
|---|---|
| Terraform | Deploy a managed instance by using Terraform. |
| Backup transparency with msdb GA | For the purpose of backup transparency, it's now possible to query the msdb database to explore automated backup history. This feature is generally available. To learn more, review backup transparency. |
| Cross-subscription PITR GA | It's now possible to restore your database for your SQL Managed Instance across subscriptions by using point-in-time restore (PITR). This feature is generally available. To learn more, review Point-in-time restore. |
| Database copy and move preview | Perform an online copy or move operation of your database across managed instances. This feature is currently in preview. To learn more, review Copy or move your database. |
| Free license for standby replica preview | It's now possible to designate your secondary DR-only instance as Standby, saving on licensing costs. This feature is currently in preview. To learn more, review Configure standby replica. |
| Gen5 hardware rename | The Gen5 hardware in the vCore purchasing model has been renamed to standard-series (Gen5). |
| Log Replay Service GA | Migrate your databases to Azure SQL Managed Instance using the Log Replay Service (LRS). This feature is now generally available. To learn more, review Log Replay Service overview. To get started, review Migrate with LRS |
| Managed Instance link for SQL Server 2022 GA | Using the Managed Instance link to replicate data from SQL Server 2022 to Azure SQL Managed Instance is now generally available. Using the link feature with versions older than SQL Server 2022 is still in preview. To learn more, review Managed Instance link. |
| Managed Instance link fail over to SQL Server 2022 preview | It's now possible to use the Managed Instance link feature to fail back from Azure SQL Managed Instance to SQL Server 2022. This feature is currently in preview. To learn more, review Managed Instance link. |
| Restore database to SQL Server GA | It's now possible to restore your database backup from Azure SQL Managed Instance to SQL Server 2022. The capability to do so is generally available, and enabled by default on all instances, both currently existing, and those deployed in the future. To learn more, review Restore database to SQL Server. |
| Time series GA | Generates a series of numbers within a given interval. This feature is generally available. Review GENERATE_SERIES and DATE_BUCKET to learn more. |
| Transactional replication GA | Replicate data from SQL Managed Instance to database hosted on SQL Server, SQL Managed Instance or SQL Database, or from SQL Server to SQL Managed Instance. This feature is now generally available. To learn more, review Transactional Replication. To get started, review Configure replication in Azure SQL Managed Instance. |
| Approximate percentiles preview | Support has been added to quickly compute percentiles using approximate percentile aggregate functions for large datasets with acceptable rank-based error bounds. This feature is currently in preview. To learn more, review Approx_Percentile_Cont and Approx_Percentile_Disc. |
| Automated TDE key rotation for CMK GA | Automatically switch to a new key when using a customer-managed key (CMK) with TDE. This feature is now generally available. To learn more, review Automated key rotation. |
| Data virtualization GA | The data virtualization feature allows users to join locally stored relational data with data queried from external data sources, such as Azure Data Lake Storage Gen2 or Azure Blob Storage. This feature is now generally available. Review Data virtualization to learn more. |
| Windows Auth for Azure Active Directory principals GA | Kerberos authentication for Azure Active Directory (Azure AD) enables Windows Authentication access to Azure SQL Managed Instance. This feature is now generally available (GA). To learn more, review Windows Auth for Azure Active Directory principals. |
| Query Store hints GA | Use query hints to optimize your query execution via the OPTION clause. This feature is now generally available (GA). To learn more, review, Query Store hints |
| JavaScript & Python bindings | Support for JavaScript and Python SQL bindings for Azure Functions is currently in preview. See Azure SQL bindings for Azure Functions to learn more. |
| Data virtualization preview | It's now possible to query data in external sources such as Azure Data Lake Storage Gen2 or Azure Blob Storage, joining it with locally stored relational data. This feature is currently in preview. To learn more, see Data virtualization. |
| Managed Instance link guidance | We've published a number of guides for using the Managed Instance link feature, including how to prepare your environment, configure replication by using SSMS, configure replication via scripts, fail over your database by using SSMS, fail over your database via scripts and some best practices when using the link feature (currently in preview). |
| Maintenance window GA, advance notifications preview | The maintenance window feature is now generally available, allowing you to configure a maintenance schedule for your Azure SQL Managed Instance. It's also possible to receive advance notifications for planned maintenance events, which is currently in preview. Review Maintenance window advance notifications (preview) to learn more. |
| Windows Auth for Azure Active Directory principals preview | Windows Authentication for managed instances empowers customers to move existing services to the cloud while maintaining a seamless user experience, and provides the basis for infrastructure modernization. Learn more in Windows Authentication for Azure Active Directory principals on Azure SQL Managed Instance. |
2021
The following changes were added to SQL Managed Instance and the documentation in 2021:
| Changes | Details |
|---|---|
| 16 TB support for General Purpose GA | Deploying a 16-TB instance to the General Purpose service tier is now generally available. See resource limits to learn more. |
| Azure AD-only authentication GA | Restricting authentication to your Azure SQL Managed Instance only to Azure Active Directory users is now generally available. To learn more, see Azure AD-only authentication. |
| Distributed transactions GA | The ability to execute distributed transactions across managed instances is now generally available. See Distributed transactions to learn more. |
| Link feature preview | Use the link feature for SQL Managed Instance to replicate data from your SQL Server hosted anywhere to Azure SQL Managed Instance, leveraging the benefits of Azure without moving your data to Azure, to offload your workloads, for disaster recovery, or to migrate to the cloud. See the Link feature for SQL Managed Instance to learn more. The link feature is currently in limited public preview. |
| Long-term backup retention GA | Storing full backups for a specific database with configured redundancy for up to 10 years in Azure Blob storage is now generally available. To learn more, see Long-term backup retention. |
| Move instance to different subnet GA | It's now possible to move your SQL Managed Instance to a different subnet. See Move instance to different subnet to learn more. |
| Split what's new | The previously combined What's new article has been split by product - What's new in SQL Database and What's new in SQL Managed Instance, making it easier to identify what features are currently in preview, generally available, and significant documentation changes. Additionally, the Known Issues in SQL Managed Instance content has moved to its own page. |
| 16 TB support for General Purpose preview | Support has been added for allocation of up to 16 TB of space for SQL Managed Instance in the General Purpose service tier. See resource limits to learn more. This instance offer is currently in preview. |
| Parallel backup | It's now possible to take backups in parallel for SQL Managed Instance in the General Purpose tier, enabling faster backups. See the Parallel backup for better performance blog entry to learn more. |
| Azure AD-only authentication preview | It's now possible to restrict authentication to your Azure SQL Managed Instance only to Azure Active Directory users. This feature is currently in preview. To learn more, see Azure AD-only authentication. |
| Resource Health monitor | Use Resource Health to monitor the health status of your Azure SQL Managed Instance. For more information, see Resource health. |
| Granular permissions for data masking GA | Granular permissions for dynamic data masking for Azure SQL Managed Instance is now generally available (GA). To learn more, see Dynamic data masking. |
| User-defined routes (UDR) tables | Service-aided subnet configuration for Azure SQL Managed Instance now makes use of service tags for user-defined routes (UDR) tables. See the connectivity architecture to learn more. |
| Audit management operations | The ability to audit SQL Managed Instance operations is now generally available (GA). |
| Log Replay Service | It's now possible to migrate databases from SQL Server to Azure SQL Managed Instance using the Log Replay Service. To learn more, see Migrate with Log Replay Service. This feature is currently in preview. |
| Long-term backup retention | Support for Long-term backup retention up to 10 years on Azure SQL Managed Instance. To learn more, see Long-term backup retention |
| Maintenance window | The maintenance window feature allows you to configure a maintenance schedule for your Azure SQL Managed Instance. To learn more, see maintenance window. |
2020
The following changes were added to SQL Managed Instance and the documentation in 2020:
| Changes | Details |
|---|---|
| Audit support operations | The auditing of Azure support operations capability enables you to audit Azure support operations when you need to access your servers and/or databases during a support request to your audit logs destination (Preview). To learn more, see Audit support operations. |
| Elastic transactions | Elastic transactions allow for distributed database transactions spanning multiple databases across Azure SQL Database and Azure SQL Managed Instance. Elastic transactions have been added to enable frictionless migration of existing applications, as well as development of modern multitenant applications relying on vertically or horizontally partitioned database architecture (Preview). To learn more, see Distributed transactions. |
| Configurable backup storage redundancy | It's now possible to configure Locally redundant storage (LRS) and zone-redundant storage (ZRS) options for backup storage redundancy, providing more flexibility and choice. To learn more, see Configure backup storage redundancy. |
| TDE-encrypted backup performance improvements | It's now possible to set the point-in-time restore (PITR) backup retention period, and automated compression of backups encrypted with transparent data encryption (TDE) are now 30 percent more efficient in consuming backup storage space, saving costs for the end user. See Change PITR to learn more. |
| Azure AD authentication improvements | Automate user creation using Azure AD applications and create individual Azure AD guest users (preview). To learn more, see Directory readers in Azure AD |
| Global VNet peering support | Global virtual network peering support has been added to SQL Managed Instance, improving the geo-replication experience. See geo-replication between managed instances. |
| Hosting SSRS catalog databases | SQL Managed Instance can now host catalog databases of SQL Server Reporting Services (SSRS) for versions 2017 and newer. |
| Major performance improvements | Introducing improvements to SQL Managed Instance performance, including improved transaction log write throughput, improved data and log IOPS for Business Critical instances, and improved tempdb performance. For more information, see the improved performance tech community blog to learn more. |
| Enhanced management experience | Using the new OPERATIONS API, it's now possible to check the progress of long-running instance operations. To learn more, see Management operations. |
| User-initiated failover | User-initiated failover is now generally available, providing you with the capability to manually initiate an automatic failover using PowerShell, CLI commands, and API calls, improving application resiliency. To learn more, see, testing resiliency. |
Known issues
The known issues content has moved to a dedicated known issues in SQL Managed Instance article.