A Guardrail Only Humans Enforce Isn’t One
MongoDB won’t stop you querying a collection that doesn’t exist, or storing mismatched documents side by side. That’s by design, and it has a cost.
Why SQL Server RTM Diffs Do Not Match CU Diffs
SQL Server 2025 RTM and CU9 do not have the same system surface. I compared both diffs and counted the changed findings.
SQL Server 2025 Has Automatic Index Management Parts, but I Could Not Turn CREATE_INDEX On
SQL Server 2025 ships automatic index management procedures and internal views, but CREATE_INDEX was not accepted on my local test.
SQL Server 2025 Added Lock Modes to Extended Events
SQL Server 2025 adds XE lock-mode map values, LAQ events, and optimized-locking evidence from a small scratch workload.
SQL Server 2025 sp_columns Omits JSON and Vector Columns
SQL Server 2025 filters json and vector columns from sp_columns and ODBC catalog output. I tested the alternatives.
What Is openrowset auto_create_statistics Connected To?
I traced the undocumented openrowset auto_create_statistics option through SQL Server inventory, Microsoft docs, and a local 2025 test.