16 Sep, 2024

Create a SSDT Project Template based on your Database Project

I attended quite some conferences in the first 6 months of 2024. When I get the chance, and there is an SSDT (SQL Server Data Tools) session on the schedule, I go to the session to learn something new. Lately, at Data Saturday Croatia, I had the chance to attend an advanced session about SSDT […]

2 mins read

Getting started with tSQLt

It’s time to take the first steps into Database Unit Testing. As mentioned in my previous blog post, I will use tSQLt, an open-source unit testing framework for databases. Since I’m a big fan of SSDT (SQL Server Data Tools), we will use a Database Project to set up the tSQLt framework. Recipe Overview Preparation […]

5 mins read

Unit Testing for Data Warehousing / Database Development

In the past few years, I learned much about collaborative data warehouse development and deployment automatization by using Database Projects (SSDT) and Azure DevOps (and other tools). I had my fair share of learning curves, making mistakes, and having great learning opportunities. Lately, I started my next journey to learn about Unit Testing for data […]

4 mins read

Help – I want Tabular Model Documentation

A few months ago, I chatted with colleagues about our Tabular Model. More specifically the lack of Tabular Model documentation. Since we were thinking about replacing our current model, I started to think about how to integrate documentation easily. Having documentation is 1 thing, making sure it’s used is something completely different. And then we’re […]

4 mins read