Tag: DatabaseProjects
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 […]
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 […]
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 […]
Database Projects – Getting your database partially in a Database Project
In my previous blog post, we finalized our development phase by deploying our changes to the development environment(Database Projects – Deploying Changes). Since we now have a complete overview of how development can be done, we can look at specific use cases. Quick Overview Use Case Description Step-by-Step Example Important Notices Use Case Description In […]
Speaking @ SQL Saturday MN
I’m very happy to share that I will be delivering my session about “Improving Team Collaboration using Database Projects & Azure DevOps” at SQL Saturday MN. 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 – 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 […]
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 […]
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 […]
Speaking @ Data Bristol User Group
I’m delighted to share that I will be speaking at the Data Bristol User Group where I will be sharing my personal experience with Database Projects & Azure DevOps. During this session, I will start off by explaining what went horribly wrong in the past, where we were struggling and how we overcame our challenges. […]