88,728

Downloads

10,156

Downloads of 9.1.0.0

2018-01-24

Last published

xSQLServer

9.1.0.0

Module with DSC Resources for deployment and configuration of Microsoft SQL Server. This module has been renamed to SqlServerDsc. Development of these resources will continue under that module. This specific module (xSQLServer) is now deprecated and use of SqlServerDsc is recommended.

Inspect

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

Install

PS> Install-Module -Name xSQLServer

Deploy

See Documentation for more details.

Release Notes

This module has been renamed to SqlServerDsc. Development of these resources will continue under that module. This specific module (xSQLServer) is now deprecated and use of SqlServerDsc is recommended. The only change between version 9.0.0.0 and 9.1.0.0 is the addition of this note to the description of the module. There are no other changes.

Owners

Authors

Microsoft Corporation

Copyright

(c) 2018 Microsoft Corporation. All rights reserved.

FileList

Show
  • xSQLServer.nuspec
  • CHANGELOG.md
  • CONTRIBUTING.md
  • LICENSE
  • PSGetModuleInfo.xml
  • README.md
  • xSQLServer.psd1
  • xSQLServerHelper.psm1
  • DSCResources\CommonResourceHelper.psm1
  • 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_xSQLServerAlwaysOnAvailabilityGroupDatabaseMembership\MSFT_xSQLServerAlwaysOnAvailabilityGroupDatabaseMembership.psm1
  • DSCResources\MSFT_xSQLServerAlwaysOnAvailabilityGroupDatabaseMembership\MSFT_xSQLServerAlwaysOnAvailabilityGroupDatabaseMembership.schema.mof
  • DSCResources\MSFT_xSQLServerAlwaysOnAvailabilityGroupDatabaseMembership\en-US\about_xSQLServerAlwaysOnAvailabilityGroupDatabaseMembership.help.txt
  • DSCResources\MSFT_xSQLServerAlwaysOnAvailabilityGroupDatabaseMembership\en-US\MSFT_xSQLServerAlwaysOnAvailabilityGroupDatabaseMembership.strings.psd1
  • 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_xSQLServerDatabaseDefaultLocation\MSFT_xSQLServerDatabaseDefaultLocation.psm1
  • DSCResources\MSFT_xSQLServerDatabaseDefaultLocation\MSFT_xSQLServerDatabaseDefaultLocation.schema.mof
  • DSCResources\MSFT_xSQLServerDatabaseDefaultLocation\en-US\MSFT_xSQLServerDatabaseDefaultLocation.strings.psd1
  • 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_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_xSQLServerNetwork\en-US\MSFT_xSQLServerNetwork.strings.psd1
  • 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_xSQLServerServiceAccount\MSFT_xSQLServerServiceAccount.psm1
  • DSCResources\MSFT_xSQLServerServiceAccount\MSFT_xSQLServerServiceAccount.schema.mof
  • DSCResources\MSFT_xSQLServerServiceAccount\en-US\MSFT_xSQLServerServiceAccount.strings.psd1
  • DSCResources\MSFT_xSQLServerSetup\MSFT_xSQLServerSetup.psm1
  • DSCResources\MSFT_xSQLServerSetup\MSFT_xSQLServerSetup.schema.mof
  • DSCResources\MSFT_xSQLServerSetup\en-US\MSFT_xSQLServerSetup.strings.psd1
  • DSCResources\MSFT_xSQLServerSetup\sv-SE\MSFT_xSQLServerSetup.strings.psd1
  • DSCResources\MSFT_xWaitForAvailabilityGroup\MSFT_xWaitForAvailabilityGroup.psm1
  • DSCResources\MSFT_xWaitForAvailabilityGroup\MSFT_xWaitForAvailabilityGroup.schema.mof
  • en-US\xSQLServerHelper.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\xSQLServerAlwaysOnAvailabilityGroup\3-CreateAvailabilityGroupDetailed.ps1
  • Examples\Resources\xSQLServerAlwaysOnAvailabilityGroupDatabaseMembership\1-AddDatabasesToAvailabilityGroup.ps1
  • Examples\Resources\xSQLServerAlwaysOnAvailabilityGroupDatabaseMembership\2-RemoveDatabasesFromAvailabilityGroup.ps1
  • Examples\Resources\xSQLServerAlwaysOnAvailabilityGroupDatabaseMembership\3-MatchDefinedDatabasesInAvailabilityGroup.ps1
  • Examples\Resources\xSQLServerAlwaysOnAvailabilityGroupReplica\1-CreateAvailabilityGroupReplica.ps1
  • Examples\Resources\xSQLServerAlwaysOnAvailabilityGroupReplica\2-RemoveAvailabilityGroupReplica.ps1
  • Examples\Resources\xSQLServerAlwaysOnService\1-EnableAlwaysOn.ps1
  • Examples\Resources\xSQLServerAlwaysOnService\2-DisableAlwaysOn.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\xSQLServerDatabaseDefaultLocation\1-SetDatabaseDefaultLocation.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-EnableTcpIpWithStaticPort.ps1
  • Examples\Resources\xSQLServerNetwork\2-EnableTcpIpWithDynamicPort.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\xSQLServerRSConfig\1-DefaultConfiguration.ps1
  • Examples\Resources\xSQLServerRSConfig\2-CustomConfiguration.ps1
  • Examples\Resources\xSQLServerScript\1-RunScriptUsingSQLAuthentication.ps1
  • Examples\Resources\xSQLServerScript\2-RunScriptUsingWindowsAuthentication.ps1
  • Examples\Resources\xSQLServerServiceAccount\1-ConfigureServiceAccount-UserAccount.ps1
  • Examples\Resources\xSQLServerServiceAccount\2-ConfigureServiceAccount-VirtualAccount.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
  • Examples\Resources\xWaitForAvailabilityGroup\1-WaitForASingleClusterGroup.ps1
  • Examples\Resources\xWaitForAvailabilityGroup\2-WaitForMultipleClusterGroups.ps1
  • sv-SE\xSQLServerHelper.strings.psd1
  • Tests\xSQLServerCommon.Tests.ps1
  • Tests\Integration\MSFT_xSQLServerAlwaysOnService.config.ps1
  • Tests\Integration\MSFT_xSQLServerAlwaysOnService.Integration.Tests.ps1
  • Tests\Integration\MSFT_xSQLServerDatabaseDefaultLocation.config.ps1
  • Tests\Integration\MSFT_xSQLServerDatabaseDefaultLocation.Integration.Tests.ps1
  • Tests\Integration\MSFT_xSQLServerRSConfig.config.ps1
  • Tests\Integration\MSFT_xSQLServerRSConfig.Integration.Tests.ps1
  • Tests\Integration\MSFT_xSQLServerSetup.config.ps1
  • Tests\Integration\MSFT_xSQLServerSetup.Integration.Tests.ps1
  • Tests\TestHelpers\CommonTestHelper.psm1
  • Tests\Unit\CommonResourceHelper.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerAlias.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerAlwaysOnAvailabilityGroup.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerAlwaysOnAvailabilityGroupDatabaseMembership.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_xSQLServerDatabaseDefaultLocation.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_xSQLServerNetwork.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerPermission.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerReplication.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerRole.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerRSConfig.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerScript.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerServiceAccount.Tests.ps1
  • Tests\Unit\MSFT_xSQLServerSetup.Tests.ps1
  • Tests\Unit\MSFT_xWaitForAvailabilityGroup.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

    DSCResources

    Dependencies

    This module has no dependencies.

    Minimum PowerShell version

    5.0

    Version History

    Version Downloads Last updated
    xSQLServer 9.0.0.0 6914 Wednesday, November 15 2017
    xSQLServer 8.2.0.0 4851 Thursday, October 05 2017
    xSQLServer 8.1.0.0 4944 Wednesday, August 23 2017
    xSQLServer 8.0.0.0 4579 Wednesday, July 12 2017
    xSQLServer 7.1.0.0 4708 Wednesday, May 31 2017
    xSQLServer 7.0.0.0 8085 Wednesday, April 19 2017
    xSQLServer 6.0.0.0 10352 Wednesday, March 08 2017
    xSQLServer 5.0.0.0 2501 Thursday, January 26 2017
    xSQLServer 4.0.0.0 1814 Wednesday, December 14 2016
    xSQLServer 3.0.0.0 1695 Wednesday, November 02 2016
    xSQLServer 2.0.0.0 5786 Wednesday, September 21 2016
    xSQLServer 1.8.0.0 13998 Wednesday, August 10 2016
    xSQLServer 1.7.0.0 2168 Wednesday, June 29 2016
    xSQLServer 1.6.0.0 1173 Wednesday, May 18 2016
    xSQLServer 1.5.0.0 984 Thursday, March 31 2016
    xSQLServer 1.4.0.0 1526 Wednesday, February 03 2016
    xSQLServer 1.3.0.0 2146 Saturday, May 02 2015
    xSQLServer 1.2.1.0 233 Thursday, February 19 2015
    xSQLServer 1.2.0.0 52 Thursday, December 18 2014
    xSQLServer 1.1.0.0 63 Friday, October 24 2014