SqlServerDsc
16.0.0-preview0013
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
Copyright the DSC Community contributors. All rights reserved.
Package Details
Author(s)
- DSC Community
Tags
DesiredStateConfiguration DSC DSCResourceKit DSCResource
Functions
Connect-SqlDscDatabaseEngine ConvertFrom-SqlDscDatabasePermission ConvertFrom-SqlDscServerPermission ConvertTo-SqlDscDatabasePermission ConvertTo-SqlDscServerPermission Disable-SqlDscAudit Enable-SqlDscAudit Get-SqlDscAudit Get-SqlDscDatabasePermission Get-SqlDscServerPermission Invoke-SqlDscQuery New-SqlDscAudit Remove-SqlDscAudit Set-SqlDscAudit Set-SqlDscDatabasePermission Set-SqlDscServerPermission Test-SqlDscIsDatabasePrincipal Test-SqlDscIsLogin
DSCResources
SqlAudit SqlDatabasePermission SqlPermission SqlAG SqlAGDatabase SqlAgentAlert SqlAgentFailsafe SqlAgentOperator SqlAGListener SqlAGReplica SqlAlias SqlAlwaysOnService SqlConfiguration SqlDatabase SqlDatabaseDefaultLocation SqlDatabaseMail SqlDatabaseObjectPermission SqlDatabaseRole SqlDatabaseUser SqlEndpoint SqlEndpointPermission SqlLogin SqlMaxDop SqlMemory SqlProtocol SqlProtocolTcpIp SqlReplication SqlRole SqlRS SqlRSSetup SqlScript SqlScriptQuery SqlSecureConnection SqlServiceAccount SqlSetup SqlTraceFlag SqlWaitForAG SqlWindowsFirewall
Dependencies
This module has no dependencies.
Release Notes
## [16.0.0-preview0013] - 2022-08-20
### Removed
- The deprecated DSC resource SqlDatabaseOwner have been removed _(and replaced_
_by a property in [**SqlDatabase**](https://github.com/dsccommunity/SqlServerDsc/wiki/sqldatabase))_
([issue #1725](https://github.com/dsccommunity/SqlServerDsc/issues/1725)).
- The deprecated DSC resource SqlDatabaseRecoveryModel have been removed _(and_
_replaced by a property in [**SqlDatabase**](https://github.com/dsccommunity/SqlServerDsc/wiki/sqldatabase))_
([issue #1725](https://github.com/dsccommunity/SqlServerDsc/issues/1725)).
- The deprecated DSC resource SqlServerEndpointState have been removed _(and_
_replaced by a property in [**SqlEndpoint**](https://github.com/dsccommunity/SqlServerDsc/wiki/sqlendpoint))_
([issue #1725](https://github.com/dsccommunity/SqlServerDsc/issues/1725)).
- The deprecated DSC resource SqlServerNetwork have been removed _(and replaced by_
_[**SqlProtocol**](https://github.com/dsccommunity/SqlServerDsc/wiki/sqlprotocol)_
_and [**SqlProtocolTcpIp**](https://github.com/dsccommunity/SqlServerDsc/wiki/sqlprotocoltcpip))_
([issue #1725](https://github.com/dsccommunity/SqlServerDsc/issues/1725)).
- CommonTestHelper
- Remove the helper function `Wait-ForIdleLcm` since it has been moved
to the module _DscResource.Test_.
- Remove the helper function `Get-InvalidOperationRecord` since it has
been moved to the module _DscResource.Test_.
- Remove the helper function `Get-InvalidResultRecord` since it has been
moved to the module _DscResource.Test_.
### Added
- SqlServerDsc
- Added recommended VS Code extensions.
- Added settings for VS Code extension _Pester Test Adapter_.
- Added new Script Analyzer rules from the module _Indented.ScriptAnalyzerRules_
to help development and review process. The rules that did not contradict
the existing DSC Community rules and style guideline were added.
- Added the Visual Studio Code extension _Code Spell Checker_ to the list
of recommended Visual Studio Code extensions.
- Added a file `prefix.ps1` which content is placed first in the built module
(.psm1). This file imports dependent modules, and imports localized strings
used by private and public commands.
- The following classes were added to the module:
- `DatabasePermission` - complex type for the DSC resource SqlDatabasePermission.
- `Ensure` - Enum to be used for the property `Ensure` in class-based
resources.
- `Reason` - Used by method `Get()` to return the reason a property is not
in desired state.
- `ResourceBase` - class that can be inherited by class-based resource and
provides functionality meant simplify the creating of class-based resource.
- `SqlResourceBase` - class that can be inherited by class-based resource and
provides default DSC properties and method for get a `[Server]`-object.
- `ServerPermission` - complex type for the DSC resource SqlPermission.
- The following private functions were added to the module (see comment-based
help for more information):
- `ConvertFrom-CompareResult`
- `ConvertTo-Reason`
- `Get-ClassName`
- `Get-DscProperty`
- `Get-LocalizedDataRecursive`
- `Test-ResourceHasDscProperty`
- `Test-ResourceDscPropertyIsAssigned`
- The following public functions were added to the module (see comment-based
help for more information):
- `Connect-SqlDscDatabaseEngine`
- `ConvertFrom-SqlDscDatabasePermission`
- `ConvertTo-SqlDscDatabasePermission`
- `Get-SqlDscDatabasePermission`
- `Set-SqlDscDatabasePermission`
- `Test-SqlDscIsDatabasePrincipal`
- `Test-SqlDscIsLogin`
- `ConvertFrom-SqlDscServerPermission`
- `ConvertTo-SqlDscServerPermission`
- `Get-SqlDscServerPermission`
- `Set-SqlDscServerPermission`
- `Invoke-SqlDscQuery`
- `Get-SqlDscAudit`
- `New-SqlDscAudit`
- `Set-SqlDscAudit`
- `Remove-SqlDscAudit`
- `Enable-SqlDscAudit`
- `Disable-SqlDscAudit`
- Support for debugging of integration tests in AppVeyor.
- Only run for pull requests
- Add new resource SqlAudit.
- CommonTestHelper
- `Import-SqlModuleStub`
- Added the optional parameter **PasThru** that, if used, will return the
name of the stub module.
- When removing stub modules from the session that is not supposed to
be loaded, it uses `Get-Module -All` to look for previously loaded
stub modules.
- `Remove-SqlModuleStub`
- Added a new helper function `Remove-SqlModuleStub` for tests to remove
the PowerShell SqlServer stub module when a test has run.
- SqlWindowsFirewall
- Added integration tests for SqlWindowsFirewall ([issue #747](https://github.com/dsccommunity/SqlServerDsc/issues/747)).
- `Get-DscProperty`
- Added parameter `ExcludeName` to exclude property names from being returned.
### Changed
- SqlServerDsc
- Updated pipeline to use the build worker image 'ubuntu-latest'.
- Switch to installing GitVersion using 'dotnet tool install' ([issue #1732](https://github.com/dsccommunity/SqlServerDsc/issues/1732)).
- Bumped Stale task to v5 in the GitHub workflow.
- Make it possible to publish code coverage on failed test runs, and
when re-run a fail job.
- Exclude Script Analyzer rule **TypeNotFound** in the file `.vscode/analyzersettings.psd1`.
- Update CONTRIBUTING.md describing error handling in commands and class-based
resources.
- The QA tests are now run in Windows PowerShell due to a bug in PowerShell 7
that makes class-based resource using inheritance to not work.
- The QA test are excluding the rule **TypeNotFound** because it cannot
run on the source files (there is a new issue that is tracking so this
rule is only run on the built module).
- The Pester code coverage has been switched to use the older functionality
that uses breakpoints to calculate coverage. Newer functionality sometimes
throw an exception when used in conjunction with class-based resources.¨
- SMO stubs (used in the unit tests)
- Was updated to remove a bug related to the type `DatabasePermissionInfo`
when used with the type `DatabasePermissionSet`.
The stubs suggested that the property `PermissionType` (of type `DatabasePermissionSet`)
in `DatabasePermissionInfo` should have been a array `DatabasePermissionSet[]`.
This conflicted with real SMO as it does not pass an array, but instead
a single `DatabasePermissionSet`. The stubs was modified to mimic the
real SMO. At the same time some old mock code in the SMO stubs was removed
as it was no longer in use.
- Was updated to remove a bug related to the type `ServerPermissionInfo`
when used with the type `ServerPermissionSet`. The stubs suggested that
the property `PermissionType` (of type `ServerPermissionSet`)
in `ServerPermissionInfo` should have been a array `ServerPermissionSet[]`.
This conflicted with real SMO as it does not pass an array, but instead
a single `ServerPermissionSet`. The stubs was modified to mimic the
real SMO. At the same time some old mock code in the SMO stubs was removed
as it was no longer in use.
- Updated integration tests README.md to describe how to use Appveyor to
debug integration tests.
- Wiki
- add introduction and links to DSC technology
- SqlServerDsc.Common
- The parameter `SetupCredential` of the function `Connect-SQL` was renamed
to `Credential` and the parameter name `SetupCredential` was made a
parameter alias.
- SqlLogin
- BREAKING CHANGE: The parameters `LoginMustChangePassword`, `LoginPasswordExpirationEnabled`,
and `LoginPasswordPolicyEnforced` no longer have a default value of `$true`.
This means that when creating a new login, and not specifically setting
these parameters to `$true` in the configuration, the login that is created
will have these properties set to `$false`.
- BREAKING CHANGE: `LoginMustChangePassword`, `LoginPasswordExpirationEnabled`,
and `LoginPasswordPolicyEnforced` parameters no longer enforce default
values ([issue #1669](https://github.com/dsccommunity/SqlServerDsc/issues/1669)).
- SqlServerDsc
- All tests have been converted to run in Pester 5 (Pester 4 can no
longer be supported) ([issue #1654](https://github.com/dsccommunity/SqlServerDsc/issues/1654)).
- Pipeline build and deploy now runs on Ubuntu 18.04, see more information
in https://github.com/actions/virtual-environments/issues/3287.
- Update the pipeline file _azure-pipelines.yml_ to use the latest version
from the Sampler project.
- SqlRs
- BREAKING CHANGE: Now the Reporting Services is always restarted after
the call to CIM method `SetDatabaseConnection` when setting up the
Reporting Services. This so to try to finish the initialization of
Reporting Services. This was prior only done for _SQL Server Reporting_
_Services 2019_ ([issue #1721](https://github.com/dsccommunity/SqlServerDsc/issues/1721)).
- Added some verbose messages to better indicate which CIM methods are run
and when they are run.
- Minor refactor to support running unit test with strict mode enabled.
- SqlLogin
- Only enforces optional parameter `LoginType` when it is specified in the
configuration.
- Only enforces optional parameters `LoginPasswordExpirationEnabled` and
`LoginPasswordPolicyEnforced` for a SQL login when the parameters are
specified in the configuration.
- A localized string for an error message was updated to correctly reflect
the code that says that to use a SQL login the authentication mode must
be either Mixed or Normal, prio it just stated Mixed.
- SqlSecureConnection
- BREAKING CHANGE: Now `Get-TargetResource` returns the value `'Em
FileList
- SqlServerDsc.nuspec
- SqlServerDsc.psm1
- DSCResources\DSC_SqlDatabase\DSC_SqlDatabase.psm1
- SqlServerDsc.psd1
- DSCResources\DSC_SqlDatabase\README.md
- en-US\about_SqlPermission.help.txt
- DSCResources\DSC_SqlDatabase\DSC_SqlDatabase.schema.mof
- en-US\SqlPermission.strings.psd1
- DSCResources\DSC_SqlReplication\DSC_SqlReplication.schema.mof
- en-US\SqlServerDsc.strings.psd1
- DSCResources\DSC_SqlReplication\DSC_SqlReplication.psm1
- en-US\about_SqlServerDsc.help.txt
- DSCResources\DSC_SqlReplication\README.md
- en-US\about_SqlDatabasePermission.help.txt
- DSCResources\DSC_SqlProtocolTcpIp\DSC_SqlProtocolTcpIp.schema.mof
- en-US\about_SqlAudit.help.txt
- DSCResources\DSC_SqlProtocolTcpIp\DSC_SqlProtocolTcpIp.psm1
- en-US\SqlResourceBase.strings.psd1
- DSCResources\DSC_SqlProtocolTcpIp\README.md
- en-US\ResourceBase.strings.psd1
- DSCResources\DSC_SqlRole\DSC_SqlRole.psm1
- en-US\SqlAudit.strings.psd1
- DSCResources\DSC_SqlRole\DSC_SqlRole.schema.mof
- en-US\SqlDatabasePermission.strings.psd1
- DSCResources\DSC_SqlRole\README.md
- Modules\SqlServerDsc.Common\SqlServerDsc.Common.psd1
- DSCResources\DSC_SqlAGReplica\DSC_SqlAGReplica.psm1
- Modules\SqlServerDsc.Common\SqlServerDsc.Common.psm1
- DSCResources\DSC_SqlAGReplica\DSC_SqlAGReplica.schema.mof
- DSCResources\DSC_SqlScriptQuery\DSC_SqlScriptQuery.schema.mof
- DSCResources\DSC_SqlAGReplica\README.md
- DSCResources\DSC_SqlScriptQuery\DSC_SqlScriptQuery.psm1
- DSCResources\DSC_SqlServiceAccount\DSC_SqlServiceAccount.psm1
- DSCResources\DSC_SqlScriptQuery\README.md
- DSCResources\DSC_SqlServiceAccount\DSC_SqlServiceAccount.schema.mof
- DSCResources\DSC_SqlEndpoint\DSC_SqlEndpoint.psm1
- DSCResources\DSC_SqlServiceAccount\README.md
- DSCResources\DSC_SqlEndpoint\DSC_SqlEndpoint.schema.mof
- DSCResources\DSC_SqlDatabaseRole\DSC_SqlDatabaseRole.psm1
- DSCResources\DSC_SqlEndpoint\README.md
- DSCResources\DSC_SqlDatabaseRole\README.md
- DSCResources\DSC_SqlAgentOperator\DSC_SqlAgentOperator.psm1
- DSCResources\DSC_SqlDatabaseRole\DSC_SqlDatabaseRole.schema.mof
- DSCResources\DSC_SqlAgentOperator\DSC_SqlAgentOperator.schema.mof
- Modules\DscResource.Common\0.11.1\DscResource.Common.psd1
- DSCResources\DSC_SqlAgentOperator\README.md
- Modules\DscResource.Common\0.11.1\DscResource.Common.psm1
- DSCResources\DSC_SqlTraceFlag\DSC_SqlTraceFlag.psm1
- Modules\SqlServerDsc.Common\sv-SE\SqlServerDsc.Common.strings.psd1
- DSCResources\DSC_SqlTraceFlag\DSC_SqlTraceFlag.schema.mof
- Modules\SqlServerDsc.Common\en-US\SqlServerDsc.Common.strings.psd1
- DSCResources\DSC_SqlTraceFlag\README.md
- DSCResources\DSC_SqlScriptQuery\en-US\about_SqlScriptQuery.help.txt
- DSCResources\DSC_SqlAGDatabase\DSC_SqlAGDatabase.schema.mof
- DSCResources\DSC_SqlScriptQuery\en-US\DSC_SqlScriptQuery.strings.psd1
- DSCResources\DSC_SqlAGDatabase\README.md
- DSCResources\DSC_SqlEndpoint\en-US\DSC_SqlEndpoint.strings.psd1
- DSCResources\DSC_SqlAGDatabase\DSC_SqlAGDatabase.psm1
- DSCResources\DSC_SqlEndpoint\en-US\about_SqlEndpoint.help.txt
- DSCResources\DSC_SqlAG\DSC_SqlAG.schema.mof
- DSCResources\DSC_SqlAgentOperator\en-US\about_SqlAgentOperator.help.txt
- DSCResources\DSC_SqlAG\DSC_SqlAG.psm1
- DSCResources\DSC_SqlAgentOperator\en-US\DSC_SqlAgentOperator.strings.psd1
- DSCResources\DSC_SqlAG\README.md
- DSCResources\DSC_SqlTraceFlag\en-US\DSC_SqlTraceFlag.strings.psd1
- DSCResources\DSC_SqlMaxDop\DSC_SqlMaxDop.schema.mof
- DSCResources\DSC_SqlTraceFlag\en-US\about_SqlTraceFlag.help.txt
- DSCResources\DSC_SqlMaxDop\DSC_SqlMaxDop.psm1
- DSCResources\DSC_SqlAGDatabase\en-US\about_SqlAGDatabase.help.txt
- DSCResources\DSC_SqlMaxDop\README.md
- DSCResources\DSC_SqlAGDatabase\en-US\DSC_SqlAGDatabase.strings.psd1
- DSCResources\DSC_SqlAgentFailsafe\DSC_SqlAgentFailsafe.psm1
- DSCResources\DSC_SqlAG\en-US\about_SqlAG.help.txt
- DSCResources\DSC_SqlAgentFailsafe\DSC_SqlAgentFailsafe.schema.mof
- DSCResources\DSC_SqlAG\en-US\DSC_SqlAG.strings.psd1
- DSCResources\DSC_SqlAgentFailsafe\README.md
- DSCResources\DSC_SqlMaxDop\en-US\DSC_SqlMaxDop.strings.psd1
- DSCResources\DSC_SqlAgentAlert\DSC_SqlAgentAlert.schema.mof
- DSCResources\DSC_SqlMaxDop\en-US\about_SqlMaxDop.help.txt
- DSCResources\DSC_SqlAgentAlert\DSC_SqlAgentAlert.psm1
- DSCResources\DSC_SqlAgentFailsafe\en-US\about_SqlAgentFailsafe.help.txt
- DSCResources\DSC_SqlAgentAlert\README.md
- DSCResources\DSC_SqlAgentFailsafe\en-US\DSC_SqlAgentFailsafe.strings.psd1
- DSCResources\DSC_SqlScript\DSC_SqlScript.schema.mof
- DSCResources\DSC_SqlAgentAlert\en-US\DSC_SqlAgentAlert.strings.psd1
- DSCResources\DSC_SqlScript\DSC_SqlScript.psm1
- DSCResources\DSC_SqlAgentAlert\en-US\about_SqlAgentAlert.help.txt
- DSCResources\DSC_SqlScript\README.md
- DSCResources\DSC_SqlScript\en-US\DSC_SqlScript.strings.psd1
- DSCResources\DSC_SqlSetup\DSC_SqlSetup.schema.mof
- DSCResources\DSC_SqlScript\en-US\about_SqlScript.help.txt
- DSCResources\DSC_SqlSetup\DSC_SqlSetup.psm1
- DSCResources\DSC_SqlSetup\sv-SE\DSC_SqlSetup.strings.psd1
- DSCResources\DSC_SqlSetup\README.md
- DSCResources\DSC_SqlSetup\en-US\DSC_SqlSetup.strings.psd1
- DSCResources\DSC_SqlAGListener\DSC_SqlAGListener.psm1
- DSCResources\DSC_SqlSetup\en-US\about_SqlSetup.help.txt
- DSCResources\DSC_SqlAGListener\DSC_SqlAGListener.schema.mof
- DSCResources\DSC_SqlAGListener\en-US\DSC_SqlAGListener.strings.psd1
- DSCResources\DSC_SqlAGListener\README.md
- DSCResources\DSC_SqlAGListener\en-US\about_SqlAGListener.help.txt
- DSCResources\DSC_SqlDatabaseMail\DSC_SqlDatabaseMail.psm1
- DSCResources\DSC_SqlDatabaseMail\en-US\about_SqlDatabaseMail.help.txt
- DSCResources\DSC_SqlDatabaseMail\DSC_SqlDatabaseMail.schema.mof
- DSCResources\DSC_SqlDatabaseMail\en-US\DSC_SqlDatabaseMail.strings.psd1
- DSCResources\DSC_SqlDatabaseMail\README.md
- DSCResources\DSC_SqlRSSetup\en-US\DSC_SqlRSSetup.strings.psd1
- DSCResources\DSC_SqlRSSetup\DSC_SqlRSSetup.schema.mof
- DSCResources\DSC_SqlRSSetup\en-US\about_SqlRSSetup.help.txt
- DSCResources\DSC_SqlRSSetup\DSC_SqlRSSetup.psm1
- DSCResources\DSC_SqlDatabaseObjectPermission\en-US\DSC_SqlDatabaseObjectPermission.strings.psd1
- DSCResources\DSC_SqlRSSetup\README.md
- DSCResources\DSC_SqlDatabaseObjectPermission\en-US\about_SqlDatabaseObjectPermission.help.txt
- DSCResources\DSC_SqlDatabaseObjectPermission\DSC_SqlDatabaseObjectPermission.schema.mof
- DSCResources\DSC_SqlWaitForAG\en-US\DSC_SqlWaitForAG.strings.psd1
- DSCResources\DSC_SqlDatabaseObjectPermission\DSC_SqlDatabaseObjectPermission.psm1
- DSCResources\DSC_SqlWaitForAG\en-US\about_SqlWaitForAG.help.txt
- DSCResources\DSC_SqlDatabaseObjectPermission\README.md
- DSCResources\DSC_SqlDatabaseDefaultLocation\en-US\DSC_SqlDatabaseDefaultLocation.strings.psd1
- DSCResources\DSC_SqlWaitForAG\DSC_SqlWaitForAG.schema.mof
- DSCResources\DSC_SqlDatabaseDefaultLocation\en-US\about_SqlDatabaseDefaultLocation.help.txt
- DSCResources\DSC_SqlWaitForAG\DSC_SqlWaitForAG.psm1
- DSCResources\DSC_SqlDatabaseUser\en-US\DSC_SqlDatabaseUser.strings.psd1
- DSCResources\DSC_SqlWaitForAG\README.md
- DSCResources\DSC_SqlDatabaseUser\en-US\about_SqlDatabaseUser.help.txt
- DSCResources\DSC_SqlDatabaseDefaultLocation\DSC_SqlDatabaseDefaultLocation.schema.mof
- DSCResources\DSC_SqlLogin\en-US\about_SqlLogin.help.txt
- DSCResources\DSC_SqlDatabaseDefaultLocation\README.md
- DSCResources\DSC_SqlLogin\en-US\DSC_SqlLogin.strings.psd1
- DSCResources\DSC_SqlDatabaseDefaultLocation\DSC_SqlDatabaseDefaultLocation.psm1
- DSCResources\DSC_SqlRS\en-US\DSC_SqlRS.strings.psd1
- DSCResources\DSC_SqlDatabaseUser\DSC_SqlDatabaseUser.schema.mof
- DSCResources\DSC_SqlRS\en-US\about_SqlRS.help.txt
- DSCResources\DSC_SqlDatabaseUser\README.md
- DSCResources\DSC_SqlConfiguration\en-US\about_SqlConfiguration.help.txt
- DSCResources\DSC_SqlDatabaseUser\DSC_SqlDatabaseUser.psm1
- DSCResources\DSC_SqlConfiguration\en-US\DSC_SqlConfiguration.strings.psd1
- DSCResources\DSC_SqlLogin\README.md
- DSCResources\DSC_SqlWindowsFirewall\en-US\about_SqlWindowsFirewall.help.txt
- DSCResources\DSC_SqlLogin\DSC_SqlLogin.schema.mof
- DSCResources\DSC_SqlWindowsFirewall\en-US\DSC_SqlWindowsFirewall.strings.psd1
- DSCResources\DSC_SqlLogin\DSC_SqlLogin.psm1
- DSCResources\DSC_SqlAlwaysOnService\en-US\about_SqlAlwaysOnService.help.txt
- DSCResources\DSC_SqlRS\DSC_SqlRS.schema.mof
- DSCResources\DSC_SqlAlwaysOnService\en-US\DSC_SqlAlwaysOnService.strings.psd1
- DSCResources\DSC_SqlRS\DSC_SqlRS.psm1
- DSCResources\DSC_SqlSecureConnection\en-US\DSC_SqlSecureConnection.strings.psd1
- DSCResources\DSC_SqlRS\README.md
- DSCResources\DSC_SqlSecureConnection\en-US\about_SqlSecureConnection.help.txt
- DSCResources\DSC_SqlConfiguration\DSC_SqlConfiguration.psm1
- DSCResources\DSC_SqlEndpointPermission\en-US\about_SqlEndpointPermission.help.txt
- DSCResources\DSC_SqlConfiguration\DSC_SqlConfiguration.schema.mof
- DSCResources\DSC_SqlEndpointPermission\en-US\DSC_SqlEndpointPermission.strings.psd1
- DSCResources\DSC_SqlConfiguration\README.md
- DSCResources\DSC_SqlProtocol\en-US\about_SqlProtocol.help.txt
- DSCResources\DSC_SqlWindowsFirewall\DSC_SqlWindowsFirewall.psm1
- DSCResources\DSC_SqlProtocol\en-US\DSC_SqlProtocol.strings.psd1
- DSCResources\DSC_SqlWindowsFirewall\DSC_SqlWindowsFirewall.schema.mof
- DSCResources\DSC_SqlMemory\en-US\about_SqlMemory.help.txt
- DSCResources\DSC_SqlWindowsFirewall\README.md
- DSCResources\DSC_SqlMemory\en-US\DSC_SqlMemory.strings.psd1
- DSCResources\DSC_SqlAlwaysOnService\DSC_SqlAlwaysOnService.psm1
- DSCResources\DSC_SqlAlias\en-US\DSC_SqlAlias.strings.psd1
- DSCResources\DSC_SqlAlwaysOnService\DSC_SqlAlwaysOnService.schema.mof
- DSCResources\DSC_SqlAlias\en-US\about_SqlAlias.help.txt
- DSCResources\DSC_SqlAlwaysOnService\README.md
- DSCResources\DSC_SqlDatabase\en-US\DSC_SqlDatabase.strings.psd1
- DSCResources\DSC_SqlSecureConnection\DSC_SqlSecureConnection.schema.mof
- DSCResources\DSC_SqlDatabase\en-US\about_SqlDatabase.help.txt
- DSCResources\DSC_SqlSecureConnection\README.md
- DSCResources\DSC_SqlReplication\en-US\DSC_SqlReplication.strings.psd1
- DSCResources\DSC_SqlSecureConnection\DSC_SqlSecureConnection.psm1
- DSCResources\DSC_SqlReplication\en-US\about_SqlReplication.help.txt
- DSCResources\DSC_SqlEndpointPermission\DSC_SqlEndpointPermission.schema.mof
- DSCResources\DSC_SqlProtocolTcpIp\en-US\DSC_SqlProtocolTcpIp.strings.psd1
- DSCResources\DSC_SqlEndpointPermission\DSC_SqlEndpointPermission.psm1
- DSCResources\DSC_SqlProtocolTcpIp\en-US\about_SqlProtocolTcpIp.help.txt
- DSCResources\DSC_SqlEndpointPermission\README.md
- DSCResources\DSC_SqlRole\en-US\about_SqlRole.help.txt
- DSCResources\DSC_SqlProtocol\DSC_SqlProtocol.schema.mof
- DSCResources\DSC_SqlRole\en-US\DSC_SqlRole.strings.psd1
- DSCResources\DSC_SqlProtocol\README.md
- DSCResources\DSC_SqlAGReplica\en-US\about_SqlAGReplica.help.txt
- DSCResources\DSC_SqlProtocol\DSC_SqlProtocol.psm1
- DSCResources\DSC_SqlAGReplica\en-US\DSC_SqlAGReplica.strings.psd1
- DSCResources\DSC_SqlMemory\DSC_SqlMemory.schema.mof
- DSCResources\DSC_SqlServiceAccount\en-US\about_SqlServiceAccount.help.txt
- DSCResources\DSC_SqlMemory\DSC_SqlMemory.psm1
- DSCResources\DSC_SqlServiceAccount\en-US\DSC_SqlServiceAccount.strings.psd1
- DSCResources\DSC_SqlMemory\README.md
- DSCResources\DSC_SqlDatabaseRole\en-US\about_SqlDatabaseRole.help.txt
- DSCResources\DSC_SqlAlias\DSC_SqlAlias.psm1
- DSCResources\DSC_SqlDatabaseRole\en-US\DSC_SqlDatabaseRole.strings.psd1
- DSCResources\DSC_SqlAlias\DSC_SqlAlias.schema.mof
- Modules\DscResource.Common\0.11.1\en-US\DscResource.Common.strings.psd1
- DSCResources\DSC_SqlAlias\README.md
- Modules\DscResource.Common\0.11.1\en-US\about_DscResource.Common.help.txt
Version History
Version | Downloads | Last updated |
---|---|---|
17.0.1-previ... | 17 | 10/29/2024 |
17.0.1-previ... | 6 | 10/26/2024 |
17.0.1-previ... | 14 | 10/7/2024 |
17.0.0 | 40,233 | 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,058 | 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,721 | 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,489 | 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,073 | 5/6/2023 |
16.3.1-previ... | 5 | 5/6/2023 |
16.3.1-previ... | 9 | 5/4/2023 |
16.3.0 | 42,245 | 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,151 | 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,566 | 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,595 | 9/9/2022 |
16.0.0-previ... (current version) | 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,610 | 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,391,854 | 2/12/2021 |
15.1.1-previ... | 18 | 2/12/2021 |
15.1.0 | 62,442 | 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,513 | 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,161 | 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,770 | 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,843 | 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,415 | 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,496 | 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,904 | 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,394 | 5/15/2019 |
12.4.0.0 | 21,746 | 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,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,232 | 5/2/2018 |
11.1.0.0 | 6,228 | 3/22/2018 |
11.0.0.0 | 13,489 | 2/8/2018 |
10.0.0.0 | 3,650 | 12/14/2017 |