Ben Johnston in Blogs SQL Server Row Level Security Deep Dive. Part 4 – Integration, Anti-patterns, and Alternatives One of the primary reasons to implement RLS is to facilitate reporting and ease the administrative burden. This section covers... 17 September 2023 20 min read
Blogs Ben Johnston in Blogs SQL Server Row Level Security Performance: Tuning and Troubleshooting Guide 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
Blogs Ben Johnston in Blogs SQL Server Row Level Security: Setup, Access Predicates, and Examples 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
Blogs Ben Johnston in Blogs SQL Server Row Level Security Deep Dive. Part 1 – Introduction and Use Cases My initial goal of documenting and exploring SQL Server Row Level Security (RLS) was to show the basic functionality and... 01 August 2023 17 min read
Blogs Ben Johnston in Blogs 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. The first part in... 30 July 2023 13 min read
Blogs Ben Johnston in Blogs 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 blog I... 27 June 2023 30 min read
Blogs Ben Johnston in Blogs 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
Blogs Ben Johnston in Blogs 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
Blogs Ben Johnston in Blogs 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