Azure SQL Managed Instance Newsletter for August 2024

Editor's Note

Get ready to elevate your SQL Server DBA skills to the cloud at the PASS Data Summit 2024! Our learning pathway, "Becoming an Azure SQL DBA – Advancing the Role of the On-Premises SQL Server DBA" features four in-depth sessions designed to help you transition smoothly to Azure SQL.?

?? Learn more https://aka.ms/pass2024clouddba

Learning Pathway: Becoming an Azure SQL DBA - Advancing the Role of the On-Premises SQL Server DBA ( youtube.com )

Azure SQL Managed Instance Curiosity

Did you hear we're adding JSON data types to SQL ?

Azure SQL MI YouTube Channel

Did you know that the Update Policy for Azure SQL Managed Instance allows you to choose the SQL Serve engine version compatibility between SQL Server 2022 and the next version of SQL Server?

Subscribe to our new YouTube channel! We are releasing all sorts of videos here describing various features, functionality, tips, tricks and more at - Azure SQL !

Below are a listing of our recent videos:

• Azure SQL Managed Instance:? Instance Pools Fast, Predictable, and Scalable!
• Azure SQL: How to Move and Copy Managed Instance Databases
• Next-gen General Purpose impact on Azure SQL Managed Instance link seeding speed
• Enable and disable Next-gen General Purpose Azure SQL Managed Instance service tier
• Configuring failover rights license benefit for Azure SQL Managed Instance with Azure portal and CLI
• Next-gen General Purpose service tier brings 500 user dbs, improved storage and more to Azure #SQLMI

Azure SQL MI in Product Group Blogs

• Vector Support EAP extended to Azure SQL MI

• Database Watcher: Your perfmon in the cloud

• Using MI Link to transfer CLR binaries from SQL Server to Azure SQL Managed Instance

• Native Windows principals for SQL Managed Instance

Azure SQL MI Customer Service & Support Blogs

• How to check if Azure SQL Managed Instances are enrolled (or not) on November 2022 Feature Wave?

• Automate shrink database in Azure SQL

Azure SQL Managed Instance Public Previews:

• Use Next-gen General Purpose service tier - Azure SQL Managed Instance | Microsoft Learn
• Monitor Azure SQL workloads with database watcher
• Configure service endpoint policies
• Fail over link - Azure SQL Managed Instance
• Try for free
• What is an Azure SQL Managed Instance pool?
• New! JSON data type (preview) - SQL Server
• Managed Instance link feature overview
• Microsoft Entra logins and users with nonunique display names
• Native Windows principals - Azure SQL Managed Instance
• Use SDK-style projects with the SQL Database Projects extension
• SQL Server Service Broker
• Disaster recovery with Managed Instance link
• Configure Advanced Threat Protection
• High availability with Zone Redundancy

Essential Links:

• What is Azure SQL Managed Instance – a great page for the introduction of our service
• SQL MI FAQ – discover frequently asked questions about Azure SQL Managed Instance
• What’s new in SQL MI – the list of the latest and the greatest additions to Azure SQL MI
• Customer stories - empower you to learn how other customers utilize Azure SQL Managed Instance to improve their business
• Deep Dive: Modernize your Apps in the Cloud with Azure SQL Managed Instance
• The SQLMI How-To-Series blog on simple & extremely useful how-to
• What is new in Azure SQL Managed Instance