v16.2.0-preview0006

[v16.2.0-preview0006]

Added

• SqlServerDsc
  • New GitHub Actions workflow that run PSScriptAnalyzer for PRs so any
    issues are shown directly in the PR's changed files (issue #1860).
  • Added a separate integration test jobs for SQL Server Reporting Services
    to be able to test configuring SQL Server Reportings Services using
    other values that the default values.
  • Now updates GitHub Actions automatically by allowing dependabot sending
    in pull requests.

Changed

• SqlServerDsc
  • Update appveyor.yml to use dotnet tool install to install GitVersion.
  • Re-enable integration tests for SqlRSSetup and SqlRS when running against
    SQL Server 2019 (issue #1847).
  • The private function Import-SQLPSModule was replaced throughout with
    the public command Import-SqlDscPreferredModule (issue #1848).
  • Removed the regular expression features? from the GitVersion configuration.
    Before, if a fix commit mentioned the word feature but means a SQL Server
    feature GitVersion would bump minor instead of patch number.
  • Update pipeline script that is used to resolve dependencies.
  • When running in Azure Pipelines any existing SqlServer module is removed
    before running integration tests, so the tests can update to latest version.
  • Now the new label 'command proposal' is an exempt for labeling issues stale.
  • Update the initializing header for all integration test to be equal to
    the unit tests.
  • Rename task jobs in Azure Pipelines (issue #1881).
• Get-SqlDscAudit
  • The parameter Name is no longer mandatory. When left out all the current
    audits are returned (issue #1812).
• Import-SqlDscPreferredModule
  • Now correctly preserves paths that is set in the session for the environment
    variable $env:PSModulePath. If the module SqlServer or SQLPS are not
    found the command will populate the $env:PSModulePath with the
    unique paths from all targets; session, user, and machine. This is done
    so that any new path that was added to the machine or user target will
    also be set in the session.
  • Now imports the preferred module into the global scope so that MOF-based
    resources (that is in another module scope) can use the imported module.
  • Some code cleanup (issue #1881).

Fixed

• Assert-SetupActionProperties
  • Now throws an exception if the setup action is Install and the feature
    analysis services is specified without the parameter ASSysAdminAccounts
    (issue #1845).
  • Now throws an exception if the setup action is Install and the feature
    database engine is specified without the parameter SqlSysAdminAccounts.
• Invoke-SetupAction
  • The parameter SqlSysAdminAccounts is no longer mandatory to allow
    installation where the database engine is not installed.
• Install-SqlDscServer
  • The parameter SqlSysAdminAccounts is no longer mandatory to allow
    installation where the database engine is not installed.
• SqlRS
  • Fixed issue of configuring reporting services (issue #1868).
  • Test renamed to When Reports virtual directory is different so it
    is more correct and not a duplicate.
  • Integration tests configuration names was renamed to better tell what
    the configuration does (issue #1880).
• SqlServerDsc.Common
  • The command Restart-SqlService was updated to correctly evaluate when
    the timeout value is reached (issue #1889).