Overview Microsoft SQL Server 2012 introduced a feature called data classification, which allows you to mark certain columns with labels, indicating that these columns contain sensitive or special-handling data. For instance, you may want to mark a column containing credit card numbers as "confidential", or sales numbers as "management only". The problem is that you […]
2021-12-10
5,151 reads
SQL Data Catalog's new data scanning feature uses regular expressions and data dictionaries to identify where sensitive and personal data is stored in your databases.
2021-08-04
William Brewer explains how to make data governance a continuous organizational activity, based on well-established standards and practices, rather than a knee-jerk response, and which skills and tools will help you achieve compliance, including SQL Data Catalog for discovery and classification of data held in SQL Server.
2020-12-16
A data catalog allows an organization to discover and record the facts about its data, where that data is held and how it used. William Brewer explains the details.
2020-12-14
Josh Smith shows how to use SQL Data Catalog to perform a 'first cut' data classification for one your SQL Server databases, identifying all columns that are likely to hold personal or otherwise sensitive data.
2020-01-17
In the event of a breach of personal data, any organization must produce proof that they understand what data they hold and where, and how it is being used, and that they have enforced the required standards for access control and security. To make all this possible, it is essential to build a complete model of the data and its lineage, and a data catalog is the first step in this process.
2020-01-14
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
By Brian Kelley
Redgate is offering 13 PASS Summit scholarships which not only includes the 3-day ticket...
By Kevin3NF
Configuration, Performance, and Unnecessary Usage TempDB is the SQL Server equivalent of a junk...
Folks, Looking for advice on the best way to import a package. I hope...
Hi, I have two fact tables (say FactA, and FactB), that are joined/shared...
Can anybody advise on how i go about balancing threads to each node. As...
I have DDL trigger code that I'm working on in SQL Server 2022, but I am concerned that we might end up with multiple triggers firing and the response to the user is delayed. If I want to check how many triggers have fired, or are nested, how can I do this in my code?
See possible answers