Home ยป Archives for March 2023
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…
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…
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…
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…
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…