DBA Fundamentals VC Session

Test Driven Development in SQL Server – it will make your database deployments better

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.