SqlServerDsc
13.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
MSFT_SqlAG MSFT_SqlAGDatabase MSFT_SqlAgentAlert MSFT_SqlAgentFailsafe MSFT_SqlAgentOperator MSFT_SqlAGListener MSFT_SqlAGReplica MSFT_SqlAlias MSFT_SqlAlwaysOnService MSFT_SqlDatabase MSFT_SqlDatabaseDefaultLocation MSFT_SqlDatabaseOwner MSFT_SqlDatabasePermission MSFT_SqlDatabaseRecoveryModel MSFT_SqlDatabaseRole MSFT_SqlDatabaseUser MSFT_SqlRS MSFT_SqlRSSetup MSFT_SqlScript MSFT_SqlScriptQuery MSFT_SqlServerConfiguration MSFT_SqlServerDatabaseMail MSFT_SqlServerEndpoint MSFT_SqlServerEndpointPermission MSFT_SqlServerEndpointState MSFT_SqlServerLogin MSFT_SqlServerMaxDop MSFT_SqlServerMemory MSFT_SqlServerNetwork MSFT_SqlServerPermission MSFT_SqlServerReplication MSFT_SqlServerRole MSFT_SqlServerSecureConnection MSFT_SqlServiceAccount MSFT_SqlSetup MSFT_SqlWaitForAG MSFT_SqlWindowsFirewall
Dependencies
This module has no dependencies.
Release Notes
- Changes to SqlServerDsc
- New DSC resource SqlAgentFailsafe
- New DSC resource SqlDatabaseUser ([issue 846](https://github.com/PowerShell/SqlServerDsc/issues/846)).
- Adds ability to create database users with more fine-grained control,
e.g. re-mapping of orphaned logins or a different login. Supports
creating a user with or without login name, and database users mapped
to a certificate or asymmetric key.
- Changes to helper function Invoke-Query
- Fixes issues in [issue 1355](https://github.com/PowerShell/SqlServerDsc/issues/1355).
- Works together with Connect-SQL now.
- Parameters now match that of Connect-SQL ([issue 1392](https://github.com/PowerShell/SqlServerDsc/issues/1392)).
- Can now pass in credentials.
- Can now pass in "Microsoft.SqlServer.Management.Smo.Server" object.
- Can also pipe in "Microsoft.SqlServer.Management.Smo.Server" object.
- Can pipe Connect-SQL | Invoke-Query.
- Added default values to Invoke-Query.
- Now it will output verbose messages of the query that is run, so it
not as quiet of what it is doing when a user asks for verbose output
([issue 1404](https://github.com/PowerShell/SqlServerDsc/issues/1404)).
- It is possible to redact text in the verbose output by providing
strings in the new parameter `RedactText`.
- Minor style fixes in unit tests.
- Changes to helper function Connect-SQL
- When impersonating WindowsUser credential use the NetworkCredential UserName.
- Added additional verbose logging.
- Connect-SQL now uses parameter sets to more intuitive evaluate that
the correct parameters are used in different scenarios
([issue 1403](https://github.com/PowerShell/SqlServerDsc/issues/1403)).
- Changes to helper function Connect-SQLAnalysis
- Parameters now match that of Connect-SQL ([issue 1392](https://github.com/PowerShell/SqlServerDsc/issues/1392)).
- Changes to helper function Restart-SqlService
- Parameters now match that of Connect-SQL ([issue 1392](https://github.com/PowerShell/SqlServerDsc/issues/1392)).
- Changes to helper function Restart-ReportingServicesService
- Parameters now match that of Connect-SQL ([issue 1392](https://github.com/PowerShell/SqlServerDsc/issues/1392)).
- Changes to helper function Split-FullSqlInstanceName
- Parameters and function name changed to use correct casing.
- Changes to helper function Get-SqlInstanceMajorVersion
- Parameters now match that of Connect-SQL ([issue 1392](https://github.com/PowerShell/SqlServerDsc/issues/1392)).
- Changes to helper function Test-LoginEffectivePermissions
- Parameters now match that of Connect-SQL ([issue 1392](https://github.com/PowerShell/SqlServerDsc/issues/1392)).
- Changes to helper function Test-AvailabilityReplicaSeedingModeAutomatic
- Parameters now match that of Connect-SQL ([issue 1392](https://github.com/PowerShell/SqlServerDsc/issues/1392)).
- Changes to SqlServerSecureConnection
- Forced $Thumbprint to lowercase to fix [issue 1350](https://github.com/PowerShell/SqlServerDsc/issues/1350).
- Add parameter SuppressRestart with default value false.
This allows users to suppress restarts after changes have been made.
Changes will not take effect until the service has been restarted.
- Changes to SqlSetup
- Correct minor style violation [issue 1387](https://github.com/PowerShell/SqlServerDsc/issues/1387).
- Changes to SqlDatabase
- Get-TargetResource now correctly return `$null` for the collation property
when the database does not exist ([issue 1395](https://github.com/PowerShell/SqlServerDsc/issues/1395)).
- No longer enforces the collation property if the Collation parameter
is not part of the configuration ([issue 1396](https://github.com/PowerShell/SqlServerDsc/issues/1396)).
- Updated resource description in README.md
- Fix examples to use `PsDscRunAsCredential` ([issue 760](https://github.com/PowerShell/SqlServerDsc/issues/760)).
- Added integration tests ([issue 739](https://github.com/PowerShell/SqlServerDsc/issues/739)).
- Updated unit tests to the latest template ([issue 1068](https://github.com/PowerShell/SqlServerDsc/issues/1068)).
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_SqlAgentFailsafe\MSFT_SqlAgentFailsafe.psm1
- DSCResources\MSFT_SqlAgentFailsafe\MSFT_SqlAgentFailsafe.schema.mof
- DSCResources\MSFT_SqlAgentFailsafe\en-US\MSFT_SqlAgentFailsafe.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_SqlDatabaseUser\MSFT_SqlDatabaseUser.psm1
- DSCResources\MSFT_SqlDatabaseUser\MSFT_SqlDatabaseUser.schema.mof
- DSCResources\MSFT_SqlDatabaseUser\en-US\MSFT_SqlDatabaseUser.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\SqlAgentFailsafe\1-AddFailsafe.ps1
- Examples\Resources\SqlAgentFailsafe\2-RemoveFailsafe.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\SqlDatabaseUser\1-AddDatabaseUserWithLogin.ps1
- Examples\Resources\SqlDatabaseUser\2-AddDatabaseUserWithoutLogin.ps1
- Examples\Resources\SqlDatabaseUser\3-AddDatabaseUserMappedToAsymmetricKey.ps1
- Examples\Resources\SqlDatabaseUser\4-AddDatabaseUserMappedToCertificate.ps1
- Examples\Resources\SqlDatabaseUser\5-RemoveDatabaseUser.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_SqlAgentFailsafe.config.ps1
- Tests\Integration\MSFT_SqlAgentFailsafe.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_SqlDatabase.config.ps1
- Tests\Integration\MSFT_SqlDatabase.Integration.Tests.ps1
- Tests\Integration\MSFT_SqlDatabaseDefaultLocation.config.ps1
- Tests\Integration\MSFT_SqlDatabaseDefaultLocation.Integration.Tests.ps1
- Tests\Integration\MSFT_SqlDatabaseUser.config.ps1
- Tests\Integration\MSFT_SqlDatabaseUser.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_SqlAgentFailsafe.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_SqlDatabaseUser.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 (current version) | 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 | 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 |