SqlServerDsc
12.3.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 SqlAgentOperator 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
- Reverting the change that was made as part of the
[issue 1260](https://github.com/PowerShell/SqlServerDsc/issues/1260)
in the previous release, as it only mitigated the issue, it did not
solve the issue.
- Removed the container testing since that broke the integration tests,
possible due to using excessive amount of memory on the AppVeyor build
worker. This will make the unit tests to take a bit longer to run
([issue 1260](https://github.com/PowerShell/SqlServerDsc/issues/1260)).
- The unit tests and the integration tests are now run in two separate
build workers in AppVeyor. One build worker runs the integration tests,
while a second build worker runs the unit tests. The build workers runs
in parallel on paid accounts, but sequentially on free accounts
([issue 1260](https://github.com/PowerShell/SqlServerDsc/issues/1260)).
- Clean up error handling in some of the integration tests that was
part of a workaround for a bug in Pester. The bug is resolved, and
the error handling is not again built into Pester.
- Speeding up the AppVeyor tests by splitting the common tests in a
separate build job.
- Updated the appveyor.yml to have the correct build step, and also
correct run the build step only in one of the jobs.
- Update integration tests to use the new integration test template.
- Added SqlAgentOperator resource.
- Changes to SqlServiceAccount
- Fixed Get-ServiceObject when searching for Integration Services service.
Unlike the rest of SQL Server services, the Integration Services service
cannot be instanced, however you can have multiple versions installed.
Get-Service object would return the correct service name that you
are looking for, but it appends the version number at the end. Added
parameter VersionNumber so the search would return the correct
service name.
- Added code to allow for using Managed Service Accounts.
- Now the correct service type string value is returned by the function
`Get-TargetResource`. Previously one value was passed in as a parameter
(e.g. `DatabaseEngine`), but a different string value as returned
(e.g. `SqlServer`). Now `Get-TargetResource` return the same values
that can be passed as values in the parameter `ServiceType`
([issue 981](https://github.com/PowerShell/SqlServerDsc/issues/981)).
- Changes to SqlServerLogin
- Fixed issue in Test-TargetResource to valid password on disabled accounts
([issue 915](https://github.com/PowerShell/SqlServerDsc/issues/915)).
- Now when adding a login of type SqlLogin, and the SQL Server login mode
is set to `"Integrated"`, an error is correctly thrown
([issue 1179](https://github.com/PowerShell/SqlServerDsc/issues/1179)).
- Changes to SqlSetup
- Updated the integration test to stop the named instance while installing
the other instances to mitigate
[issue 1260](https://github.com/PowerShell/SqlServerDsc/issues/1260).
- Add parameters to configure the Tempdb files during the installation of
the instance. The new parameters are SqlTempdbFileCount, SqlTempdbFileSize,
SqlTempdbFileGrowth, SqlTempdbLogFileSize and SqlTempdbLogFileGrowth
([issue 1167](https://github.com/PowerShell/SqlServerDsc/issues/1167)).
- Changes to SqlServerEndpoint
- Add the optional parameter Owner. The default owner remains the login used
for the creation of the endpoint
([issue 1251](https://github.com/PowerShell/SqlServerDsc/issues/1251)).
[Maxime Daniou (@mdaniou)](https://github.com/mdaniou)
- Add integration tests
([issue 744](https://github.com/PowerShell/SqlServerDsc/issues/744)).
[Maxime Daniou (@mdaniou)](https://github.com/mdaniou)
FileList
- SqlServerDsc.nuspec
- Assert-TestEnvironment.ps1
- CHANGELOG.md
- CODE_OF_CONDUCT.md
- CONTRIBUTING.md
- LICENSE
- README.md
- SqlServerDsc.psd1
- SqlServerDscHelper.psm1
- 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_SqlAgentOperator\MSFT_SqlAgentOperator.psm1
- DSCResources\MSFT_SqlAgentOperator\MSFT_SqlAgentOperator.schema.mof
- DSCResources\MSFT_SqlAgentOperator\en-US\MSFT_SqlAgentOperator.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\SqlAgentOperator\1-AddOperator.ps1
- Examples\Resources\SqlAgentOperator\2-RemoveOperator.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-CreateEndpointWithSpecificPortIPAddressOwner.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\SqlSetup\7-InstallDefaultInstanceSingleServer2016OrLater.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_SqlAgentOperator.config.ps1
- Tests\Integration\MSFT_SqlAgentOperator.Integration.Tests.ps1
- 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_SqlServerEndPoint.config.ps1
- Tests\Integration\MSFT_SqlServerEndPoint.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_SqlAgentOperator.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... | 36 | 10/29/2024 |
17.0.1-previ... | 6 | 10/26/2024 |
17.0.1-previ... | 14 | 10/7/2024 |
17.0.0 | 53,705 | 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,147 | 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,823 | 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,510 | 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,096 | 5/6/2023 |
16.3.1-previ... | 5 | 5/6/2023 |
16.3.1-previ... | 9 | 5/4/2023 |
16.3.0 | 42,259 | 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,158 | 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,571 | 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,624 | 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,666 | 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,098 | 2/12/2021 |
15.1.1-previ... | 18 | 2/12/2021 |
15.1.0 | 62,461 | 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,551 | 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,364 | 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,523 | 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,906 | 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,396 | 5/15/2019 |
12.4.0.0 | 21,748 | 4/3/2019 |
12.3.0.0 (current version) | 40,231 | 2/20/2019 |
12.2.0.0 | 9,018 | 1/10/2019 |
12.1.0.0 | 23,280 | 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,233 | 5/2/2018 |
11.1.0.0 | 6,228 | 3/22/2018 |
11.0.0.0 | 13,532 | 2/8/2018 |
10.0.0.0 | 3,650 | 12/14/2017 |