xSQLServer

8.1.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 8.1.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 xSQLServerDatabaseOwner xSQLServerDatabasePermission xSQLServerDatabaseRecoveryModel xSQLServerDatabaseRole xSQLServerEndpoint xSQLServerEndpointPermission xSQLServerEndpointState xSQLServerFirewall xSQLServerLogin xSQLServerMaxDop xSQLServerMemory xSQLServerNetwork xSQLServerPermission xSQLServerReplication xSQLServerRole xSQLServerRSConfig xSQLServerRSSecureConnectionLevel xSQLServerScript xSQLServerSetup xWaitForAvailabilityGroup

Dependencies

This module has no dependencies.

Release Notes

- Changes to xSQLServer
 - Added back .markdownlint.json so that lint rule MD013 is enforced.
 - Change the module to use the image "Visual Studio 2017" as the build worker
   image for AppVeyor (issue 685).
 - Minor style change in CommonResourceHelper. Added missing [Parameter()] on
   three parameters.
 - Minor style changes to the unit tests for CommonResourceHelper.
 - Changes to xSQLServerHelper
   - Added Swedish localization ([issue 695](https://github.com/PowerShell/xSQLServer/issues/695)).
 - Opt-in for module files common tests ([issue 702](https://github.com/PowerShell/xFailOverCluster/issues/702)).
   - Removed Byte Order Mark (BOM) from the files; CommonResourceHelper.psm1,
     MSFT\_xSQLServerAvailabilityGroupListener.psm1, MSFT\_xSQLServerConfiguration.psm1,
     MSFT\_xSQLServerEndpointPermission.psm1, MSFT\_xSQLServerEndpointState.psm1,
     MSFT\_xSQLServerNetwork.psm1, MSFT\_xSQLServerPermission.psm1,
     MSFT\_xSQLServerReplication.psm1, MSFT\_xSQLServerScript.psm1,
     SQLPSStub.psm1, SQLServerStub.psm1.
 - Opt-in for script files common tests ([issue 707](https://github.com/PowerShell/xFailOverCluster/issues/707)).
   - Removed Byte Order Mark (BOM) from the files; DSCClusterSqlBuild.ps1,
     DSCFCISqlBuild.ps1, DSCSqlBuild.ps1, DSCSQLBuildEncrypted.ps1,
     SQLPush_SingleServer.ps1, 1-AddAvailabilityGroupListenerWithSameNameAsVCO.ps1,
     2-AddAvailabilityGroupListenerWithDifferentNameAsVCO.ps1,
     3-RemoveAvailabilityGroupListenerWithSameNameAsVCO.ps1,
     4-RemoveAvailabilityGroupListenerWithDifferentNameAsVCO.ps1,
     5-AddAvailabilityGroupListenerUsingDHCPWithDefaultServerSubnet.ps1,
     6-AddAvailabilityGroupListenerUsingDHCPWithSpecificSubnet.ps1,
     2-ConfigureInstanceToEnablePriorityBoost.ps1, 1-CreateEndpointWithDefaultValues.ps1,
     2-CreateEndpointWithSpecificPortAndIPAddress.ps1, 3-RemoveEndpoint.ps1,
     1-AddConnectPermission.ps1, 2-RemoveConnectPermission.ps1,
     3-AddConnectPermissionToAlwaysOnPrimaryAndSecondaryReplicaEachWithDifferentSqlServiceAccounts.ps1,
     4-RemoveConnectPermissionToAlwaysOnPrimaryAndSecondaryReplicaEachWithDifferentSqlServiceAccounts.ps1,
     1-MakeSureEndpointIsStarted.ps1, 2-MakeSureEndpointIsStopped.ps1,
     1-EnableTcpIpWithStaticPort.ps1, 2-EnableTcpIpWithDynamicPort.ps1,
     1-AddServerPermissionForLogin.ps1, 2-RemoveServerPermissionForLogin.ps1,
     1-ConfigureInstanceAsDistributor.ps1, 2-ConfigureInstanceAsPublisher.ps1,
     1-WaitForASingleClusterGroup.ps1, 2-WaitForMultipleClusterGroups.ps1.
 - Updated year to 2017 in license file ([issue 711](https://github.com/PowerShell/xFailOverCluster/issues/711)).
 - Code style clean-up throughout the module to align against the Style Guideline.
 - Fixed typos and the use of wrong parameters in unit tests which was found
   after release of new version of Pester ([issue 773](https://github.com/PowerShell/xFailOverCluster/issues/773)).
- Changes to xSQLServerAlwaysOnService
 - Added resource description in README.md.
 - Updated parameters descriptions in comment-based help, schema.mof and README.md.
 - Changed the datatype of the parameter to Uint32 so the same datatype is used
   in both the Get-/Test-/Set-TargetResource functions as in the schema.mof
   (issue 688).
 - Added read-only property IsHadrEnabled to schema.mof and the README.md
   (issue 687).
 - Minor cleanup of code.
 - Added examples (issue 633)
   - 1-EnableAlwaysOn.ps1
   - 2-DisableAlwaysOn.ps1
 - Fixed PS Script Analyzer errors ([issue 724](https://github.com/PowerShell/xSQLServer/issues/724))
 - Casting the result of the property IsHadrEnabled to [System.Boolean] so that
   $null is never returned, which resulted in an exception ([issue 763](https://github.com/PowerShell/xFailOverCluster/issues/763)).
- Changes to xSQLServerDatabasePermission
 - Fixed PS Script Analyzer errors ([issue 725](https://github.com/PowerShell/xSQLServer/issues/725))
- Changes to xSQLServerScript
 - Fixed PS Script Analyzer errors ([issue 728](https://github.com/PowerShell/xSQLServer/issues/728))
- Changes to xSQLServerSetup
 - Added Swedish localization ([issue 695](https://github.com/PowerShell/xSQLServer/issues/695)).
 - Now Get-TargetResource correctly returns an array for property ASSysAdminAccounts,
   and no longer throws an error when there is just one Analysis Services
   administrator (issue 691).
 - Added a simple integration test ([issue 709](https://github.com/PowerShell/xSQLServer/issues/709)).
 - Fixed PS Script Analyzer errors ([issue 729](https://github.com/PowerShell/xSQLServer/issues/729))

Version History

Version Downloads Last updated
9.1.0.0 28,101 1/24/2018
9.0.0.0 7,036 11/15/2017
8.2.0.0 5,006 10/5/2017
8.1.0.0 (current version) 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
.