Skip to content

Month: March 2023

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 in Azure DevOps. My Pipeline YAML file looked like this: As you can see, I wanted to use the windows-latest…

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 execute our first release just by clicking a button. Quick Overview Prerequisite Step-by-step Example Using Variables in the Release Pipeline…

SQLBits 2023 – My experience

In the past, I have been hearing a lot of stories about SQLBits. And, this year, I finally was able to experience it myself. Thanks to my current employer, I was allowed to attend SQLBits. I attended 2 training days and 3 conference days, which basically is the full conference. I can tell, it is definitely worth it. SQLBits is an amazing event, you can meet so many like minded people who all share the…

Help – Which Attributes & Measures can I combine from my Tabular Data Model?

In this blog post, I will guide you through all the required steps to get a Data Model Relationship Matrix in Power BI. If you don’t know what I mean, I would like to have a straightforward overview where I can see which attribute groups and measure groups I can combine from my Tabular Model in (SQL Server) Analysis Server. By the end of this blog post, we will have created the following overview: You…

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 future blog posts, we will go through the different ways of deployment to different environments. On top of that, we…