How-to restore across different SQL Managed instances when using TDE with Customer Managed Keys
This how-to post focuses on how-to restore across different SQL Managed instances when using TDE with Customer Managed Keys. Transparent Data Encryption (TDE) with Customer Managed Keys uses Azure Key Vault, which provides highly available and scalable secure storage for RSA cryptographic keys backed by FIPS 140-2 Level 2 validated hardware security modules (HSMs).Introducing Azure SQL Managed Instance Next-gen GP
The next generation of the general purpose service tier for Azure SQL Managed Instance is a major upgrade that will considerably improve the storage performance of your instances while keeping the same price as current general purpose tier. Key improvements in the next generation of general purpose storage include support for 32 TB of storage, support for 500 DBs, lower storage latency, improved storage performance, and the ability to configure the amount of IOPS (I/O operations per second).Monitoring options available for Azure SQL Managed Instance
For customers in production with Azure SQL Managed Instance, to ensure business continuity you might want to consider continuously monitoring and tuning the instance performance. This article provides a single point of view describing options available to you in setting up resource, performance monitoring and alerting on your managed instance.Modernizing SSRS And A Step-by-Step Guide to Bringing ReportServer Databases to SQL Managed Instance
This article summarizes various options that can be taken to modernize SQL Server Reporting Services (SSRS) and then provides a detailed step-by-step guide to bringing report server databases to Azure SQL Managed Instance.User initiated manual failover on SQL Managed Instance
High availability is a fundamental part of SQL Managed Instance platform that works transparently for your database applications. We have released a new feature for user-initiated manual failover helping you manually trigger a failover on a managed instance by executing PowerShell and CLI commands, or by invoking an API call. This capability will allow you to test end to end application fault resiliency on automatic failovers in case of planned or unplanned events before deploying to production. In addition to testing how failover impacts existing database sessions, you can also verify if it changes the end-to-end performance due to changes in network latency. Because the restart operation is intrusive and a large number of them could stress the platform, only one failover call is allowed every 30 minutes for each managed instance.
