liveBook · Manning

Configuration resource

As explained in 100 SQL Server Mistakes and How to Avoid Them

A configuration resource is a code unit that evaluates and changes one specific type of system configuration.

A configuration resource is a code unit that evaluates one specific server setting and changes it only when the current state differs from the desired state. Its test method detects drift; its set method corrects it. section 8.9

Treating SQL Server configuration as a one-time task leaves drift undetected. A manifest lists resources and their desired values, allowing configuration management to recheck servers periodically and automatically correct misconfiguration. section 8.9

Disabling xp_cmdshell

A DSC configuration evaluates whether xp_cmdshell is enabled every 30 minutes. If it is already disabled, the resource moves on; otherwise, its set method disables the feature across SQL Server hosts. section 8.9

How 100 SQL Server Mistakes and How to Avoid Them covers it

How deep it goes
Defines test, set, manifest, and periodic drift correction, without detailing each resource implementation.
Examples
Uses xp_cmdshell enforcement and DSC SQL Server installation and configuration resources as concrete examples.
What it assumes
Assumes basic server configuration familiarity while introducing resources, manifests, desired state, testing, and correction.
What you can do after
Operate configuration management by defining resources, compiling a DSC configuration, and applying it to SQL Server.
How it connects
Connects resources with manifests, configuration management, Desired State Configuration, and drift detection.
Cover of 100 SQL Server Mistakes and How to Avoid Them
liveBookmanning.com
Read 100 SQL Server Mistakes and How to Avoid Them on liveBook Get the book at manning.com

Related concepts

This explainer was generated by Manning's knowledge graph from the text of 100 SQL Server Mistakes and How to Avoid Them. The section links point to the parts of the book it draws on.