09 Oct, 2024

Database Projects & Azure DevOps – 5 Lessons Learned

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 […]

3 mins read

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 […]

2 mins read

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 […]

4 mins read

Database Projects – Making changes – Feature Branching

In my previous blog post about Database Projects: “Getting started with Database Projects and Version Control”, I explained how to set up a database project and connect it to Azure DevOps Repos. In this blog post, I will be focussing on how you can start development. Quick Overview What about branching? Feature branching How to […]

4 mins read

Getting started with Database Projects and Version Control

In one of my previous blog posts (Creating your first Azure DevOps Project), I described how to create an Azure DevOps Project and explained what kind of configuration you might want to consider. In this blog post, we will focus on how to get started with Database Projects and how to get this into Source […]

5 mins read