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

Copy and Paste the following command to install this package using Microsoft.PowerShell.PSResourceGet More Info

Install-PSResource -Name xSQLServer -Version 1.6.0.0

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

Owners

Copyright

(c) 2014 Microsoft Corporation. All rights reserved.

Package Details

Author(s)

  • Microsoft Corporation

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

FileList

Version History

Version Downloads Last updated
9.1.0.0 271,401 1/24/2018
9.0.0.0 7,288 11/15/2017
8.2.0.0 5,486 10/5/2017
8.1.0.0 5,913 8/23/2017
8.0.0.0 5,763 7/12/2017
7.1.0.0 6,764 5/31/2017
7.0.0.0 8,220 4/19/2017
6.0.0.0 10,759 3/8/2017
5.0.0.0 2,549 1/26/2017
4.0.0.0 2,353 12/14/2016
3.0.0.0 1,928 11/2/2016
2.0.0.0 7,389 9/21/2016
1.8.0.0 28,381 8/10/2016
1.7.0.0 2,192 6/29/2016
1.6.0.0 (current version) 1,283 5/18/2016
1.5.0.0 1,007 3/31/2016
1.4.0.0 1,594 2/3/2016
1.3.0.0 2,168 5/2/2015
1.2.1.0 502 2/19/2015
1.2.0.0 76 12/18/2014
1.1.0.0 86 10/24/2014
Show less