xSQLServer

1.8.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 1.8.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

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

Dependencies

This module has no dependencies.

Release Notes

* Converted appveyor.yml to install Pester from PSGallery instead of from Chocolatey.
* Added Support for SQL Server 2016
* xSQLAOGroupEnsure
  - Fixed spelling mistake in AutoBackupPreference property
  - Added BackupPriority property
* Added resources
 - xSQLServerPermission
 - xSQLServerEndpointState
 - xSQLServerEndpointPermission
 - xSQLServerAvailabilityGroupListener
* xSQLServerHelper
 - added functions
 - Import-SQLPSModule
 - Get-SQLPSInstanceName
 - Get-SQLPSInstance
 - Get-SQLAlwaysOnEndpoint
   - modified functions
     - New-TerminatingError - *added optional parameter "InnerException" to be able to give the user more information in the returned message*

Version History

Version Downloads Last updated
9.1.0.0 28,339 1/24/2018
9.0.0.0 7,038 11/15/2017
8.2.0.0 5,021 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 7,091 9/21/2016
1.8.0.0 (current version) 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
.