Category: Azure Pipelines
Azure DevOps Pipelines – SQL Server Deploy – One to rule them all
In one of my previous blog posts, I used the SQL Server database deploy task to deploy my DACPAC to SQL Server. Unfortunately, this task became deprecated in Release Pipelines. In this blog post, I would like to share the alternative. Additionally, we will be moving from a Classic Release pipeline to a YAML pipeline. […]
Azure DevOps YAML Pipelines – Deploy to Azure SQL
In my previous blog post, we created an Azure DevOps YAML Pipeline to automate our Database Project Build process. In this blog post, we are going to create an Azure DevOps YAML Release Pipeline for Azure SQL. Quick Overview Prerequisites Step-by-step Example —Download Pipeline Artifact —Deploy Dacpac to Azure SQL —Adding the right trigger Considerations […]
Azure DevOps YAML Pipelines – Building Database Projects
In previous blog posts, I explained how to automate the Database Project Build & Deployment process using Azure DevOps (Release) Pipelines. These blog posts focused on setting up as easily as possible using the Classic Editor. In this blog post, I’m going through the steps of setting up a build pipeline using YAML. Quick Overview […]
Automate your Database Deployments for SQL Server using Azure DevOps Releases
In my previous blog post, Automate your Database Deployments for Azure SQL using Azure DevOps Releases, I described how to automate your database deployments for Azure SQL. Now, in this blog post, we are going to take a look at how we can automate deployments for SQL Server. Since the setup is a bit different […]
Visual Studio Build in Azure DevOps Pipelines failing on latest Windows vmImage
Problem statement In the past couple of years, I have learned how to work with Azure DevOps Pipelines (Pipelines & Release Pipelines) using the Classic Editor. Last week, I started to play around with Azure DevOps YAML Pipelines. For some reason, I wasn’t able to build my Database Project using the latest vmImage for windows […]
Automate your Database Deployments for Azure SQL using Azure DevOps Releases
In my previous blog post, Automate your Database Builds – Using Azure DevOps Pipelines, we successfully automated our Build process. As a next step, we will be automating our deployment process to Azure SQL. In this blog post, we will go through the process step-by-step to set up our Release pipeline in Azure DevOps and […]
Automate your Database Builds – Using Azure DevOps Pipelines
After we successfully introduced a database development strategy in my previous blog post series, Getting Started With Database Projects & Azure DevOps, we can look at how to introduce a database deployment automation strategy using Database Projects and Azure DevOps Pipelines. As a starter, we will first be implementing a build automation process and in […]
Azure DevOps Pipelines – Release your Tabular Model without Users & Roles
Problem statement A couple of weeks ago my team & I ran into an issue with SQL Server Analysis Services (SSAS), due to a network split between companies, We weren’t able anymore to manage our SSAS access into our SSAS Tabular Model. Since deploying a Tabular Model using Visual Studio is also overwriting members & […]