DSCResources/SqlConfigurations/SqlConfigurations.schema.psm1

configuration SqlConfigurations {
    param (
        [Parameter()]
        [string]
        $DefaultInstanceName = 'MSSQLSERVER',

        [Parameter(Mandatory = $true)]
        [hashtable[]]
        $Options
    )

    <#
    InstanceName = [string]
    OptionName = [string]
    OptionValue = [Int32]
    [DependsOn = [string[]]]
    [PsDscRunAsCredential = [PSCredential]]
    [RestartService = [bool]]
    [RestartTimeout = [UInt32]]
    [ServerName = [string]]
    #>


    Import-DscResource -ModuleName SqlServerDsc

    foreach ($option in $Options)
    {
        # Remove Case Sensitivity of ordered Dictionary or Hashtables
        $option = @{} + $option

        if ([string]::IsNullOrWhiteSpace($option.InstanceName))
        {
            $option.InstanceName = $DefaultInstanceName
        }

        $executionName = "$($option.InstanceName)_$($option.OptionName -replace '[().:\s]', '_')"
        (Get-DscSplattedResource -ResourceName SqlConfiguration -ExecutionName $executionName -Properties $option -NoInvoke).Invoke($option)
    }
}