xSQLServer

1.6.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.6.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 xSQLServerDatabase xSQLServerDatabaseOwner xSQLServerDatabasePermissions xSQLServerDatabaseRole xSQLServerEndpoint xSQLServerFailoverClusterSetup xSQLServerFirewall xSQLServerLogin xSQLServerMaxDop xSQLServerMemory xSQLServerNetwork xSQLServerPowerPlan xSQLServerRSConfig xSQLServerRSSecureConnectionLevel xSQLServerSetup xWaitForAvailabilityGroup

Dependencies

This module has no dependencies.

Release Notes

* Resources Added
 - xSQLAOGroupEnsure
 - xSQLAOGroupJoin
 - xWaitForAvailabilityGroup
 - xSQLServerEndPoint
 - xSQLServerAlwaysOnService
* xSQLServerHelper
   - added functions
       - Connect-SQL
       - New-VerboseMessage
       - Grant-ServerPerms
       - Grant-CNOPerms
       - New-ListenerADObject
* xSQLDatabaseRecoveryModel
   - Updated Verbose statements to use new function New-VerboseMessage
* xSQLServerDatabase
   - Updated Verbose statements to use new function New-VerboseMessage
   - Removed ConnectSQL function and replaced with new Connect-SQL function
* xSQLServerDatabaseOwner
   - Removed ConnectSQL function and replaced with new Connect-SQL function
* xSQLServerDatabasePermissions
   - Removed ConnectSQL function and replaced with new Connect-SQL function
* xSQLServerDatabaseRole
   - Removed ConnectSQL function and replaced with new Connect-SQL function
* xSQLServerLogin
   - Removed ConnectSQL function and replaced with new Connect-SQL function
* xSQLServerMaxDop
   - Updated Verbose statements to use new function New-VerboseMessage
   - Removed ConnectSQL function and replaced with new Connect-SQL function
* xSQLServerMemory
   - Updated Verbose statements to use new function New-VerboseMessage
   - Removed ConnectSQL function and replaced with new Connect-SQL function
* xSQLServerPowerPlan
   - Updated Verbose statements to use new function New-VerboseMessage

Version History

Version Downloads Last updated
9.1.0.0 28,258 1/24/2018
9.0.0.0 7,038 11/15/2017
8.2.0.0 5,014 10/5/2017
8.1.0.0 5,098 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,141 12/14/2016
3.0.0.0 1,760 11/2/2016
2.0.0.0 7,091 9/21/2016
1.8.0.0 18,991 8/10/2016
1.7.0.0 2,171 6/29/2016
1.6.0.0 (current version) 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
.