77,982

Downloads

5,703

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 6770 Wednesday, November 15 2017
    xSQLServer 8.2.0.0 4652 Thursday, October 05 2017
    xSQLServer 8.1.0.0 4613 Wednesday, August 23 2017
    xSQLServer 8.0.0.0 3716 Wednesday, July 12 2017
    xSQLServer 7.1.0.0 3953 Wednesday, May 31 2017
    xSQLServer 7.0.0.0 7938 Wednesday, April 19 2017
    xSQLServer 6.0.0.0 10020 Wednesday, March 08 2017
    xSQLServer 5.0.0.0 2471 Thursday, January 26 2017
    xSQLServer 4.0.0.0 1756 Wednesday, December 14 2016
    xSQLServer 3.0.0.0 1672 Wednesday, November 02 2016
    xSQLServer 2.0.0.0 4774 Wednesday, September 21 2016
    xSQLServer 1.8.0.0 11663 Wednesday, August 10 2016
    xSQLServer 1.7.0.0 2161 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 1497 Wednesday, February 03 2016
    xSQLServer 1.3.0.0 2146 Saturday, May 02 2015
    xSQLServer 1.2.1.0 208 Thursday, February 19 2015
    xSQLServer 1.2.0.0 50 Thursday, December 18 2014
    xSQLServer 1.1.0.0 62 Friday, October 24 2014