Here’s a Quick Way To Generate a Running Total in SQL Server

SQL in 60 Seconds #2

When Is It Appropriate To Store JSON in SQL Server?

How NOLOCK Will Block Your Queries

I thought NOLOCK was supposed to help performance?

One SQL Cheat Code For Amazingly Fast JSON Queries

XML vs JSON Shootout: Which is Superior in SQL Server 2016?

Book Notes: Never Split the Difference by Chris Voss

I highlight and take notes when I read nonfiction books. Once I finish a book, I format and edit my notes so that I can easily remind myself of what I learned without having to reread the book. These notes are not a substitute for reading…

The Ultimate SQL Server JSON Cheat Sheet

Examples for handling JSON data in SQL Server 2016+

JSON Support Is The Best New Developer Feature in SQL 2016 — Part 4: Performance Comparisons

JSON Support Is The Best New Developer Feature in SQL 2016 — Overview Part 1: Parsing JSON

Does The Join Order of My Tables Matter?

How to force SQL to care about your table join orders