SQL

A 3-post collection

A Poor Man's Queue

Building a queue backed by a SQL Server table can be tricky in highly concurrent systems. In this post, I explain how to dequeue records safely without blocking or deadlocks. »

Row-Level Security in SQL Server

Up until version 2016, Microsoft's SQL Server didn't support row-level security (RLS) - a feature that's been around in Oracle and IBM's offerings for a while. If you ran SQL »

Generate SQL Delete Statements That Respect FK Relationships

Have you ever needed to delete a record from a database table only to be thwarted by one or more foreign key violations? Then when you try to delete records »

Posted under C#, SQL