SqlServerDsc.psd1
|
@{ # Version number of this module. moduleVersion = '14.0.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 = @() # Cmdlets to export from this module CmdletsToExport = @() # Variables to export from this module VariablesToExport = @() # Aliases to export from this module AliasesToExport = @() DscResourcesToExport = @( 'SqlAG' 'SqlAGDatabase' 'SqlAgentAlert' 'SqlAgentFailsafe' 'SqlAgentOperator' 'SqlAGListener' 'SqlAGReplica' 'SqlAlias' 'SqlAlwaysOnService' 'SqlDatabase' 'SqlDatabaseDefaultLocation' 'SqlDatabaseOwner' 'SqlDatabasePermission' 'SqlDatabaseRecoveryModel' 'SqlDatabaseRole' 'SqlDatabaseUser' 'SqlRS' 'SqlRSSetup' 'SqlScript' 'SqlScriptQuery' 'SqlServerConfiguration' 'SqlServerDatabaseMail' 'SqlServerEndpoint' 'SqlServerEndpointPermission' 'SqlServerEndpointState' 'SqlServerLogin' 'SqlServerMaxDop' 'SqlServerMemory' 'SqlServerNetwork' 'SqlServerPermission' 'SqlServerProtocol' 'SqlServerProtocolTcpIp' 'SqlServerReplication' 'SqlServerRole' 'SqlServerSecureConnection' 'SqlServiceAccount' 'SqlSetup' '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 = 'preview0006' # 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/master/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 = '## [14.0.0-preview0006] - 2020-05-05 ### Added - SqlServerDsc - Added new resource SqlServerProtocol ([issue #1377](https://github.com/dsccommunity/SqlServerDsc/issues/1377)). - Added new resource SqlServerProtocolTcpIp ([issue #1378](https://github.com/dsccommunity/SqlServerDsc/issues/1378)). - SqlSetup - A read only property `IsClustered` was added that can be used to determine if the instance is clustered. - SqlServerDsc.Common - The helper function `Restart-SqlService` was improved to handle Failover Clusters better. Now the SQL Server service will only be taken offline and back online again if the service is online to begin with. - The helper function `Restart-SqlServer` learned the new parameter `OwnerNode`. The parameter `OwnerNode` takes an array of Cluster node names. Using this parameter the cluster group will only be taken offline and back online if the cluster group owner is one specified in this parameter. ### Changed - SqlServerDsc - Changed all resource prefixes from `MSFT_` to `DSC_` ([issue #1496](https://github.com/dsccommunity/SqlServerDsc/issues/1496)). - All resources are now using the common module DscResource.Common. - When a PR is labelled with ''ready for merge'' it is no longer being marked as stale if the PR is not merged for 30 days (for example it is dependent on something else) ([issue #1504](https://github.com/dsccommunity/SqlServerDsc/issues/1504)). - Updated the CI pipeline to use latest version of the module ModuleBuilder. - Changed to use the property `NuGetVersionV2` from GitVersion in the CI pipeline. - SqlAlwaysOnService - BREAKING CHANGE: The parameter `ServerName` is now non-mandatory and defaults to `$env:COMPUTERNAME` ([issue #319](https://github.com/dsccommunity/SqlServerDsc/issues/319)). - Normalize parameter descriptive text for default values. - SqlDatabase - BREAKING CHANGE: The parameter `ServerName` is now non-mandatory and defaults to `$env:COMPUTERNAME` ([issue #319](https://github.com/dsccommunity/SqlServerDsc/issues/319)). - Normalize parameter descriptive text for default values. - SqlDatabaseDefaultLocation - BREAKING CHANGE: The parameter `ServerName` is now non-mandatory and defaults to `$env:COMPUTERNAME` ([issue #319](https://github.com/dsccommunity/SqlServerDsc/issues/319)). - Normalize parameter descriptive text for default values. - SqlDatabaseOwner - BREAKING CHANGE: Database changed to DatabaseName for consistency with other modules ([issue #1484](https://github.com/dsccommunity/SqlServerDsc/issues/1484)). - SqlDatabasePermission - BREAKING CHANGE: The parameter `ServerName` is now non-mandatory and defaults to `$env:COMPUTERNAME` ([issue #319](https://github.com/dsccommunity/SqlServerDsc/issues/319)). - Normalize parameter descriptive text for default values. - BREAKING CHANGE: Database changed to DatabaseName for consistency with other modules ([issue #1484](https://github.com/dsccommunity/SqlServerDsc/issues/1484)). - SqlDatabaseRecoveryModel - BREAKING CHANGE: The parameter `ServerName` is now non-mandatory and defaults to `$env:COMPUTERNAME` ([issue #319](https://github.com/dsccommunity/SqlServerDsc/issues/319)). - Normalize parameter descriptive text for default values. - SqlDatabaseRole - BREAKING CHANGE: The parameter `ServerName` is now non-mandatory and defaults to `$env:COMPUTERNAME` ([issue #319](https://github.com/dsccommunity/SqlServerDsc/issues/319)). - Normalize parameter descriptive text for default values. - BREAKING CHANGE: Database changed to DatabaseName for consistency with other modules ([issue #1484](https://github.com/dsccommunity/SqlServerDsc/issues/1484)). - SqlDatabaseUser - BREAKING CHANGE: The parameter `ServerName` is now non-mandatory and defaults to `$env:COMPUTERNAME` ([issue #319](https://github.com/dsccommunity/SqlServerDsc/issues/319)). - Normalize parameter descriptive text for default values. - SqlServerConfiguration - BREAKING CHANGE: The parameter `ServerName` is now non-mandatory and defaults to `$env:COMPUTERNAME` ([issue #319](https://github.com/dsccommunity/SqlServerDsc/issues/319)). - Normalize parameter descriptive text for default values. - SqlServerDatabaseMail - Normalize parameter descriptive text for default values. - SqlServerEndpoint - Normalize parameter descriptive text for default values. - SqlServerEndpointPermission - BREAKING CHANGE: The parameter `ServerName` is now non-mandatory and defaults to `$env:COMPUTERNAME` ([issue #319](https://github.com/dsccommunity/SqlServerDsc/issues/319)). - Normalize parameter descriptive text for default values. - SqlServerLogin - BREAKING CHANGE: The parameter `ServerName` is now non-mandatory and defaults to `$env:COMPUTERNAME` ([issue #319](https://github.com/dsccommunity/SqlServerDsc/issues/319)). - Normalize parameter descriptive text for default values. - SqlServerRole - BREAKING CHANGE: The parameter `ServerName` is now non-mandatory and defaults to `$env:COMPUTERNAME` ([issue #319](https://github.com/dsccommunity/SqlServerDsc/issues/319)). - Normalize parameter descriptive text for default values. - SqlServiceAccount - BREAKING CHANGE: The parameter `ServerName` is now non-mandatory and defaults to `$env:COMPUTERNAME` ([issue #319](https://github.com/dsccommunity/SqlServerDsc/issues/319)). - Normalize parameter descriptive text for default values. ### Fixed - SqlServerDsc - The regular expression for `minor-version-bump-message` in the file `GitVersion.yml` was changed to only raise minor version when the commit message contain the word `add`, `adds`, `minor`, `feature`, or `features`. - Now code coverage is reported to Codecov, and a codecov.yml was added. - Updated to support DscResource.Common v0.7.1. - SqlSetup - The property `SqlTempdbLogFileGrowth` and `SqlTempdbFileGrowth` now returns the correct values. Previously the value of the growth was wrongly divided by 1KB even if the value was in percent. Now the value for growth is the sum of the average of MB and average of the percentage. - The function `Get-TargetResource` was changed so that the property `SQLTempDBDir` will now return the database `tempdb`''s property `PrimaryFilePath`. - BREAKING CHANGE: Logic that was under feature flag `DetectionSharedFeatures` was made the default and old logic that was used to detect shared features was removed ([issue #1290](https://github.com/dsccommunity/SqlServerDsc/issues/1290)). This was implemented because the previous implementation did not work fully with SQL Server 2017. - Much of the code was refactored into units (functions) to be easier to test. Due to the size of the code the unit tests ran for an abnormal long time, after this refactoring the unit tests runs much quicker. - README.md - Changed to point to CONTRIBUTING.md on master branch to avoid "404 Page not found" ([issue #1508](https://github.com/dsccommunity/SqlServerDsc/issues/1508)). - SqlAlias - BREAKING CHANGE: The parameter `ServerName` is now non-mandatory to prevent ping-pong behavior ([issue #1502](https://github.com/dsccommunity/SqlServerDsc/issues/1502)). The `ServerName` is not returned as an empty string when the protocol is Named Pipes. - SqlRs - Fix typo in the schema parameter `SuppressRestart` description and in the parameter description in the `README.md`. - SqlSetup - Update integration tests to correctly detect sysadmins because of changes to the build worker. - SqlAgentAlert - The parameter `ServerName` now throws when passing an empty string or null value (part of [issue #319](https://github.com/dsccommunity/SqlServerDsc/issues/319)). - SqlAgentFailsafe - The parameter `ServerName` now throws when passing an empty string or null value (part of [issue #319](https://github.com/dsccommunity/SqlServerDsc/issues/319)). - SqlAgentOperator - The parameter `ServerName` now throws when passing an empty string or null value (part of [issue #319](https://github.com/dsccommunity/SqlServerDsc/issues/319)). - SqlServerDatabaseMail - The parameter `ServerName` now throws when passing an empty string or null value (part of [issue #319](https://github.com/dsccommunity/SqlServerDsc/issues/319)). - SqlServerEndpoint - The parameter `ServerName` now throws when passing an empty string or null value (part of [issue #319](https://github.com/dsccommunity/SqlServerDsc/issues/319)). - SqlServerEndpointState - The parameter `ServerName` now throws when passing an empty string or null value (part of [issue #319](https://github.com/dsccommunity/SqlServerDsc/issues/319)). - SqlServerPermission - The parameter `ServerName` now throws when passing an empty string or null value (part of [issue #319](https://github.com/dsccommunity/SqlServerDsc/issues/319)). ' } # End of PSData hashtable } # End of PrivateData hashtable } |