Redgate Blog

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… 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

automated database deployment

PowerShell

Chris Unwin

18 July 2018

Chris Unwin

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… Read more

Data Masker

The right to be forgotten

Chris Unwin

28 March 2018

Chris Unwin

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

Data Masker for SQL

PowerShell

SQL Clone

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Redgate Blog

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

2026 State of the Database Landscape

Introduction to PostgreSQL for the data professional

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Posts byChris Unwin

Cookies on red-gate.com

Posts by
Chris Unwin