Where MongoDB Schema Validation Actually Lives
MongoDB can enforce a schema, but only if you ask. I tested its validation options on 8.0 and 9.0 and compared them with SQL Server constraints.
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.