11 Dec, 2024

Create a Test Class & First Unit Test with tSQLt

We have set up our tSQLt Database Project in the previous data recipe, Create a SSDT Project Template based on your Database Project. Now it’s time to dive into the wonderful world of tSQLt Unit Testing. In the meantime, I have added my data warehouse to my SSDT Solution and added this project as a […]

4 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