xSQLServer

7.1.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 7.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) 2014 Microsoft Corporation. All rights reserved.

Owners

Tags

DesiredStateConfiguration DSC DSCResourceKit DSCResource

DSCResources

xSQLAOGroupEnsure xSQLAOGroupJoin xSQLServerAlias xSQLServerAlwaysOnAvailabilityGroup xSQLServerAlwaysOnAvailabilityGroupReplica xSQLServerAlwaysOnService xSQLServerAvailabilityGroupListener xSQLServerConfiguration xSQLServerDatabase xSQLServerDatabaseOwner xSQLServerDatabasePermission xSQLServerDatabaseRecoveryModel xSQLServerDatabaseRole xSQLServerEndpoint xSQLServerEndpointPermission xSQLServerEndpointState xSQLServerFailoverClusterSetup xSQLServerFirewall xSQLServerLogin xSQLServerMaxDop xSQLServerMemory xSQLServerNetwork xSQLServerPermission xSQLServerReplication xSQLServerRole xSQLServerRSConfig xSQLServerRSSecureConnectionLevel xSQLServerScript xSQLServerSetup xWaitForAvailabilityGroup

Dependencies

This module has no dependencies.

Release Notes

- Changes to xSQLServerMemory
 - Changed the way SQLServer parameter is passed from Test-TargetResource to Get-TargetResource so that the default value isn"t lost (issue 576).
 - Added condition to unit tests for when no SQLServer parameter is set.
- Changes to xSQLServerMaxDop
 - Changed the way SQLServer parameter is passed from Test-TargetResource to Get-TargetResource so that the default value isn"t lost (issue 576).
 - Added condition to unit tests for when no SQLServer parameter is set.
- Changes to xWaitForAvailabilityGroup
 - Updated README.md with a description for the resources and revised the parameter descriptions.
 - The default value for RetryIntervalSec is now 20 seconds and the default value for RetryCount is now 30 times (issue 505).
 - Cleaned up code and fixed PSSA rules warnings (issue 268).
 - Added unit tests (issue 297).
 - Added descriptive text to README.md that the account that runs the resource must have permission to run the cmdlet Get-ClusterGroup (issue 307).
 - Added read-only parameter GroupExist which will return $true if the cluster role/group exist, otherwise it returns $false (issue 510).
 - Added examples.
- Changes to xSQLServerPermission
 - Cleaned up code, removed SupportsShouldProcess and fixed PSSA rules warnings (issue 241 and issue 262).
 - It is now possible to add permissions to two or more logins on the same instance (issue 526).
 - The parameter NodeName is no longer mandatory and has now the default value of $env:COMPUTERNAME.
 - The parameter Ensure now has a default value of "Present".
 - Updated README.md with a description for the resources and revised the parameter descriptions.
 - Removed dependency of SQLPS provider (issue 482).
 - Added ConnectSql permission. Now that permission can also be granted or revoked.
 - Updated note in resource description to also mention ConnectSql permission.
- Changes to xSQLServerHelper module
 - Removed helper function Get-SQLPSInstance and Get-SQLPSInstanceName because there is no resource using it any longer.
 - Added four new helper functions.
   - Register-SqlSmo, Register-SqlWmiManagement and Unregister-SqlAssemblies to handle the creation on the application domain and loading and unloading of the SMO and SqlWmiManagement assemblies.
   - Get-SqlInstanceMajorVersion to get the major SQL version for a specific instance.
 - Fixed typos in comment-based help
- Changes to xSQLServer
 - Fixed typos in markdown files; CHANGELOG, CONTRIBUTING, README and ISSUE_TEMPLATE.
 - Fixed typos in schema.mof files (and README.md).
 - Updated some parameter description in schema.mof files on those that was found was not equal to README.md.
- Changes to xSQLServerAlwaysOnService
 - Get-TargetResource should no longer fail silently with error "Index operation failed; the array index evaluated to null." (issue 519). Now if the Server.IsHadrEnabled property return neither $true or $false the Get-TargetResource function will throw an error.
- Changes to xSQLServerSetUp
 - Updated xSQLServerSetup Module Get-Resource method to fix (issue 516 and 490).
 - Added change to detect DQ, DQC, BOL, SDK features. Now the function Test-TargetResource returns true after calling set for DQ, DQC, BOL, SDK features (issue 516 and 490).
- Changes to xSQLServerAlwaysOnAvailabilityGroup
 - Updated to return the exception raised when an error is thrown.
- Changes to xSQLServerAlwaysOnAvailabilityGroupReplica
 - Updated to return the exception raised when an error is thrown.
 - Updated parameter description for parameter Name, so that it says it must be in the format SQLServer\InstanceName for named instance (issue 548).
- Changes to xSQLServerLogin
 - Added an optional boolean parameter Disabled. It can be used to enable/disable existing logins or create disabled logins (new logins are created as enabled by default).
- Changes to xSQLServerDatabaseRole
 - Updated variable passed to Microsoft.SqlServer.Management.Smo.User constructor to fix issue 530
- Changes to xSQLServerNetwork
 - Added optional parameter SQLServer with default value of $env:COMPUTERNAME (issue 528).
 - Added optional parameter RestartTimeout with default value of 120 seconds.
 - Now the resource supports restarting a sql server in a cluster (issue 527 and issue 455).
 - Now the resource allows to set the parameter TcpDynamicPorts to a blank value (partly fixes issue 534). Setting a blank value for parameter TcpDynamicPorts together with a value for parameter TcpPort means that static port will be used.
 - Now the resource will not call Alter() in the Set-TargetResource when there is no change necessary (issue 537).
 - Updated example 1-EnableTcpIpOnCustomStaticPort.
 - Added unit tests (issue 294).
 - Refactored some of the code, cleaned up the rest and fixed PSSA rules warnings (issue 261).
 - If parameter TcpDynamicPort is set to "0" at the same time as TcpPort is set the resource will now throw an error (issue 535).
 - Added examples (issue 536).
 - When TcpDynamicPorts is set to "0" the Test-TargetResource function will no longer fail each time (issue 564).
- Changes to xSQLServerRSConfig
 - Replaced sqlcmd.exe usages with Invoke-Sqlcmd calls (issue 567).
- Changes to xSQLServerDatabasePermission
 - Fixed code style, updated README.md and removed *-SqlDatabasePermission functions from xSQLServerHelper.psm1.
 - Added the option "GrantWithGrant" with gives the user grant rights, together with the ability to grant others the same right.
 - Now the resource can revoke permission correctly (issue 454). When revoking "GrantWithGrant", both the grantee and all the other users the grantee has granted the same permission to, will also get their permission revoked.
 - Updated tests to cover Revoke().
- Changes to xSQLServerHelper
 - The missing helper function ("Test-SPDSCObjectHasProperty"), that was referenced in the helper function Test-SQLDscParameterState, is now incorporated into Test-SQLDscParameterState (issue 589).

Version History

Version Downloads Last updated
9.1.0.0 26,626 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 5,097 8/23/2017
8.0.0.0 4,963 7/12/2017
7.1.0.0 (current version) 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,138 12/14/2016
3.0.0.0 1,759 11/2/2016
2.0.0.0 7,066 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
Show less
.