SQL Data Catalog is Redgate’s tool for identifying and classifying sensitive data. Our tool provides a comprehensive filtering and automated rule system. It relies on column location (instance, database, schema and table) and information (name and data type).
This is fine when dealing with databases that follow a human-readable convention. You can set up a rule that marks all columns whose name contains “email” and are of string type as “Sensitive”. The tool will go off and identify all such columns (and even apply the tag if set to auto-apply).
Unfortunately not all databases are created equal and sometimes the…
