4 July 2019
4 July 2019

What’s new in v6.3 of Data Masker for SQL Server

The first time you approach the task of data masking, it can seem daunting. You've identified your sensitive columns, but how do you decide on the best data masking strategy? Which rules do you need in your data masking set? Data Masker for SQL Server makes it easy to decide.

If you want to use a copy of the production data for development and test work, then you’ll need both a plan and a strategy for protecting data that is classified as personal identifiable data, personal sensitive data or commercially sensitive data. First, you’ll need to find out in which tables and columns this personal or sensitive data resides, and document this, and then you’ll need to devise and implement a way to sanitize this data.

It’s relatively easy to anonymize data entirely; simply replace all the data with fake values. However, this is not so useful for development or test work, where we’d like the data, although sanitized, to have the same distribution and characteristics as the original data.

This is where Data Masker helps. It provides an array of data masking rules, tools and methods so that regardless of your database design, or what type of data to you to mask, you can do so in a way that the sanitized data still looks and behave like the real thing.

Helping you choose the right rules

Data Masker is a versatile tool, but that means it offers a lot of different rule types, including Command rules to allow us to execute SQL statements in the target schema, Substitution and Shuffle rules to replace and scramble data values, while retaining a certain data distribution, and many more.

Figure 1

In v.6.3 of Data Masker for SQL Server our goal was to make it much easier to define the correct rule set, by making it much easier to identify the type of rule that best fits your needs. The most important change we’ve made is to overhaul the “Add a rule” window so that it offers a lot more guidance on which type of rule might best suite your requirement:

Figure 2

As well as a cleaner look and feel, each rule includes in-product guidance about when to use the technique. You can also find links to specific online tutorials at Redgate University.

We’ve also sorted the rules into new categories based on the type of problem they solve.

Figure 3

To give it a go, all you need do is hit the ‘Try it now’ button at the top of the old “Add a rule” window. You can switch back anytime.

Quick access to frequently used rules

We’ve also made it a lot easier to get to the rules you use most commonly without opening the rules window. Just click on the New Rule dropdown at the bottom of Figure 1:

Figure 4

You’ll also notice in Figure 1 the new menu bar and tool bars. Removing the sidebar gives more space to focus on the task at hand and turning the tools tab into a menu makes possible to grab a tool without shifting context. The standard Windows menu bars should feel very familiar.

What do you think?

If you already have Data Masker for SQL Server, you can try this out today by upgrading to the latest version. Alternatively you can download a trial.

We’d love to hear how this works for you, drop us an email at datamaskereap@red-gate.com

 

You may also like

  • Article

    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.

  • Webinar

    Data Masking: Insights & Actions

    In this 30-minute webinar, Microsoft Data Platform MVP Kendra Little explores the key challenges and recommendations to prevent exposure of private data in your next data breach, featuring insight from Gartner's 2018 Market Guide for Data Masking. GARTNER is a registered trademark and service mark of Gartner, Inc. and/or its affiliates in the U.S. and internationally, and is used herein with permission. All rights reserved.

  • Webinar

    Supply realistic and safe data to Dev/Test fast with SQL Provision

    In this webinar, Redgate’s Anderson Rangel gives a practical demo to highlight the importance of SQL Provision as a part of your Database DevOps story and how it can accelerate your database delivery processes while helping you to stay compliant.

  • Community event

    Albuquerque SQL Server User Group

    The Albuquerque SQL Server Users Group (ABQSQL) is an official chapter of PASS (formerly Professional Association for SQL Server) located in Albuquerque, NM. They are an active group of SQL Server professionals that meet monthly for networking and presentations on a variety of SQL Server topics. Redgate will be sponsoring the group’s December meeting and

  • Forums

    Data Masker Forum

    Mask sensitive information in your SQL Server databases