v15.2.0-preview0005

[v15.2.0-preview0005]

Changed

• SqlServerDsc
  • Changed to the new GitHub deploy tasks that is required for the latest
    version of the Sampler module.
  • Updated pipeline configuration to align with the latest changes in Sampler.
  • Update codecov.yml to support carry forward flags.
  • Updated pipelines files to latest from Sampler project.
  • Updated GitHub issue templates.
  • Remove pipeline jobs Test_Integration_SQL2016, Test_Integration_SQL2017,
    and Test_Integration_SQL2019 and raplaced with a single job
    Test_Integration (issue #1713).
  • Update HQRM tests to run on the VM image windows-2022.
  • Update unit tests to run on the VM image windows-2022.
  • Update integration tests to run both on Windows Server 2019 and Windows
    Server 2022 (issue #1713).
• SqlSetup
  • The helper function Connect-SqlAnalysis was using LoadWithPartial()
    to load the assembly Microsoft.AnalysisServices. On a node where multiple
    instances with different versions of SQL Server (regardless of features)
    is installed, this will result in the first assembly found in the
    GAC will be loaded into the session, not taking versions into account.
    This can result in an assembly version being loaded that is not compatible
    with the version of SQL Server it was meant to be used with.
    A new method of loading the assembly Microsoft.AnalysisServices was
    introduced under a feature flag; 'AnalysisServicesConnection'.
    This new functionality depends on the SqlServer
    module, and must be present on the node. The SqlServer
    module can be installed on the node by leveraging the new DSC resource
    PSModule in the PowerShellGet
    module (v2.1.2 and higher). This new method does not work with the
    SQLPS module due to the SQLPS module does not load the correct assembly,
    while SqlServer
    module (v21.1.18080 and above) does. The new functionality is used
    when the parameter FeatureFlag is set to 'AnalysisServicesConnection'.
    This functionality will be the default in a future breaking release.
  • Under a feature flag 'AnalysisServicesConnection'. The detection of
    a successful connection to the SQL Server Analysis Services has also been
    changed. Now it actually evaluates the property Connected of the returned
    Microsoft.AnalysisServices.Server object. The new functionality is used
    when the parameter FeatureFlag is set to 'AnalysisServicesConnection'.
    This functionality will be the default in a future breaking release.
• SqlAgentAlert
  • Switched README file with SqlAgentFailsafe (issue #1709).
• SqlAgentFailsafe
  • Switched README file with SqlAgentAlert (issue #1709).

Added

• SqlMemory
  • Added two new optional parameters MinMemoryPercent and MaxMemoryPercent.
    Provides the ability to set the minimum and/or maximum buffer pool used by
    the SQL Server instance as a percentage of total server memory.
    (issue #1397).
• SqlRSSetup
  • Integration tests now install Microsoft SQL Server 2019 Reporting Services
    (issue #1717).
• SqlRS
  • Integration tests now configures Microsoft SQL Server 2019 Reporting Services.

Fixed

• SqlSetup
  • Fixed integration tests for SQL Server 2016 and SQL Server 2017.
• SqlServerDsc.Common
  • Fixed so that CredScan no longer reports a password false-positive
    (issue #1712).
• SqlRS
  • Fixed SSRS 2019 initialization (issue #1509).
  • Fix a problem that did not correctly evaluate the UseSSL property against
    the current state.