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
- erver 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