Month: January 2023
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 […]
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 […]
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 […]
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 […]
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 […]