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 🙃
Have you ever needed to prevent an entire script (or part of one) from executing? See how the session-level options PARSEONLY and NOEXEC can accomplish this.
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.