A Completely Complete Guide to how many bytes are used to represent characters in the T-SQL string datatypes
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.
Have you ever wanted to uppercase all string columns in a database? Probably not. But, this was still an interesting exercise 🙃
An in-depth analysis of the new native UTF-8 support in SQL Server 2019.
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 investigation into valid T-SQL identifier characters continues. Apparently I was not done.
Come see the complete set of rules governing how you name things in SQL Server
SQL Server 2017 adds 68 new Collations, but none end with "_SC". This seems to be due to Supplementary Characters being supported by default (which is great 😺).