Azure SQL Database Managed Instance

Azure SQL Database Managed Instance is a fully managed SQL Server Database Engine Instance hosted in Azure cloud. This is the best PaaS option for migrating your SQL Server database to the cloud. Learn how to create and use Managed Instance with our quickstarts, tutorials, and samples.

New and preview features

We are continuously improving Managed Instance with new features:

5-Minute Quickstarts

Managed Instance enables you to easily perform basic management tasks using the Azure portal, Azure CLI, and Azure PowerShell. Learn how to perform basic management tasks using the following quickstart samples:

The Azure portalThe Azure portalAzure CLIAzure CLIPowerShellPowerShellAzure Resource Manager templateAzure Resource Manager template
Create a new Instance
Modify the Instance
Configure Azure network environment
Point in time restore

Step-by-Step tutorials and learning materials

Learn how to create, manage, and use Managed Instance.

  1. Learn about hardware characteristics and limitations and Transact-SQL language differences.
  2. Configure Azure VNet where the Managed Instance will be deployed.
  3. Validate that your existing Azure VNet can be used to deploy Managed Instances.
  4. Connect to your instance using Azure Virtual Machine or Point-to-site connection, or Applications.
  5. Verify that your database can be migrated using Data Migration Asisstant or Database Experimentation Assistant.
  6. Bring your databases to Managed Instance using Native restore or Data Migration Service.
  7. Move your SSIS packages to Azure Data Factory, SSAS tabular models to Azure Analysis Service, and SSRS reports to PowerBI Premium.
  8. Apply storage performance best practices and considerations for General Purpose service tier.
  9. Find the best practices and recommendations for securing your instance.
  10. Find more How-to guides that can help you configure your Managed Instance.

Reference