Ben Johnston in Blogs

SQL Server Row Level Security: Detecting and Mitigating RLS Attacks (Part 6, Series Summary)

Detect and mitigate attacks against SQL Server Row Level Security (RLS) - side-channel timing attacks, excessive-error patterns, brute force attempts....

03 October 2023 24 min read

Ben Johnston in Blogs

SQL Server RLS Security: Attacks & Vulnerabilities

Explore SQL Server Row-Level Security vulnerabilities - direct attacks, indirect attacks, and side-channel bypasses. Essential reading before deploying RLS in...

25 September 2023 22 min read

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

Register for Simple Talk

BenJohnston_RLS

SQL Server Row Level Security: Detecting and Mitigating RLS Attacks (Part 6, Series Summary)

SQL Server RLS Security: Attacks & Vulnerabilities

SQL Server Row Level Security Deep Dive. Part 4 – Integration, Anti-patterns, and Alternatives

SQL Server Row Level Security Performance: Tuning and Troubleshooting Guide

SQL Server Row Level Security: Setup, Access Predicates, and Examples

SQL Server Row Level Security Deep Dive. Part 1 – Introduction and Use Cases