SQL Information Protection now includes new capabilities to help identify, classify or monitor data stored in your SQL databases.

 

Use on Azure SQL

To start using these new capabilities, go to your Azure ARM portal (https://portal.azure.com) and reach your SQL Server blade.

image

Then access the SQL database you want to Advanced Threat Protection configuration blade to turn on the feature

image

Once enabled you will be able to access the dashboard from the SQL database’s Data Discovery & Classification blade and then by opening the Data Discovery & Classification section

imageimage

After the activation you may have a notification to tells you the system has automatically already identified some classification; just click on the notification bar to access the findings and take the appropriate actions by selecting the recommendation(s) and then clicking on the Accept selected recommendations

imageimage

You can also add your own classification by using the Add classification button and filling the configuration blade

imageimageimage

 

Use on on-premises SQL

If you have installed SQL Management Studio 2017 (get it from https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017) you can also use this feature with any SQL Server, 2008 and later.

  • Right click on the database you want to use the data classification and choose Tasks\Classify Data

imageimage