Randstad Digital

Accelerated Release Velocity with Mandatory Unit Testing

Senior SQL Server Database Architect, Administrator, and Lead Developer2018 – Ongoing

Situation

Release cycles were running every two months and regression issues were frequent, leaving the client without confidence in the system's stability. Every release was a risk event rather than a routine delivery.

What I Did

Implemented mandatory tSQLt unit testing for all stored procedures and integrated it into the release process for every two-week sprint. Established coverage requirements so that no stored procedure could be deployed without a corresponding test suite.

Result

Cut release cycles from every two months to every two-week sprint. Regression issues dropped significantly and the client described the system as feeling "stable and accurate" for the first time.

Tools & Tech

SQL ServertSQLtCI/CD