SqlRole: Resource refactoring proposal

[johlju]

Resource proposal

A class-based SqlRole resource would manage SQL Server server-level roles and memberships. It would use commands such as Get-SqlDscRole, New-SqlDscRole, Remove-SqlDscRole.

Proposed properties

Property	Type qualifier	Data type	Description	Default value	Allowed values
Ensure	Key	String	Whether the role should be Present or Absent	Present	Present, Absent
ServerRoleName	Key	String	The name of the server role	None	Any valid server role name
Members	Write	String[]	Members of the role	None	Any valid login 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 ensure proper handling of role membership changes, idempotency, and support all built-in and custom roles. Contributors should validate role existence and membership operations.