SQL Server Desired State Configuration #
Easily standardize SQL Server settings based on version controlled configuration files.
In this example,
- Set the
model
database to SIMPLE recovery - Disable the
sa
login - Set the cost threshold for parallelism to 50
Sample Configuration File #
Applying the Configuration #
Features #
- Test your configuration and find out what changes would be made
- Target multiple SQL Servers
- Default settings that can be overridden for each server
- Configuration objects include
- All
sp_configure
settings including disabling xp_cmdshell, maximum memory, cost threshold for parallelism, etc. - SQL Server and Domain logins
- Server permissions
- Server role membership
- SQL Server Agent operators
- Databases including owner, recovery model, and Read Committed Snapshot Isolation
- Database users
- Database role members
- Database permissions
- Running SQL Server script files for more complicated situations
- All