SQL Server 2025 Added 10 Configuration Options, and One Appeared After RTM

· by · in

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

· by · in

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

· by · in

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

· by · in

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…

Why Resource Governor Ignores Your SQL Server Agent Job Owner

· by · in

You did everything right. Resource Governor is configured, you have a workload group that caps CPU and memory so one runaway job cannot starve everything else, and you have a classifier function that reads the…

SQL Server Trace Flags

· by · in

Maintaining an up-to-date list of SQL Server Trace Flags is time consuming, and difficult since the majority are undocumented. Aaron over at SQLCrossJoin.wordpress.com maintains an incredibly detailed and comprehensive list of trace flags at https://sqlcrossjoin.wordpress.com/category/trace-flags/….