SqlServerDsc
13.0.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 SqlAgentAlert SqlAgentOperator SqlAGListener SqlAGReplica SqlAlias SqlAlwaysOnService SqlDatabase SqlDatabaseDefaultLocation SqlDatabaseOwner SqlDatabasePermission SqlDatabaseRecoveryModel SqlDatabaseRole SqlRS SqlRSSetup 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
- Added SqlAgentAlert resource.
- Opt-in to the common test "Common Test - Validation Localization".
- Opt-in to the common test "Common Test - Flagged Script Analyzer Rules"
([issue 1101](https://github.com/PowerShell/SqlServerDsc/issues/1101)).
- Removed the helper function `New-TerminatingError`, `New-WarningMessage`
and `New-VerboseMessage` in favor of the the new
[localization helper functions](https://github.com/PowerShell/DscResources/blob/master/StyleGuidelines.mdlocalization).
- Combine DscResource.LocalizationHelper and DscResource.Common into
SqlServerDsc.Common ([issue 1357](https://github.com/PowerShell/SqlServerDsc/issues/1357)).
- Update Assert-TestEnvironment.ps1 to not error if strict mode is enabled
and there are no missing dependencies ([issue 1368](https://github.com/PowerShell/SqlServerDsc/issues/1368)).
- Changes to SqlServerDsc.Common
- Added StatementTimeout to function "Connect-SQL" with default 600 seconds (10mins).
- Added StatementTimeout to function "Invoke-Query" with default 600 seconds (10mins)
([issue 1358](https://github.com/PowerShell/SqlServerDsc/issues/1358)).
- Changes to helper function Connect-SQL
- The function now make it more clear that when using the parameter
`SetupCredential` is impersonates that user, and by default it does
not impersonates a user but uses the credential that the resource
is run as (for example the built-in credential parameter
`PsDscRunAsCredential`). [@kungfu71186](https://github.com/kungfu71186)
- Added parameter alias `-DatabaseCredential` for the parameter
`-SetupCredential`. [@kungfu71186](https://github.com/kungfu71186)
- Changes to SqlAG
- Added en-US localization.
- Changes to SqlAGReplica
- Added en-US localization.
- Improved verbose message output when creating availability group replica,
removing a availability group replica, and joining the availability
group replica to the availability group.
- Changes to SqlAlwaysOnService
- Now outputs the correct verbose message when restarting the service.
- Changes to SqlServerMemory
- Now outputs the correct verbose messages when calculating the dynamic
memory, and when limiting maximum memory.
- Changes to SqlServerRole
- Now outputs the correct verbose message when the members of a role is
not in desired state.
- Changes to SqlAgentOperator
- Fix minor issue that when unable to connect to an instance. Instead
of showing a message saying that connect failed another unrelated
error message could have been shown, because of an error in the code.
- Fix typo in test it block.
- Changes to SqlDatabaseRole
- BREAKING CHANGE: Refactored to enable creation/deletion of the database role
itself as well as management of the role members. *Note that the resource no
longer adds database users.* ([issue 845](https://github.com/PowerShell/SqlServerDsc/issues/845),
[issue 847](https://github.com/PowerShell/SqlServerDsc/issues/847),
[issue 1252](https://github.com/PowerShell/SqlServerDsc/issues/1252),
[issue 1339](https://github.com/PowerShell/SqlServerDsc/issues/1339)).
[Paul Shamus @pshamus](https://github.com/pshamus)
- Changes to SqlSetup
- Add an Action type of "Upgrade". This will ask setup to do a version
upgrade where possible ([issue 1368](https://github.com/PowerShell/SqlServerDsc/issues/1368)).
- Fix an error when testing for DQS installation ([issue 1368](https://github.com/PowerShell/SqlServerDsc/issues/1368)).
- Changed the logic of how default value of FailoverClusterGroupName is
set since that was preventing the resource to be able to be debugged
([issue 448](https://github.com/PowerShell/SqlServerDsc/issues/448)).
- Added RSInstallMode parameter ([issue 1163](https://github.com/PowerShell/SqlServerDsc/issues/1163)).
- Changes to SqlWindowsFirewall
- Where a version upgrade has changed paths for a database engine, the
existing firewall rule for that instance will be updated rather than
another one created ([issue 1368](https://github.com/PowerShell/SqlServerDsc/issues/1368)).
Other firewall rules can be fixed to work in the same way later.
- Changes to SqlAGDatabase
- Added new parameter "ReplaceExisting" with default false.
This allows forced restores when a database already exists on secondary.
- Added StatementTimeout to Invoke-Query to fix Issue1358
- Fix issue where calling Get would return an error because the database
name list may have been returned as a string instead of as a string array
([issue 1368](https://github.com/PowerShell/SqlServerDsc/issues/1368)).
FileList
- SqlServerDsc.nuspec
- Assert-TestEnvironment.ps1
- CHANGELOG.md
- CODE_OF_CONDUCT.md
- CONTRIBUTING.md
- LICENSE
- README.md
- SqlServerDsc.psd1
- DSCResources\MSFT_SqlAG\MSFT_SqlAG.psm1
- DSCResources\MSFT_SqlAG\MSFT_SqlAG.schema.mof
- DSCResources\MSFT_SqlAG\en-US\MSFT_SqlAG.strings.psd1
- 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_SqlAgentAlert\MSFT_SqlAgentAlert.psm1
- DSCResources\MSFT_SqlAgentAlert\MSFT_SqlAgentAlert.schema.mof
- DSCResources\MSFT_SqlAgentAlert\en-US\MSFT_SqlAgentAlert.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_SqlAGListener\en-US\MSFT_SqlAGListener.strings.psd1
- DSCResources\MSFT_SqlAGReplica\MSFT_SqlAGReplica.psm1
- DSCResources\MSFT_SqlAGReplica\MSFT_SqlAGReplica.schema.mof
- DSCResources\MSFT_SqlAGReplica\en-US\MSFT_SqlAGReplica.strings.psd1
- DSCResources\MSFT_SqlAlias\MSFT_SqlAlias.psm1
- DSCResources\MSFT_SqlAlias\MSFT_SqlAlias.schema.mof
- DSCResources\MSFT_SqlAlias\en-US\MSFT_SqlAlias.strings.psd1
- DSCResources\MSFT_SqlAlwaysOnService\MSFT_SqlAlwaysOnService.psm1
- DSCResources\MSFT_SqlAlwaysOnService\MSFT_SqlAlwaysOnService.schema.mof
- DSCResources\MSFT_SqlAlwaysOnService\en-US\MSFT_SqlAlwaysOnService.strings.psd1
- DSCResources\MSFT_SqlDatabase\MSFT_SqlDatabase.psm1
- DSCResources\MSFT_SqlDatabase\MSFT_SqlDatabase.schema.mof
- DSCResources\MSFT_SqlDatabase\en-US\MSFT_SqlDatabase.strings.psd1
- 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_SqlDatabaseOwner\en-US\MSFT_SqlDatabaseOwner.strings.psd1
- DSCResources\MSFT_SqlDatabasePermission\MSFT_SqlDatabasePermission.psm1
- DSCResources\MSFT_SqlDatabasePermission\MSFT_SqlDatabasePermission.schema.mof
- DSCResources\MSFT_SqlDatabasePermission\en-US\MSFT_SqlDatabasePermission.strings.psd1
- DSCResources\MSFT_SqlDatabaseRecoveryModel\MSFT_SqlDatabaseRecoveryModel.psm1
- DSCResources\MSFT_SqlDatabaseRecoveryModel\MSFT_SqlDatabaseRecoveryModel.schema.mof
- DSCResources\MSFT_SqlDatabaseRecoveryModel\en-US\MSFT_SqlDatabaseRecoveryModel.strings.psd1
- DSCResources\MSFT_SqlDatabaseRole\MSFT_SqlDatabaseRole.psm1
- DSCResources\MSFT_SqlDatabaseRole\MSFT_SqlDatabaseRole.schema.mof
- DSCResources\MSFT_SqlDatabaseRole\en-US\MSFT_SqlDatabaseRole.strings.psd1
- DSCResources\MSFT_SqlRS\MSFT_SqlRS.psm1
- DSCResources\MSFT_SqlRS\MSFT_SqlRS.schema.mof
- DSCResources\MSFT_SqlRS\en-US\MSFT_SqlRS.strings.psd1
- DSCResources\MSFT_SqlRSSetup\MSFT_SqlRSSetup.psm1
- DSCResources\MSFT_SqlRSSetup\MSFT_SqlRSSetup.schema.mof
- DSCResources\MSFT_SqlRSSetup\en-US\MSFT_SqlRSSetup.strings.psd1
- DSCResources\MSFT_SqlScript\MSFT_SqlScript.psm1
- DSCResources\MSFT_SqlScript\MSFT_SqlScript.schema.mof
- DSCResources\MSFT_SqlScript\en-US\MSFT_SqlScript.strings.psd1
- DSCResources\MSFT_SqlScriptQuery\MSFT_SqlScriptQuery.psm1
- DSCResources\MSFT_SqlScriptQuery\MSFT_SqlScriptQuery.schema.mof
- DSCResources\MSFT_SqlScriptQuery\en-US\MSFT_SqlScriptQuery.strings.psd1
- 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_SqlServerEndpoint\en-US\MSFT_SqlServerEndpoint.strings.psd1
- DSCResources\MSFT_SqlServerEndpointPermission\MSFT_SqlServerEndpointPermission.psm1
- DSCResources\MSFT_SqlServerEndpointPermission\MSFT_SqlServerEndpointPermission.schema.mof
- DSCResources\MSFT_SqlServerEndpointPermission\en-US\MSFT_SqlServerEndpointPermission.strings.psd1
- DSCResources\MSFT_SqlServerEndpointState\MSFT_SqlServerEndpointState.psm1
- DSCResources\MSFT_SqlServerEndpointState\MSFT_SqlServerEndpointState.schema.mof
- DSCResources\MSFT_SqlServerEndpointState\en-US\MSFT_SqlServerEndpointState.strings.psd1
- DSCResources\MSFT_SqlServerLogin\MSFT_SqlServerLogin.psm1
- DSCResources\MSFT_SqlServerLogin\MSFT_SqlServerLogin.schema.mof
- DSCResources\MSFT_SqlServerLogin\en-US\MSFT_SqlServerLogin.strings.psd1
- DSCResources\MSFT_SqlServerMaxDop\MSFT_SqlServerMaxDop.psm1
- DSCResources\MSFT_SqlServerMaxDop\MSFT_SqlServerMaxDop.schema.mof
- DSCResources\MSFT_SqlServerMaxDop\en-US\MSFT_SqlServerMaxDop.strings.psd1
- DSCResources\MSFT_SqlServerMemory\MSFT_SqlServerMemory.psm1
- DSCResources\MSFT_SqlServerMemory\MSFT_SqlServerMemory.schema.mof
- DSCResources\MSFT_SqlServerMemory\en-US\MSFT_SqlServerMemory.strings.psd1
- 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_SqlServerPermission\en-US\MSFT_SqlServerPermission.strings.psd1
- DSCResources\MSFT_SqlServerReplication\MSFT_SqlServerReplication.psm1
- DSCResources\MSFT_SqlServerReplication\MSFT_SqlServerReplication.schema.mof
- DSCResources\MSFT_SqlServerReplication\en-US\MSFT_SqlServerReplication.strings.psd1
- 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_SqlWaitForAG\en-US\MSFT_SqlWaitForAG.strings.psd1
- DSCResources\MSFT_SqlWindowsFirewall\MSFT_SqlWindowsFirewall.psm1
- DSCResources\MSFT_SqlWindowsFirewall\MSFT_SqlWindowsFirewall.schema.mof
- DSCResources\MSFT_SqlWindowsFirewall\en-US\MSFT_SqlWindowsFirewall.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\SqlAgentAlert\1-AddAlert.ps1
- Examples\Resources\SqlAgentAlert\2-RemoveAlert.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\SqlDatabaseRole\3-EnforceDatabaseRoleMembers.ps1
- Examples\Resources\SqlDatabaseRole\4-MembersToIncludeInDatabaseRole.ps1
- Examples\Resources\SqlDatabaseRole\5-MembersToExcludeFromDatabaseRole.ps1
- Examples\Resources\SqlDatabaseRole\6-MembersToIncludeAndExcludeInDatabaseRole.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\SqlRSSetup\1-InstallReportingServices.ps1
- Examples\Resources\SqlRSSetup\2-UninstallReportingServices.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\SqlServerSecureConnection\4-SecureConnectionUsingSYSTEMAccount.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
- Modules\SqlServerDsc.Common\SqlServerDsc.Common.psm1
- Modules\SqlServerDsc.Common\en-US\SqlServerDsc.Common.strings.psd1
- Modules\SqlServerDsc.Common\sv-SE\SqlServerDsc.Common.strings.psd1
- Tests\Tests.depend.psd1
- Tests\Integration\MSFT_SqlAgentAlert.config.ps1
- Tests\Integration\MSFT_SqlAgentAlert.Integration.Tests.ps1
- 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_SqlRSSetup.config.ps1
- Tests\Integration\MSFT_SqlRSSetup.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\MSFT_SqlAG.Tests.ps1
- Tests\Unit\MSFT_SqlAGDatabase.Tests.ps1
- Tests\Unit\MSFT_SqlAgentAlert.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_SqlRSSetup.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\SqlServerDsc.Common.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,506 | 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,854 | 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,690 | 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,434 | 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 (current version) | 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 | 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 |