SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Classifying your data in Azure SQL DB for GDPR

Azure SQL DB is a robust data platform that’s cloud native and can be managed from SQL Server Management Studio (SSMS); though, the management tasks available from SSMS for Azure SQL DB may not exist, such as: data classification.

You may have read my last post How to classify your data for GDPR. If you want to use this feature on an Azure SQL database don’t worry if you can’t find it in SSMS. It’s actually runnable in the Azure portal and works a bit better.

Here’s how to find it. Simply open the portal and navigate to your database. Then choose the Data discovery & classification option.

image

From here you’ll see a report for the database where you can begin.

image

Confessions of a Microsoft Addict

Daniel Janik has been supporting SQL Server for 18 years as a DBA, developer, architect, and consultant. He spent six years at Microsoft Corporation supporting SQL Server as a Senior Premier Field Engineer (PFE) where he supported over 287 different clients with both reactive and proactive database needs. Daniel has spoken at several SQL Saturday events across the US and Caribbean and regularly speaks at PASS local chapters.

Comments

Leave a comment on the original post [sqltechblog.com, opens in a new window]

Loading comments...