Testing! We're Talking About (Unit) Testing...Your Database!
Proposed session for SQLBits 2026TL; 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