Olivier Van Steenlandt - Data Enthusiast | Public Speaker | Blogger
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 the beginning of 2023 I switched over back to Visual Studio to manage branches since for some reason the tool…
When I started to explore and use Database Projects, I ran into a specific situation quite fast where I was required to use SQLCMD variables. In this blog post, I will describe what they are, how you can use SQLCMD variables in Database Projects and where this might become very useful for you. Quick Overview Use Case Description What are SQLCMD variables? Practical Example Use Case Description A couple of years ago, I was working…
I’m happy to share that I will be delivering my session about “Improving Team Collaboration using Database Projects & Azure DevOps” at the dataMinds User Group. During this session, I will first be explaining what went wrong in the past for me, during the main part of the session, I will be showing how to get started, what the challenges will be and how I would overcome these challenges. When? Wednesday, January 25th, 2023 Where?…
In one of the previous blog posts, I described how to merge branches manually (Database Projects – Merging changes). When merging manually, there is no way to revise the development that someone did. If you want to start with peer reviewing during the development process, you can easily do so by using Pull Requests. Quick Overview What is a pull request? How to create a Pull Request? How to review a Pull Request? How to…
The moment that Microsoft announced that Power BI Paginated reporting was becoming a Pro feature (link), I finally realized that I would be able to move from 2 different reporting platforms (Power BI Portal & SQL Server Reporting Services) back to 1 (Power BI Portal). Quick Overview SQL Server Reporting Services Report Power BI Report Builder Publish to the Power BI Portal Configure the Power BI Portal SQL Server Reporting Services Report In this blog…
