Microsoft Purview DevOps policies for Azure SQL MI enters Public Preview

Access to system metadata is crucial for IT and DevOps personnel to ensure that critical database systems are healthy, performing to expectations, and secure. You can grant and revoke that access efficiently and at scale through Microsoft Purview DevOps policies.

Microsoft Purview DevOps policies already support integrations with Azure SQL Database (GA) and SQL Server 2022 via Azure Arc (GA). DevOps policies is already Generally Available (GA) for those two data sources. I am pleased to announce that today we are adding one more data source to the list: Azure SQL Managed Instance into Public Preview.

Figure 1: Screenshot of DevOps policy

Here is a quick video showcasing Microsoft Purview DevOps policies: DevOps policies: provision access at-scale for IT operations users while limiting insider threats

Here is how you can configure DevOps policies for Azure SQL MI:

Manage access to Azure SQL MI system health and performance using Microsoft Purview DevOps policies, a type of RBAC policies. | Microsoft Learn

Continue reading...