Learn all about Dynamic Data Masking in SQL Server with Ben Johnston’s detailed guide.

SQL Server

Ben Johnston in SQL Server

Unmasking SQL Server Dynamic Data Masking, Part 5: Mitigations and Summary

This is the fifth and final part of this series on SQL Server Dynamic Data Masking. In this article, I’ll…

30 July 2023 12 min read

SQL Server

Ben Johnston in SQL Server

Unmasking SQL Server Dynamic Data Masking, Part 4, Unmasking Formatted and Unformatted Text

Continuing from the previous entry in this series on security concerns with using Dynamic Data Masking, in this article I…

27 June 2023 30 min read

SQL Server

Ben Johnston in SQL Server

SQL Server DDM Security Risks: Side Channel Attacks and Partial Unmasking

SQL Server Dynamic Data Masking can be bypassed: learn how side channel attacks use range queries to infer masked values,…

14 June 2023 31 min read

SQL Server

Ben Johnston in SQL Server

SQL Server Dynamic Data Masking Setup Guide

Set up SQL Server Dynamic Data Masking step by step. Covers ALTER TABLE masking syntax, mask functions (default, email, random,…

07 June 2023 28 min read

SQL Server

Ben Johnston in SQL Server

SQL Server Dynamic Data Masking: Introduction and Use Cases (Part 1)

SQL Server Dynamic Data Masking (DDM) obfuscates column data for unauthorized users without changing the stored data. Part 1 introduces…

26 May 2023 13 min read