Ben Johnston in SQL Server SQL Server Row-Level Security: Integration, anti-patterns, and alternatives (complete guide, part four) A complete guide to SQL Server Row-Level Security integration, anti-patterns, and alternatives.… 17 September 2023 20 min read
SQL Server Ben Johnston in SQL Server SQL Server Row-Level Security: Performance, tuning, and troubleshooting (complete guide, part three) Tune SQL Server Row Level Security performance: compare authentication methods (SESSION_CONTEXT, roles, AD), optimise access predicate indexing, and troubleshoot ETL... 10 September 2023 25 min read
SQL Server Ben Johnston in SQL Server SQL Server Row-Level Security: Setup, access predicates, and examples (complete guide, part two) Set up SQL Server Row Level Security with access predicates (inline TVFs) and security policies. Part 2 covers three setup... 03 September 2023 16 min read
SQL Server Ben Johnston in SQL Server A practical introduction to Row-Level Security in SQL Server (complete guide, part one) Row-Level Security in SQL Server lets identical queries return different rows per user. Here's how it works, when to use... 01 August 2023 16 min read
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