sys.xp_delete_files and 'allow filesystem enumeration': two new undocumented items in SQL Server 2019
A misguided attempt to improve security that not only increases the chances of SQL Injection, but also prevented useful changes from being made.
Specific String Pattern Magically Hidden From Step Output in SQL Agent History. Who Knew?
Installing SQL Server 2019 CTP 2.5 fails with almost no useful info. Searching on code or message finds nothing. This post fixes that 😎
Can a Certificate's Private Key be Restored From a Binary Literal / Hex Bytes? The Documentation Says, "No". What Does SQL Server Say?
Come see how to prevent SQL Server from starting, and in an easy-to-fix-yet-impossible-to-find way! 😈
Does resetting an Identity Seed to a specific value via DBCC CHECKIDENT(..., RESEED, new_seed_value) work the way the documentation states? It depends 🙃
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.