add pipeline update workaround

dzsquared · dzsquared · commit 39bfe77f323a · 2021-06-24T18:05:33.000-07:00
diff --git a/docs/tools/sqlpackage/sqlpackage-download.md b/docs/tools/sqlpackage/sqlpackage-download.md
@@ -9,7 +9,7 @@ ms.topic: conceptual
 author: "dzsquared"
 ms.author: "drskwier"
 ms.reviewer: "maghan; sstein"
-ms.date: 06/02/2021
+ms.date: 06/24/2021
 ---
 
 # Download and install sqlpackage
@@ -46,7 +46,7 @@ dotnet add package Microsoft.SqlServer.DACFx
 
 This release of sqlpackage includes a standard Windows installer experience, and a .zip: 
 
-1. Download and run the [DacFramework.msi installer for Windows](https://go.microsoft.com/fwlink/?linkid=2157201).
+1. Download and run the [DacFramework.msi installer for Windows](https://aka.ms/dacfx-msi).
 2. Open a new Command Prompt window, and run sqlpackage.exe
     - sqlpackage is installed to the ```C:\Program Files\Microsoft SQL Server\150\DAC\bin``` folder
 
diff --git a/docs/tools/sqlpackage/sqlpackage-pipelines.md b/docs/tools/sqlpackage/sqlpackage-pipelines.md
@@ -1,6 +1,6 @@
 ---
 title: SqlPackage in development pipelines
-description: Learn how to troubleshoot database development pipelines with SqlPackage.exe by checking the installed build number.
+description: Learn how to leverage and troubleshoot database development pipelines with SqlPackage.exe.
 ms.prod: sql
 ms.prod_service: sql-tools
 ms.technology: tools-other
@@ -9,7 +9,7 @@ ms.assetid: 198198e2-7cf4-4a21-bda4-51b36cb4284b
 author: "dzsquared"
 ms.author: "drskwier"
 ms.reviewer: "maghan; sstein"
-ms.date: 11/4/2020
+ms.date: 06/25/2021
 ---
 
 # SqlPackage in development pipelines
@@ -46,6 +46,25 @@ By leveraging the [run](https://docs.github.com/en/free-pro-team@latest/actions/
 
 :::image type="content" source="media/sqlpackage-pipelines-github-action.png" alt-text="GitHub action output displaying build number 15.0.4897.1":::
 
+## Update SqlPackage on the pipeline agent
+
+In some scenarios, the current version of SqlPackage installed in the pipeline environment may be insufficient. An additional step can be used to install a newer version of SqlPackage before running any DacPac or BacPac operations in the same pipeline. This task can be combined with a step to [check the version](#checking-the-sqlpackage-version) to ensure that the upgrade completed as expected.
+
+### Azure Pipelines
+By leveraging the [Powershell](/azure/devops/pipelines/tasks/utility/powershell) task in an Azure Pipeline, a step can be added to an Azure Pipeline that downloads the desired MSI and installs it silently. 
+
+```yaml
+- task: PowerShell@2
+  displayName: 'upgrade sqlpackage'
+  inputs:
+    targetType: 'inline'
+    script: |
+      # use evergreen or specific dacfx msi link below
+      wget -O DacFramework.msi "https://aka.ms/dacfx-msi"
+      msiexec.exe /i "DacFramework.msi" /qn
+```
+
+
 ## Next steps
 
 - Learn more about [sqlpackage](sqlpackage.md)
