SqlServerDsc

15.2.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.2.0-preview0004 -AllowPrerelease

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

Author(s)

DSC Community

Copyright

Copyright the DSC Community contributors. All rights reserved.

Owners

Tags

DesiredStateConfiguration DSC DSCResourceKit DSCResource

DSCResources

SqlAG SqlAGDatabase SqlAgentAlert SqlAgentFailsafe SqlAgentOperator SqlAGListener SqlAGReplica SqlAlias SqlAlwaysOnService SqlConfiguration SqlDatabase SqlDatabaseDefaultLocation SqlDatabaseMail SqlDatabaseObjectPermission SqlDatabasePermission SqlDatabaseRole SqlDatabaseUser SqlEndpoint SqlEndpointPermission SqlLogin SqlMaxDop SqlMemory SqlPermission SqlProtocol SqlProtocolTcpIp SqlReplication SqlRole SqlRS SqlRSSetup SqlScript SqlScriptQuery SqlSecureConnection SqlServiceAccount SqlSetup SqlTraceFlag SqlWaitForAG SqlWindowsFirewall SqlDatabaseOwner SqlDatabaseRecoveryModel SqlServerEndpointState SqlServerNetwork

Dependencies

This module has no dependencies.

Release Notes

## [15.2.0-preview0004] - 2021-07-23

### Changed

- SqlServerDsc
 - Changed to the new GitHub deploy tasks that is required for the latest
   version of the Sampler module.
 - Updated pipeline configuration to align with the latest changes in [Sampler](https://github.com/gaelcolas/Sampler).
 - Update codecov.yml to support carry forward flags.
- SqlSetup
 - The helper function `Connect-SqlAnalysis` was using `LoadWithPartial()`
   to load the assembly _Microsoft.AnalysisServices_. On a node where multiple
   instances with different versions of SQL Server (regardless of features)
   is installed, this will result in the first assembly found in the
   GAC will be loaded into the session, not taking versions into account.
   This can result in an assembly version being loaded that is not compatible
   with the version of SQL Server it was meant to be used with.
   A new method of loading the assembly _Microsoft.AnalysisServices_ was
   introduced under a feature flag; `'AnalysisServicesConnection'`.
   This new functionality depends on the [SqlServer](https://www.powershellgallery.com/packages/SqlServer)
   module, and must be present on the node. The [SqlServer](https://www.powershellgallery.com/packages/SqlServer)
   module can be installed on the node by leveraging the new DSC resource
   `PSModule` in the [PowerShellGet](https://www.powershellgallery.com/packages/PowerShellGet/2.1.2)
   module (v2.1.2 and higher). This new method does not work with the
   SQLPS module due to the SQLPS module does not load the correct assembly,
   while [SqlServer](https://www.powershellgallery.com/packages/SqlServer)
   module (v21.1.18080 and above) does. The new functionality is used
   when the parameter `FeatureFlag` is set to `'AnalysisServicesConnection'`.
   This functionality will be the default in a future breaking release.
 - Under a feature flag `'AnalysisServicesConnection'`. The detection of
   a successful connection to the SQL Server Analysis Services has also been
   changed. Now it actually evaluates the property `Connected` of the returned
   `Microsoft.AnalysisServices.Server` object. The new functionality is used
   when the parameter `FeatureFlag` is set to `'AnalysisServicesConnection'`.
   This functionality will be the default in a future breaking release.
- SqlAgentAlert
 - Switched README file with SqlAgentFailsafe. [Issue #1709](https://github.com/dsccommunity/SqlServerDsc/issues/1397).
- SqlAgentFailsafe
 - Switched README file with SqlAgentAlert. [Issue #1709](https://github.com/dsccommunity/SqlServerDsc/issues/1397).

### Added

- SqlMemory
 - Added two new optional parameters MinMemoryPercent and MaxMemoryPercent.
   Provides the ability to set the minimum and/or maximum buffer pool used by
   the SQL Server instance as a percentage of total server memory.
   ([issue #1397](https://github.com/dsccommunity/SqlServerDsc/issues/1397)).

### Fixed

- SqlSetup
 - Fixed integration tests for SQL Server 2016 and SQL Server 2017.

Version History

Version Downloads Last updated
15.2.0 140,752 9/1/2021
15.2.0-previ... 2 9/1/2021
15.2.0-previ... (current version) 31 7/23/2021
15.2.0-previ... 62 6/6/2021
15.2.0-previ... 52 4/18/2021
15.2.0-previ... 72 3/12/2021
15.1.1 1,349,471 2/12/2021
15.1.1-previ... 4 2/12/2021
15.1.0 59,878 2/2/2021
15.1.0-previ... 11 2/1/2021
15.1.0-previ... 6 1/31/2021
15.0.2-previ... 5 1/30/2021
15.0.2-previ... 11 1/24/2021
15.0.2-previ... 8 1/21/2021
15.0.2-previ... 7 1/12/2021
15.0.1 142,191 1/9/2021
15.0.1-previ... 5 1/9/2021
15.0.1-previ... 8 1/6/2021
15.0.1-previ... 5 1/6/2021
15.0.1-previ... 13 12/27/2020
15.0.1-previ... 6 12/26/2020
15.0.1-previ... 6 12/23/2020
15.0.1-previ... 16 12/14/2020
15.0.1-previ... 5 12/13/2020
15.0.1-previ... 5 12/12/2020
15.0.1-previ... 5 12/10/2020
15.0.0 205,639 12/6/2020
15.0.0-previ... 5 12/6/2020
15.0.0-previ... 11 11/25/2020
15.0.0-previ... 5 11/22/2020
15.0.0-previ... 5 11/21/2020
14.3.0-previ... 43 10/5/2020
14.3.0-previ... 1 10/3/2020
14.3.0-previ... 1 10/2/2020
14.2.2-previ... 51 8/19/2020
14.2.2-previ... 4 8/16/2020
14.2.1 626,722 8/14/2020
14.2.1-previ... 4 8/13/2020
14.2.1-previ... 6 8/11/2020
14.2.1-previ... 4 8/11/2020
14.2.1-previ... 14 7/31/2020
14.2.1-previ... 3 7/28/2020
14.2.0 71,764 7/23/2020
14.2.0-previ... 5 7/23/2020
14.2.0-previ... 5 7/19/2020
14.2.0-previ... 11 7/13/2020
14.2.0-previ... 6 7/10/2020
14.2.0-previ... 5 7/9/2020
14.1.1-previ... 3 7/9/2020
14.1.0 112,423 7/6/2020
14.1.0-previ... 105 7/5/2020
14.1.0-previ... 3 7/4/2020
14.1.0-previ... 3 7/4/2020
14.1.0-previ... 3 7/3/2020
14.1.0-previ... 6 7/1/2020
14.0.1-previ... 12 6/28/2020
14.0.1-previ... 4 6/26/2020
14.0.0 10,290 6/12/2020
14.0.0-previ... 5 6/12/2020
14.0.0-previ... 9 6/11/2020
14.0.0-previ... 8 6/10/2020
14.0.0-previ... 8 6/10/2020
14.0.0-previ... 43 5/28/2020
14.0.0-previ... 21 5/25/2020
14.0.0-previ... 3 5/25/2020
14.0.0-previ... 15 5/19/2020
14.0.0-previ... 11 5/19/2020
14.0.0-previ... 18 5/17/2020
14.0.0-previ... 4 5/17/2020
14.0.0-previ... 3 5/16/2020
14.0.0-previ... 4 5/14/2020
14.0.0-previ... 6 5/13/2020
14.0.0-previ... 11 5/12/2020
14.0.0-previ... 3 5/12/2020
14.0.0-previ... 3 5/12/2020
14.0.0-previ... 17 5/8/2020
14.0.0-previ... 3 5/6/2020
14.0.0-previ... 5 5/5/2020
14.0.0-previ... 5 5/4/2020
14.0.0-previ... 4 5/3/2020
14.0.0-previ... 3 5/3/2020
14.0.0-previ... 18 4/27/2020
14.0.0-previ... 10 4/26/2020
13.5.0 27,009 4/12/2020
13.5.0-previ... 9 4/11/2020
13.5.0-previ... 11 4/11/2020
13.4.1-previ... 37 3/31/2020
13.4.0 122,108 3/18/2020
13.4.0-previ... 5 3/18/2020
13.3.1-previ... 52 1/18/2020
13.3.0 471,669 1/17/2020
13.3.0-previ... 5 1/17/2020
13.3.0-previ... 12 1/12/2020
13.3.0-previ... 6 1/8/2020
13.3.0-previ... 9 1/7/2020
13.3.0-previ... 5 1/3/2020
13.3.0-previ... 5 1/2/2020
13.3.0-previ... 7 1/2/2020
13.2.0.0 789,135 9/19/2019
13.1.0.0 34,586 8/8/2019
13.0.0.0 25,909 6/26/2019
12.5.0.0 16,526 5/15/2019
12.4.0.0 21,427 4/3/2019
12.3.0.0 39,860 2/20/2019
12.2.0.0 8,599 1/10/2019
12.1.0.0 22,839 10/25/2018
12.0.0.0 21,285 9/5/2018
11.4.0.0 16,060 7/25/2018
11.3.0.0 7,224 6/13/2018
11.2.0.0 3,948 5/2/2018
11.1.0.0 5,945 3/22/2018
11.0.0.0 9,194 2/8/2018
10.0.0.0 3,552 12/14/2017