v16.6.0-preview0004
Pre-release
Pre-release
[v16.6.0-preview0004]
Added
- SqlServerDsc
- Added build tasks to generate Wiki documentation for public commands.
- Initial integration tests for commands.
- SqlDatabaseMail
- Added the parameter
UseDefaultCredentials
to control use of the DatabaseEngine
service account for SMTP server authentication.
- Added the parameter
- New public commands
Save-SqlDscSqlServerMediaFile
- Downloads the content on the provided URL
and if it is an executable it will use the executable to download the
ISO image media.
Fixed
- SqlServerDsc
Get-SMOModuleCalculatedVersion
- Return SQLPS version as 12.0 instead of 120
Get-SqlDscPreferredModule
- Fix sort to get the latest version
- Public commands no handles when both
-Force
and-Confirm $true
would be passed to command. - Enabled NUnit results for HQRM tests.
Assert-Feature
- Fixed unit tests.
- SqlAGReplica
- Fix unit test FailedRemoveAvailabilityGroupReplica
- SqlAgentOperator
- Integration test for changing e-mail address on an existing operator.
DatabasePermission
- New method ToString() for making verbose output better.
ServerPermission
- New method ToString() for making verbose output better.
- SqlAgDatabase
- Remove unused help file (issue #1745).
Install-SqlDscServer
- No longer throws with duplicate parameter error if the parameter
ErrorAction
is passed to the command.
- No longer throws with duplicate parameter error if the parameter
Add-SqlDscNode
- No longer throws with duplicate parameter error if the parameter
ErrorAction
is passed to the command.
- No longer throws with duplicate parameter error if the parameter
Complete-SqlDscFailoverCluster
- No longer throws with duplicate parameter error if the parameter
ErrorAction
is passed to the command.
- No longer throws with duplicate parameter error if the parameter
Complete-SqlDscImage
- No longer throws with duplicate parameter error if the parameter
ErrorAction
is passed to the command.
- No longer throws with duplicate parameter error if the parameter
Initialize-SqlDscRebuildDatabase
- No longer throws with duplicate parameter error if the parameter
ErrorAction
is passed to the command.
- No longer throws with duplicate parameter error if the parameter
Remove-SqlDscNode
- No longer throws with duplicate parameter error if the parameter
ErrorAction
is passed to the command.
- No longer throws with duplicate parameter error if the parameter
Repair-SqlDscServer
- No longer throws with duplicate parameter error if the parameter
ErrorAction
is passed to the command.
- No longer throws with duplicate parameter error if the parameter
Uninstall-SqlDscServer
- No longer throws with duplicate parameter error if the parameter
ErrorAction
is passed to the command.
- No longer throws with duplicate parameter error if the parameter
- Private functions
Invoke-SetupAction
no longer throws when secure strings is passed on
Windows PowerShell.
Changed
- SqlServerDsc
- Updated pipeline files to support pre-releases with ModuleFast (when
resolving dependencies). - Bump PSResourceGet to v1.0.0 (used when resolving dependencies).
- Update markdown highlights with newly supported keywords.
- Bump GitHub Action Stale to v9.
- Bump GitHub Action CodeQL-Action to v3.
- Documentation is now built using a separate meta task
docs
.
It is run with the meta taskpack
which is run by the pipeline.
To run the meta taskdocs
the SMO assemblies must be loaded into the
session, either by importing SqlServer module or loading SMO stubs. - QA test improved to speed up quality testing.
- The pipeline test stages has been split into different stages.
- Updated pipeline files to support pre-releases with ModuleFast (when
- SqlAG
- Converted unit test to Pester 5
- DtcSupportEnabled option in Set-TargetResource and TestTargetResource
- SqlSetup
- Updated integration tests to use PSResourceGet to download required modules.
- SqlRS
- Integration tests for SQL Server 2022 has been temporarily disabled due
to a unknown problem. More information in issue #2009.
- Integration tests for SQL Server 2022 has been temporarily disabled due