xSQLServer

2.0.0.0

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

Minimum PowerShell version

4.0

Installation Options

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

Install-Module -Name xSQLServer -RequiredVersion 2.0.0.0

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deloy 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)

Microsoft Corporation

Copyright

(c) 2014 Microsoft Corporation. All rights reserved.

Owners

Tags

DesiredStateConfiguration DSC DSCResourceKit DSCResource

DSCResources

xSQLAlias xSQLAOGroupEnsure xSQLAOGroupJoin xSQLDatabaseRecoveryModel xSQLServerAlwaysOnService xSQLServerAvailabilityGroupListener xSQLServerConfiguration xSQLServerDatabase xSQLServerDatabaseOwner xSQLServerDatabasePermissions xSQLServerDatabaseRole xSQLServerEndpoint xSQLServerEndpointPermission xSQLServerEndpointState xSQLServerFailoverClusterSetup xSQLServerFirewall xSQLServerLogin xSQLServerMaxDop xSQLServerMemory xSQLServerNetwork xSQLServerPermission xSQLServerPowerPlan xSQLServerReplication xSQLServerRole xSQLServerRSConfig xSQLServerRSSecureConnectionLevel xSQLServerScript xSQLServerSetup xWaitForAvailabilityGroup

Dependencies

This module has no dependencies.

Release Notes

* Added resources
 - xSQLServerReplication
 - xSQLServerScript
 - xSQLAlias  
 - xSQLServerRole
* Added tests for resources
 - xSQLServerPermission
 - xSQLServerEndpointState
 - xSQLServerEndpointPermission
 - xSQLServerAvailabilityGroupListener
 - xSQLServerLogin
 - xSQLAOGroupEnsure
 - xSQLAlias
 - xSQLServerRole
* Fixes in xSQLServerAvailabilityGroupListener
 - In one case the Get-method did not report that DHCP was configured.
 - Now the resource will throw "Not supported" when IP is changed between Static and DHCP.
 - Fixed an issue where sometimes the listener wasn"t removed.
 - Fixed the issue when trying to add a static IP to a listener was ignored.
* Fix in xSQLServerDatabase
 - Fixed so dropping a database no longer throws an error
 - BREAKING CHANGE: Fixed an issue where it was not possible to add the same database to two instances on the same server.
 - BREAKING CHANGE: The name of the parameter Database has changed. It is now called Name.
* Fixes in xSQLAOGroupEnsure
 - Added parameters to New-ListenerADObject to allow usage of a named instance.
 - pass setup credential correctly
* Changes to xSQLServerLogin
  - Fixed an issue when dropping logins.
  - BREAKING CHANGE: Fixed an issue where it was not possible to add the same login to two instances on the same server.
* Changes to xSQLServerMaxDop
  - BREAKING CHANGE: Made SQLInstance parameter a key so that multiple instances on the same server can be configured

Version History

Version Downloads Last updated
9.1.0.0 28,355 1/24/2018
9.0.0.0 7,038 11/15/2017
8.2.0.0 5,023 10/5/2017
8.1.0.0 5,100 8/23/2017
8.0.0.0 4,964 7/12/2017
7.1.0.0 5,251 5/31/2017
7.0.0.0 8,170 4/19/2017
6.0.0.0 10,547 3/8/2017
5.0.0.0 2,522 1/26/2017
4.0.0.0 2,143 12/14/2016
3.0.0.0 1,761 11/2/2016
2.0.0.0 (current version) 7,091 9/21/2016
1.8.0.0 19,016 8/10/2016
1.7.0.0 2,171 6/29/2016
1.6.0.0 1,199 5/18/2016
1.5.0.0 986 3/31/2016
1.4.0.0 1,558 2/3/2016
1.3.0.0 2,147 5/2/2015
1.2.1.0 252 2/19/2015
1.2.0.0 53 12/18/2014
1.1.0.0 64 10/24/2014
Show less
.