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.
If you have ever used SET CONTEXT_INFO to store a simple value, you probably ran into this frustrating behavior 🙀