35,865

Downloads

6,306

Downloads of 7.0.0.0

2017-04-19

Last published

xSQLServer

7.0.0.0

Module with DSC Resources for deployment and configuration of Microsoft SQL Server.

Inspect

PS> Save-Module -Name xSQLServer -Path <path>

Install

PS> Install-Module -Name xSQLServer

Deploy

See Documentation for more details.

Release Notes

- Examples
  - xSQLServerDatabaseRole
    - 1-AddDatabaseRole.ps1
    - 2-RemoveDatabaseRole.ps1
  - xSQLServerRole
    - 3-AddMembersToServerRole.ps1
    - 4-MembersToIncludeInServerRole.ps1
    - 5-MembersToExcludeInServerRole.ps1
  - xSQLServerSetup
    - 1-InstallDefaultInstanceSingleServer.ps1
    - 2-InstallNamedInstanceSingleServer.ps1
    - 3-InstallNamedInstanceSingleServerFromUncPathUsingSourceCredential.ps1
    - 4-InstallNamedInstanceInFailoverClusterFirstNode.ps1
    - 5-InstallNamedInstanceInFailoverClusterSecondNode.ps1
  - xSQLServerReplication
    - 1-ConfigureInstanceAsDistributor.ps1
    - 2-ConfigureInstanceAsPublisher.ps1
  - xSQLServerNetwork
    - 1-EnableTcpIpOnCustomStaticPort.ps1
  - xSQLServerAvailabilityGroupListener
    - 1-AddAvailabilityGroupListenerWithSameNameAsVCO.ps1
    - 2-AddAvailabilityGroupListenerWithDifferentNameAsVCO.ps1
    - 3-RemoveAvailabilityGroupListenerWithSameNameAsVCO.ps1
    - 4-RemoveAvailabilityGroupListenerWithDifferentNameAsVCO.ps1
    - 5-AddAvailabilityGroupListenerUsingDHCPWithDefaultServerSubnet.ps1
    - 6-AddAvailabilityGroupListenerUsingDHCPWithSpecificSubnet.ps1
  - xSQLServerEndpointPermission
    - 1-AddConnectPermission.ps1
    - 2-RemoveConnectPermission.ps1
    - 3-AddConnectPermissionToAlwaysOnPrimaryAndSecondaryReplicaEachWithDifferentSqlServiceAccounts.ps1
    - 4-RemoveConnectPermissionToAlwaysOnPrimaryAndSecondaryReplicaEachWithDifferentSqlServiceAccounts.ps1
  - xSQLServerPermission
    - 1-AddServerPermissionForLogin.ps1
    - 2-RemoveServerPermissionForLogin.ps1
  - xSQLServerEndpointState
    - 1-MakeSureEndpointIsStarted.ps1
    - 2-MakeSureEndpointIsStopped.ps1
  - xSQLServerConfiguration
    - 1-ConfigureTwoInstancesOnTheSameServerToEnableClr.ps1
    - 2-ConfigureInstanceToEnablePriorityBoost.ps1
  - xSQLServerEndpoint
    - 1-CreateEndpointWithDefaultValues.ps1
    - 2-CreateEndpointWithSpecificPortAndIPAddress.ps1
    - 3-RemoveEndpoint.ps1
- Changes to xSQLServerDatabaseRole
  - Fixed code style, added updated parameter descriptions to schema.mof and README.md.
- Changes to xSQLServer
  - Raised the CodeCov target to 70% which is the minimum and required target for HQRM resource.
- Changes to xSQLServerRole
  - **BREAKING CHANGE: The resource has been reworked in it"s entirely.** Below is what has changed.
    - The mandatory parameters now also include ServerRoleName.
    - The ServerRole parameter was before an array of server roles, now this parameter is renamed to ServerRoleName and can only be set to one server role.
      - ServerRoleName are no longer limited to built-in server roles. To add members to a built-in server role, set ServerRoleName to the name of the built-in server role.
      - The ServerRoleName will be created when Ensure is set to "Present" (if it does not already exist), or removed if Ensure is set to "Absent".
    - Three new parameters are added; Members, MembersToInclude and MembersToExclude.
      - Members can be set to one or more logins, and those will _replace all_ the memberships in the server role.
      - MembersToInclude and MembersToExclude can be set to one or more logins that will add or remove memberships, respectively, in the server role. MembersToInclude and MembersToExclude _can not_ be used at the same time as parameter Members. But both MembersToInclude and MembersToExclude can be used together at the same time.
- Changes to xSQLServerSetup
  - Added a note to the README.md saying that it is not possible to add or remove features from a SQL Server failover cluster (issue 433).
  - Changed so that it reports false if the desired state is not correct (issue 432).
    - Added a test to make sure we always return false if a SQL Server failover cluster is missing features.
  - Helper function Connect-SQLAnalysis
    - Now has correct error handling, and throw does not used the unknown named parameter "-Message" (issue 436)
    - Added tests for Connect-SQLAnalysis
    - Changed to localized error messages.
    - Minor changes to error handling.
  - This adds better support for Addnode (issue 369).
  - Now it skips cluster validation för add node (issue 442).
  - Now it ignores parameters that are not allowed for action Addnode (issue 441).
  - Added support for vNext CTP 1.4 (issue 472).
- Added new resource
  - xSQLServerAlwaysOnAvailabilityGroupReplica
- Changes to xSQLServerDatabaseRecoveryModel
  - Fixed code style, removed SQLServerDatabaseRecoveryModel functions from xSQLServerHelper.
- Changes to xSQLServerAlwaysOnAvailabilityGroup
  - Fixed the permissions check loop so that it exits the loop after the function determines the required permissions are in place.
- Changes to xSQLServerAvailabilityGroupListener
  - Removed the dependency of SQLPS provider (issue 460).
  - Cleaned up code.
  - Added test for more coverage.
  - Fixed PSSA rule warnings (issue 255).
  - Parameter Ensure now defaults to "Present" (issue 450).
- Changes to xSQLServerFirewall
  - Now it will correctly create rules when the resource is used for two or more instances on the same server (issue 461).
- Changes to xSQLServerEndpointPermission
  - Added description to the README.md
  - Cleaned up code (issue 257 and issue 231)
  - Now the default value for Ensure is "Present".
  - Removed dependency of SQLPS provider (issue 483).
  - Refactored tests so they use less code.
- Changes to README.md
  - Adding deprecated tag to xSQLServerFailoverClusterSetup, xSQLAOGroupEnsure and xSQLAOGroupJoin in README.md so it it more clear that these resources has been replaced by xSQLServerSetup, xSQLServerAlwaysOnAvailabilityGroup and xSQLServerAlwaysOnAvailabilityGroupReplica respectively.
- Changes to xSQLServerEndpoint
  - BREAKING CHANGE: Now SQLInstanceName is mandatory, and is a key, so SQLInstanceName has no longer a default value (issue 279).
  - BREAKING CHANGE: Parameter AuthorizedUser has been removed (issue 466, issue 275 and issue 80). Connect permissions can be set using the resource xSQLServerEndpointPermission.
  - Optional parameter IpAddress has been added. Default is to listen on any valid IP-address. (issue 232)
  - Parameter Port now has a default value of 5022.
  - Parameter Ensure now defaults to "Present".
  - Resource now supports changing IP address and changing port.
  - Added unit tests (issue 289)
  - Added examples.
- Changes to xSQLServerEndpointState
  - Cleaned up code, removed SupportsShouldProcess and fixed PSSA rules warnings (issue 258 and issue 230).
  - Now the default value for the parameter State is "Started".
  - Updated README.md with a description for the resources and revised the parameter descriptions.
  - Removed dependency of SQLPS provider (issue 481).
  - The parameter NodeName is no longer mandatory and has now the default value of $env:COMPUTERNAME.
  - The parameter Name is now a key so it is now possible to change the state on more than one endpoint on the same instance. _Note: The resource still only supports Database Mirror endpoints at this time._
- Changes to xSQLServerHelper module
  - Removing helper function Get-SQLAlwaysOnEndpoint because there is no resource using it any longer.
  - BREAKING CHANGE: Changed helper function Import-SQLPSModule to support SqlServer module (issue 91). The SqlServer module is the preferred module so if it is found it will be used, and if not found an attempt will be done to load SQLPS module instead.
- Changes to xSQLServerScript
  - Updated tests for this resource, because they failed when Import-SQLPSModule was updated.

Owners

Authors

Microsoft Corporation

Copyright

(c) 2014 Microsoft Corporation. All rights reserved.

FileList

Show
  • xSQLServer.nuspec
  • CHANGELOG.md
  • CONTRIBUTING.md
  • gulpfile.js
  • LICENSE
  • README.md
  • xPDT.psm1
  • xSQLServer.psd1
  • xSQLServerHelper.psm1
  • DSCResources\MSFT_xSQLAOGroupEnsure\MSFT_xSQLAOGroupEnsure.psm1
  • DSCResources\MSFT_xSQLAOGroupEnsure\MSFT_xSQLAOGroupEnsure.schema.mof
  • DSCResources\MSFT_xSQLAOGroupJoin\MSFT_xSQLAOGroupJoin.psm1
  • DSCResources\MSFT_xSQLAOGroupJoin\MSFT_xSQLAOGroupJoin.schema.mof
  • DSCResources\MSFT_xSQLServerAlias\MSFT_xSQLServerAlias.psm1
  • DSCResources\MSFT_xSQLServerAlias\MSFT_xSQLServerAlias.schema.mof
  • DSCResources\MSFT_xSQLServerAlwaysOnAvailabilityGroup\MSFT_xSQLServerAlwaysOnAvailabilityGroup.psm1
  • DSCResources\MSFT_xSQLServerAlwaysOnAvailabilityGroup\MSFT_xSQLServerAlwaysOnAvailabilityGroup.schema.mof
  • DSCResources\MSFT_xSQLServerAlwaysOnAvailabilityGroupReplica\MSFT_xSQLServerAlwaysOnAvailabilityGroupReplica.psm1
  • DSCResources\MSFT_xSQLServerAlwaysOnAvailabilityGroupReplica\MSFT_xSQLServerAlwaysOnAvailabilityGroupReplica.schema.mof
  • DSCResources\MSFT_xSQLServerAlwaysOnService\MSFT_xSQLServerAlwaysOnService.psm1
  • DSCResources\MSFT_xSQLServerAlwaysOnService\MSFT_xSQLServerAlwaysOnService.schema.mof
  • DSCResources\MSFT_xSQLServerAvailabilityGroupListener\MSFT_xSQLServerAvailabilityGroupListener.psm1
  • DSCResources\MSFT_xSQLServerAvailabilityGroupListener\MSFT_xSQLServerAvailabilityGroupListener.schema.mof
  • DSCResources\MSFT_xSQLServerConfiguration\MSFT_xSQLServerConfiguration.psm1
  • DSCResources\MSFT_xSQLServerConfiguration\MSFT_xSQLServerConfiguration.schema.mof
  • DSCResources\MSFT_xSQLServerDatabase\MSFT_xSQLServerDatabase.psm1
  • DSCResources\MSFT_xSQLServerDatabase\MSFT_xSQLServerDatabase.schema.mof
  • DSCResources\MSFT_xSQLServerDatabaseOwner\MSFT_xSQLServerDatabaseOwner.psm1
  • DSCResources\MSFT_xSQLServerDatabaseOwner\MSFT_xSQLServerDatabaseOwner.schema.mof
  • DSCResources\MSFT_xSQLServerDatabasePermission\MSFT_xSQLServerDatabasePermission.psm1
  • DSCResources\MSFT_xSQLServerDatabasePermission\MSFT_xSQLServerDatabasePermission.schema.mof
  • DSCResources\MSFT_xSQLServerDatabaseRecoveryModel\MSFT_xSQLServerDatabaseRecoveryModel.psm1
  • DSCResources\MSFT_xSQLServerDatabaseRecoveryModel\MSFT_xSQLServerDatabaseRecoveryModel.schema.mof
  • DSCResources\MSFT_xSQLServerDatabaseRole\MSFT_xSQLServerDatabaseRole.psm1
  • DSCResources\MSFT_xSQLServerDatabaseRole\MSFT_xSQLServerDatabaseRole.schema.mof
  • DSCResources\MSFT_xSQLServerEndpoint\MSFT_xSQLServerEndpoint.psm1
  • DSCResources\MSFT_xSQLServerEndpoint\MSFT_xSQLServerEndpoint.schema.mof
  • DSCResources\MSFT_xSQLServerEndpointPermission\MSFT_xSQLServerEndpointPermission.psm1
  • DSCResources\MSFT_xSQLServerEndpointPermission\MSFT_xSQLServerEndpointPermission.schema.mof
  • DSCResources\MSFT_xSQLServerEndpointState\MSFT_xSQLServerEndpointState.psm1
  • DSCResources\MSFT_xSQLServerEndpointState\MSFT_xSQLServerEndpointState.schema.mof
  • DSCResources\MSFT_xSQLServerFailoverClusterSetup\MSFT_xSQLServerFailoverClusterSetup.psm1
  • DSCResources\MSFT_xSQLServerFailoverClusterSetup\MSFT_xSQLServerFailoverClusterSetup.schema.mof
  • DSCResources\MSFT_xSQLServerFirewall\MSFT_xSQLServerFirewall.psm1
  • DSCResources\MSFT_xSQLServerFirewall\MSFT_xSQLServerFirewall.schema.mof
  • DSCResources\MSFT_xSQLServerLogin\MSFT_xSQLServerLogin.psm1
  • DSCResources\MSFT_xSQLServerLogin\MSFT_xSQLServerLogin.schema.mof
  • DSCResources\MSFT_xSQLServerMaxDop\MSFT_xSQLServerMaxDop.psm1
  • DSCResources\MSFT_xSQLServerMaxDop\MSFT_xSQLServerMaxDop.schema.mof
  • DSCResources\MSFT_xSQLServerMemory\MSFT_xSQLServerMemory.psm1
  • DSCResources\MSFT_xSQLServerMemory\MSFT_xSQLServerMemory.schema.mof
  • DSCResources\MSFT_xSQLServerNetwork\MSFT_xSQLServerNetwork.psm1
  • DSCResources\MSFT_xSQLServerNetwork\MSFT_xSQLServerNetwork.schema.mof
  • DSCResources\MSFT_xSQLServerPermission\MSFT_xSQLServerPermission.psm1
  • DSCResources\MSFT_xSQLServerPermission\MSFT_xSQLServerPermission.schema.mof
  • DSCResources\MSFT_xSQLServerReplication\MSFT_xSQLServerReplication.psm1
  • DSCResources\MSFT_xSQLServerReplication\MSFT_xSQLServerReplication.schema.mof
  • DSCResources\MSFT_xSQLServerRole\MSFT_xSQLServerRole.psm1
  • DSCResources\MSFT_xSQLServerRole\MSFT_xSQLServerRole.schema.mof
  • DSCResources\MSFT_xSQLServerRSConfig\MSFT_xSQLServerRSConfig.psm1
  • DSCResources\MSFT_xSQLServerRSConfig\MSFT_xSQLServerRSConfig.schema.mof
  • DSCResources\MSFT_xSQLServerRSSecureConnectionLevel\MSFT_xSQLServerRSSecureConnectionLevel.psm1
  • DSCResources\MSFT_xSQLServerRSSecureConnectionLevel\MSFT_xSQLServerRSSecureConnectionLevel.schema.mof
  • DSCResources\MSFT_xSQLServerScript\MSFT_xSQLServerScript.psm1
  • DSCResources\MSFT_xSQLServerScript\MSFT_xSQLServerScript.schema.mof
  • DSCResources\MSFT_xSQLServerSetup\MSFT_xSQLServerSetup.psm1
  • DSCResources\MSFT_xSQLServerSetup\MSFT_xSQLServerSetup.schema.mof
  • DSCResources\MSFT_xWaitForAvailabilityGroup\MSFT_xWaitForAvailabilityGroup.psm1
  • DSCResources\MSFT_xWaitForAvailabilityGroup\MSFT_xWaitForAvailabilityGroup.schema.mof
  • en-US\xPDT.strings.psd1
  • en-US\xSQLServer.strings.psd1
  • Examples\DSCClusterSqlBuild.ps1
  • Examples\DSCFCISqlBuild.ps1
  • Examples\DSCSqlBuild.ps1
  • Examples\DSCSQLBuildEncrypted.ps1
  • Examples\SQL-ClusterDB.ps1
  • Examples\SQL-Standalone.ps1
  • Examples\SQLPush_SingleServer.ps1
  • Examples\Resources\xSQLServerAlias\1-AddSQLServerAlias.ps1
  • Examples\Resources\xSQLServerAlias\2-RemoveSQLServerAlias.ps1
  • Examples\Resources\xSQLServerAlwaysOnAvailabilityGroup\1-CreateAvailabilityGroup.ps1
  • Examples\Resources\xSQLServerAlwaysOnAvailabilityGroup\2-RemoveAvailabilityGroup.ps1
  • Examples\Resources\xSQLServerAlwaysOnAvailabilityGroupReplica\1-CreateAvailabilityGroupReplica.ps1
  • Examples\Resources\xSQLServerAlwaysOnAvailabilityGroupReplica\2-RemoveAvailabilityGroupReplica.ps1
  • Examples\Resources\xSQLServerAvailabilityGroupListener\1-AddAvailabilityGroupListenerWithSameNameAsVCO.ps1
  • Examples\Resources\xSQLServerAvailabilityGroupListener\2-AddAvailabilityGroupListenerWithDifferentNameAsVCO.ps1
  • Examples\Resources\xSQLServerAvailabilityGroupListener\3-RemoveAvailabilityGroupListenerWithSameNameAsVCO.ps1
  • Examples\Resources\xSQLServerAvailabilityGroupListener\4-RemoveAvailabilityGroupListenerWithDifferentNameAsVCO.ps1
  • Examples\Resources\xSQLServerAvailabilityGroupListener\5-AddAvailabilityGroupListenerUsingDHCPWithDefaultServerSubnet.ps1
  • Examples\Resources\xSQLServerAvailabilityGroupListener\6-AddAvailabilityGroupListenerUsingDHCPWithSpecificSubnet.ps1
  • Examples\Resources\xSQLServerConfiguration\1-ConfigureTwoInstancesOnTheSameServerToEnableClr.ps1
  • Examples\Resources\xSQLServerConfiguration\2-ConfigureInstanceToEnablePriorityBoost.ps1
  • Examples\Resources\xSQLServerDatabase\1-CreateDatabase.ps1
  • Examples\Resources\xSQLServerDatabase\2-DeleteDatabase.ps1
  • Examples\Resources\xSQLServerDatabaseOwner\1-SetDatabaseOwner.ps1
  • Examples\Resources\xSQLServerDatabasePermission\1-GrantDatabasePermissions.ps1
  • Examples\Resources\xSQLServerDatabasePermission\2-RevokeDatabasePermissions.ps1
  • Examples\Resources\xSQLServerDatabasePermission\3-DenyDatabasePermissions.ps1
  • Examples\Resources\xSQLServerDatabaseRecoveryModel\1-SetDatabaseRecoveryModel.ps1
  • Examples\Resources\xSQLServerDatabaseRole\1-AddDatabaseRole.ps1
  • Examples\Resources\xSQLServerDatabaseRole\2-RemoveDatabaseRole.ps1
  • Examples\Resources\xSQLServerEndpoint\1-CreateEndpointWithDefaultValues.ps1
  • Examples\Resources\xSQLServerEndpoint\2-CreateEndpointWithSpecificPortAndIPAddress.ps1
  • Examples\Resources\xSQLServerEndpoint\3-RemoveEndpoint.ps1
  • Examples\Resources\xSQLServerEndpointPermission\1-AddConnectPermission.ps1
  • Examples\Resources\xSQLServerEndpointPermission\2-RemoveConnectPermission.ps1
  • Examples\Resources\xSQLServerEndpointPermission\3-AddConnectPermissionToAlwaysOnPrimaryAndSecondaryReplicaEachWithDifferentSqlServiceAccounts.ps1
  • Examples\Resources\xSQLServerEndpointPermission\4-RemoveConnectPermissionToAlwaysOnPrimaryAndSecondaryReplicaEachWithDifferentSqlServiceAccounts.ps1
  • Examples\Resources\xSQLServerEndpointState\1-MakeSureEndpointIsStarted.ps1
  • Examples\Resources\xSQLServerEndpointState\2-MakeSureEndpointIsStopped.ps1
  • Examples\Resources\xSQLServerFirewall\1-CreateInboundFirewallRules.ps1
  • Examples\Resources\xSQLServerFirewall\2-RemoveInboundFirewallRules.ps1
  • Examples\Resources\xSQLServerLogin\1-AddLogin.ps1
  • Examples\Resources\xSQLServerLogin\2-RemoveLogin.ps1
  • Examples\Resources\xSQLServerMaxDop\1-SetMaxDopToOne.ps1
  • Examples\Resources\xSQLServerMaxDop\2-SetMaxDopToAuto.ps1
  • Examples\Resources\xSQLServerMaxDop\3-SetMaxDopToDefault.ps1
  • Examples\Resources\xSQLServerMemory\1-SetMaxMemoryTo12GB.ps1
  • Examples\Resources\xSQLServerMemory\2-SetMaxMemoryToAuto.ps1
  • Examples\Resources\xSQLServerMemory\3-SetMinMemoryToFixedValueAndMaxMemoryToAuto.ps1
  • Examples\Resources\xSQLServerMemory\4-SetMaxMemoryToDefault.ps1
  • Examples\Resources\xSQLServerNetwork\1-EnableTcpIpOnCustomStaticPort.ps1
  • Examples\Resources\xSQLServerPermission\1-AddServerPermissionForLogin.ps1
  • Examples\Resources\xSQLServerPermission\2-RemoveServerPermissionForLogin.ps1
  • Examples\Resources\xSQLServerReplication\1-ConfigureInstanceAsDistributor.ps1
  • Examples\Resources\xSQLServerReplication\2-ConfigureInstanceAsPublisher.ps1
  • Examples\Resources\xSQLServerRole\1-AddServerRole.ps1
  • Examples\Resources\xSQLServerRole\2-RemoveServerRole.ps1
  • Examples\Resources\xSQLServerRole\3-AddMembersToServerRole.ps1
  • Examples\Resources\xSQLServerRole\4-MembersToIncludeInServerRole.ps1
  • Examples\Resources\xSQLServerRole\5-MembersToExcludeInServerRole.ps1
  • Examples\Resources\xSQLServerScript\1-RunScriptUsingSQLAuthentication.ps1
  • Examples\Resources\xSQLServerScript\2-RunScriptUsingWindowsAuthentication.ps1
  • Examples\Resources\xSQLServerSetup\1-InstallDefaultInstanceSingleServer.ps1
  • Examples\Resources\xSQLServerSetup\2-InstallNamedInstanceSingleServer.ps1
  • Examples\Resources\xSQLServerSetup\3-InstallNamedInstanceSingleServerFromUncPathUsingSourceCredential.ps1
  • Examples\Resources\xSQLServerSetup\4-InstallNamedInstanceInFailoverClusterFirstNode.ps1
  • Examples\Resources\xSQLServerSetup\5-InstallNamedInstanceInFailoverClusterSecondNode.ps1
  • Tests\xSQLServerCommon.Tests.ps1
  • Tests\Unit\MSFT_xSQLAOGroupEnsure.Tests.ps1
  • Tests\Unit\MSFT_xSQLAOGroupJoin.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerAlias.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerAlwaysOnAvailabilityGroup.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerAlwaysOnAvailabilityGroupReplica.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerAlwaysOnService.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerAvailabilityGroupListener.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerConfiguration.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerDatabase.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerDatabaseOwner.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerDatabasePermission.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerDatabaseRecoveryModel.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerDatabaseRole.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerEndpoint.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerEndpointPermission.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerEndpointState.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerFirewall.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerLogin.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerMaxDop.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerMemory.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerPermission.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerReplication.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerRole.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerScript.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerSetup.Tests.ps1
  • Tests\Unit\xSQLServerHelper.Tests.ps1
  • Tests\Unit\Stubs\SMO.cs
  • Tests\Unit\Stubs\SqlPowerShellSqlExecutionException.cs
  • Tests\Unit\Stubs\SQLPSStub.psm1
  • Tests\Unit\Stubs\SQLServerStub.psm1
  • Tests\Unit\Stubs\Write-ModuleStubFile.ps1
  • Tags

    Cmdlets

    This module has no cmdlets.

    Functions

    This module has no functions.

    DSC Resources

    Workflows

    This module has no workflows.

    Role Capabilities

    This module has no role capabilities.

    Dependencies

    This module has no dependencies.

    Minimum PowerShell version

    4.0

    Version History

    Version Downloads Last updated
    xSQLServer 6.0.0.0 8884 Wednesday, March 08 2017
    xSQLServer 5.0.0.0 2271 Thursday, January 26 2017
    xSQLServer 4.0.0.0 1580 Wednesday, December 14 2016
    xSQLServer 3.0.0.0 1508 Wednesday, November 02 2016
    xSQLServer 2.0.0.0 2427 Wednesday, September 21 2016
    xSQLServer 1.8.0.0 5116 Wednesday, August 10 2016
    xSQLServer 1.7.0.0 1937 Wednesday, June 29 2016
    xSQLServer 1.6.0.0 1166 Wednesday, May 18 2016
    xSQLServer 1.5.0.0 978 Thursday, March 31 2016
    xSQLServer 1.4.0.0 1309 Wednesday, February 03 2016
    xSQLServer 1.3.0.0 2139 Saturday, May 02 2015
    xSQLServer 1.2.1.0 145 Thursday, February 19 2015
    xSQLServer 1.2.0.0 44 Thursday, December 18 2014
    xSQLServer 1.1.0.0 55 Friday, October 24 2014