SQL Server Management Studio 17.5 is out, and new in this release is a SQL Data Discovery & Classification feature. The idea is that it’ll scan your database, identify columns containing potentially sensitive data, and help you become compliant with regulations like PCI, HIPAA, and GDPR.
Let’s see how it works on the Stack Overflow public data dump.
Start by opening up SSMS, and then right-click the database, Tasks, Classify Data:
Within moments, your compliance needs are…hang on, that can’t be right:
I’ve tried it on 3 VMs now, even tried with AdventureWorks, and no dice. My guess – and this is just a guess – is that maybe it has to do with the upgrade process not working, even though I even tried a full install as opposed to an upgrade. We’ll probably get another build in the next few days.
Compliance. Sure is hard.
Update: looks like nobody tested it on case-sensitive database servers: