Skip to content

Category: Azure DevOps

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

Getting started with Database Projects and Version Control

In my previous blog post (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 it to…

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…