Test Driven Development (TDD) is a practice that has for years enabled application developers to write code that is less-buggy.

It is extremely relevant for database development, as it ensures that the code produced using TDD will be of higher quality, which means interactions with data and code are safer.

In this session we will go through how to setup some simple unit tests using various industry tools such as the open-source framework – tSQLt, the SQL Cop testing utility and Redgate’s SQL Test tool which brings it all together.

The advantage of these tools is that we can run them within our familiar SQL Server Management Studio, whereas other testing frameworks rely on the Visual Studio IDE.

It will be shown in a comprehensive DEMO how to bring TDD to your database development and result in higher quality deployments to your databases when incorporated into Continuous Integration processes.


Hamish Watson, DevOps Alchemist Morph iT

Hamish Watson is a Microsoft Data Platform MVP and VMware Expert with a passion for efficient database and application deployment using DevOps methodologies.

He has 20+ years of IT experience in managing and deploying large scale databases on SQL Server technologies.

He has been managing SQL Server since SQL Server 2000, and pragmatic approaches to delivering business value to clients is his career passion.

Educating and helping others learn is a driver for Hamish. He is a Director-At-Large on the PASS Board, international speaker, and a repeat guest lecturer at a local university.