SqlServerDsc

16.1.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 16.1.0-preview0009 -AllowPrerelease

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

Install-PSResource -Name SqlServerDsc -Version 16.1.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

Functions

Add-SqlDscNode Complete-SqlDscFailoverCluster Complete-SqlDscImage Connect-SqlDscDatabaseEngine ConvertFrom-SqlDscDatabasePermission ConvertFrom-SqlDscServerPermission ConvertTo-SqlDscDatabasePermission ConvertTo-SqlDscServerPermission Disable-SqlDscAudit Enable-SqlDscAudit Get-SqlDscAudit Get-SqlDscDatabasePermission Get-SqlDscServerPermission Initialize-SqlDscRebuildDatabase Install-SqlDscServer Invoke-SqlDscQuery New-SqlDscAudit Remove-SqlDscAudit Remove-SqlDscNode Repair-SqlDscServer Set-SqlDscAudit Set-SqlDscDatabasePermission Set-SqlDscServerPermission Test-SqlDscIsDatabasePrincipal Test-SqlDscIsLogin Uninstall-SqlDscServer

DSCResources

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

Dependencies

This module has no dependencies.

Release Notes

## [16.1.0-preview0009] - 2023-01-04

### Removed

- SqlServerDsc
 - Removed `Assert-ElevatedUser` from private functions ([issue #1797](https://github.com/dsccommunity/SqlServerDsc/issues/1797)).
   - `Assert-ElevatedUser` added to _DscResource.Common_ public functions
     ([issue #82](https://github.com/dsccommunity/DscResource.Common/issues/82)).
 - Removed `Test-IsNumericType` from private functions ([issue #1795](https://github.com/dsccommunity/SqlServerDsc/issues/1795)).
   - `Test-IsNumericType` added to _DscResource.Common_ public functions
   ([issue #87](https://github.com/dsccommunity/DscResource.Common/issues/87)).
 - Removed `Test-ServiceAccountRequirePassword` from private functions ([issue #1794](https://github.com/dsccommunity/SqlServerDsc/issues/1794)
   - Replaced by `Test-AccountRequirePassword` that was added to _DscResource.Common_
     public functions ([issue #93](https://github.com/dsccommunity/DscResource.Common/issues/93)).
 - Removed `Assert-RequiredCommandParameter` from private functions ([issue #1796](https://github.com/dsccommunity/SqlServerDsc/issues/1796)).
   - Replaced by `Assert-BoundParameter` (part of _DscResource.Common_)
     that had a new parameter set added ([issue #92](https://github.com/dsccommunity/DscResource.Common/issues/92)).
 - Removed private function `Test-ResourceDscPropertyIsAssigned` and
   `Test-ResourceHasDscProperty`. Both are replaced by `Test-DscProperty`
   which is now part of the module _DscResource.Common_.
 - Removed private function `Get-DscProperty`. It is replaced by `Get-DscProperty`
   which is now part of the module _DscResource.Common_.
 - The class `ResourceBase` and `Reason` has been removed, they are now
   part of the module _DscResource.Base_.
 - The enum `Ensure` has been removed, is is now part of the module
   _DscResource.Base_.
 - The private functions that the class `ResourceBase` depended on has been
   moved to the module _DscResource.Base_.
   - `ConvertFrom-CompareResult`
   - `ConvertTo-Reason`
   - `Get-ClassName`
   - `Get-LocalizedDataRecursive`

### Added

- SqlServerDsc
 - The following private functions were added to the module (see comment-based
   help for more information):
   - `Assert-SetupActionProperties`
   - `Invoke-SetupAction`
 - The following public functions were added to the module (see comment-based
   help for more information):
   - `Install-SqlDscServer`
   - `Uninstall-SqlDscServer`
   - `Add-SqlDscNode`
   - `Remove-SqlDscNode`
   - `Repair-SqlDscServer`
   - `Complete-SqlDscImage`
   - `Complete-SqlDscFailoverCluster`
   - `Initialize-SqlDscRebuildDatabase`
 - New GitHub issue templates for proposing new public commands, proposing
   an enhancement to an existing command, or having a problem with an existing
   command.
 - Integration tests are now also run on SQL Server 2022 and SQL Server
   Reporting Services 2022.
 - Integration tests now wait for LCM after each It-block, not just at the
   end of a Context-block. Hopefully this will mitigate some of the intermittent
   errors we have seen when running the integration tests in the pipeline.
 - Use preview version of Pester to support the development of Pester as
   this is a code base with a diverse set of tests thar can help catch
   issues in Pester. If preview release of Pester prevents release we
   should temporary shift back to stable.
 - Add the GitHub App _Pull Request Quantifier_ as an experiment to see if it
   brings any value ([issue #1811](https://github.com/dsccommunity/SqlServerDsc/issues/1811)).
   - Updated thresholds, and label names and colors.
 - New QA tests for public commands and private functions.
- SqlDatabase
 - Added compatibility levels for SQL Server 2022 (major version 16).
- SqlSetup
 - Paths for SQL Server 2022 are correctly returned by Get.
- The public commands `Add-SqlDscNode`, `Complete-SqlDscFailoverCluster`,
 `Complete-SqlDscImage`, `Install-SqlDscServer`, and `Repair-SqlDscServer`
 now support the setup argument `ProductCoveredBySA` ([issue #1798](https://github.com/dsccommunity/SqlServerDsc/issues/1798)).

### Changed

- SqlServerDsc
 - Update Stale GitHub Action to v7.
 - Update to build module in separate folder under `output`.
 - Moved the build step of the pipeline to a Windows build worker when
   running in Azure DevOps.
 - Class-based resources now uses the parent class `ResourceBase` from the
   module _DscResource.Base_ ([issue #1790](https://github.com/dsccommunity/SqlServerDsc/issues/1790)).
 - Settings for the _Visual Studio Code_ extension _Pester Tests_ was changed
   to be able to run all unit tests, and all tests run by the extension
   are now run in a separate process to be able to handle changes in
   class-based resources.
- `Install-SqlServerDsc`
 - No longer throws an exception when parameter `AgtSvcAccount` is not specified.
- SqlAgReplica
 - Converted unit test to Pester 5.
- Private function `Invoke-SetupAction` ([issue #1798](https://github.com/dsccommunity/SqlServerDsc/issues/1798)).
 - Was changed to support the SQL Server 2022 GA feature `AzureExtension`
   (that replaced the feature name `ARC`).
 - Support the setup argument `ProductCoveredBySA`.
 - No longer supports the argument `OnBoardSQLToARC` as it was removed in
   SQL Server 2022 GA.
- `Install-SqlDscServer`
 - Was changed to support the SQL Server 2022 GA feature `AzureExtension`
   (that replaced the feature name `ARC`) ([issue #1798](https://github.com/dsccommunity/SqlServerDsc/issues/1798)).
- `Uninstall-SqlDscServer`
 - Was changed to support the SQL Server 2022 GA feature `AzureExtension`
   (that replaced the feature name `ARC`) ([issue #1798](https://github.com/dsccommunity/SqlServerDsc/issues/1798)).

### Fixed

- SqlServerDsc
 - Localized strings file `en-US/SqlServerDsc.strings.psd1` no longer
   referencing the wrong module in a comment.
- SqlAGReplica
 - No longer tries to enforce EndpointHostName when it is not part of the
   configuration ([issue #1821](https://github.com/dsccommunity/SqlServerDsc/issues/1821)).
 - Now `Get-TargetResource` always returns values for the properties `Name`
   and `AvailabilityGroupName` ([issue #1822](https://github.com/dsccommunity/SqlServerDsc/issues/1822)).
 - Now `Test-TargetResource` no longer test properties that cannot
   be enforced ([issue #1822](https://github.com/dsccommunity/SqlServerDsc/issues/1822)).

FileList

Version History

Version Downloads Last updated
17.0.1-previ... 38 10/29/2024
17.0.1-previ... 6 10/26/2024
17.0.1-previ... 14 10/7/2024
17.0.0 61,297 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,159 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,869 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,512 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,137 5/6/2023
16.3.1-previ... 5 5/6/2023
16.3.1-previ... 9 5/4/2023
16.3.0 42,263 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,159 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,574 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... (current version) 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,668 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,717 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,394,588 2/12/2021
15.1.1-previ... 18 2/12/2021
15.1.0 62,465 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,559 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,439 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,776 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,844 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... 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,417 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,531 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,908 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,407 5/15/2019
12.4.0.0 21,748 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,286 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,234 5/2/2018
11.1.0.0 6,228 3/22/2018
11.0.0.0 13,548 2/8/2018
10.0.0.0 3,650 12/14/2017
Show less