v17.0.0

[v17.0.0]

Added

• SqlSetup
  • Added new parameter ProductCoveredbySA which is introduced in SQL 2022.

Added

• Connect-SqlDscDatabaseEngine
  • Added integration test for the command.
• Uninstall-SqlDscServer
  • Added integration test for the command.

Changed

• SqlScript

  • BREAKING CHANGE: The parameter Id is now required to allow
    reuse of a script with different variables. Set this to a unique value.
    The information entered is never used to actually run the script.
    (issue #596).
  • Fix unit test to fully check Set-TargetResource using timeout.

• SqlScriptQuery

  • BREAKING CHANGE: The parameter Id is now required to allow
    reuse of a script with different variables. Set this to a unique value.
    The information entered is never used to actually run the script.
    (issue #596).
  • Fix unit test to fully check Set-TargetResource using timeout.

• SqlServerDsc

  • Replaced inline task Package_Wiki_Content with the one now available
    in the module DscResource.DocGenerator.

• Connect-SqlDscDatabaseEngine

  • Update comment-based help with more examples.

• SqlSetup

  • The parameter SecurityMode now only (correctly) allows the value
    SQL (issue #1185).

Fixed

• SqlServerDsc
  • Fix issue template.
• Connect-SqlDscDatabaseEngine
  • Comment-based help for parameter LoginType was corrected.
  • An integration test now runs to test the command.
• SqlAudit
  • Fixed unit tests.
• SqlDatabaseMail
  • Fix unit test, removing Assert-VerifiableMock that was left over from
    Pester 5 conversion.