I have written quite a few blogs about this release. In this blog, we would see the new options available in sys.configurations catalog view.
LPIM in Configuration Manager: Enable Lock Pages in Memory
You can set LPIM in Configuration Manager without editing the local security policy by hand. This post shows where the property sits, how to read it from PowerShell, and how to check the result with T-SQL after the restart. It also explains why a memory cap comes first.
SQL SERVER 2019 – How to Turn On or Enable Instant File Initialization?
SQL Server 2019 Configuration Manager provides an interface for instant file initialization. My lab also used it with SQL Server 2017.
Database Scoped Configuration: Turn Off Parameter Sniffing
A database scoped configuration lets you turn off parameter sniffing for one database with a single statement. This post measures a procedure with the setting on and off, shows that the change clears the cached plans of the database, and explains what the switch does not fix.
GLOBAL_TEMPORARY_TABLE_AUTO_DROP: Keeping ## Tables Alive on Purpose
Understand GLOBAL_TEMPORARY_TABLE_AUTO_DROP, its version and database scope, explicit cleanup, and the risks of shared global tables.
What is the Priority of Database Scoped Configurations? – Interview Question of the Week #254
Question: What is the Priority of Database Scoped Configurations over Global Configuration at Server Level?
Answer: This is a follow-up question.
Database Scoped Configuration Options in SQL Server
Database scoped configuration options change how one database behaves, without touching the server. This post lists all 41 options on SQL Server 2025, finds the 7 ids that are missing, and changes and restores two settings in a demo database. It also answers the old question about configuration id 5.