Bite Size Data Tales | Olivier Van Steenlandt
Problem Statement Today, I was working on a SSIS Package that executes a Python script for every day I want to retrieve the data. Since I was reloading data for a couple of months in my development environment, the process took quite some time. I developed my package in Visual Studio 2019 and deployed my […]
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 […]
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 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 […]
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 […]
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 […]
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 […]
Almost 5 years ago I made the switch from “traditional” database development using SQL Server Management Studio to a more flexible way of development by using Database Projects and Source Control. In the first few years, I worked with BitBucket as my code management system and for 2 years I’m using Azure DevOps. In my […]
Since Microsoft announced that Power BI Paginated Reports was becoming a Power BI Pro feature, I started exploring the available functionality for Power BI Paginated Reports. As a first step, I tried to “migrate” an example report from SQL Server Reporting Services to Power BI. In a previous blog post, I described the steps required […]
Problem statement It’s no big surprise that I’m a big fan of database/dwh development with Database Projects and Azure DevOps. Ever since I started using it, I try to keep my local branches as clean as possible. Since I swapped laptop last year, I started to use a third party tool to manage branches. In […]
