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

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.

Feedback Link -

Starts: 12:50 12th Mar 2022
Ends: 13:10 12th Mar 2022


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

Slidedeck Link

Testing - We're Talking About Unit Testing.pptx


Dan Mallott


Platform AgnosticDataOpsTestingAzure SQL DatabaseSQL 2019SQL 2022BeginnerHow

The SQL Bits Story

SQLBits was formed in 2007 by a group of volunteers who were passionate about the SQL Server product suite and wanted to provide much-needed community-driven education to the data community.

As one of the largest data platform conferences in the world, we offer more opportunities to a wider audience.

15 Years

We’ve grown and expanded a lot since 2007.

2500 Participants

SQLBits is the best place to meet fellow data professionals.

82 Countries

We welcome data professionals from all over the globe.

1140 recorded sessions

All the live sessions are recorded and offered for free, year round.

Experience the SQLBits Conference


Want to be part of the SQLBits community?

Attend the London conference in-person or virtually on 

March 8-12, 2022 at ExCel London, UK.