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