xSQLServer
3.0.0.0
Module with DSC Resources for deployment and configuration of Microsoft SQL Server.
Minimum PowerShell version
4.0
Installation Options
Owners
Copyright
(c) 2014 Microsoft Corporation. All rights reserved.
Package Details
Author(s)
- Microsoft Corporation
Tags
DesiredStateConfiguration DSC DSCResourceKit DSCResource
DSCResources
xSQLAlias xSQLAOGroupEnsure xSQLAOGroupJoin xSQLDatabaseRecoveryModel xSQLServerAlwaysOnService xSQLServerAvailabilityGroupListener xSQLServerConfiguration xSQLServerDatabase xSQLServerDatabaseOwner xSQLServerDatabasePermissions xSQLServerDatabaseRole xSQLServerEndpoint xSQLServerEndpointPermission xSQLServerEndpointState xSQLServerFailoverClusterSetup xSQLServerFirewall xSQLServerLogin xSQLServerMaxDop xSQLServerMemory xSQLServerNetwork xSQLServerPermission xSQLServerPowerPlan xSQLServerReplication xSQLServerRole xSQLServerRSConfig xSQLServerRSSecureConnectionLevel xSQLServerScript xSQLServerSetup xWaitForAvailabilityGroup
Dependencies
This module has no dependencies.
Release Notes
* xSQLServerHelper
- added functions
- Test-SQLDscParameterState
- Get-SqlDatabaseOwner
- Set-SqlDatabaseOwner
* Examples
- xSQLServerDatabaseOwner
- 1-SetDatabaseOwner.ps1
* Added tests for resources
- MSFT_xSQLServerDatabaseOwner.Tests.Tests.ps1
FileList
- xSQLServer.nuspec
- LICENSE
- README.md
- xPDT.psm1
- xPDT.xml
- xSQLServer.psd1
- xSQLServerHelper.psm1
- DSCResources\MSFT_xSQLAlias\MSFT_xSQLAlias.psm1
- DSCResources\MSFT_xSQLAlias\MSFT_xSQLAlias.schema.mof
- 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_xSQLDatabaseRecoveryModel\MSFT_xSQLDatabaseRecoveryModel.psm1
- DSCResources\MSFT_xSQLDatabaseRecoveryModel\MSFT_xSQLDatabaseRecoveryModel.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_xSQLServerDatabasePermissions\MSFT_xSQLServerDatabasePermissions.psm1
- DSCResources\MSFT_xSQLServerDatabasePermissions\MSFT_xSQLServerDatabasePermissions.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_xSQLServerPowerPlan\MSFT_xSQLServerPowerPlan.psm1
- DSCResources\MSFT_xSQLServerPowerPlan\MSFT_xSQLServerPowerPlan.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\SQLServerNetwork.ps1
- Examples\SQLServerScript.ps1
- Examples\xSQLServerAvailabilityGroupListener.ps1
- Examples\xSQLServerConfiguration.ps1
- Examples\xSQLServerEndpointPermission.ps1
- Examples\xSQLServerEndpointState.ps1
- Examples\xSQLServerPermission.ps1
- Examples\xSQLServerReplication.ps1
- Examples\Resources\xSQLServerDatabaseOwner\1-SetDatabaseOwner.ps1
- Examples\Resources\xSQLServerRole\1-AddServerRole.ps1
- Examples\Resources\xSQLServerRole\2-RemoveServerRole.ps1
- Tests\Integration\integration_config_template.ps1
- Tests\Integration\integration_template.ps1
- Tests\Unit\MSFT_xSqlAlias.Tests.ps1
- Tests\Unit\MSFT_xSQLAOGroupEnsure.Tests.ps1
- Tests\Unit\MSFT_xSQLServerAvailabilityGroupListener.Tests.ps1
- Tests\Unit\MSFT_xSQLServerDatabase.Tests.ps1
- Tests\Unit\MSFT_xSQLServerDatabaseOwner.Tests.ps1
- Tests\Unit\MSFT_xSQLServerEndpointPermission.Tests.ps1
- Tests\Unit\MSFT_xSQLServerEndpointState.Tests.ps1
- Tests\Unit\MSFT_xSQLServerLogin.Tests.ps1
- Tests\Unit\MSFT_xSQLServerPermission.Tests.ps1
- Tests\Unit\MSFT_xSQLServerReplication.Tests.ps1
- Tests\Unit\MSFT_xSQLServerRole.Tests.ps1
- Tests\Unit\MSFT_xSQLServerScript.Test.ps1
- Tests\Unit\unit_template.ps1
- Tests\Unit\Stubs\SMO.cs
- Tests\Unit\Stubs\SQLPSStub.psm1
- Tests\Unit\Stubs\SQLServerStub.psm1
- Tests\Unit\Stubs\Write-ModuleStubFile.ps1
Version History
Version | Downloads | Last updated |
---|---|---|
9.1.0.0 | 288,513 | 1/24/2018 |
9.0.0.0 | 7,301 | 11/15/2017 |
8.2.0.0 | 5,487 | 10/5/2017 |
8.1.0.0 | 5,956 | 8/23/2017 |
8.0.0.0 | 5,767 | 7/12/2017 |
7.1.0.0 | 6,874 | 5/31/2017 |
7.0.0.0 | 8,221 | 4/19/2017 |
6.0.0.0 | 10,770 | 3/8/2017 |
5.0.0.0 | 2,550 | 1/26/2017 |
4.0.0.0 | 2,354 | 12/14/2016 |
3.0.0.0 (current version) | 1,929 | 11/2/2016 |
2.0.0.0 | 7,390 | 9/21/2016 |
1.8.0.0 | 28,478 | 8/10/2016 |
1.7.0.0 | 2,193 | 6/29/2016 |
1.6.0.0 | 1,323 | 5/18/2016 |
1.5.0.0 | 1,008 | 3/31/2016 |
1.4.0.0 | 1,595 | 2/3/2016 |
1.3.0.0 | 2,169 | 5/2/2015 |
1.2.1.0 | 503 | 2/19/2015 |
1.2.0.0 | 77 | 12/18/2014 |
1.1.0.0 | 87 | 10/24/2014 |