Redgate Hub

Product: Data Masker

Replace sensitive data with realistic, anonymized, test data on SQL Server or Oracle.

All topics

All databases

All levels

SQL Provision logo

How to do Accurate Address Masking using Data Masker

Grant Fritchey shows how to adapt a data masking process, for address data, so that it incorporates knowledge of the data distribution in the real data. The result is fake address data, with an accurate distribution, for use in development and testing work. Read more

SQL Provision logo

A Basic Technique for Masking Address Data using Data Masker

Grant Fritchey provides a simple way to create fake address information that still looks real. The compromise is that it uses random data distributions and doesn't maintain any correlation between postal codes, states and cities, so won’t accurately reflect the real address data. Read more

Data Masker logo

Spoofing Realistic Credit Card Data for your Test Systems using Data Masker

Grant Fritchey shows how to use Data Masker to create fake credit card data that not only looks like the real thing, but also has the right distribution, so will act like it too, when we query it. Read more

SQL Provision logo

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

Data Masker logo

Data Masker

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

Data Masker logo

Data Masking in Practice

This article takes a strategic look at common data masking and anonymization techniques, and the challenges inherent in protecting certain types of sensitive and personal data, while ensuring that it still looks like the real data, and retains its referential integrity, and distribution characteristics. It also explains, briefly, with references,… Read more

Data Masker logo

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 logo

Masking Dates in a Non-Production Database

Gerry Leith explores what’s required for the effective masking of dates and times in your data. Read more

SQL Provision logo

SQL Provision adds fully integrated data masking

Karis Brummit announces SQL Provision, which combines SQL Clone's fast, lightweight database copying and centralized management of provisioning, with Data Maskers's ability to obfuscate sensitive or personal data, prior to distribution. Read more

SQL Provision logo

Create, protect and manage non-production databases with SQL Provision

SQL Provision allows users to create copies of SQL Server databases in seconds, using a fraction of disk space, and mask any sensitive data to help address data privacy and protection concerns. It serves as a gateway between production and non-production environments, to ensure the safe distribution of database copies from… Read more

Previous Next

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 Hub

Product: Data Masker

How to do Accurate Address Masking using Data Masker

A Basic Technique for Masking Address Data using Data Masker

Spoofing Realistic Credit Card Data for your Test Systems using Data Masker

Creating Multiple Masked Databases with SQL Provision

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

Data Masking in Practice

Approaches to masking email addresses

Masking Dates in a Non-Production Database

SQL Provision adds fully integrated data masking

Create, protect and manage non-production databases with SQL Provision

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

Product: Data Masker

Cookies on red-gate.com