This post has been republished via RSS; it originally appeared at: Microsoft Tech Community - Latest Blogs - .
We are happy to announce that Azure SQL database, SQL managed instance & Azure Synapse database now provides you with MIP (Microsoft Information Protection) integrated data classification solution. MIP sensitivity labels provide a simple way for your users to classify sensitive data across the org with uniform standards and provide end to end classification solutions. If you have created standard sensitivity labels in Microsoft 365 then you can leverage this new enhancement to propagate the labels to Azure SQL Database and then to other downstream applications like PowerBI. This new capability in SQL native classification enables you to authenticate to Microsoft 365 and fetch the sensitivity labels automatically which can then be applied to the critical columns in the database. In addition to this, downstream inheritance of protection labels in PowerBI helps ensure that sensitive data remains classified throughout its journey, from data source to point of consumption. This new capability is now available in Data Discovery & Classification section under Security in Azure SQL portal.
Check out our documentation for detailed steps:
SQL data discovery & classification: Data Discovery & Classification - Azure SQL Database, Azure SQL Managed Instance, and Azure Synapse | Microsoft Docs
Other references:
Microsoft compliance center: Microsoft 365 compliance center
Create & publish MIP labels in Microsoft 365: Create and publish sensitivity labels - Microsoft 365 Compliance | Microsoft Docs
Inheritance of sensitivity labels in PowerBI: Sensitivity label inheritance from data sources in Power BI - Power BI | Microsoft Docs
Availability of MIP enhancement for on-prem SQL Server: SQL data classification now offers Microsoft Informaton Protection labels in SSMS - Microsoft Tech Community