SqlServerDsc.psd1

@{
    # Script module or binary module file associated with this manifest.
    RootModule           = 'SqlServerDsc.psm1'

    # Version number of this module.
    ModuleVersion        = '16.2.0'

    # ID used to uniquely identify this module
    GUID                 = '693ee082-ed36-45a7-b490-88b07c86b42f'

    # Author of this module
    Author               = 'DSC Community'

    # Company or vendor of this module
    CompanyName          = 'DSC Community'

    # Copyright statement for this module
    Copyright            = 'Copyright the DSC Community contributors. All rights reserved.'

    # Description of the functionality provided by this module
    Description          = 'Module with DSC resources for deployment and configuration of Microsoft SQL Server.'

    # Minimum version of the Windows PowerShell engine required by this module
    PowerShellVersion    = '5.0'

    # Minimum version of the common language runtime (CLR) required by this module
    CLRVersion           = '4.0'

    # Functions to export from this module
    FunctionsToExport    = @('Add-SqlDscNode','Add-SqlDscTraceFlag','Complete-SqlDscFailoverCluster','Complete-SqlDscImage','Connect-SqlDscDatabaseEngine','ConvertFrom-SqlDscDatabasePermission','ConvertFrom-SqlDscServerPermission','ConvertTo-SqlDscDatabasePermission','ConvertTo-SqlDscServerPermission','Disable-SqlDscAudit','Enable-SqlDscAudit','Get-SqlDscAudit','Get-SqlDscDatabasePermission','Get-SqlDscManagedComputer','Get-SqlDscManagedComputerService','Get-SqlDscServerPermission','Get-SqlDscStartupParameter','Get-SqlDscTraceFlag','Import-SqlDscPreferredModule','Initialize-SqlDscRebuildDatabase','Install-SqlDscServer','Invoke-SqlDscQuery','New-SqlDscAudit','Remove-SqlDscAudit','Remove-SqlDscNode','Remove-SqlDscTraceFlag','Repair-SqlDscServer','Set-SqlDscAudit','Set-SqlDscDatabasePermission','Set-SqlDscServerPermission','Set-SqlDscStartupParameter','Set-SqlDscTraceFlag','Test-SqlDscIsDatabasePrincipal','Test-SqlDscIsLogin','Uninstall-SqlDscServer')

    # Cmdlets to export from this module
    CmdletsToExport      = @()

    # Variables to export from this module
    VariablesToExport    = @()

    # Aliases to export from this module
    AliasesToExport      = @()

    DscResourcesToExport = @('SqlAudit','SqlDatabasePermission','SqlPermission','SqlAG','SqlAGDatabase','SqlAgentAlert','SqlAgentFailsafe','SqlAgentOperator','SqlAGListener','SqlAGReplica','SqlAlias','SqlAlwaysOnService','SqlConfiguration','SqlDatabase','SqlDatabaseDefaultLocation','SqlDatabaseMail','SqlDatabaseObjectPermission','SqlDatabaseRole','SqlDatabaseUser','SqlEndpoint','SqlEndpointPermission','SqlLogin','SqlMaxDop','SqlMemory','SqlProtocol','SqlProtocolTcpIp','SqlReplication','SqlRole','SqlRS','SqlRSSetup','SqlScript','SqlScriptQuery','SqlSecureConnection','SqlServiceAccount','SqlSetup','SqlTraceFlag','SqlWaitForAG','SqlWindowsFirewall')

    RequiredAssemblies   = @()

    # Private data to pass to the module specified in RootModule/ModuleToProcess. This may also contain a PSData hashtable with additional module metadata used by PowerShell.
    PrivateData          = @{

        PSData = @{
            # Set to a prerelease string value if the release should be a prerelease.
            Prerelease   = 'preview0007'

            # Tags applied to this module. These help with module discovery in online galleries.
            Tags         = @('DesiredStateConfiguration', 'DSC', 'DSCResourceKit', 'DSCResource')

            # A URL to the license for this module.
            LicenseUri   = 'https://github.com/dsccommunity/SqlServerDsc/blob/main/LICENSE'

            # A URL to the main website for this project.
            ProjectUri   = 'https://github.com/dsccommunity/SqlServerDsc'

            # A URL to an icon representing this module.
            IconUri      = 'https://dsccommunity.org/images/DSC_Logo_300p.png'

            # ReleaseNotes of this module
            ReleaseNotes = '## [16.2.0-preview0007] - 2023-04-01
 
### Added
 
- SqlServerDsc
  - New GitHub Actions workflow that run PSScriptAnalyzer for PRs so any
    issues are shown directly in the PR''s changed files ([issue #1860](https://github.com/dsccommunity/SqlServerDsc/issues/1860)).
  - Added a separate integration test jobs for SQL Server Reporting Services
    to be able to test configuring SQL Server Reportings Services using
    other values that the default values.
  - Now updates GitHub Actions automatically by allowing dependabot sending
    in pull requests.
- `SqlSecureConnection`
  - Added new parameter `ServerName` that will be used as the host name when
    restarting the SQL Server instance. The specified value should be the same
    name that is used in the certificate ([issue #1888](https://github.com/dsccommunity/SqlServerDsc/issues/1888)).
 
### Changed
 
- SqlServerDsc
  - Update `appveyor.yml` to use `dotnet tool install` to install _GitVersion_.
  - Re-enable integration tests for SqlRSSetup and SqlRS when running against
    SQL Server 2019 ([issue #1847](https://github.com/dsccommunity/SqlServerDsc/issues/1847)).
  - The private function `Import-SQLPSModule` was replaced throughout with
    the public command `Import-SqlDscPreferredModule` ([issue #1848](https://github.com/dsccommunity/SqlServerDsc/issues/1848)).
  - Removed the regular expression `features?` from the GitVersion configuration.
    Before, if a fix commit mentioned the word feature but means a SQL Server
    feature GitVersion would bump minor instead of patch number.
  - Update pipeline script that is used to resolve dependencies.
  - When running in Azure Pipelines any existing SqlServer module is removed
    before running integration tests, so the tests can update to latest version.
  - Now the new label ''command proposal'' is an exempt for labeling issues stale.
  - Update the initializing header for all integration test to be equal to
    the unit tests.
  - Rename task jobs in Azure Pipelines ([issue #1881](https://github.com/dsccommunity/SqlServerDsc/issues/1881)).
- `Get-SqlDscAudit`
  - The parameter `Name` is no longer mandatory. When left out all the current
    audits are returned ([issue #1812](https://github.com/dsccommunity/SqlServerDsc/issues/1812)).
- `Import-SqlDscPreferredModule`
  - Now correctly preserves paths that is set in the session for the environment
    variable `$env:PSModulePath`. If the module _SqlServer_ or _SQLPS_ are not
    found the command will populate the `$env:PSModulePath` with the
    unique paths from all targets; session, user, and machine. This is done
    so that any new path that was added to the machine or user target will
    also be set in the session.
  - Now imports the preferred module into the global scope so that MOF-based
    resources (that is in another module scope) can use the imported module.
  - Some code cleanup ([issue #1881](https://github.com/dsccommunity/SqlServerDsc/issues/1881)).
 
### Fixed
 
- `Assert-SetupActionProperties`
  - Now throws an exception if the setup action is `Install` and the feature
    analysis services is specified without the parameter `ASSysAdminAccounts`
    ([issue #1845](https://github.com/dsccommunity/SqlServerDsc/issues/1845)).
  - Now throws an exception if the setup action is `Install` and the feature
    database engine is specified without the parameter `SqlSysAdminAccounts`.
- `Invoke-SetupAction`
  - The parameter `SqlSysAdminAccounts` is no longer mandatory to allow
    installation where the database engine is not installed.
- `Install-SqlDscServer`
  - The parameter `SqlSysAdminAccounts` is no longer mandatory to allow
    installation where the database engine is not installed.
- `SqlRS`
  - Fixed issue of configuring reporting services ([issue #1868](https://github.com/dsccommunity/SqlServerDsc/issues/1868)).
  - Test renamed to `When Reports virtual directory is different` so it
    is more correct and not a duplicate.
  - Integration tests configuration names was renamed to better tell what
    the configuration does ([issue #1880](https://github.com/dsccommunity/SqlServerDsc/issues/1880)).
- SqlServerDsc.Common
  - The command `Restart-SqlService` was updated to correctly evaluate when
    the timeout value is reached ([issue #1889](https://github.com/dsccommunity/SqlServerDsc/issues/1889)).
 
'


        } # End of PSData hashtable

    } # End of PrivateData hashtable
}