Configuration Drift Between SQL Server Instances: Comparing sys.configurations to a Saved Baseline
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.
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.
SQL Server 2025 Added 10 Configuration Options, and One Appeared After RTM
I checked the SQL Server 2025 configuration options added after SQL Server 2022 against sys.configurations and Microsoft Learn.
The 11 Configuration Options Added in SQL Server 2022, and Their Documentation
I checked the 11 SQL Server 2022 configuration options added after SQL Server 2019 against sys.configurations and Microsoft Learn.
Can You Actually Downgrade to Standard Edition? Ask the Database First
Since SQL Server 2016 SP1, sys.dm_db_persisted_sku_features over-reports edition features. How to read it before downgrading to Standard.
Upgrading Database Compatibility Levels Across a Whole Instance
The instance upgrade went perfectly. You moved from SQL Server 2019 to 2022, the installer turned green, the services came back up, and the application connected on the first try. A week later someone asks…