sql server

A 2-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 »