SQL Server 2019 offers powerful new features to help in safeguarding your data and complying with various privacy regulations, which we’ll be covering in this article
SQL Server 2019提供了强大的新功能来帮助保护您的数据并遵守各种隐私法规,我们将在本文中进行介绍。
SQL Server Management Studio 17.5 introduced a new feature for data discovery and data classification into different categories. This helps to discover sensitive data such as SSN number, credit card number, bank account details, personal records etc. It is very critical for the data to be secure and compliant under SOX, PCI, and GDPR for each organization. The Classify data features adds extended properties to the columns to specify the label and the information type.
SQL Server Management Studio 17.5引入了一项新功能,用于将数据发现和数据分类到不同类别中。 这有助于发现敏感数据,例如SSN号,信用卡号,银行帐户详细信息,个人记录等。对于每个组织来说,对于SOX,PCI和GDPR,确保数据的安全性和合规性至关重要。 “分类”数据功能将扩展属性添加到列中以指定标签和信息类型。
This option is available under (Right click on Database) Tasks->Data Discovery and Classification ->Classify Data in SSMS version 17.5 and above.
在SSMS 17.5及更高版本中,(在数据库上单击鼠标右键)“任务”->“数据发现和分类”->“分类数据”下提供此选项。
If we run the ‘Classify Data’ on WideWorldImporters database, we get the ‘Data Classification’ report.
如果在WideWorldImporters数据库上运行“分类数据”,则将获得“数据分类”报告。
We can see that we have the option to classify the information type. We can decide whether this column contains contact info, banking, credit card, date of birth, financial, National ID etc.
我们可以看到我们可以选择对信息类型进行分类。 我们可以决定此列是否包含联系方式,银行业务,信用卡,出生日期,财务状况,身份证等。
Similarly, we can choose the sensitive level as shown below:
同样,我们可以选择敏感级别,如下所示:
Therefore, we can choose the appropriate information type and sensitivity level and apply the recommendation accordingly. Once we apply and save the recommendation, we can view the SQL Data Classification Report that shows the information such as Classified columns, tables containing sensitive data.
因此,我们可以选择适当的信息类型和敏感度级别并相应地应用建议。 应用并保存建议后,我们可以查看SQL数据分类报告,该报告显示诸如分类列,包含敏感数据的表之类的信息。
Once we have defined the information type and sensitivity level, we can go to particular column properties and can see that this information is added as part of extended properties as shown below:
定义信息类型和敏感度级别后,我们可以转到特定的列属性,并且可以看到此信息是作为扩展属性的一部分添加的,如下所示:
We can see all the columns in a database where we defined the data classification.
我们可以看到定义了数据分类的数据库中的所有列。
SELECT Schem