xSQLServer

9.0.0.0

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

Minimum PowerShell version

5.0

Installation Options

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

Install-Module -Name xSQLServer -RequiredVersion 9.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) 2017 Microsoft Corporation. All rights reserved.

Owners

Tags

DesiredStateConfiguration DSC DSCResourceKit DSCResource

DSCResources

xSQLServerAlias xSQLServerAlwaysOnAvailabilityGroup xSQLServerAlwaysOnAvailabilityGroupDatabaseMembership xSQLServerAlwaysOnAvailabilityGroupReplica xSQLServerAlwaysOnService xSQLServerAvailabilityGroupListener xSQLServerConfiguration xSQLServerDatabase xSQLServerDatabaseDefaultLocation xSQLServerDatabaseOwner xSQLServerDatabasePermission xSQLServerDatabaseRecoveryModel xSQLServerDatabaseRole xSQLServerEndpoint xSQLServerEndpointPermission xSQLServerEndpointState xSQLServerFirewall xSQLServerLogin xSQLServerMaxDop xSQLServerMemory xSQLServerNetwork xSQLServerPermission xSQLServerReplication xSQLServerRole xSQLServerRSConfig xSQLServerRSSecureConnectionLevel xSQLServerScript xSQLServerServiceAccount xSQLServerSetup xWaitForAvailabilityGroup

Dependencies

This module has no dependencies.

Release Notes

- Changes to xSQLServer
 - Updated Pester syntax to v4
 - Fixes broken links to issues in the CHANGELOG.md.
- Changes to xSQLServerDatabase
 - Added parameter to specify collation for a database to be different from server
   collation ([issue 767](https://github.com/PowerShell/xSQLServer/issues/767)).
 - Fixed unit tests for Get-TargetResource to ensure correctly testing return
   values ([issue 849](https://github.com/PowerShell/xSQLServer/issues/849))
- Changes to xSQLServerAlwaysOnAvailabilityGroup
 - Refactored the unit tests to allow them to be more user friendly and to test
   additional SQLServer variations.
   - Each test will utilize the Import-SQLModuleStub to ensure the correct
     module is loaded ([issue 784](https://github.com/PowerShell/xSQLServer/issues/784)).
 - Fixed an issue when setting the SQLServer parameter to a Fully Qualified
   Domain Name (FQDN) ([issue 468](https://github.com/PowerShell/xSQLServer/issues/468)).
 - Fixed the logic so that if a parameter is not supplied to the resource, the
   resource will not attempt to apply the defaults on subsequent checks
   ([issue 517](https://github.com/PowerShell/xSQLServer/issues/517)).
 - Made the resource cluster aware. When ProcessOnlyOnActiveNode is specified,
   the resource will only determine if a change is needed if the target node
   is the active host of the SQL Server instance ([issue 868](https://github.com/PowerShell/xSQLServer/issues/868)).
- Changes to xSQLServerAlwaysOnAvailabilityGroupDatabaseMembership
 - Made the resource cluster aware. When ProcessOnlyOnActiveNode is specified,
   the resource will only determine if a change is needed if the target node
   is the active host of the SQL Server instance ([issue 869](https://github.com/PowerShell/xSQLServer/issues/869)).
- Changes to xSQLServerAlwaysOnAvailabilityGroupReplica
 - Made the resource cluster aware. When ProcessOnlyOnActiveNode is specified,
   the resource will only determine if a change is needed if the target node is
   the active host of the SQL Server instance ([issue 870](https://github.com/PowerShell/xSQLServer/issues/870)).
- Added the CommonTestHelper.psm1 to store common testing functions.
 - Added the Import-SQLModuleStub function to ensure the correct version of the
   module stubs are loaded ([issue 784](https://github.com/PowerShell/xSQLServer/issues/784)).
- Changes to xSQLServerMemory
 - Made the resource cluster aware. When ProcessOnlyOnActiveNode is specified,
   the resource will only determine if a change is needed if the target node
   is the active host of the SQL Server instance ([issue 867](https://github.com/PowerShell/xSQLServer/issues/867)).
- Changes to xSQLServerNetwork
 - BREAKING CHANGE: Renamed parameter TcpDynamicPorts to TcpDynamicPort and
   changed type to Boolean ([issue 534](https://github.com/PowerShell/xSQLServer/issues/534)).
 - Resolved issue when switching from dynamic to static port.
   configuration ([issue 534](https://github.com/PowerShell/xSQLServer/issues/534)).
 - Added localization (en-US) for all strings in resource and unit tests
   ([issue 618](https://github.com/PowerShell/xSQLServer/issues/618)).
 - Updated examples to reflect new parameters.
- Changes to xSQLServerRSConfig
 - Added examples
- Added resource
 - xSQLServerDatabaseDefaultLocation
   ([issue 656](https://github.com/PowerShell/xSQLServer/issues/656))
- Changes to xSQLServerEndpointPermission
 - Fixed a problem when running the tests locally in a PowerShell console it
   would ask for parameters ([issue 897](https://github.com/PowerShell/xSQLServer/issues/897)).
- Changes to xSQLServerAvailabilityGroupListener
 - Fixed a problem when running the tests locally in a PowerShell console it
   would ask for parameters ([issue 897](https://github.com/PowerShell/xSQLServer/issues/897)).
- Changes to xSQLServerMaxDop
 - Made the resource cluster aware. When ProcessOnlyOnActiveNode is specified,
   the resource will only determine if a change is needed if the target node
   is the active host of the SQL Server instance ([issue 882](https://github.com/PowerShell/xSQLServer/issues/882)).

Version History

Version Downloads Last updated
9.1.0.0 28,101 1/24/2018
9.0.0.0 (current version) 7,036 11/15/2017
8.2.0.0 5,006 10/5/2017
8.1.0.0 5,097 8/23/2017
8.0.0.0 4,964 7/12/2017
7.1.0.0 5,240 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,139 12/14/2016
3.0.0.0 1,759 11/2/2016
2.0.0.0 7,072 9/21/2016
1.8.0.0 18,890 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,557 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
.