A Completely Complete Guide to how many bytes are used to represent characters in the T-SQL string datatypes
What is the maximum number of rows for the Table Value Constructor? And, do different uses of it behave differently?
Can a Certificate's Private Key be Restored From a Binary Literal / Hex Bytes? The Documentation Says, "No". What Does SQL Server Say?
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.
Come explore the actual differences between the seemingly not-so-different binary collations...
Ever notice how IntelliSense in SSMS lists functions that don't work or aren't documented? Here's documentation for one that works: UNCOMPRESS
Does resetting an Identity Seed to a specific value via DBCC CHECKIDENT(..., RESEED, new_seed_value) work the way the documentation states? It depends 🙃