Skip to content

Category: Azure DevOps

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

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…

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 get started? Get started by example Create a new feature branch Making changes What about branching? Depending on how you…

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 Control (Azure Repos). So together we will create our first Database Project, import our database into the project and push…

Azure DevOps Pipelines – Release your Tabular Model without Users & Roles

Problem statement A couple of weeks ago my team & I ran into an issue with SQL Server Analysis Services (SSAS), due to a network split between companies, We weren’t able anymore to manage our SSAS access into our SSAS Tabular Model. Since deploying a Tabular Model using Visual Studio is also overwriting members & roles, we needed to find a valid alternative to execute our deployments. Manually at first and automated in the end.…

Creating your first Azure DevOps Project

Before you can setup an Azure DevOps Projects, you need to create a Azure DevOps account and organization. This setup is very easy and basic configuration can be done in a matter of minutes. For this blogpost, I will skip the organization setup and I will dive into Azure DevOps Project Setup straight away. When creating an Azure DevOps Project, there are a few considerations to make, do you want your project to be publicly…