SQL Server for Developers

SQW07 SQL Data Discovery and Classification


2:00pm - 3:15pm

Level: Intermediate

Karen Lopez

Data Evangelist, Space Enthusiast, & NASA Datanaut

SQL Server Management Studio (SSMS) recently introduced SQL Data Discovery and Classification. This new feature allows teams to find and categorize sensitive data. SSMS looks at the names of columns to help you find where your most vulnerable data resides.

We'll look at a new feature of SQL Server that supports maintaining the classification in auditing logs for columns.

For SQL DB and Azure Data Warehouse, we'll look at Advanced Data Security to classify and record data classifications. Finally, we'll quickly look at how these classifications can feed into Azure SQL Database Auditing.

You will learn:

  • The basics of data classification
  • How to use SSMS and Azure Advanced Data Security to classify data in their databases
  • How Azure SQL Database Auditing uses these classifications