The DBA Fundamentals VG offers training and support to individuals interested in a solid DBA foundation.

Event Display
Meeting Detail

Tue, Apr 10 2018 12:30 (UTC+10:00) Brisbane


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

RSVP: None

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.


Hamish is a Systems Management Specialist with a passion for efficient database & application deployment using DevOps methodologies. He has 19 years 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 end users is his career passion. Educating and helping others learn is a driver for Hamish and he is a PASS Chapter Leader, International speaker and a repeat guest lecturer at a local university.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids