Cross-Database Ownership Chaining: What a db_owner Can Reach

· by · in

How cross-database ownership chaining works, a test on SQL Server 2019 and 2025 of what a db_owner can read with it, and a query to find it.

Configuration Drift Between SQL Server Instances: Comparing sys.configurations to a Saved Baseline

· by · in

Save sys.configurations from each SQL Server instance to a baseline table, then find options that differ, are missing, or need RECONFIGURE or a restart.

Testing Trace Flag 2861 and Zero-Cost Plans on SQL Server 2019 and 2025

· by · in

Does SolarWinds DPA’s trace flag 2861 keep zero-cost plans in the plan cache? A test on SQL Server 2019 and 2025 found no measurable effect.

Why SQL Server RTM Diffs Do Not Match CU Diffs

· by · in

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

· by · in

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

· by · in

SQL Server 2025 adds XE lock-mode map values, LAQ events, and optimized-locking evidence from a small scratch workload.