Azure SQL Managed Instance content reference
In this article you can find a content reference to various guides, scripts, and explanations that help you manage and configure Azure SQL Managed Instance.
- Migrate to Azure SQL Managed Instance: Learn about the recommended migration process and tools for migration to Azure SQL Managed Instance.
- Migrate TDE cert to Azure SQL Managed Instance: If your SQL Server database is protected with transparent data encryption (TDE), you would need to migrate the certificate that SQL Managed Instance can use to decrypt the backup that you want to restore in Azure.
- Import a DB from a BACPAC
- Export a DB to BACPAC
- Load data with BCP
- Load data with Azure Data Factory
- Determine subnet size: Since the subnet cannot be resized after SQL Managed Instance is deployed, you need to calculate what IP range of addresses is required for the number and types of managed instances you plan to deploy to the subnet.
- Create a new VNet and subnet: Configure the virtual network and subnet according to the network requirements.
- Configure an existing VNet and subnet: Verify network requirements and configure your existing virtual network and subnet to deploy SQL Managed Instance.
- Configure custom DNS: Configure custom DNS to grant external resource access to custom domains from SQL Managed Instance via a linked server of db mail profiles.
- Sync network configuration: Refresh the networking configuration plan if you can't establish a connection after integrating your app with an Azure virtual network.
- Find the management endpoint IP address: Determine the public endpoint that SQL Managed Instance is using for management purposes.
- Verify built-in firewall protection: Verify that SQL Managed Instance allows traffic only on necessary ports, and other built-in firewall rules.
- Connect applications: Learn about different patterns for connecting the applications to SQL Managed Instance.
- Configure Azure AD auth
- Configure conditional access
- Multi-factor Azure AD auth
- Configure multi-factor auth
- Configure a temporal retention policy
- Configure TDE with BYOK
- Rotate TDE BYOK keys
- Remove a TDE protector
- Configure In-Memory OLTP
- Configure Azure Automation
- Transactional replication enables you to replicate your data between managed instances, or from SQL Server on-premises to SQL Managed Instance, and vice versa.
- Configure threat detection – threat detection is a built-in Azure SQL Managed Instance feature that detects various potential attacks such as SQL injection or access from suspicious locations.
- Creating alerts enables you to set up alerts on monitored metrics such as CPU utilization, storage space consumption, IOPS and others for SQL Managed Instance.
Monitoring and tuning
- Manual tuning
- Use DMVs to monitor performance
- Use Query Store to monitor performance
- Troubleshoot performance with Intelligent Insights
- Use the Intelligent Insights diagnostics log
- Monitor In-Memory OLTP space
- Use Spark Connector
- Authenticate an app
- Use batching for better performance
- Connectivity guidance
- DNS aliases
- Set up a DNS alias by using PowerShell
- Ports - ADO.NET
- C and C ++
Design Multi-tenant SaaS applications
Get started by deploying SQL Managed Instance.