22-25 April 2026 
Database Unit Testing for Data Professionals
Proposed session for SQLBits 2026TL; DR
In this session, we will dive into the world of Unit Testing for databases, with a focus on Data Warehousing solutions.
Before we dive into practical examples, we need to understand the key concepts and the importance of Unit Testing.
As soon as the basics are set, we will talk about different possibilities/frameworks to implement Unit Testing.
Near the the halfway mark, we will dive into the tSQLt Framework specifically and we will start to get more practical.
What are we going to discover?
* How to create 1 or more Test Classes?
* How to create different Unit tests?
* What's possible with tSQLt?
* How to automate your Unit tests?
If you are wondering how to get started with Unit Testing for Data Warehouse solutions or databases in general this session is for you!
Session Details
In traditional software development, Unit Testing is pretty well known. But what about Unit Testing for database solutions?
Or more specifically, what about Unit testing for Data Warehouse solutions?
In this session, we will dive into the world of Unit Testing for databases, with a focus on Data Warehousing solutions.
Before we dive into practical examples, we need to understand the key concepts and the importance of Unit Testing.
As soon as the basics are set, we will talk about different possibilities/frameworks to implement Unit Testing.
Near the the halfway mark, we will dive into the tSQLt Framework specifically and we will start to get more practical.
What are we going to discover?
* How to create 1 or more Test Classes?
* How to create different Unit tests?
* What's possible with tSQLt?
* How to automate your Unit tests?
If you are wondering how to get started with Unit Testing for Data Warehouse solutions or databases in general this session is for you!
Or more specifically, what about Unit testing for Data Warehouse solutions?
In this session, we will dive into the world of Unit Testing for databases, with a focus on Data Warehousing solutions.
Before we dive into practical examples, we need to understand the key concepts and the importance of Unit Testing.
As soon as the basics are set, we will talk about different possibilities/frameworks to implement Unit Testing.
Near the the halfway mark, we will dive into the tSQLt Framework specifically and we will start to get more practical.
What are we going to discover?
* How to create 1 or more Test Classes?
* How to create different Unit tests?
* What's possible with tSQLt?
* How to automate your Unit tests?
If you are wondering how to get started with Unit Testing for Data Warehouse solutions or databases in general this session is for you!
3 things you'll get out of this session
What are we going to discover?
* How to create 1 or more Test Classes?
* How to create different Unit tests?
* What's possible with tSQLt?
* How to automate your Unit tests?