Uppercase All String Columns (and in a Single Query!)

Have you ever wanted to uppercase all string columns in a database? Probably not. But, this was still an interesting exercise 🙃

Differences Between the Various Binary Collations (Cultures, Versions, and BIN vs BIN2)

Come explore the actual differences between the seemingly not-so-different binary collations...

Cruel Joke: Prevent SQL Server From Starting, and With (Almost) No Indication Why

Come see how to prevent SQL Server from starting, and in an easy-to-fix-yet-impossible-to-find way! 😈