Learn how to get a list of all Unicode characters to copy and paste, or use in queries / web pages / programs, or search by value, etc.
Month: March 2019
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! 😈