Testing! We're Talking About (Unit) Testing...Your Database!

Proposed session for SQLBits 2026

TL; DR

Do you test your database code? If not, maybe you should! Automated testing is relatively easy to setup and integrate with CI/CD processes. Come learn how!

Session Details

Do you have business logic in your database? Is it tested? Do your developers look down their noses at your antiquated practices? If any of these are true, this session may be for you. In it, we will explore the different ways to test your database code without affecting your production database (or data). We will start with the basics of test case setup, followed by manual testing methods, and finish out with talking through tSQLt and how we can use it to automate our unit testing.

3 things you'll get out of this session

Learn why to test database code Learn the basics of tSQLt Learn how to integrate testing into CI/CD

Dan Mallott's other proposed sessions for 2026

ORMs and the DBA: How to Make Both Happy - 2026

The Field Guide For the Accidental Manager - 2026

Why Am I Always Late? Or Is It Early? Why Are Dates So Hard? - 2026

Zero to Hero: Surviving the Transaction Process Like a Pro - 2026

Dan Mallott's previous sessions

Testing! We're Talking About (Unit) Testing!

Is the business logic in your database tested? It should be, and in this talk, we'll talk about how.

Secure SQL Server Database Design: Tactics and Technology

When you design and build an application, do you think about security first or is it an afterthought? In this talk, you will learn strategies for designing and securing your data layer.