Skip to content

Blog

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