data catalogs

The Need for a Data Catalog

  • Article

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

Practical steps for end-to-end data protection

  • Article

If you plan to make production data available for development and test purposes, you'll need to understand which columns contain personal or sensitive data, create a data catalog to record those decisions, devise and implement a data masking, and then provision the sanitized database copies. Richard Macaskill show how to automate as much of this process as possible.

2019-08-02

Blogs

Daily Coping 4 Jun 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

SQL Homework – June 2020 – DML Triggers

By

Triggers. Blech. Triggers are a really really cool feature of SQL Server, that are...

Backup your SQL instances configurations to GIT with dbatools – Part 2 – Add parallelism

By

We have seen how we can export and save the results to a folder...

Read the latest Blogs

Forums

estimated execution plan

By sizal0234

  I have an SP which is truncating a table and then insert into...

optimizing SSIS package

By sizal0234

  I am trying to optimize an SSIS package which has multiple streams..so step...

SSRS report doesn't show some of the non-null data for some reason...

By sgmunson

Okay folks... riddle me this one:   Why does SSRS not display the non null...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Minus Query

See possible answers