dsccommunity / dsccommunity/SqlServerDsc
SqlStartupParameter: New resource proposal
Nobody has claimed this yet.
- Dominant language
- PowerShell
- Stars
- 385
- Forks
- 224
- PR merge metrics
- No merged PRs in 30d
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.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reading the behavior of Get-SqlDscStartupParameter and Set-SqlDscStartupParameter, then determine how existing class-based resources represent Parameters, ServerName, and InstanceName. Done means the new SqlStartupParameter resource validates compatible parameters, handles service restarts and errors safely, and preserves service availability.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- powershell
- Domain
- databases, devops
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 30/100