Data Discovery and Classification
Whenever you need to discover and report any sensitive data in your database, you can use a new feature called Data Discovery and Classification . When you are discovering the data, you must also classify and label any data found that fits your classification needs. There are several use cases for this feature, as follows:
- Meeting data privacy standards (for example, General Data Protection Regulation (GDPR); Payment Card Industry Data Security Standard (PCI DSS); Sarbanes-Oxley (SOX); Health Insurance Portability and Accountability Act (HIPAA))
- Controlling access to highly sensitive data (for example, personally identifiable information (PII))
Note
This feature is available for SQL Server 2012 and newer and was introduced with SQL Server Management Studio 17.5; however, it's recommended to use the latest version of SQL Server Management Studio.
While you are connected to the SQL Server, you can run classification on your database...