Product learning

Posts by

Chris Unwin

28 August 2020

How to Classify and Protect your Development Data Automatically using SQL Data Catalog and Data Masker Command Line

Chris Unwin describes a classification-driven static data masking process, using SQL Data Catalog to classify all the different types of data, its purpose and sensitivity, and then command line automation to generate the masking set that Data Masker for SQL Server can use to protect this data. Read more

Chris Unwin

9 January 2019

Chris Unwin

9 January 2019

SQL Provision and Azure SQL Database: Creating Local Development and Test Databases

As more businesses start to use cloud-based platforms, such as Azure SQL Database, as their primary database solution, they find that they still need to support on-premise workflows for development and test databases. This is a perfect task for SQL Provision. Read more

Chris Unwin

19 December 2018

Chris Unwin

19 December 2018

A Christmas tale for DBAs – “Twas the night before deployment”

DBAs have a tough job sometimes. When deployments go wrong, they’re the ones everyone looks to. They’re also the ones who have to fix it, which can mean working through the night, the weekend, the holidays, whatever it takes. So let’s lighten the mood this Christmas with a DBA take on a festive classic, The... Read more

8 August 2018

8 August 2018

Creating Multiple Masked Databases with SQL Provision

Chris Unwin explains how SQL Provision can create copies of multiple databases, each masked consistently, and deliver them as a group. This is useful when, for example, you are working with a Data Warehouse that contains several cross-database relationships. Read more

PowerShell

automated database deployment

18 July 2018

18 July 2018

The ‘Right to be Forgotten’ and Data Masker for SQL Server

The right to be forgotten is one of the main features of new data protection legislation across the globe. Under Article 17 of one such piece of legislation in Europe, the GDPR, individuals have the right to have personal data erased from all systems and data the company may be storing about them. Similarly,... Read more

The right to be forgotten

28 March 2018

28 March 2018

Approaches to masking email addresses

Chris Unwin explains the basic approaches to anonymizing email addresses, and shows how Data Masker can generate realistic email addresses, based on faked names, and even retain the correct distribution of email providers. Read more

Data Masker for SQL

Chris Unwin

19 December 2017

Chris Unwin

19 December 2017

How to automatically provision sanitized data using SQL Clone, Data Masker and PowerShell

Chris Unwin describes a strategy, using data masking, cloned databases and PowerShell, which will allow you to sanitize data before provisioning test or development environments. Read more

PowerShell

SQL Provision

SQL Clone

Redgate Test Data Manager

Flyway

Redgate Monitor

Overview

Test Data Management

Automate

Monitor

Product learning

Posts by

Chris Unwin

How to Classify and Protect your Development Data Automatically using SQL Data Catalog and Data Masker Command Line

SQL Provision and Azure SQL Database: Creating Local Development and Test Databases

A Christmas tale for DBAs – “Twas the night before deployment”

Creating Multiple Masked Databases with SQL Provision

The ‘Right to be Forgotten’ and Data Masker for SQL Server

Approaches to masking email addresses

How to automatically provision sanitized data using SQL Clone, Data Masker and PowerShell

Redgate Test Data Manager

Flyway

Redgate Monitor

Overview

Test Data Management

Automate

Monitor

Posts by Chris Unwin

Posts by

Chris Unwin