v16.6.0-preview0003

[v16.6.0-preview0003]

Added

• SqlServerDsc
  • Added build tasks to generate Wiki documentation for public commands.
• SqlDatabaseMail
  • Added the parameter UseDefaultCredentials to control use of the DatabaseEngine
    service account for SMTP server authentication.

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).

Changed

• SqlServer
  • Updated pipeline files to support pre-releases with ModuleFast (when
    resolving dependencies).
• SqlAG
  • Converted unit test to Pester 5
  • DtcSupportEnabled option in Set-TargetResource and TestTargetResource
• SqlServerDsc
  • 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 task pack which is run by the pipeline.
    To run the meta task docs 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.
• SqlSetup
  • Updated integration tests to use PSResourceGet to download required modules.