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 multicloud environments by using Azure Arc
- SQL Server enabled by Azure Arc in Active Directory authentication with system-managed keytab - prerequisites
- Deploy Active Directory-integrated SQL Managed Instance enabled by Azure Arc
- Tutorial – Deploy Active Directory connector in system-managed keytab mode
- Tutorial – Deploy Active Directory (AD) connector in customer-managed keytab mode
- Monitoring, log analytics, billing information, Azure portal (SQL Managed Instance)
- Automating Indirectly connected mode Log and Metric data uploads