Updated: July 23, 2020 (March 13, 2018)

  Analyst Report

SQL Information Protection Assists Data Classification, Auditing

My Atlas / Analyst Reports

346 wordsTime to read: 2 min
Andrew Snodgrass by
Andrew Snodgrass

Andrew analyzes and writes about Microsoft's data management, business intelligence, and machine learning solutions, as well as aspects of licensing... more

  • SQL Information Protection can help organizations discover and classify potentially sensitive data stored in SQL Server databases.
  • The features provide guidance and simplify tagging database columns, but they do not actually protect or secure the data.

SQL Information Protection is a set of data discovery, data classification, and reporting features to help identify and tag sensitive data stored in SQL Server databases. The illustration shows a report for a database, after the tool has identified and classified all columns containing sensitive data.

The features can help organizations meet data privacy and regulatory compliance requirements and assist with auditing efforts. However, the features are for data classification and reporting only. They do not apply SQL Server security techniques, such as data encryption and data masking to protect the actual data, nor do they configure SQL Server auditing features that track access to sensitive data, which is a critical part of compliance.

Atlas Members have full access

Get access to this and thousands of other unbiased analyses, roadmaps, decision kits, infographics, reference guides, and more, all included with membership. Comprehensive access to the most in-depth and unbiased expertise for Microsoft enterprise decision-making is waiting.

Membership Options

Already have an account? Login Now