SqlStartupParameter: New resource proposal #2169
Description
Resource proposal
A class-based SqlStartupParameter resource would manage SQL Server service startup parameters, ensuring required flags and configuration are set. It would use Get-SqlDscStartupParameter and Set-SqlDscStartupParameter.
Proposed properties
| Property | Type qualifier | Data type | Description | Default value | Allowed values |
|---|---|---|---|---|---|
| Parameters | Key | String[] | List of startup parameters to ensure | None | Any valid startup parameter list |
| 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 parameters for SQL Server compatibility and ensure changes do not impact service availability. Contributors should handle service restarts and error conditions gracefully.