dsccommunity / dsccommunity/SqlServerDsc

SqlDatabaseFile: New resource proposal

Open
#57 20 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

help wanted resource proposal
Dominant language
PowerShell
Stars
385
Forks
224
PR merge metrics
No merged PRs in 30d

Description

SqlDatabaseFile

I would like to see a new resource SqlDatabaseFile which can add and modify data file and/or log file.
Comments on this appreciated.

Description

I can see this resource take multiple names of files. So it can create one file or several files depending on the users requirement. But I think the resource should not create Log and Data files at the same time. User should implement two steps n the configuration file for adding both log and data files.
I don't see this module to be able to move data or log file to a new path, maybe that can be a improvement. With modify I mean it can make sure sizes are always the same, if user wants that.

Usage

I personally want to be able to use this to modify the tempdb as well as other databases.

Schema suggestion

ServerName - The host name of the SQL Server.
InstanceName - The instance name of the SQL Server. Default is 'MSSQLSERVER'.
Ensure - If the file should me present or absent, and if it present if the sizes should be enforced. Valid values are 'Present', 'PresentAndSize', 'Absent'.
Name - Name of the file. Will be used as name and display name.
Path - The path where file will be created. It defaults to the path of the first file returned.
FileType - The type of file to create. Valid values are 'DATA','LOG'. Defaults to 'DATA'.
FileGroup - The file group to add the data file to. Defaults to 'PRIMARY'. Ignored if -FileType is 'LOG'.
GrowthType - The auto growth type. Valid values are 'Percent' or 'MB'.
Growth - The auto growth size for the file. Value is in percent or MB depending of -GrowthType.
IntialSize - The initial size of the file in MB. If -Ensure is set to 'PresentAndSize' then the initial size will be tried to be enforced.
MaxSize - The max size of the file in MB, or -1for unlimited size. If -Ensure is set to 'PresentAndSize' and -MaxSize does not equal -1 then the max size will be tried to be enforced.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reviewing the proposed SqlDatabaseFile schema and usage requirements in the issue. No implementation files, tests, or entry points are identified; the work is not ready until the resource scope, behavior for data and log files, and acceptance criteria are agreed.

Written by the indexing model from the issue text.

Assessment

Tech stack
powershell, sql
Domain
databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.