(A talk given at PIPELINE Conference – March 2017 – Test Drive Your Database – https://pipelineconf.info/2017-event/speakers/)

“Software is eating the world, but few apps are useful without a database behind them too. As such, we want to ensure our database code is well-designed and tested. Test-Driven Development (TDD) is a good tool for software design, and as SPROCs are as much code as classes and methods, we can apply the same principles to unit test our database rather than integration test it via the app.

This talk will cover how to write unit tests for your database, which parts you should (and shouldn’t!) test, and how to run your tests automatically on a CI server, after which you will be able to write unit tests for your own SQL code and enjoy database development again!”

Alastair is a developer at Cloud Hub 360. While he enjoys writing C# on the back end and HTML/CSS/JavaScript on the front end, he’s tried a number of languages over the last decade and found his real interests lie in good coding practices and ensuring software quality with automated tests. He is the founder of the Cambridge Software Craftsmanship Community in the UK and a co-organiser of DDD East Anglia.