SqlServerDsc
12.1.0.0
Module with DSC Resources for deployment and configuration of Microsoft SQL Server.
Minimum PowerShell version
5.0
See the version list below for details.
Installation Options
Owners
Copyright
(c) 2018 Microsoft Corporation. All rights reserved.
Package Details
Author(s)
- Microsoft Corporation
Tags
DesiredStateConfiguration DSC DSCResourceKit DSCResource
DSCResources
SqlAG SqlAGDatabase SqlAGListener SqlAGReplica SqlAlias SqlAlwaysOnService SqlDatabase SqlDatabaseDefaultLocation SqlDatabaseOwner SqlDatabasePermission SqlDatabaseRecoveryModel SqlDatabaseRole SqlRS SqlScript SqlScriptQuery SqlServerConfiguration SqlServerDatabaseMail SqlServerEndpoint SqlServerEndpointPermission SqlServerEndpointState SqlServerLogin SqlServerMaxDop SqlServerMemory SqlServerNetwork SqlServerPermission SqlServerReplication SqlServerRole SqlServerSecureConnection SqlServiceAccount SqlSetup SqlWaitForAG SqlWindowsFirewall
Dependencies
This module has no dependencies.
Release Notes
- Changes to SqlServerDsc
- Add support for validating the code with the DSC ResourceKit
Script Analyzer rules, both in Visual Studio Code and directly using
`Invoke-ScriptAnalyzer`.
- Opt-in for common test "Common Tests - Validate Markdown Links".
- Updated broken links in `\README.md` and in `\Examples\README.md`
- Opt-in for common test "Common Tests - Relative Path Length".
- Updated the Installation section in the README.md.
- Updated the Contributing section in the README.md after
[Style Guideline and Best Practices guidelines](https://github.com/PowerShell/DscResources/blob/master/StyleGuidelines.md)
has merged into one document.
- To speed up testing in AppVeyor, unit tests are now run in two containers.
- Adding the PowerShell script `Assert-TestEnvironment.ps1` which
must be run prior to running any unit tests locally with
`Invoke-Pester`.
Read more in the specific contributing guidelines, under the section
[Unit Tests](https://github.com/PowerShell/SqlServerDsc/blob/dev/CONTRIBUTING.mdunit-tests).
- Changes to SqlServerDscHelper
- Fix style guideline lint errors.
- Changes to Connect-SQL
- Adding verbose message in Connect-SQL so it
now shows the username that is connecting.
- Changes to Import-SQLPS
- Fixed so that when importing SQLPS it imports
using the path (and not the .psd1 file).
- Fixed so that the verbose message correctly
shows the name, version and path when importing
the module SQLPS (it did show correctly for the
SqlServer module).
- Changes to SqlAg, SqlAGDatabase, and SqlAGReplica examples
- Included configuration for SqlAlwaysOnService to enable
HADR on each node to avoid confusion
([issue 1182](https://github.com/PowerShell/SqlServerDsc/issues/1182)).
- Changes to SqlServerDatabaseMail
- Minor update to Ensure parameter description in the README.md.
- Changes to Write-ModuleStubFile.ps1
- Create aliases for cmdlets in the stubbed module which have aliases
([issue 1224](https://github.com/PowerShell/SqlServerDsc/issues/1224)).
[Dan Reist (@randomnote1)](https://github.com/randomnote1)
- Use a string builder to build the function stubs.
- Fixed formatting issues for the function to work with modules other
than SqlServer.
- New DSC resource SqlServerSecureConnection
- New resource to configure a SQL Server instance for encrypted SQL
connections.
- Changes to SqlAlwaysOnService
- Updated integration tests to use NetworkingDsc
([issue 1129](https://github.com/PowerShell/SqlServerDsc/issues/1129)).
- Changes to SqlServiceAccount
- Fix unit tests that didn"t mock some of the calls. It no longer fail
when a SQL Server installation is not present on the node running the
unit test ([issue 983](https://github.com/PowerShell/SqlServerDsc/issues/983)).
FileList
- SqlServerDsc.nuspec
- .codecov.yml
- .markdownlint.json
- .MetaTestOptIn.json
- Assert-TestEnvironment.ps1
- CHANGELOG.md
- CODE_OF_CONDUCT.md
- CONTRIBUTING.md
- LICENSE
- README.md
- SqlServerDsc.psd1
- SqlServerDscHelper.psm1
- .git\config
- .git\description
- .git\HEAD
- .git\index
- .git\packed-refs
- .git\hooks\applypatch-msg.sample
- .git\hooks\commit-msg.sample
- .git\hooks\post-update.sample
- .git\hooks\pre-applypatch.sample
- .git\hooks\pre-commit.sample
- .git\hooks\pre-push.sample
- .git\hooks\pre-rebase.sample
- .git\hooks\pre-receive.sample
- .git\hooks\prepare-commit-msg.sample
- .git\hooks\update.sample
- .git\info\exclude
- .git\logs\HEAD
- .git\logs\refs\heads\dev
- .git\logs\refs\heads\master
- .git\logs\refs\remotes\origin\HEAD
- .git\objects\pack\pack-5727a38e6da03ba6715d637fffc190bd7e85e69c.idx
- .git\objects\pack\pack-5727a38e6da03ba6715d637fffc190bd7e85e69c.pack
- .git\refs\heads\dev
- .git\refs\heads\master
- .git\refs\remotes\origin\HEAD
- .github\CONTRIBUTING.md
- .github\PULL_REQUEST_TEMPLATE.md
- .github\stale.yml
- .github\ISSUE_TEMPLATE\General.md
- .github\ISSUE_TEMPLATE\Problem_with_resource.md
- .github\ISSUE_TEMPLATE\Resource_proposal.md
- .vscode\analyzersettings.psd1
- .vscode\settings.json
- DSCResources\CommonResourceHelper.psm1
- DSCResources\MSFT_SqlAG\MSFT_SqlAG.psm1
- DSCResources\MSFT_SqlAG\MSFT_SqlAG.schema.mof
- DSCResources\MSFT_SqlAGDatabase\MSFT_SqlAGDatabase.psm1
- DSCResources\MSFT_SqlAGDatabase\MSFT_SqlAGDatabase.schema.mof
- DSCResources\MSFT_SqlAGDatabase\en-US\about_SqlAGDatabase.help.txt
- DSCResources\MSFT_SqlAGDatabase\en-US\MSFT_SqlAGDatabase.strings.psd1
- DSCResources\MSFT_SqlAGListener\MSFT_SqlAGListener.psm1
- DSCResources\MSFT_SqlAGListener\MSFT_SqlAGListener.schema.mof
- DSCResources\MSFT_SqlAGReplica\MSFT_SqlAGReplica.psm1
- DSCResources\MSFT_SqlAGReplica\MSFT_SqlAGReplica.schema.mof
- DSCResources\MSFT_SqlAlias\MSFT_SqlAlias.psm1
- DSCResources\MSFT_SqlAlias\MSFT_SqlAlias.schema.mof
- DSCResources\MSFT_SqlAlwaysOnService\MSFT_SqlAlwaysOnService.psm1
- DSCResources\MSFT_SqlAlwaysOnService\MSFT_SqlAlwaysOnService.schema.mof
- DSCResources\MSFT_SqlDatabase\MSFT_SqlDatabase.psm1
- DSCResources\MSFT_SqlDatabase\MSFT_SqlDatabase.schema.mof
- DSCResources\MSFT_SqlDatabaseDefaultLocation\MSFT_SqlDatabaseDefaultLocation.psm1
- DSCResources\MSFT_SqlDatabaseDefaultLocation\MSFT_SqlDatabaseDefaultLocation.schema.mof
- DSCResources\MSFT_SqlDatabaseDefaultLocation\en-US\MSFT_SqlDatabaseDefaultLocation.strings.psd1
- DSCResources\MSFT_SqlDatabaseOwner\MSFT_SqlDatabaseOwner.psm1
- DSCResources\MSFT_SqlDatabaseOwner\MSFT_SqlDatabaseOwner.schema.mof
- DSCResources\MSFT_SqlDatabasePermission\MSFT_SqlDatabasePermission.psm1
- DSCResources\MSFT_SqlDatabasePermission\MSFT_SqlDatabasePermission.schema.mof
- DSCResources\MSFT_SqlDatabaseRecoveryModel\MSFT_SqlDatabaseRecoveryModel.psm1
- DSCResources\MSFT_SqlDatabaseRecoveryModel\MSFT_SqlDatabaseRecoveryModel.schema.mof
- DSCResources\MSFT_SqlDatabaseRole\MSFT_SqlDatabaseRole.psm1
- DSCResources\MSFT_SqlDatabaseRole\MSFT_SqlDatabaseRole.schema.mof
- DSCResources\MSFT_SqlRS\MSFT_SqlRS.psm1
- DSCResources\MSFT_SqlRS\MSFT_SqlRS.schema.mof
- DSCResources\MSFT_SqlScript\MSFT_SqlScript.psm1
- DSCResources\MSFT_SqlScript\MSFT_SqlScript.schema.mof
- DSCResources\MSFT_SqlScriptQuery\MSFT_SqlScriptQuery.psm1
- DSCResources\MSFT_SqlScriptQuery\MSFT_SqlScriptQuery.schema.mof
- DSCResources\MSFT_SqlServerConfiguration\MSFT_SqlServerConfiguration.psm1
- DSCResources\MSFT_SqlServerConfiguration\MSFT_SqlServerConfiguration.schema.mof
- DSCResources\MSFT_SqlServerConfiguration\en-US\MSFT_SqlServerConfiguration.strings.psd1
- DSCResources\MSFT_SqlServerDatabaseMail\MSFT_SqlServerDatabaseMail.psm1
- DSCResources\MSFT_SqlServerDatabaseMail\MSFT_SqlServerDatabaseMail.schema.mof
- DSCResources\MSFT_SqlServerDatabaseMail\en-US\MSFT_SqlServerDatabaseMail.strings.psd1
- DSCResources\MSFT_SqlServerEndpoint\MSFT_SqlServerEndpoint.psm1
- DSCResources\MSFT_SqlServerEndpoint\MSFT_SqlServerEndpoint.schema.mof
- DSCResources\MSFT_SqlServerEndpointPermission\MSFT_SqlServerEndpointPermission.psm1
- DSCResources\MSFT_SqlServerEndpointPermission\MSFT_SqlServerEndpointPermission.schema.mof
- DSCResources\MSFT_SqlServerEndpointState\MSFT_SqlServerEndpointState.psm1
- DSCResources\MSFT_SqlServerEndpointState\MSFT_SqlServerEndpointState.schema.mof
- DSCResources\MSFT_SqlServerLogin\MSFT_SqlServerLogin.psm1
- DSCResources\MSFT_SqlServerLogin\MSFT_SqlServerLogin.schema.mof
- DSCResources\MSFT_SqlServerMaxDop\MSFT_SqlServerMaxDop.psm1
- DSCResources\MSFT_SqlServerMaxDop\MSFT_SqlServerMaxDop.schema.mof
- DSCResources\MSFT_SqlServerMemory\MSFT_SqlServerMemory.psm1
- DSCResources\MSFT_SqlServerMemory\MSFT_SqlServerMemory.schema.mof
- DSCResources\MSFT_SqlServerNetwork\MSFT_SqlServerNetwork.psm1
- DSCResources\MSFT_SqlServerNetwork\MSFT_SqlServerNetwork.schema.mof
- DSCResources\MSFT_SqlServerNetwork\en-US\MSFT_SqlServerNetwork.strings.psd1
- DSCResources\MSFT_SqlServerPermission\MSFT_SqlServerPermission.psm1
- DSCResources\MSFT_SqlServerPermission\MSFT_SqlServerPermission.schema.mof
- DSCResources\MSFT_SqlServerReplication\MSFT_SqlServerReplication.psm1
- DSCResources\MSFT_SqlServerReplication\MSFT_SqlServerReplication.schema.mof
- DSCResources\MSFT_SqlServerRole\MSFT_SqlServerRole.psm1
- DSCResources\MSFT_SqlServerRole\MSFT_SqlServerRole.schema.mof
- DSCResources\MSFT_SqlServerRole\en-US\MSFT_SqlServerRole.strings.psd1
- DSCResources\MSFT_SqlServerSecureConnection\MSFT_SqlServerSecureConnection.psm1
- DSCResources\MSFT_SqlServerSecureConnection\MSFT_SqlServerSecureConnection.schema.mof
- DSCResources\MSFT_SqlServerSecureConnection\en-US\MSFT_SqlServerSecureConnection.strings.psd1
- DSCResources\MSFT_SqlServiceAccount\MSFT_SqlServiceAccount.psm1
- DSCResources\MSFT_SqlServiceAccount\MSFT_SqlServiceAccount.schema.mof
- DSCResources\MSFT_SqlServiceAccount\en-US\MSFT_SqlServiceAccount.strings.psd1
- DSCResources\MSFT_SqlSetup\MSFT_SqlSetup.psm1
- DSCResources\MSFT_SqlSetup\MSFT_SqlSetup.schema.mof
- DSCResources\MSFT_SqlSetup\en-US\MSFT_SqlSetup.strings.psd1
- DSCResources\MSFT_SqlSetup\sv-SE\MSFT_SqlSetup.strings.psd1
- DSCResources\MSFT_SqlWaitForAG\MSFT_SqlWaitForAG.psm1
- DSCResources\MSFT_SqlWaitForAG\MSFT_SqlWaitForAG.schema.mof
- DSCResources\MSFT_SqlWindowsFirewall\MSFT_SqlWindowsFirewall.psm1
- DSCResources\MSFT_SqlWindowsFirewall\MSFT_SqlWindowsFirewall.schema.mof
- en-US\SqlServerDscHelper.strings.psd1
- Examples\README.md
- Examples\Resources\SqlAG\1-CreateAvailabilityGroup.ps1
- Examples\Resources\SqlAG\2-RemoveAvailabilityGroup.ps1
- Examples\Resources\SqlAG\3-CreateAvailabilityGroupDetailed.ps1
- Examples\Resources\SqlAGDatabase\1-AddDatabaseToAvailabilityGroup.ps1
- Examples\Resources\SqlAGDatabase\2-RemoveDatabaseFromAvailabilityGroup.ps1
- Examples\Resources\SqlAGDatabase\3-MatchDefinedDatabaseInAvailabilityGroup.ps1
- Examples\Resources\SqlAGListener\1-AddAvailabilityGroupListenerWithSameNameAsVCO.ps1
- Examples\Resources\SqlAGListener\2-AddAvailabilityGroupListenerWithDifferentNameAsVCO.ps1
- Examples\Resources\SqlAGListener\3-RemoveAvailabilityGroupListenerWithSameNameAsVCO.ps1
- Examples\Resources\SqlAGListener\4-RemoveAvailabilityGroupListenerWithDifferentNameAsVCO.ps1
- Examples\Resources\SqlAGListener\5-AddAvailabilityGroupListenerUsingDHCPWithDefaultServerSubnet.ps1
- Examples\Resources\SqlAGListener\6-AddAvailabilityGroupListenerUsingDHCPWithSpecificSubnet.ps1
- Examples\Resources\SqlAGReplica\1-CreateAvailabilityGroupReplica.ps1
- Examples\Resources\SqlAGReplica\2-RemoveAvailabilityGroupReplica.ps1
- Examples\Resources\SqlAlias\1-AddSqlAlias.ps1
- Examples\Resources\SqlAlias\2-RemoveSqlAlias.ps1
- Examples\Resources\SqlAlwaysOnService\1-EnableAlwaysOn.ps1
- Examples\Resources\SqlAlwaysOnService\2-DisableAlwaysOn.ps1
- Examples\Resources\SqlDatabase\1-CreateDatabase.ps1
- Examples\Resources\SqlDatabase\2-DeleteDatabase.ps1
- Examples\Resources\SqlDatabaseDefaultLocation\1-SetDatabaseDefaultLocation.ps1
- Examples\Resources\SqlDatabaseOwner\1-SetDatabaseOwner.ps1
- Examples\Resources\SqlDatabasePermission\1-GrantDatabasePermissions.ps1
- Examples\Resources\SqlDatabasePermission\2-RevokeDatabasePermissions.ps1
- Examples\Resources\SqlDatabasePermission\3-DenyDatabasePermissions.ps1
- Examples\Resources\SqlDatabaseRecoveryModel\1-SetDatabaseRecoveryModel.ps1
- Examples\Resources\SqlDatabaseRole\1-AddDatabaseRole.ps1
- Examples\Resources\SqlDatabaseRole\2-RemoveDatabaseRole.ps1
- Examples\Resources\SqlRS\1-DefaultConfiguration.ps1
- Examples\Resources\SqlRS\2-CustomConfiguration.ps1
- Examples\Resources\SqlRS\3-CustomConfigurationUsingSsl.ps1
- Examples\Resources\SqlRS\4-CompleteWithTwoInstances.ps1
- Examples\Resources\SqlScript\1-RunScriptUsingSQLAuthentication.ps1
- Examples\Resources\SqlScript\2-RunScriptUsingWindowsAuthentication.ps1
- Examples\Resources\SqlScript\3-RunScriptCompleteExample.ps1
- Examples\Resources\SqlScriptQuery\1-RunScriptUsingSQLAuthentication.ps1
- Examples\Resources\SqlScriptQuery\2-RunScriptUsingWindowsAuthentication.ps1
- Examples\Resources\SqlScriptQuery\3-RunScriptCompleteExample.ps1
- Examples\Resources\SqlServerConfiguration\1-ConfigureTwoInstancesOnTheSameServerToEnableClr.ps1
- Examples\Resources\SqlServerConfiguration\2-ConfigureInstanceToEnablePriorityBoost.ps1
- Examples\Resources\SqlServerDatabaseMail\1-EnableDatabaseMail.ps1
- Examples\Resources\SqlServerDatabaseMail\2-DisableDatabaseMail.ps1
- Examples\Resources\SqlServerEndpoint\1-CreateEndpointWithDefaultValues.ps1
- Examples\Resources\SqlServerEndpoint\2-CreateEndpointWithSpecificPortAndIPAddress.ps1
- Examples\Resources\SqlServerEndpoint\3-RemoveEndpoint.ps1
- Examples\Resources\SqlServerEndpointPermission\1-AddConnectPermission.ps1
- Examples\Resources\SqlServerEndpointPermission\2-RemoveConnectPermission.ps1
- Examples\Resources\SqlServerEndpointPermission\3-AddConnectPermissionToTwoReplicasEachWithDifferentServiceAccount.ps1
- Examples\Resources\SqlServerEndpointPermission\4-RemoveConnectPermissionForTwoReplicasEachWithDifferentServiceAccount.ps1
- Examples\Resources\SqlServerEndpointState\1-MakeSureEndpointIsStarted.ps1
- Examples\Resources\SqlServerEndpointState\2-MakeSureEndpointIsStopped.ps1
- Examples\Resources\SqlServerLogin\1-AddLogin.ps1
- Examples\Resources\SqlServerLogin\2-RemoveLogin.ps1
- Examples\Resources\SqlServerMaxDop\1-SetMaxDopToOne.ps1
- Examples\Resources\SqlServerMaxDop\2-SetMaxDopToAuto.ps1
- Examples\Resources\SqlServerMaxDop\3-SetMaxDopToDefault.ps1
- Examples\Resources\SqlServerMemory\1-SetMaxMemoryTo12GB.ps1
- Examples\Resources\SqlServerMemory\2-SetMaxMemoryToAuto.ps1
- Examples\Resources\SqlServerMemory\3-SetMinMemoryToFixedValueAndMaxMemoryToAuto.ps1
- Examples\Resources\SqlServerMemory\4-SetMaxMemoryToDefault.ps1
- Examples\Resources\SqlServerNetwork\1-EnableTcpIpWithStaticPort.ps1
- Examples\Resources\SqlServerNetwork\2-EnableTcpIpWithDynamicPort.ps1
- Examples\Resources\SqlServerPermission\1-AddServerPermissionForLogin.ps1
- Examples\Resources\SqlServerPermission\2-RemoveServerPermissionForLogin.ps1
- Examples\Resources\SqlServerReplication\1-ConfigureInstanceAsDistributor.ps1
- Examples\Resources\SqlServerReplication\2-ConfigureInstanceAsPublisher.ps1
- Examples\Resources\SqlServerRole\1-AddServerRole.ps1
- Examples\Resources\SqlServerRole\2-RemoveServerRole.ps1
- Examples\Resources\SqlServerRole\3-AddMembersToServerRole.ps1
- Examples\Resources\SqlServerRole\4-MembersToIncludeInServerRole.ps1
- Examples\Resources\SqlServerRole\5-MembersToExcludeInServerRole.ps1
- Examples\Resources\SqlServerSecureConnection\1-ForceSecureConnection.ps1
- Examples\Resources\SqlServerSecureConnection\2-SecureConnectionNotForced.ps1
- Examples\Resources\SqlServerSecureConnection\3-SecureConnectionAbsent.ps1
- Examples\Resources\SqlServiceAccount\1-ConfigureServiceAccount-UserAccount.ps1
- Examples\Resources\SqlServiceAccount\2-ConfigureServiceAccount-VirtualAccount.ps1
- Examples\Resources\SqlSetup\1-InstallDefaultInstanceSingleServer.ps1
- Examples\Resources\SqlSetup\2-InstallNamedInstanceSingleServer.ps1
- Examples\Resources\SqlSetup\3-InstallNamedInstanceSingleServerFromUncPathUsingSourceCredential.ps1
- Examples\Resources\SqlSetup\4-InstallNamedInstanceInFailoverClusterFirstNode.ps1
- Examples\Resources\SqlSetup\5-InstallNamedInstanceInFailoverClusterSecondNode.ps1
- Examples\Resources\SqlSetup\6-InstallNamedInstanceSingleServerWithAgtSvcStartupTypeDisabled.ps1
- Examples\Resources\SqlWaitForAG\1-WaitForASingleClusterGroup.ps1
- Examples\Resources\SqlWaitForAG\2-WaitForMultipleClusterGroups.ps1
- Examples\Resources\SqlWindowsFirewall\1-CreateInboundFirewallRules.ps1
- Examples\Resources\SqlWindowsFirewall\2-RemoveInboundFirewallRules.ps1
- sv-SE\SqlServerDscHelper.strings.psd1
- Tests\Tests.depend.psd1
- Tests\Integration\MSFT_SqlAlwaysOnService.config.ps1
- Tests\Integration\MSFT_SqlAlwaysOnService.Integration.Tests.ps1
- Tests\Integration\MSFT_SqlDatabaseDefaultLocation.config.ps1
- Tests\Integration\MSFT_SqlDatabaseDefaultLocation.Integration.Tests.ps1
- Tests\Integration\MSFT_SqlRS.config.ps1
- Tests\Integration\MSFT_SqlRS.Integration.Tests.ps1
- Tests\Integration\MSFT_SqlScript.config.ps1
- Tests\Integration\MSFT_SqlScript.Integration.Tests.ps1
- Tests\Integration\MSFT_SqlScriptQuery.config.ps1
- Tests\Integration\MSFT_SqlScriptQuery.Integration.Tests.ps1
- Tests\Integration\MSFT_SqlServerDatabaseMail.config.ps1
- Tests\Integration\MSFT_SqlServerDatabaseMail.Integration.Tests.ps1
- Tests\Integration\MSFT_SqlServerLogin.config.ps1
- Tests\Integration\MSFT_SqlServerLogin.Integration.Tests.ps1
- Tests\Integration\MSFT_SqlServerNetwork.config.ps1
- Tests\Integration\MSFT_SqlServerNetwork.Integration.Tests.ps1
- Tests\Integration\MSFT_SqlServerRole.config.ps1
- Tests\Integration\MSFT_SqlServerRole.Integration.Tests.ps1
- Tests\Integration\MSFT_SqlServerSecureConnection.config.ps1
- Tests\Integration\MSFT_SqlServerSecureConnection.Integration.Tests.ps1
- Tests\Integration\MSFT_SqlServiceAccount.config.ps1
- Tests\Integration\MSFT_SqlServiceAccount.Integration.Tests.ps1
- Tests\Integration\MSFT_SqlSetup.config.ps1
- Tests\Integration\MSFT_SqlSetup.Integration.Tests.ps1
- Tests\Integration\README.md
- Tests\TestHelpers\CommonTestHelper.psm1
- Tests\Unit\CommonResourceHelper.Tests.ps1
- Tests\Unit\MSFT_SqlAG.Tests.ps1
- Tests\Unit\MSFT_SqlAGDatabase.Tests.ps1
- Tests\Unit\MSFT_SqlAGListener.Tests.ps1
- Tests\Unit\MSFT_SqlAGReplica.Tests.ps1
- Tests\Unit\MSFT_SqlAlias.Tests.ps1
- Tests\Unit\MSFT_SqlAlwaysOnService.Tests.ps1
- Tests\Unit\MSFT_SqlDatabase.Tests.ps1
- Tests\Unit\MSFT_SqlDatabaseDefaultLocation.Tests.ps1
- Tests\Unit\MSFT_SqlDatabaseOwner.Tests.ps1
- Tests\Unit\MSFT_SqlDatabasePermission.Tests.ps1
- Tests\Unit\MSFT_SqlDatabaseRecoveryModel.Tests.ps1
- Tests\Unit\MSFT_SqlDatabaseRole.Tests.ps1
- Tests\Unit\MSFT_SqlRS.Tests.ps1
- Tests\Unit\MSFT_SqlScript.Tests.ps1
- Tests\Unit\MSFT_SqlScriptQuery.Tests.ps1
- Tests\Unit\MSFT_SqlServerConfiguration.Tests.ps1
- Tests\Unit\MSFT_SqlServerDatabaseMail.Tests.ps1
- Tests\Unit\MSFT_SqlServerEndpoint.Tests.ps1
- Tests\Unit\MSFT_SqlServerEndpointPermission.Tests.ps1
- Tests\Unit\MSFT_SqlServerEndpointState.Tests.ps1
- Tests\Unit\MSFT_SqlServerLogin.Tests.ps1
- Tests\Unit\MSFT_SqlServerMaxDop.Tests.ps1
- Tests\Unit\MSFT_SqlServerMemory.Tests.ps1
- Tests\Unit\MSFT_SqlServerNetwork.Tests.ps1
- Tests\Unit\MSFT_SqlServerPermission.Tests.ps1
- Tests\Unit\MSFT_SqlServerReplication.Tests.ps1
- Tests\Unit\MSFT_SqlServerRole.Tests.ps1
- Tests\Unit\MSFT_SqlServerSecureConnection.Tests.ps1
- Tests\Unit\MSFT_SqlServiceAccount.Tests.ps1
- Tests\Unit\MSFT_SqlSetup.Tests.ps1
- Tests\Unit\MSFT_SqlWaitForAG.Tests.ps1
- Tests\Unit\MSFT_SqlWindowsFirewall.Tests.ps1
- Tests\Unit\SqlServerDSCHelper.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
Version History
Version | Downloads | Last updated |
---|---|---|
17.0.1-previ... | 38 | 10/29/2024 |
17.0.1-previ... | 6 | 10/26/2024 |
17.0.1-previ... | 14 | 10/7/2024 |
17.0.0 | 59,479 | 9/30/2024 |
17.0.0-previ... | 4 | 9/29/2024 |
17.0.0-previ... | 48 | 8/13/2024 |
16.6.1-previ... | 118 | 5/23/2024 |
16.6.1-previ... | 5 | 5/22/2024 |
16.6.0 | 91,157 | 5/17/2024 |
16.6.0-previ... | 10 | 5/12/2024 |
16.6.0-previ... | 4 | 5/11/2024 |
16.6.0-previ... | 104 | 3/3/2024 |
16.6.0-previ... | 46 | 1/20/2024 |
16.6.0-previ... | 6 | 1/19/2024 |
16.5.1-previ... | 68 | 12/15/2023 |
16.5.1-previ... | 91 | 11/19/2023 |
16.5.1-previ... | 47 | 11/2/2023 |
16.5.0 | 144,852 | 10/5/2023 |
16.5.0-previ... | 12 | 10/1/2023 |
16.5.0-previ... | 7 | 9/29/2023 |
16.5.0-previ... | 47 | 9/1/2023 |
16.5.0-previ... | 7 | 8/26/2023 |
16.4.1-previ... | 6 | 8/25/2023 |
16.4.0 | 111,511 | 8/22/2023 |
16.4.0-previ... | 5 | 8/20/2023 |
16.4.0-previ... | 5 | 8/20/2023 |
16.4.0-previ... | 6 | 8/19/2023 |
16.4.0-previ... | 76 | 5/18/2023 |
16.4.0-previ... | 20 | 5/10/2023 |
16.4.0-previ... | 6 | 5/9/2023 |
16.4.0-previ... | 7 | 5/8/2023 |
16.3.1 | 460,119 | 5/6/2023 |
16.3.1-previ... | 5 | 5/6/2023 |
16.3.1-previ... | 9 | 5/4/2023 |
16.3.0 | 42,263 | 4/26/2023 |
16.3.0-previ... | 7 | 4/26/2023 |
16.3.0-previ... | 7 | 4/25/2023 |
16.3.0-previ... | 6 | 4/24/2023 |
16.3.0-previ... | 6 | 4/23/2023 |
16.3.0-previ... | 21 | 4/18/2023 |
16.3.0-previ... | 5 | 4/16/2023 |
16.2.1-previ... | 7 | 4/12/2023 |
16.2.0 | 75,159 | 4/10/2023 |
16.2.0-previ... | 5 | 4/10/2023 |
16.2.0-previ... | 5 | 4/8/2023 |
16.2.0-previ... | 5 | 4/8/2023 |
16.2.0-previ... | 10 | 4/6/2023 |
16.2.0-previ... | 10 | 4/1/2023 |
16.2.0-previ... | 11 | 3/28/2023 |
16.2.0-previ... | 10 | 3/26/2023 |
16.2.0-previ... | 5 | 3/25/2023 |
16.2.0-previ... | 170 | 3/19/2023 |
16.2.0-previ... | 27 | 3/7/2023 |
16.2.0-previ... | 10 | 3/4/2023 |
16.1.0 | 175,574 | 2/28/2023 |
16.1.0-previ... | 6 | 2/28/2023 |
16.1.0-previ... | 9 | 2/25/2023 |
16.1.0-previ... | 6 | 2/24/2023 |
16.1.0-previ... | 48 | 2/13/2023 |
16.1.0-previ... | 28 | 2/12/2023 |
16.1.0-previ... | 25 | 2/5/2023 |
16.1.0-previ... | 11 | 2/1/2023 |
16.1.0-previ... | 29 | 1/25/2023 |
16.1.0-previ... | 8 | 1/24/2023 |
16.1.0-previ... | 5 | 1/24/2023 |
16.1.0-previ... | 12 | 1/22/2023 |
16.1.0-previ... | 346 | 1/4/2023 |
16.1.0-previ... | 6 | 1/3/2023 |
16.1.0-previ... | 15 | 12/26/2022 |
16.1.0-previ... | 50 | 12/19/2022 |
16.1.0-previ... | 13 | 12/17/2022 |
16.1.0-previ... | 115 | 12/11/2022 |
16.1.0-previ... | 13 | 12/4/2022 |
16.1.0-previ... | 36 | 11/26/2022 |
16.1.0-previ... | 11 | 11/24/2022 |
16.0.1-previ... | 31 | 11/11/2022 |
16.0.0 | 827,650 | 9/9/2022 |
16.0.0-previ... | 30 | 8/21/2022 |
16.0.0-previ... | 24 | 8/13/2022 |
16.0.0-previ... | 15 | 8/13/2022 |
16.0.0-previ... | 26 | 8/1/2022 |
16.0.0-previ... | 81 | 6/14/2022 |
16.0.0-previ... | 25 | 6/8/2022 |
16.0.0-previ... | 18 | 6/6/2022 |
16.0.0-previ... | 15 | 6/6/2022 |
16.0.0-previ... | 89 | 4/26/2022 |
16.0.0-previ... | 45 | 3/28/2022 |
16.0.0-previ... | 66 | 2/12/2022 |
15.2.0 | 2,684,689 | 9/1/2021 |
15.2.0-previ... | 16 | 9/1/2021 |
15.2.0-previ... | 45 | 7/23/2021 |
15.2.0-previ... | 76 | 6/6/2021 |
15.2.0-previ... | 66 | 4/18/2021 |
15.2.0-previ... | 86 | 3/12/2021 |
15.1.1 | 1,394,521 | 2/12/2021 |
15.1.1-previ... | 18 | 2/12/2021 |
15.1.0 | 62,465 | 2/2/2021 |
15.1.0-previ... | 25 | 2/1/2021 |
15.1.0-previ... | 20 | 1/31/2021 |
15.0.2-previ... | 19 | 1/30/2021 |
15.0.2-previ... | 25 | 1/24/2021 |
15.0.2-previ... | 63 | 1/21/2021 |
15.0.2-previ... | 62 | 1/12/2021 |
15.0.1 | 143,076 | 1/9/2021 |
15.0.1-previ... | 59 | 1/9/2021 |
15.0.1-previ... | 64 | 1/6/2021 |
15.0.1-previ... | 60 | 1/6/2021 |
15.0.1-previ... | 69 | 12/27/2020 |
15.0.1-previ... | 61 | 12/26/2020 |
15.0.1-previ... | 63 | 12/23/2020 |
15.0.1-previ... | 71 | 12/14/2020 |
15.0.1-previ... | 62 | 12/13/2020 |
15.0.1-previ... | 60 | 12/12/2020 |
15.0.1-previ... | 61 | 12/10/2020 |
15.0.0 | 214,559 | 12/6/2020 |
15.0.0-previ... | 61 | 12/6/2020 |
15.0.0-previ... | 66 | 11/25/2020 |
15.0.0-previ... | 58 | 11/22/2020 |
15.0.0-previ... | 62 | 11/21/2020 |
14.3.0-previ... | 99 | 10/5/2020 |
14.3.0-previ... | 55 | 10/3/2020 |
14.3.0-previ... | 61 | 10/2/2020 |
14.2.2-previ... | 105 | 8/19/2020 |
14.2.2-previ... | 61 | 8/16/2020 |
14.2.1 | 642,433 | 8/14/2020 |
14.2.1-previ... | 60 | 8/13/2020 |
14.2.1-previ... | 61 | 8/11/2020 |
14.2.1-previ... | 57 | 8/11/2020 |
14.2.1-previ... | 72 | 7/31/2020 |
14.2.1-previ... | 60 | 7/28/2020 |
14.2.0 | 72,592 | 7/23/2020 |
14.2.0-previ... | 63 | 7/23/2020 |
14.2.0-previ... | 65 | 7/19/2020 |
14.2.0-previ... | 74 | 7/13/2020 |
14.2.0-previ... | 65 | 7/10/2020 |
14.2.0-previ... | 62 | 7/9/2020 |
14.1.1-previ... | 64 | 7/9/2020 |
14.1.0 | 221,776 | 7/6/2020 |
14.1.0-previ... | 369 | 7/5/2020 |
14.1.0-previ... | 61 | 7/4/2020 |
14.1.0-previ... | 62 | 7/4/2020 |
14.1.0-previ... | 64 | 7/3/2020 |
14.1.0-previ... | 66 | 7/1/2020 |
14.0.1-previ... | 72 | 6/28/2020 |
14.0.1-previ... | 61 | 6/26/2020 |
14.0.0 | 10,844 | 6/12/2020 |
14.0.0-previ... | 62 | 6/12/2020 |
14.0.0-previ... | 68 | 6/11/2020 |
14.0.0-previ... | 70 | 6/10/2020 |
14.0.0-previ... | 69 | 6/10/2020 |
14.0.0-previ... | 103 | 5/28/2020 |
14.0.0-previ... | 78 | 5/25/2020 |
14.0.0-previ... | 68 | 5/25/2020 |
14.0.0-previ... | 80 | 5/19/2020 |
14.0.0-previ... | 76 | 5/19/2020 |
14.0.0-previ... | 82 | 5/17/2020 |
14.0.0-previ... | 71 | 5/17/2020 |
14.0.0-previ... | 69 | 5/16/2020 |
14.0.0-previ... | 70 | 5/14/2020 |
14.0.0-previ... | 72 | 5/13/2020 |
14.0.0-previ... | 80 | 5/12/2020 |
14.0.0-previ... | 70 | 5/12/2020 |
14.0.0-previ... | 70 | 5/12/2020 |
14.0.0-previ... | 83 | 5/8/2020 |
14.0.0-previ... | 69 | 5/6/2020 |
14.0.0-previ... | 73 | 5/5/2020 |
14.0.0-previ... | 71 | 5/4/2020 |
14.0.0-previ... | 70 | 5/3/2020 |
14.0.0-previ... | 69 | 5/3/2020 |
14.0.0-previ... | 84 | 4/27/2020 |
14.0.0-previ... | 79 | 4/26/2020 |
13.5.0 | 28,417 | 4/12/2020 |
13.5.0-previ... | 76 | 4/11/2020 |
13.5.0-previ... | 78 | 4/11/2020 |
13.4.1-previ... | 105 | 3/31/2020 |
13.4.0 | 122,350 | 3/18/2020 |
13.4.0-previ... | 71 | 3/18/2020 |
13.3.1-previ... | 117 | 1/18/2020 |
13.3.0 | 480,530 | 1/17/2020 |
13.3.0-previ... | 74 | 1/17/2020 |
13.3.0-previ... | 79 | 1/12/2020 |
13.3.0-previ... | 73 | 1/8/2020 |
13.3.0-previ... | 76 | 1/7/2020 |
13.3.0-previ... | 73 | 1/3/2020 |
13.3.0-previ... | 74 | 1/2/2020 |
13.3.0-previ... | 75 | 1/2/2020 |
13.2.0.0 | 861,908 | 9/19/2019 |
13.1.0.0 | 35,024 | 8/8/2019 |
13.0.0.0 | 26,042 | 6/26/2019 |
12.5.0.0 | 17,403 | 5/15/2019 |
12.4.0.0 | 21,748 | 4/3/2019 |
12.3.0.0 | 40,231 | 2/20/2019 |
12.2.0.0 | 9,018 | 1/10/2019 |
12.1.0.0 (current version) | 23,283 | 10/25/2018 |
12.0.0.0 | 21,441 | 9/5/2018 |
11.4.0.0 | 16,156 | 7/25/2018 |
11.3.0.0 | 7,383 | 6/13/2018 |
11.2.0.0 | 5,234 | 5/2/2018 |
11.1.0.0 | 6,228 | 3/22/2018 |
11.0.0.0 | 13,544 | 2/8/2018 |
10.0.0.0 | 3,650 | 12/14/2017 |