Accelerated Release Velocity with Mandatory Unit Testing
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.
Result
Cut release cycles from every two months to every two-week sprint.
Core staff scheduling stored procedures were running at 1,500ms+ per call, impacting the responsiveness of the scheduling solution used across 2,500+ clinics. Under peak load the latency compounded across concurrent sessions.
Result
Improved performance of core staff scheduling stored procedures from 1,500ms+ per call to under 200ms — better than a 7x improvement in response time.
SQL developers had plenty of reference sites but almost nothing purpose-built for tSQLt unit testing and CI/CD pipeline integration. The information existed but was scattered and lacked practical, opinionated guidance.