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 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.
CDC Extended DDL Handling in SQL Server 2022 and 2025
SQL Server 2022 added an unsupported CDC extended DDL option. I tested the parameter, metadata function and 2025 procedure changes.
EngineEdition Branches Inside System Procedures DBAs Already Call
SQL Server 2025 adds EngineEdition 12 branches to familiar system procedures, and sp_spaceused can delegate to a FIDO path.
sp_dw_* and the Trident Procedures in SQL Server 2025
SQL Server 2025 adds more sp_dw and Trident system surface, including procedures, wait types, Extended Events, and messages.