SqlServerDsc

14.0.0-preview0009

Module with DSC resources for deployment and configuration of Microsoft SQL Server.

Minimum PowerShell version

5.0

This is a prerelease version of SqlServerDsc.
There is a newer prerelease version of this module available.
See the version list below for details.

Installation Options

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Module -Name SqlServerDsc -RequiredVersion 14.0.0-preview0009 -AllowPrerelease

Copy and Paste the following command to install this package using Microsoft.PowerShell.PSResourceGet More Info

Install-PSResource -Name SqlServerDsc -Version 14.0.0-preview0009 -Prerelease

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deploy all the dependencies to Azure Automation. Learn More

Manually download the .nupkg file to your system's default download location. Note that the file won't be unpacked, and won't include any dependencies. Learn More

Owners

Copyright

Copyright the DSC Community contributors. All rights reserved.

Package Details

Author(s)

  • DSC Community

Tags

DesiredStateConfiguration DSC DSCResourceKit DSCResource

DSCResources

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

Dependencies

This module has no dependencies.

Release Notes

## [14.0.0-preview0009] - 2020-05-12

### Deprecated

The documentation, examples, unit test, and integration tests have been
removed for these deprecated resources.

- SqlServerNetwork
 - This resource is now deprecated. The functionality is now covered by
   the resources _SqlServerProtocol_ and _SqlServerProtocolTcpIp_.

### 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)).
 - Fixing a problem with the latest ModuleBuild 1.7.0 that breaks the CI
   pipeline.
- SqlSetup
 - A read only property `IsClustered` was added that can be used to determine
   if the instance is clustered.
 - Added the properties `NpEnabled` and `TcpEnabled` ([issue #1161](https://github.com/dsccommunity/SqlServerDsc/issues/1161)).
- SqlServerReplication
 - Add integration tests ([issue #755](https://github.com/dsccommunity/SqlServerDsc/issues/755)
- 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)).
   _Deprecated resource has not changed prefix._
 - 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.
 - The unit tests now run on PowerShell 7 to optimize the total run time.
- SqlServerDsc.Common
 - The helper function `Invoke-InstallationMediaCopy` was changed to
   handle a breaking change in PowerShell 7 ([issue #1530](https://github.com/dsccommunity/SqlServerDsc/issues/1530)).
- 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.
- SqlSetup
 - BREAKING CHANGE: Now if the parameter `AgtSvcStartupType` is not specified
   in the configuration the resource will no longer by default add an
   argument to `setup.exe` with a value of `Automatic` for the argument
   `AGTSVCSTARTUPTYPE`. If the parameter `AgtSvcStartupType` is not specified
   in the configuration there will be no setup argument added at all
   ([issue #464](https://github.com/dsccommunity/SqlServerDsc/issues/464)).

### 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.
 - Changed to point to CONTRIBUTING.md on master branch to avoid "404 Page not found"
   ([issue #1508](https://github.com/dsccommunity/SqlServerDsc/issues/1508)).
- SqlAGDatabase
 - Fixed unit tests that failed intermittently when running unit tests
   in PowerShell 7 ([issue #1532](https://github.com/dsccommunity/SqlServerDsc/issues/1532)).
 - Minor code style issue changes.
- 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)).
- 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.
- SqlDatabase
 - Fixed missing parameter `CompatibilityLevel` in the README.md (and
   updated the description in the schema.mof).
- SqlRs
 - Fix typo in the schema parameter `SuppressRestart` description
   and in the parameter description in the `README.md`.
- 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)).
- SqlServerReplication
 - Enhanced the exception handling so it shows the inner exception error
   message that have the actual error that occurred.
 - Corrected the examples.
- SqlSetup
 - Update integration tests to correctly detect sysadmins because of change

FileList

Version History

Version Downloads Last updated
17.0.1-previ... 18 10/29/2024
17.0.1-previ... 6 10/26/2024
17.0.1-previ... 14 10/7/2024
17.0.0 42,433 9/30/2024
17.0.0-previ... 4 9/29/2024
17.0.0-previ... 48 8/13/2024
16.6.1-previ... 118 5/23/2024
16.6.1-previ... 5 5/22/2024
16.6.0 91,061 5/17/2024
16.6.0-previ... 10 5/12/2024
16.6.0-previ... 4 5/11/2024
16.6.0-previ... 104 3/3/2024
16.6.0-previ... 46 1/20/2024
16.6.0-previ... 6 1/19/2024
16.5.1-previ... 68 12/15/2023
16.5.1-previ... 91 11/19/2023
16.5.1-previ... 47 11/2/2023
16.5.0 144,733 10/5/2023
16.5.0-previ... 12 10/1/2023
16.5.0-previ... 7 9/29/2023
16.5.0-previ... 47 9/1/2023
16.5.0-previ... 7 8/26/2023
16.4.1-previ... 6 8/25/2023
16.4.0 111,491 8/22/2023
16.4.0-previ... 5 8/20/2023
16.4.0-previ... 5 8/20/2023
16.4.0-previ... 6 8/19/2023
16.4.0-previ... 76 5/18/2023
16.4.0-previ... 20 5/10/2023
16.4.0-previ... 6 5/9/2023
16.4.0-previ... 7 5/8/2023
16.3.1 460,082 5/6/2023
16.3.1-previ... 5 5/6/2023
16.3.1-previ... 9 5/4/2023
16.3.0 42,245 4/26/2023
16.3.0-previ... 7 4/26/2023
16.3.0-previ... 7 4/25/2023
16.3.0-previ... 6 4/24/2023
16.3.0-previ... 6 4/23/2023
16.3.0-previ... 21 4/18/2023
16.3.0-previ... 5 4/16/2023
16.2.1-previ... 7 4/12/2023
16.2.0 75,152 4/10/2023
16.2.0-previ... 5 4/10/2023
16.2.0-previ... 5 4/8/2023
16.2.0-previ... 5 4/8/2023
16.2.0-previ... 10 4/6/2023
16.2.0-previ... 10 4/1/2023
16.2.0-previ... 11 3/28/2023
16.2.0-previ... 10 3/26/2023
16.2.0-previ... 5 3/25/2023
16.2.0-previ... 170 3/19/2023
16.2.0-previ... 27 3/7/2023
16.2.0-previ... 10 3/4/2023
16.1.0 175,569 2/28/2023
16.1.0-previ... 6 2/28/2023
16.1.0-previ... 9 2/25/2023
16.1.0-previ... 6 2/24/2023
16.1.0-previ... 48 2/13/2023
16.1.0-previ... 28 2/12/2023
16.1.0-previ... 25 2/5/2023
16.1.0-previ... 11 2/1/2023
16.1.0-previ... 29 1/25/2023
16.1.0-previ... 8 1/24/2023
16.1.0-previ... 5 1/24/2023
16.1.0-previ... 12 1/22/2023
16.1.0-previ... 346 1/4/2023
16.1.0-previ... 6 1/3/2023
16.1.0-previ... 15 12/26/2022
16.1.0-previ... 50 12/19/2022
16.1.0-previ... 13 12/17/2022
16.1.0-previ... 115 12/11/2022
16.1.0-previ... 13 12/4/2022
16.1.0-previ... 36 11/26/2022
16.1.0-previ... 11 11/24/2022
16.0.1-previ... 31 11/11/2022
16.0.0 827,598 9/9/2022
16.0.0-previ... 30 8/21/2022
16.0.0-previ... 24 8/13/2022
16.0.0-previ... 15 8/13/2022
16.0.0-previ... 26 8/1/2022
16.0.0-previ... 81 6/14/2022
16.0.0-previ... 25 6/8/2022
16.0.0-previ... 18 6/6/2022
16.0.0-previ... 15 6/6/2022
16.0.0-previ... 89 4/26/2022
16.0.0-previ... 45 3/28/2022
16.0.0-previ... 66 2/12/2022
15.2.0 2,684,622 9/1/2021
15.2.0-previ... 16 9/1/2021
15.2.0-previ... 45 7/23/2021
15.2.0-previ... 76 6/6/2021
15.2.0-previ... 66 4/18/2021
15.2.0-previ... 86 3/12/2021
15.1.1 1,392,080 2/12/2021
15.1.1-previ... 18 2/12/2021
15.1.0 62,443 2/2/2021
15.1.0-previ... 25 2/1/2021
15.1.0-previ... 20 1/31/2021
15.0.2-previ... 19 1/30/2021
15.0.2-previ... 25 1/24/2021
15.0.2-previ... 63 1/21/2021
15.0.2-previ... 62 1/12/2021
15.0.1 143,076 1/9/2021
15.0.1-previ... 59 1/9/2021
15.0.1-previ... 64 1/6/2021
15.0.1-previ... 60 1/6/2021
15.0.1-previ... 69 12/27/2020
15.0.1-previ... 61 12/26/2020
15.0.1-previ... 63 12/23/2020
15.0.1-previ... 71 12/14/2020
15.0.1-previ... 62 12/13/2020
15.0.1-previ... 60 12/12/2020
15.0.1-previ... 61 12/10/2020
15.0.0 214,519 12/6/2020
15.0.0-previ... 61 12/6/2020
15.0.0-previ... 66 11/25/2020
15.0.0-previ... 58 11/22/2020
15.0.0-previ... 62 11/21/2020
14.3.0-previ... 99 10/5/2020
14.3.0-previ... 55 10/3/2020
14.3.0-previ... 61 10/2/2020
14.2.2-previ... 105 8/19/2020
14.2.2-previ... 61 8/16/2020
14.2.1 642,175 8/14/2020
14.2.1-previ... 60 8/13/2020
14.2.1-previ... 61 8/11/2020
14.2.1-previ... 57 8/11/2020
14.2.1-previ... 72 7/31/2020
14.2.1-previ... 60 7/28/2020
14.2.0 72,592 7/23/2020
14.2.0-previ... 63 7/23/2020
14.2.0-previ... 65 7/19/2020
14.2.0-previ... 74 7/13/2020
14.2.0-previ... 65 7/10/2020
14.2.0-previ... 62 7/9/2020
14.1.1-previ... 64 7/9/2020
14.1.0 221,770 7/6/2020
14.1.0-previ... 369 7/5/2020
14.1.0-previ... 61 7/4/2020
14.1.0-previ... 62 7/4/2020
14.1.0-previ... 64 7/3/2020
14.1.0-previ... 66 7/1/2020
14.0.1-previ... 72 6/28/2020
14.0.1-previ... 61 6/26/2020
14.0.0 10,843 6/12/2020
14.0.0-previ... 62 6/12/2020
14.0.0-previ... 68 6/11/2020
14.0.0-previ... 70 6/10/2020
14.0.0-previ... 69 6/10/2020
14.0.0-previ... 103 5/28/2020
14.0.0-previ... 78 5/25/2020
14.0.0-previ... 68 5/25/2020
14.0.0-previ... 80 5/19/2020
14.0.0-previ... 76 5/19/2020
14.0.0-previ... 82 5/17/2020
14.0.0-previ... 71 5/17/2020
14.0.0-previ... 69 5/16/2020
14.0.0-previ... 70 5/14/2020
14.0.0-previ... 72 5/13/2020
14.0.0-previ... 80 5/12/2020
14.0.0-previ... 70 5/12/2020
14.0.0-previ... (current version) 70 5/12/2020
14.0.0-previ... 83 5/8/2020
14.0.0-previ... 69 5/6/2020
14.0.0-previ... 73 5/5/2020
14.0.0-previ... 71 5/4/2020
14.0.0-previ... 70 5/3/2020
14.0.0-previ... 69 5/3/2020
14.0.0-previ... 84 4/27/2020
14.0.0-previ... 79 4/26/2020
13.5.0 28,416 4/12/2020
13.5.0-previ... 76 4/11/2020
13.5.0-previ... 78 4/11/2020
13.4.1-previ... 105 3/31/2020
13.4.0 122,350 3/18/2020
13.4.0-previ... 71 3/18/2020
13.3.1-previ... 117 1/18/2020
13.3.0 480,497 1/17/2020
13.3.0-previ... 74 1/17/2020
13.3.0-previ... 79 1/12/2020
13.3.0-previ... 73 1/8/2020
13.3.0-previ... 76 1/7/2020
13.3.0-previ... 73 1/3/2020
13.3.0-previ... 74 1/2/2020
13.3.0-previ... 75 1/2/2020
13.2.0.0 861,904 9/19/2019
13.1.0.0 35,024 8/8/2019
13.0.0.0 26,042 6/26/2019
12.5.0.0 17,394 5/15/2019
12.4.0.0 21,746 4/3/2019
12.3.0.0 40,231 2/20/2019
12.2.0.0 9,018 1/10/2019
12.1.0.0 23,280 10/25/2018
12.0.0.0 21,441 9/5/2018
11.4.0.0 16,156 7/25/2018
11.3.0.0 7,383 6/13/2018
11.2.0.0 5,233 5/2/2018
11.1.0.0 6,228 3/22/2018
11.0.0.0 13,495 2/8/2018
10.0.0.0 3,650 12/14/2017
Show less