| title | Configure & manage content reference | ||
|---|---|---|---|
| titleSuffix | Azure SQL Managed Instance | ||
| description | A reference guide of content that teaches you how to configure and manage Azure SQL Managed Instance. | ||
| author | MashaMSFT | ||
| ms.author | mathoma | ||
| ms.reviewer | mathoma, danil | ||
| ms.date | 12/06/2024 | ||
| ms.service | azure-sql-managed-instance | ||
| ms.subservice | deployment-configuration | ||
| ms.topic | concept-article | ||
| ms.custom |
|
||
| monikerRange | =azuresql||=azuresql-mi |
[!INCLUDE appliesto-sqlmi]
In this article, you can find content references to various guides, scripts, and explanations that help you manage and configure Azure SQL Managed Instance.
- SQL Server to Azure SQL Managed Instance Guide: 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 need to migrate the certificate to decrypt the backup that you want to restore in Azure SQL Managed Instance.
- 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 can't 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 SQL managed instances you plan to deploy to the subnet.
- Create a new virtual network and subnet: Configure the virtual network and subnet according to the network requirements.
- Configure an existing virtual network and subnet: Verify network requirements and configure your existing virtual network and subnet to deploy SQL Managed Instance.
- Configure service endpoint policies for Azure Storage (Preview): Secure your subnet against erroneous or malicious data exfiltration into unauthorized Azure Storage accounts.
- Resolving private DNS names in Azure SQL Managed Instance: Configure custom DNS servers to establish access from SQL Managed Instance to an external resource, such as scenarios involving linked servers or database mail.
- Find the management endpoint IP address: Determine the public endpoint that SQL Managed Instance is using for management purposes.
- Connect applications: Learn about different patterns for connecting the applications to Azure SQL Managed Instance.
- Configure authentication with Microsoft Entra ID (formerly Azure Active Directory)
- Configure conditional access
- Microsoft Entra multifactor authentication
- Configure failover group to automatically fail over all databases on an instance to a secondary instance in another region.
- Configure a temporal retention policy
- 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.
To learn more about the link:
To use the link:
- Prepare environment for the Managed Instance link
- Configure link between SQL Server and SQL Managed instance with SSMS
- Configure link between SQL Server and SQL Managed instance with scripts
- Fail over the link
- Migrate with the link
- Best practices for maintaining the link
- Troubleshoot issues with the link
- 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
- Connectivity
- 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 ++
- Excel
[!div class="nextstepaction"] Quickstart: Create an Azure SQL Managed Instance