Alister Macgregor has been teaching in the public tertiary environment for over twenty years, having previously worked as a consultant in process industries. His academic interests focus on algorithms, data management and analyzing gathered data to assist with solving information systems problems. He is also interested in rural issues, and explaining the costs and benefits of IT to the layperson, having previously written on these subjects.
Test-Driven Development (TDD) has a proven track record in application development, but is less ingrained in database development work, despite data quality is increasingly critical in a data-driven economy.
This mindset has changed with the arrival of test frameworks that use the SQL language, and that are available as plug-ins for development environments. In this workshop, we will discuss in detail a Unit Testing framework for databases called tSQLt that is available as a plug-in for SQL Server Management Studio.
This free open-source library has gained a lot of attention lately; even more so since industry leader Redgate have put their weight behind it by making tSQLt the backbone of their product SQL Test.