Unit Testing

SQL Unit Testing Using tSQLt: Part 3

SQL Unit Testing Using tSQLt: Part 3


The Journey Continues!

Welcome back to the tSQLt series, where we are covering the fundamentals of Unit Testing within SQL Server by using the tSQLt Framework.

Today we are progressing onward by discussing some of the useful features within tSQLt to ensure our tests are accurate, reliable, and repeatable.

SQL Unit Testing Using tSQLt: Part 2

SQL Unit Testing Using tSQLt: Part 2


Unit Testing Experts!

In the last post, we went through what unit testing is, at least when discussing it in the context of SQL Server. In addition to that, we discussed what benefits using the open-source framework tSQLt can bring. Of course, you have studied that post diligently and now we’re all unit testing experts, right? … hello?

SQL Unit Testing Using tSQLt: Part 1

SQL Unit Testing Using tSQLt: Part 1


Unit…what now?

Other practitioners of code-slinging, such as .NET folks, have been unit testing their code for many moons now. We SQL folks, however, rarely seem to do this, at least in my experience. Several job roles ago, I had to use unit testing on a daily basis. It was heavily integrated into our workflow via the CI/CD pipelines we used