v16.1.0-preview0007

[v16.1.0-preview0007]

Removed

• SqlServerDsc
  • Removed Assert-ElevatedUser from private functions - Issue #1797
    • Assert-ElevatedUser added to DscResource.Common public functions - Issue #82
  • Removed Test-IsNumericType from private functions - Issue #1795
    • Test-IsNumericType added to DscResource.Common public functions - Issue #87

Added

• SqlServerDsc
  • The following private functions were added to the module (see comment-based
    help for more information):
    • Assert-RequiredCommandParameter
    • Assert-SetupActionProperties
    • Invoke-SetupAction
  • The following public functions were added to the module (see comment-based
    help for more information):
    • Install-SqlDscServer
    • Uninstall-SqlDscServer
    • Add-SqlDscNode
    • Remove-SqlDscNode
    • Repair-SqlDscServer
    • Complete-SqlDscImage
    • Complete-SqlDscFailoverCluster
    • Initialize-SqlDscRebuildDatabase
  • New GitHub issue templates for proposing new public commands, proposing
    an enhancement to an existing command, or having a problem with an existing
    command.
  • Integration tests are now also run on SQL Server 2022 and SQL Server
    Reporting Services 2022.
  • Integration tests now wait for LCM after each It-block, not just at the
    end of a Context-block. Hopefully this will mitigate some of the intermittent
    errors we have seen when running the integration tests in the pipeline.
  • Use preview version of Pester to support the development of Pester as
    this is a code base with a diverse set of tests thar can help catch
    issues in Pester. If preview release of Pester prevents release we
    should temporary shift back to stable.
• SqlDatabase
  • Added compatibility levels for SQL Server 2022 (major version 16).
• SqlSetup
  • Paths for SQL Server 2022 are correctly returned by Get.
• The public commands Add-SqlDscNode, Complete-SqlDscFailoverCluster,
  Complete-SqlDscImage, Install-SqlDscServer, and Repair-SqlDscServer
  now support the setup argument ProductCoveredBySA (issue #1798).

Changed

• SqlServerDsc
  • Update Stale GitHub Action to v7.
  • Update to build module in separate folder under output.
  • Moved the build step of the pipeline to a Windows build worker when
    running in Azure DevOps.
• Install-SqlServerDsc
  • No longer throws an exception when parameter AgtSvcAccount is not specified.
• SqlAgReplica
  • Converted unit test to Pester 5.
• Private function Invoke-SetupAction (issue #1798).
  • Was changed to support the SQL Server 2022 GA feature AzureExtension
    (that replaced the feature name ARC).
  • Support the setup argument ProductCoveredBySA.
  • No longer supports the argument OnBoardSQLToARC as it was removed in
    SQL Server 2022 GA.
• Install-SqlDscServer
  • Was changed to support the SQL Server 2022 GA feature AzureExtension
    (that replaced the feature name ARC) (issue #1798).
• Uninstall-SqlDscServer
  • Was changed to support the SQL Server 2022 GA feature AzureExtension
    (that replaced the feature name ARC) (issue #1798).

Fixed

• SqlServerDsc
  • Localized strings file en-US/SqlServerDsc.strings.psd1 no longer
    referencing the wrong module in a comment.
• SqlAGReplica
  • No longer tries to enforce EndpointHostName when it is not part of the
    configuration (issue #1821).
  • Now Get-TargetResource always returns values for the properties Name
    and AvailabilityGroupName (issue #1822).
  • Now Test-TargetResource no longer test properties that cannot
    be enforced (issue #1822).