azure-pipelines Setup All SQL Servers.yml

variables:
  NUGET_VERSION: 0.1
  PS1_TROUBLE_SHOOT: On
  # Short name is critical for 2017 and older
  PS1_REPO_DOWNLOAD_FOLDER_1: 'B:\SQL-Media'
  PS1_REPO_DOWNLOAD_FOLDER_2: 'D:\SQL-Media'
  PS1_REPO_DOWNLOAD_FOLDER_3: 'C:\SQL-Media'

trigger:
  branches:
    include:
    - main

jobs:

- job: Install
  pool:
    vmImage: '$(IMAGE)'
  timeoutInMinutes: 180
  cancelTimeoutInMinutes: 7
  strategy:
    maxParallel: 10
    matrix:
      '2008R2-x64 on Server2019':
        IMAGE: 'windows-2019'
        TEST_SQL_VERSIONS: '2008R2-x64'
        TEST_SQL_UPDATES: False
      '2008R2-x86 on Server2019':
        IMAGE: 'windows-2019'
        TEST_SQL_VERSIONS: '2008R2-x86'
        TEST_SQL_UPDATES: False

      '2012-x86 Developer on Server2022':
        IMAGE: 'windows-2022'
        TEST_SQL_VERSIONS: '2012-x86'
        TEST_SQL_MEDIA: Developer
        TEST_SQL_UPDATES: False
      '2012-x64 Developer on Server2022':
        IMAGE: 'windows-2022'
        TEST_SQL_VERSIONS: '2012-x64'
        TEST_SQL_MEDIA: Developer
        TEST_SQL_UPDATES: False

      '2012-x86 Developer on Server2019':
        IMAGE: 'windows-2019'
        TEST_SQL_VERSIONS: '2012-x86'
        TEST_SQL_MEDIA: Developer
        TEST_SQL_UPDATES: False
      '2012-x64 Developer on Server2019':
        IMAGE: 'windows-2019'
        TEST_SQL_VERSIONS: '2012-x64'
        TEST_SQL_MEDIA: Developer
        TEST_SQL_UPDATES: False

      'Developer 2022 2019 2017 2016 2014 on Server2022':
        IMAGE: 'windows-2019'
        TEST_SQL_VERSIONS: '2022 2019 2017 2016 2014'
        TEST_SQL_MEDIA: Developer
        TEST_SQL_UPDATES: False
      'Developer 2022 2019 2017 2016 2014 on Server2019':
        IMAGE: 'windows-2019'
        TEST_SQL_VERSIONS: '2022 2019 2017 2016 2014'
        TEST_SQL_MEDIA: Developer
        TEST_SQL_UPDATES: False

      '2014 Developer on Server2022':
        IMAGE: 'windows-2019'
        TEST_SQL_VERSIONS: '2014'
        TEST_SQL_MEDIA: Developer
        TEST_SQL_UPDATES: False
      '2014 Developer on Server2019':
        IMAGE: 'windows-2022'
        TEST_SQL_VERSIONS: '2014'
        TEST_SQL_MEDIA: Developer
        TEST_SQL_UPDATES: False

      '2008R2-x64 Advanced on Server2022':
        IMAGE: 'windows-2022'
        TEST_SQL_VERSIONS: '2008R2-x64'
        TEST_SQL_MEDIA: Advanced
        TEST_SQL_UPDATES: False
      '2008R2-x64 Core on Server2022':
        IMAGE: 'windows-2022'
        TEST_SQL_VERSIONS: '2008R2-x64'
        TEST_SQL_MEDIA: Core
        TEST_SQL_UPDATES: False
      '2008R2-x86 Advanced on Server2022':
        IMAGE: 'windows-2022'
        TEST_SQL_VERSIONS: '2008R2-x86'
        TEST_SQL_MEDIA: Advanced
        TEST_SQL_UPDATES: False
      '2008R2-x86 Core on Server2022':
        IMAGE: 'windows-2022'
        TEST_SQL_VERSIONS: '2008R2-x86'
        TEST_SQL_MEDIA: Core
        TEST_SQL_UPDATES: False

      '2005 on Server2022':
        IMAGE: 'windows-2022'
        TEST_SQL_VERSIONS: '2005'
        TEST_SQL_UPDATES: False
      '2005 on Server2019':
        IMAGE: 'windows-2019'
        TEST_SQL_VERSIONS: '2005'
        TEST_SQL_UPDATES: False
      '2008-x64 on Server2019':
        IMAGE: 'windows-2019'
        TEST_SQL_VERSIONS: '2008-x64'
        TEST_SQL_UPDATES: False
      '2008-x86 on Server2019':
        IMAGE: 'windows-2019'
        TEST_SQL_VERSIONS: '2008-x86'
        TEST_SQL_UPDATES: False


      '2022 2019 2017 2016 on Server2022':
        IMAGE: 'windows-2022'
        TEST_SQL_VERSIONS: '2022 2019 2017 2016'
        TEST_SQL_UPDATES: False
      '2017 on Server2022':
        IMAGE: 'windows-2022'
        TEST_SQL_VERSIONS: '2017'
        TEST_SQL_UPDATES: False
      '2016 on Server2022':
        IMAGE: 'windows-2022'
        TEST_SQL_VERSIONS: '2016'
        TEST_SQL_UPDATES: False
      '2014 2012 on Server2022':
        IMAGE: 'windows-2022'
        TEST_SQL_VERSIONS: '2014 2012'
        TEST_SQL_UPDATES: False

      '2022 2019 2017 2016 on Server2019':
        IMAGE: 'windows-2019'
        TEST_SQL_VERSIONS: '2022 2019 2017 2016'
        TEST_SQL_UPDATES: False
      '2017 2016 on Server2019':
        IMAGE: 'windows-2019'
        TEST_SQL_VERSIONS: '2017 2016'
        TEST_SQL_UPDATES: False
      '2016 on Server2019':
        IMAGE: 'windows-2019'
        TEST_SQL_VERSIONS: '2016'
        TEST_SQL_UPDATES: False
      '2014 2012 on Server2019':
        IMAGE: 'windows-2019'
        TEST_SQL_VERSIONS: '2014 2012'
        TEST_SQL_UPDATES: False

  steps:

  - powershell: |
      Write-Host "CPU: $((Get-WmiObject Win32_Processor).Name), $([System.Environment]::ProcessorCount) Cores"

      gdr -PSProvider 'FileSystem'
      
      Set-WMIInstance -class Win32_PageFileSetting -Arguments @{name="c:\pagefile.sys";InitialSize=500;MaximumSize=500} -EA Continue;
      Get-WmiObject -class "Win32_PageFileUsage" -namespace "root\CIMV2" -computername localhost | Format-Table Caption, Name, PeakUsage, AllocatedBaseSize, CurrentUsage -AutoSize | Out-String -Width 256
    displayName: 'Bootstrap'

  - powershell: |
       cd Scripts
       powershell -f "[Test] Setup All The SQL Servers.ps1" *| tee "$($ENV:SYSTEM_ARTIFACTSDIRECTORY)\FULL-LOG.txt"
       gdr -PSProvider 'FileSystem'
       # Install-Module -Force Platform-Info
    condition: succeededOrFailed()
    displayName: 'Install'

  - powershell: |
       get-wmiobject win32_service | where {$_.Name.ToLower().IndexOf("sql") -ge 0 } | sort-object -Property "DisplayName" | ft State, Name, DisplayName, StartMode, StartName
       cd Scripts
       powershell -f "[Test] Publish SQL Server Setup Logs.ps1" 
       gdr -PSProvider 'FileSystem'
    condition: succeededOrFailed()
    displayName: 'Publish Setup Logs'

  - powershell: |
       cd Scripts
       & 7z x LocalSqlDiscovery-net4.5.7z -oc:\Temp\
       cd c:\Temp\LocalSqlDiscovery-net4.5
       .\SHOW-SQL-Servers.cmd 
       Get-WmiObject -class "Win32_PageFileUsage" -namespace "root\CIMV2" -computername localhost | Format-Table Caption, Name, PeakUsage, AllocatedBaseSize, CurrentUsage -AutoSize | Out-String -Width 256
    condition: succeededOrFailed()
    displayName: 'Show SQL Servers'

  - bash: |
      set -eu; set -o pipefail
      d=$PWD
      pushd "$(System.ARTIFACTSDIRECTORY)"
      7z a -mx=1 -ms=on -mqs=on "Source-$(Agent.JobName).7z" "$d"
      popd
    condition: succeededOrFailed()
    displayName: 'Prepare Artifacts'

  - task: PublishBuildArtifacts@1
    condition: succeededOrFailed()
    displayName: 'Publish'
    inputs:
      pathtoPublish: '$(System.ARTIFACTSDIRECTORY)'
      artifactName: '$(Agent.JobName)'