Mistake #1: treating configuration management as irrelevant to SQL Server. A test method checks whether a resource already matches its desired state; only detected drift should trigger the set method. For example, DSC repeatedly checks whether xp_cmdshell is enabled and disables it when the desired state is disabled. section 8.9
Use the test method as the safe control point:
- Evaluate the current configuration before changing it. section 8.9
- Treat the desired state as the comparison target, not as an unconditional command. section 8.9
- Use recurring evaluation to expose drift and support consistent, secure administration. section 8.9
Figure 8.3 Configuration management process
Follow the configuration-management process from testing the current state to applying corrective configuration. section 8.9
