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...

What Does the Undocumented UNCOMPRESS Function Do?

Ever notice how IntelliSense in SSMS lists functions that don't work or aren't documented? Here's documentation for one that works: UNCOMPRESS

Beware! Beware of Unintended Changes When Altering Columns!

Beware of big green dragons, er, well, of unexpected changes when changing a column's datatype. You might be unpleasantly surprised! 🙀 Beware!

Native UTF-8 Support in SQL Server 2019: Savior or False Prophet?

An in-depth analysis of the new native UTF-8 support in SQL Server 2019.

Changing the Collation of the Instance, the Databases, and All Columns in All User Databases: What Could Possibly Go Wrong?

Need to change the collation at ALL levels? Prefer to avoid reloading all objects and data? Learn what the "sqlservr -q" option does, and doesn't, do.

The Uni-Code: The Search for the True List of Valid Characters for T-SQL Identifiers, Part 3 of 2 (Delimited Identifiers)

The investigation into valid T-SQL identifier characters continues. Apparently I was not done.

What’s in a Name?: Inside the Wacky World of T-SQL Identifiers

Come see the complete set of rules governing how you name things in SQL Server

Which Collation is Used to Convert NVARCHAR to VARCHAR in a WHERE Condition? (Part B of 2: “Rabbit”)

Who will win "Who's Collation is it Anyway?" Database Collation is ahead, but Column Collation isn't about to give up.

Which Collation is Used to Convert NVARCHAR to VARCHAR in a WHERE Condition? (Part A of 2: “Duck”)

Microsoft says string literals not prefixed with "N" are converted to the Code Page of the Database OR referenced column. Is that true?