SqlConfiguration: Resource refactoring proposal

[johlju]

Resource proposal

A class-based SqlConfiguration resource would manage sp_configure options and server-wide configurations. It would use Get-SqlDscConfigurationOption and Invoke-SqlDscQuery for setting values.

Proposed properties

Property	Type qualifier	Data type	Description	Default value	Allowed values
OptionName	Key	String	The name of the configuration option	None	Any valid option name
OptionValue	Write	String	Option value to set	None	Valid value for option
ServerName	Key	String	The SQL Server host name	None	Any valid server name
InstanceName	Key	String	The SQL Server instance name	None	Any valid instance name

Special considerations or limitations

Should validate allowed values and consider SQL Server version differences. Contributors should ensure changes are idempotent and do not require unnecessary service restarts.