Simplifying Unit Testing Main Stored Procedure Which Also Calls a Utility Procedure
This article provides a walkthrough of database unit testing a stored procedure which contains a...
Jump to Start Test-Driven Database Development (TDDD)
As a rule, we start to develop database solutions by creating database objects, such as tables, views, stored procedures, etc., based on...
Art of Isolating Dependencies and Data in Database Unit Testing
All the database developers more or less write database unit tests that not only help in detecting bugs early but also save a lot of time...
Rules for Implementing TDD in Old Project
The article “Sliding Responsibility of the Repository Pattern” raised several...
Why Using Unit Tests is a Great Investment into High-Quality Architecture
I have decided to write this article in order to show that unit tests are not only a tool to grapple with regression in the code but is...
SQL Server Unit Testing with tSQLt Framework
In this article, we will talk about the tSQLt framework — a free database unit testing framework for Microsoft SQL Server. You...