Summary
In this module, you explored the security and monitoring capabilities of Azure Arc-enabled SQL Managed Instance. These capabilities allowed you to protect the on-premises databases through integration with your Active Directory environment, support for Transparent Data Encryption, and the ability to constrain container level privileges in the manner that complies with the principle of least privilege.
You also verified that open-source solutions such as Grafana and Kibana offer insights into Azure Arc-enabled SQL Managed Instance metrics and logs. Lastly, you confirmed that Azure Monitor provides the option to implement a single pane of glass interface for monitoring on-premises and cloud-resident SQL Server-based workloads.
References
- Optimize administration of SQL Server instances in on-premises and multi-cloud environments by using Azure Arc
- Arc-enabled SQL Managed Instance AD Authentication
- Deploy Active Directory-integrated Azure Arc-enabled SQL Managed Instance
- Deploy AD with System Managed Keytab
- Deploy AD with Customer Managed Keytab
- Monitoring, log analytics, billing information, Azure portal (SQL Managed Instance)
- Automating Indirectly connected mode Log and Metric data uploads