Azure SQL Managed Instance documentation

Find documentation about Azure SQL Managed Instance, a managed instance in Azure based on the latest stable version of Microsoft SQL Server.

Azure SQL Managed Instance

Overview

• What is Azure SQL Managed Instance?

What's new

• What's new?

Quickstart

• Create SQL Managed Instance
• Restore a backup

video

• Azure SQL Managed Instance overview

Concept

• vCore purchasing model
• T-SQL differences with SQL Server
• Connectivity architecture
• Frequently asked questions

Management

Concept

• Migrate from SQL Server
• Management operations
• Start and stop instance
• Managed Instance link
• Copy or move a database
• Transactional replication
• Connect apps to Azure SQL Managed Instance

Artificial Intelligence

Concept

• Intelligent applications and AI in SQL Server
• Multi-model capabilities in Azure SQL
• Connect to REST API endpoints for a SQL database
• Connect to GraphQL endpoints for a SQL database
• SQL MCP Server

Learn Azure SQL Managed Instance

Training

• Azure SQL bootcamp
• Azure SQL Managed Instance Learning Paths
• DP-800 - SQL AI Developer Associate
• DP-300 - Azure Database Administrator Associate
• Educational SQL resources

video

• @AzureSQL on YouTube
• Azure SQL for beginners
• Azure SQL Database essentials

Business continuity

How-To Guide

• Business continuity
• High availability
• Failover groups
• Automated backups
• Recover with backup
• Long-term backup retention

Advanced security

Concept

• Security capabilities
• Security best practices
• Logins, user accounts, roles, and permissions
• Microsoft Entra ID (formerly Azure Active Directory)
• Auditing
• Transparent Data Encryption (TDE)
• Dynamic Data Masking
• Public endpoints
• Private endpoints

Reference

Deploy

• Azure CLI samples
• PowerShell samples
• Azure Resource Manager template samples

Download

• SQL Server Management Studio (SSMS)
• SQL Server Data Tools
• Visual Studio 2022

Reference

• Migration guide
• Transact-SQL (T-SQL)
• Azure CLI
• PowerShell
• REST API

Planned maintenance

Concept

• Plan for Azure maintenance events
• Maintenance window
• Resource health

How-To Guide

• Maintenance window
• Maintenance Window Notifications

Monitor

Concept

• Monitoring Azure SQL Managed Instance data reference
• Monitor Azure SQL workloads with database watcher
• Monitor Azure SQL Managed Instance with Azure Monitor
• Monitoring Microsoft Azure SQL Managed Instance performance using dynamic management views