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

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

Install-PSResource -Name xSQLServer -Version 1.8.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 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*

FileList

Version History

Version Downloads Last updated
9.1.0.0 268,296 1/24/2018
9.0.0.0 7,288 11/15/2017
8.2.0.0 5,485 10/5/2017
8.1.0.0 5,912 8/23/2017
8.0.0.0 5,760 7/12/2017
7.1.0.0 6,759 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 (current version) 28,377 8/10/2016
1.7.0.0 2,192 6/29/2016
1.6.0.0 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