SqlServerDsc

15.0.0-preview0004

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 15.0.0-preview0004 -AllowPrerelease

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

Install-PSResource -Name SqlServerDsc -Version 15.0.0-preview0004 -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 SqlDatabaseObjectPermission SqlDatabasePermission SqlDatabaseRecoveryModel SqlDatabaseRole SqlDatabaseUser SqlRS SqlRSSetup SqlScript SqlScriptQuery SqlConfiguration SqlDatabaseMail SqlEndpoint SqlEndpointPermission SqlServerEndpointState SqlLogin SqlMaxDop SqlMemory SqlServerNetwork SqlPermission SqlProtocol SqlProtocolTcpIp SqlReplication SqlRole SqlSecureConnection SqlServiceAccount SqlSetup SqlTraceFlag SqlWaitForAG SqlWindowsFirewall DSC_SqlAG DSC_SqlAGDatabase DSC_SqlAgentAlert DSC_SqlAgentFailsafe DSC_SqlAgentOperator DSC_SqlAGListener DSC_SqlAGReplica DSC_SqlAlias DSC_SqlAlwaysOnService DSC_SqlConfiguration DSC_SqlDatabase DSC_SqlDatabaseDefaultLocation DSC_SqlDatabaseMail DSC_SqlDatabaseObjectPermission DSC_SqlDatabasePermission DSC_SqlDatabaseRole DSC_SqlDatabaseUser DSC_SqlEndpoint DSC_SqlEndpointPermission DSC_SqlLogin DSC_SqlMaxDop DSC_SqlMemory DSC_SqlPermission DSC_SqlProtocol DSC_SqlProtocolTcpIp DSC_SqlReplication DSC_SqlRole DSC_SqlRS DSC_SqlRSSetup DSC_SqlScript DSC_SqlScriptQuery DSC_SqlSecureConnection DSC_SqlServiceAccount DSC_SqlSetup DSC_SqlTraceFlag DSC_SqlWaitForAG DSC_SqlWindowsFirewall MSFT_SqlDatabaseOwner MSFT_SqlDatabaseRecoveryModel MSFT_SqlServerEndpointState MSFT_SqlServerNetwork

Dependencies

This module has no dependencies.

Release Notes

## [15.0.0-preview0004] - 2020-12-06

### Added

- SqlServerDsc
 - Added new resource SqlTraceFlag to set or changes TraceFlags on SQL Server.
   This resource is based on @Zuldans code but with SqlServerDsc integrated SMO.
   Credits: https://github.com/Zuldan/cSQLServerTraceFlag
 - Added a lot of test scripts to validated the code.
- SqlEndpoint
 - Added support for the Service Broker Endpoint ([issue #498](https://github.com/dsccommunity/SqlServerDsc/issues/498)).
- SqlDatabaseRole
 - Added test to ensure Add-SqlDscDatabaseRoleMember throws the expected error
   ([issue #1620](https://github.com/dsccommunity/SqlServerDsc/issues/1620)).

### Changed

- SqlServerDsc
 - Updated code formatting using latest release of PSScriptAnalyzer.
 - The URLs in the CHANGELOG.md that was pointing to issues is now
   referencing the new repository name and URL.
- SqlServerDsc.Common
 - The helper function `Get-SqlInstanceMajorVersion` no longer have a default
   value for parameter **InstanceName** since the parameter is mandatory
   and it was never used.
- SqlReplication
 - The resource are now using the helper function `Get-SqlInstanceMajorVersion`
   ([issue #1408](https://github.com/dsccommunity/SqlServerDsc/issues/1408)).
- SqlRole
 - Major overhaul of resource.
 - BREAKING CHANGE: Removed decision making from get-TargetResource; this
   prevented a simple solution for issue #550. it now just tels if a role
   exists or not. And what members are in that role. MembersToInclude and
   MembersToExclude now always return $null.
 - Added sanitize function (`Get-CorrectedMemberParameters`) to make it
   so for the sysadmin role SA does not get altered ([issue #550](https://github.com/dsccommunity/SqlServerDsc/issues/550)).
 - Added lots of tests.
- SqlWaitForAG
 - BREAKING CHANGE: Fix for issue ([issue #1569](https://github.com/dsccommunity/SqlServerDsc/issues/1569))
   The resource now waits for the Availability Group to become Available.
 - Two parameters where added to test get and set resource at instance level.
- SqlSetup
 - Minor change to the evaluation of the parameter `BrowserSvcStartupType`,
   if it has an assigned a value or not.

### Fixed

- SqlDatabaseRole
 - Fixed check to see if the role and user existed in the database. The
   previous logic would always indicate the role or user was not found unless
   the role had the same name as the user. Also updated the
   DesiredMembersNotPresent string to be more accurate when an extra user is
   in the role ([issue #1487](https://github.com/dsccommunity/SqlServerDsc/issues/1487)).
- SqlAlwaysOnService
 - Updated Get-TargetResource to return all defined schema properties
   ([issue #150](https://github.com/dsccommunity/SqlServerDsc/issues/1501)).
- SqlSetup
 - Added a note to the documentation that the parameter `BrowserSvcStartupType`
   cannot be used for configurations that utilize the `'InstallFailoverCluster'`
   action ([issue #1627](https://github.com/dsccommunity/SqlServerDsc/issues/1627)).

FileList

Version History

Version Downloads Last updated
16.6.0-previ... 79 3/3/2024
16.6.0-previ... 45 1/20/2024
16.6.0-previ... 5 1/19/2024
16.5.1-previ... 67 12/15/2023
16.5.1-previ... 90 11/19/2023
16.5.1-previ... 46 11/2/2023
16.5.0 135,822 10/5/2023
16.5.0-previ... 11 10/1/2023
16.5.0-previ... 6 9/29/2023
16.5.0-previ... 46 9/1/2023
16.5.0-previ... 6 8/26/2023
16.4.1-previ... 5 8/25/2023
16.4.0 111,242 8/22/2023
16.4.0-previ... 4 8/20/2023
16.4.0-previ... 4 8/20/2023
16.4.0-previ... 5 8/19/2023
16.4.0-previ... 75 5/18/2023
16.4.0-previ... 19 5/10/2023
16.4.0-previ... 5 5/9/2023
16.4.0-previ... 6 5/8/2023
16.3.1 459,350 5/6/2023
16.3.1-previ... 4 5/6/2023
16.3.1-previ... 8 5/4/2023
16.3.0 42,103 4/26/2023
16.3.0-previ... 6 4/26/2023
16.3.0-previ... 5 4/25/2023
16.3.0-previ... 5 4/24/2023
16.3.0-previ... 5 4/23/2023
16.3.0-previ... 20 4/18/2023
16.3.0-previ... 4 4/16/2023
16.2.1-previ... 6 4/12/2023
16.2.0 74,991 4/10/2023
16.2.0-previ... 4 4/10/2023
16.2.0-previ... 4 4/8/2023
16.2.0-previ... 4 4/8/2023
16.2.0-previ... 9 4/6/2023
16.2.0-previ... 9 4/1/2023
16.2.0-previ... 10 3/28/2023
16.2.0-previ... 9 3/26/2023
16.2.0-previ... 4 3/25/2023
16.2.0-previ... 169 3/19/2023
16.2.0-previ... 26 3/7/2023
16.2.0-previ... 9 3/4/2023
16.1.0 175,458 2/28/2023
16.1.0-previ... 5 2/28/2023
16.1.0-previ... 8 2/25/2023
16.1.0-previ... 5 2/24/2023
16.1.0-previ... 47 2/13/2023
16.1.0-previ... 27 2/12/2023
16.1.0-previ... 24 2/5/2023
16.1.0-previ... 10 2/1/2023
16.1.0-previ... 28 1/25/2023
16.1.0-previ... 7 1/24/2023
16.1.0-previ... 4 1/24/2023
16.1.0-previ... 11 1/22/2023
16.1.0-previ... 345 1/4/2023
16.1.0-previ... 5 1/3/2023
16.1.0-previ... 14 12/26/2022
16.1.0-previ... 49 12/19/2022
16.1.0-previ... 12 12/17/2022
16.1.0-previ... 114 12/11/2022
16.1.0-previ... 12 12/4/2022
16.1.0-previ... 35 11/26/2022
16.1.0-previ... 10 11/24/2022
16.0.1-previ... 30 11/11/2022
16.0.0 826,605 9/9/2022
16.0.0-previ... 29 8/21/2022
16.0.0-previ... 23 8/13/2022
16.0.0-previ... 14 8/13/2022
16.0.0-previ... 25 8/1/2022
16.0.0-previ... 80 6/14/2022
16.0.0-previ... 24 6/8/2022
16.0.0-previ... 17 6/6/2022
16.0.0-previ... 14 6/6/2022
16.0.0-previ... 88 4/26/2022
16.0.0-previ... 44 3/28/2022
16.0.0-previ... 65 2/12/2022
15.2.0 2,683,602 9/1/2021
15.2.0-previ... 15 9/1/2021
15.2.0-previ... 44 7/23/2021
15.2.0-previ... 75 6/6/2021
15.2.0-previ... 65 4/18/2021
15.2.0-previ... 85 3/12/2021
15.1.1 1,379,378 2/12/2021
15.1.1-previ... 17 2/12/2021
15.1.0 62,280 2/2/2021
15.1.0-previ... 24 2/1/2021
15.1.0-previ... 19 1/31/2021
15.0.2-previ... 18 1/30/2021
15.0.2-previ... 24 1/24/2021
15.0.2-previ... 62 1/21/2021
15.0.2-previ... 61 1/12/2021
15.0.1 143,029 1/9/2021
15.0.1-previ... 58 1/9/2021
15.0.1-previ... 63 1/6/2021
15.0.1-previ... 59 1/6/2021
15.0.1-previ... 68 12/27/2020
15.0.1-previ... 59 12/26/2020
15.0.1-previ... 62 12/23/2020
15.0.1-previ... 70 12/14/2020
15.0.1-previ... 61 12/13/2020
15.0.1-previ... 59 12/12/2020
15.0.1-previ... 60 12/10/2020
15.0.0 213,999 12/6/2020
15.0.0-previ... (current version) 60 12/6/2020
15.0.0-previ... 65 11/25/2020
15.0.0-previ... 57 11/22/2020
15.0.0-previ... 61 11/21/2020
14.3.0-previ... 98 10/5/2020
14.3.0-previ... 54 10/3/2020
14.3.0-previ... 60 10/2/2020
14.2.2-previ... 104 8/19/2020
14.2.2-previ... 60 8/16/2020
14.2.1 639,701 8/14/2020
14.2.1-previ... 59 8/13/2020
14.2.1-previ... 60 8/11/2020
14.2.1-previ... 56 8/11/2020
14.2.1-previ... 71 7/31/2020
14.2.1-previ... 59 7/28/2020
14.2.0 72,555 7/23/2020
14.2.0-previ... 62 7/23/2020
14.2.0-previ... 64 7/19/2020
14.2.0-previ... 73 7/13/2020
14.2.0-previ... 64 7/10/2020
14.2.0-previ... 61 7/9/2020
14.1.1-previ... 63 7/9/2020
14.1.0 217,110 7/6/2020
14.1.0-previ... 367 7/5/2020
14.1.0-previ... 60 7/4/2020
14.1.0-previ... 61 7/4/2020
14.1.0-previ... 63 7/3/2020
14.1.0-previ... 65 7/1/2020
14.0.1-previ... 71 6/28/2020
14.0.1-previ... 60 6/26/2020
14.0.0 10,834 6/12/2020
14.0.0-previ... 61 6/12/2020
14.0.0-previ... 67 6/11/2020
14.0.0-previ... 69 6/10/2020
14.0.0-previ... 68 6/10/2020
14.0.0-previ... 102 5/28/2020
14.0.0-previ... 77 5/25/2020
14.0.0-previ... 67 5/25/2020
14.0.0-previ... 79 5/19/2020
14.0.0-previ... 75 5/19/2020
14.0.0-previ... 81 5/17/2020
14.0.0-previ... 70 5/17/2020
14.0.0-previ... 68 5/16/2020
14.0.0-previ... 69 5/14/2020
14.0.0-previ... 71 5/13/2020
14.0.0-previ... 79 5/12/2020
14.0.0-previ... 69 5/12/2020
14.0.0-previ... 69 5/12/2020
14.0.0-previ... 82 5/8/2020
14.0.0-previ... 68 5/6/2020
14.0.0-previ... 72 5/5/2020
14.0.0-previ... 70 5/4/2020
14.0.0-previ... 69 5/3/2020
14.0.0-previ... 68 5/3/2020
14.0.0-previ... 83 4/27/2020
14.0.0-previ... 78 4/26/2020
13.5.0 28,261 4/12/2020
13.5.0-previ... 75 4/11/2020
13.5.0-previ... 77 4/11/2020
13.4.1-previ... 104 3/31/2020
13.4.0 122,342 3/18/2020
13.4.0-previ... 70 3/18/2020
13.3.1-previ... 116 1/18/2020
13.3.0 480,197 1/17/2020
13.3.0-previ... 73 1/17/2020
13.3.0-previ... 78 1/12/2020
13.3.0-previ... 72 1/8/2020
13.3.0-previ... 75 1/7/2020
13.3.0-previ... 72 1/3/2020
13.3.0-previ... 73 1/2/2020
13.3.0-previ... 74 1/2/2020
13.2.0.0 860,543 9/19/2019
13.1.0.0 34,990 8/8/2019
13.0.0.0 26,018 6/26/2019
12.5.0.0 17,354 5/15/2019
12.4.0.0 21,698 4/3/2019
12.3.0.0 40,221 2/20/2019
12.2.0.0 8,926 1/10/2019
12.1.0.0 23,219 10/25/2018
12.0.0.0 21,421 9/5/2018
11.4.0.0 16,150 7/25/2018
11.3.0.0 7,377 6/13/2018
11.2.0.0 5,034 5/2/2018
11.1.0.0 6,197 3/22/2018
11.0.0.0 12,851 2/8/2018
10.0.0.0 3,648 12/14/2017
Show less