Skip to content

Olivier Van Steenlandt Posts

Remote Azure DevOps Repository Out Of Sync in Visual Studio Database Project

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…

Database Projects – Working with SQLCMD variables

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…

Speaking @ dataMinds User Group

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?…

Database Projects – Working with Pull Requests

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…

Converting SSRS Reports to Power BI Paginated Reports

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…

What a year, 2022 review

Well, it’s that time of the year, days are getting shorter, it’s pretty cold outside and that typically is the time for me to get cosy on the sofa and review the year. This year was a special one, I was able to achieve a couple of awesome milestones in my professional career During the first half of 2022, I was preparing to present my very first session which I successfully delivered in June 2022…

Database Projects – Getting your database partially in a Database Project

In my previous blog post, we finalized our development phase by deploying our changes to the development environment(Database Projects – Deploying Changes). Since we now have a complete overview of how development can be done, we can look at specific use cases. Quick Overview Use Case Description Step-by-Step Example Important Notices Use Case Description In this blog post, I will describe how you can get a database in source control partially. You might be wondering…

Speaking @ SQL Saturday MN

I’m very happy to share that I will be delivering my session about “Improving Team Collaboration using Database Projects & Azure DevOps” at SQL Saturday MN. 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, where the challenges will be and how I would overcome these challenges. When? Saturday, December 3rd, 2022 Where?…

Database Projects – Deploying Changes

In a previous blog post (Database Projects – Merging changes), we successfully merged our feature branch into our development branch. Now, as a final step in our development process, we want to get our changes deployed to our development environment. In this blog post, we will go through the process step by step to execute a manual deployment. We will take a look at what happens behind the scenes, how deployment works and we also…

Database Projects – Merging changes

In my previous blog post (Database Projects – Making Changes), we successfully executed our first development task in a feature branch. To get our changes to the development environment, we will need to execute a couple of steps which are called merging. Quick Overview What is merging exactly? Merging by example Lessons Learned What is merging exactly? When you start development, you create a feature branch, which is a living copy of your main branch…