azure-pipelines.yml

trigger:
  branches:
    include:
    - main
  paths:
    include:
    - source/*
  tags:
    include:
    - "v*"
    exclude:
    - "*-*"

variables:
  buildFolderName: output
  buildArtifactName: output
  testResultFolderName: testResults
  testArtifactName: 'testResults_$(System.JobAttempt)'
  sourceFolderName: source
  defaultBranch: main

# cSpell: ignore setvariable updatebuildnumber DSCSQLTEST hqrmtest quickconfig dbatools
stages:
  - stage: Build
    jobs:
      - job: Package_Module
        displayName: 'Package Module'
        pool:
          vmImage: 'windows-latest'
        steps:
          - pwsh: |
              dotnet tool install --global GitVersion.Tool --version 5.*
              $gitVersionObject = dotnet-gitversion | ConvertFrom-Json
              $gitVersionObject.PSObject.Properties.ForEach{
                  Write-Host -Object "Setting Task Variable '$($_.Name)' with value '$($_.Value)'."
                  Write-Host -Object "##vso[task.setvariable variable=$($_.Name);]$($_.Value)"
              }
              Write-Host -Object "##vso[build.updatebuildnumber]$($gitVersionObject.FullSemVer)"
            displayName: Calculate ModuleVersion (GitVersion)
          - pwsh: |
              <#
                  This is intentionally not saved to RequiredModules. It is only
                  used for creating documentation and should not be part of the
                  build artifact.
              #>
              Write-Information -MessageData 'Removing SqlServer and SQLPS from the CI worker.' -InformationAction Continue
              Import-Module -Name ./tests/TestHelpers/CommonTestHelper.psm1
              Remove-PowerShellModuleFromCI -Name @('SqlServer', 'SQLPS')
              Remove-Module -Name CommonTestHelper
              Write-Information -MessageData 'Installing latest SqlServer on the CI worker' -InformationAction Continue
              Install-Module -Name SqlServer -Force -Confirm:$false -Verbose
              Get-Module -Name SqlServer -ListAvailable |
                  Select-Object -Property Name,Version,@{Name='Prerelease'; Expression={$_.PrivateData.PSData.Prerelease}}, Path
            displayName: Install SqlServer module
          - task: PowerShell@2
            name: package
            displayName: 'Build & Package Module'
            inputs:
              filePath: './build.ps1'
              arguments: '-ResolveDependency -tasks pack'
              pwsh: true
            env:
              ModuleVersion: $(NuGetVersionV2)
          - task: PublishPipelineArtifact@1
            displayName: 'Publish Build Artifact'
            inputs:
              targetPath: '$(buildFolderName)/'
              artifact: $(buildArtifactName)
              publishLocation: 'pipeline'
              parallel: true

  - stage: Quality_Test_and_Unit_Test
    displayName: 'Quality Test and Unit Test'
    dependsOn: Build
    jobs:
      - job: Determine_DSC_Resource_Test_Requirements
        displayName: 'Determine DSC Resource Test Requirements'
        pool:
          vmImage: 'windows-latest'
        steps:
          - task: DownloadPipelineArtifact@2
            displayName: 'Download Build Artifact'
            inputs:
              buildType: 'current'
              artifactName: $(buildArtifactName)
              targetPath: '$(Build.SourcesDirectory)/$(buildFolderName)'
          - task: PowerShell@2
            name: determineDscResourceTests
            displayName: 'Determine if DSC Resource Integration Tests Should Run'
            inputs:
              targetType: 'inline'
              script: |
                # Determine if we should run DSC resource integration tests based on branch logic
                $shouldRun = $false

                if ($env:SYSTEM_PULLREQUEST_TARGETBRANCH)
                {
                    $targetBranch = "origin/$env:SYSTEM_PULLREQUEST_TARGETBRANCH"
                    Write-Host "Pull request detected, targeting branch $targetBranch. Using script analysis to determine test requirements."
                    $shouldRun = & ./.build/Test-ShouldRunDscResourceIntegrationTests.ps1 -BaseBranch $targetBranch -CurrentBranch 'HEAD'
                }
                elseif ($env:BUILD.SOURCEBRANCHNAME -eq '$(defaultBranch)')
                {
                    Write-Host "Target is default branch ($(defaultBranch)). Always running DSC resource integration tests."
                    $shouldRun = $true
                }
                else
                {
                    Write-Host "Target is non-default branch ($env:BUILD.SOURCEBRANCH). Using script analysis to determine test requirements against default branch."
                    $shouldRun = & ./.build/Test-ShouldRunDscResourceIntegrationTests.ps1 -BaseBranch "origin/$(defaultBranch)" -CurrentBranch 'HEAD' -UseMergeBase
                }

                # Set Azure DevOps output variable for pipeline conditions
                Write-Host "##vso[task.setvariable variable=ShouldRunDscResourceIntegrationTests;isOutput=true]$shouldRun"

                Write-Host "Variable ShouldRunDscResourceIntegrationTests is set to: $shouldRun"
              pwsh: true

      - job: Test_HQRM
        displayName: 'HQRM'
        pool:
          vmImage: 'windows-latest'
        timeoutInMinutes: '0'
        variables:
          # This sets environment variable $env:SqlServerDscCI.
          SqlServerDscCI: true
        steps:
          - task: DownloadPipelineArtifact@2
            displayName: 'Download Build Artifact'
            inputs:
              buildType: 'current'
              artifactName: $(buildArtifactName)
              targetPath: '$(Build.SourcesDirectory)/$(buildFolderName)'
          # This task need to use Windows PowerShell due to a bug in PS7 that cannot
          # find/use class-based DSC resources that uses inheritance, which result in
          # the examples cannot compile. See the following issue for more information:
          # https://github.com/dsccommunity/DnsServerDsc/issues/268#issuecomment-918505230
          - powershell: |
              # Workaround for issue https://github.com/dsccommunity/DscResource.Test/issues/100
              ./build.ps1 -Task noop

              $pesterConfig = New-PesterConfiguration
              $pesterConfig.Run.Path = '.\tests\QA'
              $pesterConfig.Run.Throw = $true
              $pesterConfig.Output.Verbosity = 'Detailed'

              Invoke-Pester -Configuration $pesterConfig
            name: qualityTest
            displayName: 'Run SqlServerDsc QA Test'
          - task: PowerShell@2
            name: test
            displayName: 'Run HQRM Test'
            condition: succeededOrFailed()
            inputs:
              filePath: './build.ps1'
              arguments: '-Tasks hqrmtest'
              pwsh: false
          - task: PublishTestResults@2
            displayName: 'Publish Test Results'
            condition: succeededOrFailed()
            inputs:
              testResultsFormat: 'NUnit'
              testResultsFiles: '$(buildFolderName)/$(testResultFolderName)/NUnit*.xml'
              testRunTitle: 'HQRM'

      - job: Test_Unit
        displayName: 'Unit'
        pool:
          vmImage: 'windows-latest'
        timeoutInMinutes: '0'
        variables:
          # This sets environment variable $env:SqlServerDscCI.
          SqlServerDscCI: true
        steps:
          - task: DownloadPipelineArtifact@2
            displayName: 'Download Build Artifact'
            inputs:
              buildType: 'current'
              artifactName: $(buildArtifactName)
              targetPath: '$(Build.SourcesDirectory)/$(buildFolderName)'
          - task: PowerShell@2
            name: test
            displayName: 'Run Unit Test'
            inputs:
              filePath: './build.ps1'
              arguments: "-Tasks test -PesterPath 'tests/Unit'"
              pwsh: true
          - task: PublishTestResults@2
            displayName: 'Publish Test Results'
            condition: succeededOrFailed()
            inputs:
              testResultsFormat: 'NUnit'
              testResultsFiles: '$(buildFolderName)/$(testResultFolderName)/NUnit*.xml'
              testRunTitle: 'Unit (Windows Server 2019)'
          - task: PublishPipelineArtifact@1
            displayName: 'Publish Test Artifact'
            condition: succeededOrFailed()
            inputs:
              targetPath: '$(buildFolderName)/$(testResultFolderName)/'
              artifactName: $(testArtifactName)

      - job: Code_Coverage
        displayName: 'Publish Code Coverage'
        dependsOn: Test_Unit
        condition: succeededOrFailed()
        pool:
          vmImage: 'ubuntu-latest'
        timeoutInMinutes: '0'
        steps:
          - pwsh: |
              $repositoryOwner,$repositoryName = $env:BUILD_REPOSITORY_NAME -split '/'
              echo "##vso[task.setvariable variable=RepositoryOwner;isOutput=true]$repositoryOwner"
              echo "##vso[task.setvariable variable=RepositoryName;isOutput=true]$repositoryName"
            name: dscBuildVariable
            displayName: 'Set Environment Variables'
          - task: DownloadPipelineArtifact@2
            displayName: 'Download Build Artifact'
            inputs:
              buildType: 'current'
              artifactName: $(buildArtifactName)
              targetPath: '$(Build.SourcesDirectory)/$(buildFolderName)'
          - task: DownloadPipelineArtifact@2
            displayName: 'Download Test Artifact'
            inputs:
              buildType: 'current'
              artifactName: $(testArtifactName)
              targetPath: '$(Build.SourcesDirectory)/$(buildFolderName)/$(testResultFolderName)'
          - task: PublishCodeCoverageResults@1
            displayName: 'Publish Code Coverage to Azure DevOps'
            inputs:
              codeCoverageTool: 'JaCoCo'
              summaryFileLocation: '$(Build.SourcesDirectory)/$(buildFolderName)/$(testResultFolderName)/JaCoCo_coverage.xml'
              pathToSources: '$(Build.SourcesDirectory)/$(sourceFolderName)/'
          - script: |
              bash <(curl -s https://codecov.io/bash) -f "./$(buildFolderName)/$(testResultFolderName)/JaCoCo_coverage.xml" -F unit
            displayName: 'Publish Code Coverage to Codecov.io'

  - stage: Integration_Test_Commands_SqlServer
    displayName: 'Integration Test Commands - SQL Server'
    dependsOn: Quality_Test_and_Unit_Test
    jobs:
      - job: Test_Integration
        displayName: 'Commands'
        strategy:
          matrix:
            SQL2017_WIN2022:
              JOB_VMIMAGE: 'windows-2022'
              TEST_CONFIGURATION: 'Integration_SQL2017'
            SQL2019_WIN2022:
              JOB_VMIMAGE: 'windows-2022'
              TEST_CONFIGURATION: 'Integration_SQL2019'
            SQL2019_WIN2025:
              JOB_VMIMAGE: 'windows-2025'
              TEST_CONFIGURATION: 'Integration_SQL2019'
            SQL2022_WIN2022:
              JOB_VMIMAGE: 'windows-2022'
              TEST_CONFIGURATION: 'Integration_SQL2022'
            SQL2022_WIN2025:
              JOB_VMIMAGE: 'windows-2025'
              TEST_CONFIGURATION: 'Integration_SQL2022'
        pool:
          vmImage: $(JOB_VMIMAGE)
        timeoutInMinutes: '0'
        steps:
          - task: DownloadPipelineArtifact@2
            displayName: 'Download Build Artifact'
            inputs:
              buildType: 'current'
              artifactName: $(buildArtifactName)
              targetPath: '$(Build.SourcesDirectory)/$(buildFolderName)'
          - task: PowerShell@2
            name: configureWinRM
            displayName: 'Configure WinRM'
            inputs:
              targetType: 'inline'
              script: 'winrm quickconfig -quiet'
              pwsh: false
          - powershell: |
              Import-Module -Name ./tests/TestHelpers/CommonTestHelper.psm1
              Remove-PowerShellModuleFromCI -Name @('SqlServer', 'SQLPS')
              Remove-Module -Name CommonTestHelper
            name: cleanCIWorker
            displayName: 'Clean CI worker'
          - powershell: |
              ./build.ps1 -Tasks test -CodeCoverageThreshold 0 -PesterTag $(TEST_CONFIGURATION) -PesterPath @(
                  # Run the integration tests in a specific group order.
                  # Group 0
                  'tests/Integration/Commands/Prerequisites.Integration.Tests.ps1'
                  'tests/Integration/Commands/Save-SqlDscSqlServerMediaFile.Integration.Tests.ps1'
                  'tests/Integration/Commands/Import-SqlDscPreferredModule.Integration.Tests.ps1'
                  # Group 1
                  'tests/Integration/Commands/Install-SqlDscServer.Integration.Tests.ps1'
                  'tests/Integration/Commands/Connect-SqlDscDatabaseEngine.Integration.Tests.ps1'
                  # Group 2
                  'tests/Integration/Commands/Assert-SqlDscLogin.Integration.Tests.ps1'
                  'tests/Integration/Commands/New-SqlDscLogin.Integration.Tests.ps1'
                  'tests/Integration/Commands/Get-SqlDscLogin.Integration.Tests.ps1'
                  'tests/Integration/Commands/Get-SqlDscConfigurationOption.Integration.Tests.ps1'
                  'tests/Integration/Commands/Set-SqlDscConfigurationOption.Integration.Tests.ps1'
                  'tests/Integration/Commands/Test-SqlDscConfigurationOption.Integration.Tests.ps1'
                  'tests/Integration/Commands/Set-SqlDscStartupParameter.Integration.Tests.ps1'
                  'tests/Integration/Commands/Test-SqlDscIsSupportedFeature.Integration.Tests.ps1'
                  'tests/Integration/Commands/Get-SqlDscManagedComputer.Integration.Tests.ps1'
                  'tests/Integration/Commands/Set-SqlDscTraceFlag.Integration.Tests.ps1'
                  'tests/Integration/Commands/Get-SqlDscManagedComputerInstance.Integration.Tests.ps1'
                  'tests/Integration/Commands/Get-SqlDscManagedComputerService.Integration.Tests.ps1'
                  'tests/Integration/Commands/Get-SqlDscServerProtocolName.Integration.Tests.ps1'
                  'tests/Integration/Commands/ConvertTo-SqlDscEditionName.Integration.Tests.ps1'
                  'tests/Integration/Commands/Get-SqlDscServerProtocol.Integration.Tests.ps1'
                  'tests/Integration/Commands/Disable-SqlDscLogin.Integration.Tests.ps1'
                  'tests/Integration/Commands/Enable-SqlDscLogin.Integration.Tests.ps1'
                  'tests/Integration/Commands/Test-SqlDscIsLogin.Integration.Tests.ps1'
                  'tests/Integration/Commands/Test-SqlDscIsLoginEnabled.Integration.Tests.ps1'
                  'tests/Integration/Commands/New-SqlDscRole.Integration.Tests.ps1'
                  'tests/Integration/Commands/Get-SqlDscRole.Integration.Tests.ps1'
                  'tests/Integration/Commands/Test-SqlDscIsRole.Integration.Tests.ps1'
                  'tests/Integration/Commands/Grant-SqlDscServerPermission.Integration.Tests.ps1'
                  'tests/Integration/Commands/Get-SqlDscServerPermission.Integration.Tests.ps1'
                  'tests/Integration/Commands/Set-SqlDscServerPermission.Integration.Tests.ps1'
                  'tests/Integration/Commands/ConvertFrom-SqlDscServerPermission.Integration.Tests.ps1'
                  'tests/Integration/Commands/Test-SqlDscServerPermission.Integration.Tests.ps1'
                  'tests/Integration/Commands/Deny-SqlDscServerPermission.Integration.Tests.ps1'
                  'tests/Integration/Commands/Revoke-SqlDscServerPermission.Integration.Tests.ps1'
                  'tests/Integration/Commands/Get-SqlDscDatabase.Integration.Tests.ps1'
                  'tests/Integration/Commands/New-SqlDscDatabase.Integration.Tests.ps1'
                  'tests/Integration/Commands/Set-SqlDscDatabase.Integration.Tests.ps1'
                  'tests/Integration/Commands/Test-SqlDscDatabase.Integration.Tests.ps1'
                  'tests/Integration/Commands/Set-SqlDscDatabasePermission.Integration.Tests.ps1'
                  'tests/Integration/Commands/ConvertTo-SqlDscDatabasePermission.Integration.Tests.ps1'
                  'tests/Integration/Commands/Get-SqlDscAgentAlert.Integration.Tests.ps1'
                  'tests/Integration/Commands/New-SqlDscAgentAlert.Integration.Tests.ps1'
                  'tests/Integration/Commands/New-SqlDscAudit.Integration.Tests.ps1'
                  'tests/Integration/Commands/Set-SqlDscAgentAlert.Integration.Tests.ps1'
                  'tests/Integration/Commands/Test-SqlDscAgentAlertProperty.Integration.Tests.ps1'
                  'tests/Integration/Commands/Test-SqlDscIsAgentAlert.Integration.Tests.ps1'
                  'tests/Integration/Commands/Get-SqlDscAgentOperator.Integration.Tests.ps1'
                  'tests/Integration/Commands/New-SqlDscAgentOperator.Integration.Tests.ps1'
                  'tests/Integration/Commands/Set-SqlDscAgentOperator.Integration.Tests.ps1'
                  'tests/Integration/Commands/Test-SqlDscIsAgentOperator.Integration.Tests.ps1'
                  'tests/Integration/Commands/Assert-SqlDscAgentOperator.Integration.Tests.ps1'
                  'tests/Integration/Commands/Enable-SqlDscAgentOperator.Integration.Tests.ps1'
                  'tests/Integration/Commands/Disable-SqlDscAgentOperator.Integration.Tests.ps1'
                  'tests/Integration/Commands/Disable-SqlDscAudit.Integration.Tests.ps1'
                  'tests/Integration/Commands/Add-SqlDscTraceFlag.Integration.Tests.ps1'
                  # Group 8
                  'tests/Integration/Commands/Remove-SqlDscAgentAlert.Integration.Tests.ps1'
                  'tests/Integration/Commands/Remove-SqlDscAgentOperator.Integration.Tests.ps1'
                  'tests/Integration/Commands/Remove-SqlDscAudit.Integration.Tests.ps1'
                  'tests/Integration/Commands/Set-SqlDscAudit.Integration.Tests.ps1'
                  'tests/Integration/Commands/Remove-SqlDscDatabase.Integration.Tests.ps1'
                  'tests/Integration/Commands/Remove-SqlDscRole.Integration.Tests.ps1'
                  'tests/Integration/Commands/Remove-SqlDscLogin.Integration.Tests.ps1'
                  'tests/Integration/Commands/Remove-SqlDscTraceFlag.Integration.Tests.ps1'
                  # Group 9
                  'tests/Integration/Commands/Uninstall-SqlDscServer.Integration.Tests.ps1'
              )
            name: test
            displayName: 'Run Integration Test'
          - task: PublishTestResults@2
            displayName: 'Publish Test Results'
            condition: succeededOrFailed()
            inputs:
              testResultsFormat: 'NUnit'
              testResultsFiles: '$(buildFolderName)/$(testResultFolderName)/NUnit*.xml'
              testRunTitle: 'Integration Commands ($(TEST_CONFIGURATION) / $(JOB_VMIMAGE))'

  - stage: Integration_Test_Commands_ReportingServices
    displayName: 'Integration Test Commands - Reporting Services'
    dependsOn: Integration_Test_Commands_SqlServer
    jobs:
      - job: Test_Integration
        displayName: 'Commands'
        strategy:
          matrix:
            SQL2017_WIN2022:
              JOB_VMIMAGE: 'windows-2022'
              TEST_CONFIGURATION: 'Integration_SQL2017_RS'
            SQL2019_WIN2022:
              JOB_VMIMAGE: 'windows-2022'
              TEST_CONFIGURATION: 'Integration_SQL2019_RS'
            SQL2019_WIN2025:
              JOB_VMIMAGE: 'windows-2025'
              TEST_CONFIGURATION: 'Integration_SQL2019_RS'
            SQL2022_WIN2022:
              JOB_VMIMAGE: 'windows-2022'
              TEST_CONFIGURATION: 'Integration_SQL2022_RS'
            SQL2022_WIN2025:
              JOB_VMIMAGE: 'windows-2025'
              TEST_CONFIGURATION: 'Integration_SQL2022_RS'
        pool:
          vmImage: $(JOB_VMIMAGE)
        timeoutInMinutes: '0'
        steps:
          - task: DownloadPipelineArtifact@2
            displayName: 'Download Build Artifact'
            inputs:
              buildType: 'current'
              artifactName: $(buildArtifactName)
              targetPath: '$(Build.SourcesDirectory)/$(buildFolderName)'
          - task: PowerShell@2
            name: configureWinRM
            displayName: 'Configure WinRM'
            inputs:
              targetType: 'inline'
              script: 'winrm quickconfig -quiet'
              pwsh: false
          - powershell: |
              Import-Module -Name ./tests/TestHelpers/CommonTestHelper.psm1
              Remove-PowerShellModuleFromCI -Name @('SqlServer', 'SQLPS')
              Remove-Module -Name CommonTestHelper
            name: cleanCIWorker
            displayName: 'Clean CI worker'
          - powershell: |
              ./build.ps1 -Tasks test -CodeCoverageThreshold 0 -PesterTag $(TEST_CONFIGURATION) -PesterPath @(
                  # Run the integration tests in a specific group order.
                  # Group 0
                  'tests/Integration/Commands/Prerequisites.Integration.Tests.ps1'
                  'tests/Integration/Commands/Save-SqlDscSqlServerMediaFile.Integration.Tests.ps1'
                  'tests/Integration/Commands/Import-SqlDscPreferredModule.Integration.Tests.ps1'
                  # Group 1
                  'tests/Integration/Commands/Install-SqlDscReportingService.Integration.Tests.ps1'
                  # Group 2
                  'tests/Integration/Commands/Get-SqlDscInstalledInstance.Integration.Tests.ps1'
                  'tests/Integration/Commands/Get-SqlDscRSSetupConfiguration.Integration.Tests.ps1'
                  'tests/Integration/Commands/Test-SqlDscRSInstalled.Integration.Tests.ps1'
                  # Group 8
                  'tests/Integration/Commands/Repair-SqlDscReportingService.Integration.Tests.ps1'
                  # Group 9
                  'tests/Integration/Commands/Uninstall-SqlDscReportingService.Integration.Tests.ps1'
              )
            name: test
            displayName: 'Run Integration Test'
          - task: PublishTestResults@2
            displayName: 'Publish Test Results'
            condition: succeededOrFailed()
            inputs:
              testResultsFormat: 'NUnit'
              testResultsFiles: '$(buildFolderName)/$(testResultFolderName)/NUnit*.xml'
              testRunTitle: 'Integration Commands ($(TEST_CONFIGURATION) / $(JOB_VMIMAGE))'

  - stage: Integration_Test_Commands_BIReportServer
    displayName: 'Integration Test Commands - BI Report Server'
    dependsOn: Integration_Test_Commands_SqlServer
    jobs:
      - job: Test_Integration
        displayName: 'Commands'
        strategy:
          matrix:
            PowerBI_WIN2022:
              JOB_VMIMAGE: 'windows-2022'
              TEST_CONFIGURATION: 'Integration_PowerBI'
            PowerBI_WIN2025:
              JOB_VMIMAGE: 'windows-2025'
              TEST_CONFIGURATION: 'Integration_PowerBI'
        pool:
          vmImage: $(JOB_VMIMAGE)
        timeoutInMinutes: '0'
        steps:
          - task: DownloadPipelineArtifact@2
            displayName: 'Download Build Artifact'
            inputs:
              buildType: 'current'
              artifactName: $(buildArtifactName)
              targetPath: '$(Build.SourcesDirectory)/$(buildFolderName)'
          - task: PowerShell@2
            name: configureWinRM
            displayName: 'Configure WinRM'
            inputs:
              targetType: 'inline'
              script: 'winrm quickconfig -quiet'
              pwsh: false
          - powershell: |
              Import-Module -Name ./tests/TestHelpers/CommonTestHelper.psm1
              Remove-PowerShellModuleFromCI -Name @('SqlServer', 'SQLPS')
              Remove-Module -Name CommonTestHelper
            name: cleanCIWorker
            displayName: 'Clean CI worker'
          - powershell: |
              ./build.ps1 -Tasks test -CodeCoverageThreshold 0 -PesterTag $(TEST_CONFIGURATION) -PesterPath @(
                  # Run the integration tests in a specific group order.
                  # Group 0
                  'tests/Integration/Commands/Prerequisites.Integration.Tests.ps1'
                  'tests/Integration/Commands/Save-SqlDscSqlServerMediaFile.Integration.Tests.ps1'
                  'tests/Integration/Commands/Import-SqlDscPreferredModule.Integration.Tests.ps1'
                  # Group 1
                  'tests/Integration/Commands/Install-SqlDscBIReportServer.Integration.Tests.ps1'
                  # Group 2
                  'tests/Integration/Commands/Get-SqlDscInstalledInstance.Integration.Tests.ps1'
                  'tests/Integration/Commands/Get-SqlDscRSSetupConfiguration.Integration.Tests.ps1'
                  'tests/Integration/Commands/Test-SqlDscRSInstalled.Integration.Tests.ps1'
                  # Group 8
                  'tests/Integration/Commands/Repair-SqlDscBIReportServer.Integration.Tests.ps1'
                  # Group 9
                  'tests/Integration/Commands/Uninstall-SqlDscBIReportServer.Integration.Tests.ps1'
              )
            name: test
            displayName: 'Run Integration Test'
          - task: PublishTestResults@2
            displayName: 'Publish Test Results'
            condition: succeededOrFailed()
            inputs:
              testResultsFormat: 'NUnit'
              testResultsFiles: '$(buildFolderName)/$(testResultFolderName)/NUnit*.xml'
              testRunTitle: 'Integration Commands ($(TEST_CONFIGURATION) / $(JOB_VMIMAGE))'

  - stage: Integration_Test_Resources_SqlServer
    displayName: 'Integration Test Resources - SQL Server'
    dependsOn: Quality_Test_and_Unit_Test
    condition: |
      and(
        succeeded(),
        eq(lower(dependencies.Quality_Test_and_Unit_Test.outputs['Determine_DSC_Resource_Test_Requirements.determineDscResourceTests.ShouldRunDscResourceIntegrationTests']), 'true')
      )
    jobs:
      - job: Test_Integration
        displayName: 'Integration'
        strategy:
          matrix:
            SQL2017_WIN2022:
              JOB_VMIMAGE: 'windows-2022'
              TEST_CONFIGURATION: 'Integration_SQL2017'
            SQL2019_WIN2022:
              JOB_VMIMAGE: 'windows-2022'
              TEST_CONFIGURATION: 'Integration_SQL2019'
            SQL2019_WIN2025:
              JOB_VMIMAGE: 'windows-2025'
              TEST_CONFIGURATION: 'Integration_SQL2019'
            SQL2022_WIN2022:
              JOB_VMIMAGE: 'windows-2022'
              TEST_CONFIGURATION: 'Integration_SQL2022'
            SQL2022_WIN2025:
              JOB_VMIMAGE: 'windows-2025'
              TEST_CONFIGURATION: 'Integration_SQL2022'
        pool:
          vmImage: $(JOB_VMIMAGE)
        timeoutInMinutes: '0'
        steps:
          - task: DownloadPipelineArtifact@2
            displayName: 'Download Build Artifact'
            inputs:
              buildType: 'current'
              artifactName: $(buildArtifactName)
              targetPath: '$(Build.SourcesDirectory)/$(buildFolderName)'
          - task: PowerShell@2
            name: configureWinRM
            displayName: 'Configure WinRM'
            inputs:
              targetType: 'inline'
              script: 'winrm quickconfig -quiet'
              pwsh: false
          - powershell: |
              Import-Module -Name ./tests/TestHelpers/CommonTestHelper.psm1
              Remove-PowerShellModuleFromCI -Name @('SqlServer', 'SQLPS')
              Remove-Module -Name CommonTestHelper
            name: cleanCIWorker
            displayName: 'Clean CI worker'
          - powershell: |
              ./build.ps1 -Tasks test -CodeCoverageThreshold 0 -PesterTag $(TEST_CONFIGURATION) -PesterPath @(
                  # Run the integration tests in a specific group order.
                  # Group 1
                  'tests/Integration/Resources/DSC_SqlSetup.Integration.Tests.ps1'
                  # Group 2
                  'tests/Integration/Resources/DSC_SqlAgentAlert.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlLogin.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlEndpoint.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlDatabaseMail.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlRSSetup.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlDatabaseDefaultLocation.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlDatabase.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlAlwaysOnService.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlAgentOperator.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlServiceAccount.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlAgentFailsafe.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlTraceFlag.Integration.Tests.ps1'
                  # Group 3
                  'tests/Integration/Resources/DSC_SqlRole.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlRS_Default.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlDatabaseUser.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlReplication.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlAudit.Integration.Tests.ps1'
                  # Group 4
                  'tests/Integration/Resources/DSC_SqlScript.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlDatabasePermission.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlPermission.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlWindowsFirewall.Integration.Tests.ps1'
                  # Group 5
                  'tests/Integration/Resources/DSC_SqlSecureConnection.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlScriptQuery.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlProtocol.Integration.Tests.ps1'
                  # Group 6 (tests makes changes that could make SQL Server to loose connectivity)
                  'tests/Integration/Resources/DSC_SqlProtocolTcpIp.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlDatabaseObjectPermission.Integration.Tests.ps1'
              )
            name: test
            displayName: 'Run Integration Test'
          - task: PublishTestResults@2
            displayName: 'Publish Test Results'
            condition: succeededOrFailed()
            inputs:
              testResultsFormat: 'NUnit'
              testResultsFiles: '$(buildFolderName)/$(testResultFolderName)/NUnit*.xml'
              testRunTitle: 'Integration Resources ($(TEST_CONFIGURATION) / $(JOB_VMIMAGE))'

  - stage: Integration_Test_Resources_SqlServer_dbatools
    displayName: 'Integration Test Resources - SQL Server (dbatools)'
    dependsOn: Integration_Test_Resources_SqlServer
    condition: |
      and(
        succeeded(),
        eq(lower(dependencies.Quality_Test_and_Unit_Test.outputs['Determine_DSC_Resource_Test_Requirements.determineDscResourceTests.ShouldRunDscResourceIntegrationTests']), 'true')
      )
    jobs:
      - job: Test_Integration
        displayName: 'Integration'
        strategy:
          matrix:
            SQL2017_WIN2022:
              JOB_VMIMAGE: 'windows-2022'
              TEST_CONFIGURATION: 'Integration_SQL2017'
            SQL2019_WIN2022:
              JOB_VMIMAGE: 'windows-2022'
              TEST_CONFIGURATION: 'Integration_SQL2019'
            SQL2022_WIN2022:
              JOB_VMIMAGE: 'windows-2022'
              TEST_CONFIGURATION: 'Integration_SQL2022'
        pool:
          vmImage: $(JOB_VMIMAGE)
        timeoutInMinutes: '0'
        variables:
          SMODefaultModuleName: 'dbatools'
        steps:
          - task: DownloadPipelineArtifact@2
            displayName: 'Download Build Artifact'
            inputs:
              buildType: 'current'
              artifactName: $(buildArtifactName)
              targetPath: '$(Build.SourcesDirectory)/$(buildFolderName)'
          - task: PowerShell@2
            name: configureWinRM
            displayName: 'Configure WinRM'
            inputs:
              targetType: 'inline'
              script: 'winrm quickconfig -quiet'
              pwsh: false
          - powershell: |
              Import-Module -Name ./tests/TestHelpers/CommonTestHelper.psm1
              # Make sure to keep SQLPS so that Invoke-SqlCmd is available.
              Remove-PowerShellModuleFromCI -Name @('SqlServer')
              Remove-Module -Name CommonTestHelper
            name: cleanCIWorker
            displayName: 'Clean CI worker'
          - powershell: |
              ./build.ps1 -Tasks test -CodeCoverageThreshold 0 -PesterTag $(TEST_CONFIGURATION) -PesterPath @(
                  # Run the integration tests in a specific group order.
                  # Group 1
                  'tests/Integration/Resources/DSC_SqlSetup.Integration.Tests.ps1'
                  # Group 2
                  'tests/Integration/Resources/DSC_SqlAgentAlert.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlLogin.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlEndpoint.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlDatabaseMail.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlRSSetup.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlDatabaseDefaultLocation.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlDatabase.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlAlwaysOnService.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlAgentOperator.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlServiceAccount.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlAgentFailsafe.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlTraceFlag.Integration.Tests.ps1'
                  # Group 3
                  'tests/Integration/Resources/DSC_SqlRole.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlRS_Default.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlDatabaseUser.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlReplication.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlAudit.Integration.Tests.ps1'
                  # Group 4
                  'tests/Integration/Resources/DSC_SqlScript.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlDatabasePermission.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlPermission.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlWindowsFirewall.Integration.Tests.ps1'
                  # Group 5
                  'tests/Integration/Resources/DSC_SqlSecureConnection.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlScriptQuery.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlProtocol.Integration.Tests.ps1'
                  # Group 6 (tests makes changes that could make SQL Server to loose connectivity)
                  'tests/Integration/Resources/DSC_SqlProtocolTcpIp.Integration.Tests.ps1'
                  'tests/Integration/Resources/DSC_SqlDatabaseObjectPermission.Integration.Tests.ps1'
              )
            name: test
            displayName: 'Run Integration Test'
          - task: PublishTestResults@2
            displayName: 'Publish Test Results'
            condition: succeededOrFailed()
            inputs:
              testResultsFormat: 'NUnit'
              testResultsFiles: '$(buildFolderName)/$(testResultFolderName)/NUnit*.xml'
              testRunTitle: 'Integration (dbatools) ($(TEST_CONFIGURATION) / $(JOB_VMIMAGE))'

  - stage: Integration_Test_Resources_ReportingServices
    displayName: 'Integration Test Resources - Reporting Services'
    dependsOn: Integration_Test_Resources_SqlServer
    condition: |
      and(
        succeeded(),
        eq(lower(dependencies.Quality_Test_and_Unit_Test.outputs['Determine_DSC_Resource_Test_Requirements.determineDscResourceTests.ShouldRunDscResourceIntegrationTests']), 'true')
      )
    jobs:
      - job: Test_Integration
        displayName: 'Integration'
        strategy:
          matrix:
            SQL2017_WIN2022:
              JOB_VMIMAGE: 'windows-2022'
              TEST_CONFIGURATION: 'Integration_SQL2017'
            SQL2019_WIN2022:
              JOB_VMIMAGE: 'windows-2022'
              TEST_CONFIGURATION: 'Integration_SQL2019'
            SQL2019_WIN2025:
              JOB_VMIMAGE: 'windows-2025'
              TEST_CONFIGURATION: 'Integration_SQL2019'
            SQL2022_WIN2022:
              JOB_VMIMAGE: 'windows-2022'
              TEST_CONFIGURATION: 'Integration_SQL2022'
            SQL2022_WIN2025:
              JOB_VMIMAGE: 'windows-2025'
              TEST_CONFIGURATION: 'Integration_SQL2022'
        variables:
          SKIP_DATABASE_ENGINE_DEFAULT_INSTANCE: true
          SKIP_ANALYSIS_MULTI_INSTANCE: true
          SKIP_ANALYSIS_TABULAR_INSTANCE: true
          SMODefaultModuleName: 'SqlServer'
        pool:
          vmImage: $(JOB_VMIMAGE)
        timeoutInMinutes: '0'
        steps:
          - task: DownloadPipelineArtifact@2
            displayName: 'Download Build Artifact'
            inputs:
              buildType: 'current'
              artifactName: $(buildArtifactName)
              targetPath: '$(Build.SourcesDirectory)/$(buildFolderName)'
          - task: PowerShell@2
            name: configureWinRM
            displayName: 'Configure WinRM'
            inputs:
              targetType: 'inline'
              script: 'winrm quickconfig -quiet'
              pwsh: false
          - powershell: |
              Import-Module -Name ./tests/TestHelpers/CommonTestHelper.psm1
              Remove-PowerShellModuleFromCI -Name @('SqlServer', 'SQLPS')
              Remove-Module -Name CommonTestHelper
            name: cleanCIWorker
            displayName: 'Clean CI worker'
          - powershell: |
              ./build.ps1 -Tasks test -CodeCoverageThreshold 0 -PesterTag $(TEST_CONFIGURATION) -PesterPath @(
                  # Run the integration tests in a specific group order.
                  # Group 1
                  'tests/Integration/Resources/DSC_SqlSetup.Integration.Tests.ps1'
                  # Group 2
                  'tests/Integration/Resources/DSC_SqlRSSetup.Integration.Tests.ps1'
                  # Group 3
                  'tests/Integration/Resources/DSC_SqlRS.Integration.Tests.ps1'
              )
            name: test
            displayName: 'Run Reporting Services Integration Test'
          - task: PublishTestResults@2
            displayName: 'Publish Test Results'
            condition: succeededOrFailed()
            inputs:
              testResultsFormat: 'NUnit'
              testResultsFiles: '$(buildFolderName)/$(testResultFolderName)/NUnit*.xml'
              testRunTitle: 'Integration RS ($(TEST_CONFIGURATION) / $(JOB_VMIMAGE))'

  - stage: Integration_Test_Resources_PowerBIReportServer
    displayName: 'Integration Test Resources - Power BI Report Server'
    dependsOn: Quality_Test_and_Unit_Test
    condition: |
      and(
        succeeded(),
        eq(lower(dependencies.Quality_Test_and_Unit_Test.outputs['Determine_DSC_Resource_Test_Requirements.determineDscResourceTests.ShouldRunDscResourceIntegrationTests']), 'true')
      )
    jobs:
      - job: Test_Integration
        displayName: 'Integration'
        strategy:
          matrix:
            PowerBI_WIN2022:
              JOB_VMIMAGE: 'windows-2022'
              TEST_CONFIGURATION: 'Integration_PowerBI'
            PowerBI_WIN2025:
              JOB_VMIMAGE: 'windows-2025'
              TEST_CONFIGURATION: 'Integration_PowerBI'
        variables:
          SKIP_DATABASE_ENGINE_DEFAULT_INSTANCE: true
          SKIP_ANALYSIS_MULTI_INSTANCE: true
          SKIP_ANALYSIS_TABULAR_INSTANCE: true
          SMODefaultModuleName: 'SqlServer'
        pool:
          vmImage: $(JOB_VMIMAGE)
        timeoutInMinutes: '0'
        steps:
          - task: DownloadPipelineArtifact@2
            displayName: 'Download Build Artifact'
            inputs:
              buildType: 'current'
              artifactName: $(buildArtifactName)
              targetPath: '$(Build.SourcesDirectory)/$(buildFolderName)'
          - task: PowerShell@2
            name: configureWinRM
            displayName: 'Configure WinRM'
            inputs:
              targetType: 'inline'
              script: 'winrm quickconfig -quiet'
              pwsh: false
          - powershell: |
              Import-Module -Name ./tests/TestHelpers/CommonTestHelper.psm1
              Remove-PowerShellModuleFromCI -Name @('SqlServer', 'SQLPS')
              Remove-Module -Name CommonTestHelper
            name: cleanCIWorker
            displayName: 'Clean CI worker'
          - powershell: |
              ./build.ps1 -Tasks test -CodeCoverageThreshold 0 -PesterTag $(TEST_CONFIGURATION) -PesterPath @(
                  # Run the integration tests in a specific group order.
                  # Group 1
                  'tests/Integration/Resources/DSC_SqlSetup.Integration.Tests.ps1'
                  # Group 2
                  'tests/Integration/Resources/DSC_SqlRSSetup.Integration.Tests.ps1'
                  # Group 3
                  'tests/Integration/Resources/DSC_SqlRS.Integration.Tests.ps1'
              )
            name: test
            displayName: 'Run Reporting Services Integration Test'
          - task: PublishTestResults@2
            displayName: 'Publish Test Results'
            condition: succeededOrFailed()
            inputs:
              testResultsFormat: 'NUnit'
              testResultsFiles: '$(buildFolderName)/$(testResultFolderName)/NUnit*.xml'
              testRunTitle: 'Integration RS ($(TEST_CONFIGURATION) / $(JOB_VMIMAGE))'

  - stage: Integration_Test_Resources_ReportingServices_dbatools
    displayName: 'Integration Test Resources - Reporting Services (dbatools)'
    dependsOn: Integration_Test_Resources_SqlServer
    condition: |
      and(
        succeeded(),
        eq(lower(dependencies.Quality_Test_and_Unit_Test.outputs['Determine_DSC_Resource_Test_Requirements.determineDscResourceTests.ShouldRunDscResourceIntegrationTests']), 'true')
      )
    jobs:
      - job: Test_Integration
        displayName: 'Integration'
        strategy:
          matrix:
            SQL2017_WIN2022:
              JOB_VMIMAGE: 'windows-2022'
              TEST_CONFIGURATION: 'Integration_SQL2017'
            SQL2019_WIN2022:
              JOB_VMIMAGE: 'windows-2022'
              TEST_CONFIGURATION: 'Integration_SQL2019'
            SQL2022_WIN2022:
              JOB_VMIMAGE: 'windows-2022'
              TEST_CONFIGURATION: 'Integration_SQL2022'
        variables:
          SKIP_DATABASE_ENGINE_DEFAULT_INSTANCE: true
          SKIP_ANALYSIS_MULTI_INSTANCE: true
          SKIP_ANALYSIS_TABULAR_INSTANCE: true
          SMODefaultModuleName: 'dbatools'
        pool:
          vmImage: $(JOB_VMIMAGE)
        timeoutInMinutes: '0'
        steps:
          - task: DownloadPipelineArtifact@2
            displayName: 'Download Build Artifact'
            inputs:
              buildType: 'current'
              artifactName: $(buildArtifactName)
              targetPath: '$(Build.SourcesDirectory)/$(buildFolderName)'
          - task: PowerShell@2
            name: configureWinRM
            displayName: 'Configure WinRM'
            inputs:
              targetType: 'inline'
              script: 'winrm quickconfig -quiet'
              pwsh: false
          - powershell: |
              ./build.ps1 -Tasks test -CodeCoverageThreshold 0 -PesterTag $(TEST_CONFIGURATION) -PesterPath @(
                  # Run the integration tests in a specific group order.
                  # Group 1
                  'tests/Integration/Resources/DSC_SqlSetup.Integration.Tests.ps1'
                  # Group 2
                  'tests/Integration/Resources/DSC_SqlRSSetup.Integration.Tests.ps1'
                  # Group 3
                  'tests/Integration/Resources/DSC_SqlRS.Integration.Tests.ps1'
              )
            name: test
            displayName: 'Run Reporting Services Integration Test'
          - task: PublishTestResults@2
            displayName: 'Publish Test Results'
            condition: succeededOrFailed()
            inputs:
              testResultsFormat: 'NUnit'
              testResultsFiles: '$(buildFolderName)/$(testResultFolderName)/NUnit*.xml'
              testRunTitle: 'Integration RS (dbatools) ($(TEST_CONFIGURATION) / $(JOB_VMIMAGE))'

  - stage: Deploy
    dependsOn:
    - Quality_Test_and_Unit_Test
    - Integration_Test_Commands_SqlServer
    - Integration_Test_Commands_ReportingServices
    - Integration_Test_Commands_BIReportServer
    - Integration_Test_Resources_SqlServer
    - Integration_Test_Resources_SqlServer_dbatools
    - Integration_Test_Resources_ReportingServices
    - Integration_Test_Resources_PowerBIReportServer
    - Integration_Test_Resources_ReportingServices_dbatools
    condition: |
      and(
        succeeded(),
        or(
          eq(variables['Build.SourceBranch'], 'refs/heads/main'),
          startsWith(variables['Build.SourceBranch'], 'refs/tags/')
        ),
        contains(variables['System.TeamFoundationCollectionUri'], 'dsccommunity')
      )
    jobs:
      - job: Deploy_Module
        displayName: 'Deploy Module'
        pool:
          vmImage: 'ubuntu-latest'
        steps:
          - task: DownloadPipelineArtifact@2
            displayName: 'Download Build Artifact'
            inputs:
              buildType: 'current'
              artifactName: $(buildArtifactName)
              targetPath: '$(Build.SourcesDirectory)/$(buildFolderName)'
          - task: PowerShell@2
            name: publishRelease
            displayName: 'Publish Release'
            inputs:
              filePath: './build.ps1'
              arguments: '-tasks publish'
              pwsh: true
            env:
              GitHubToken: $(GitHubToken)
              GalleryApiToken: $(GalleryApiToken)
              ReleaseBranch: $(defaultBranch)
              MainGitBranch: $(defaultBranch)
          - task: PowerShell@2
            name: sendChangelogPR
            displayName: 'Send Changelog PR'
            inputs:
              filePath: './build.ps1'
              arguments: '-tasks Create_ChangeLog_GitHub_PR'
              pwsh: true
            env:
              GitHubToken: $(GitHubToken)
              ReleaseBranch: $(defaultBranch)
              MainGitBranch: $(defaultBranch)