Database code is application code, and deserves to be treated as such. There, I've said it, now it’s time to start living it. A longtime staple in application development is unit testing, but this practice has made little headway in SQL Server development. A better understanding of unit tests and some better tools will hopefully help change this. In this session we’ll cover some of the basics of unit tests, write a simple unit testing procedure which can be used in nearly any SQL-compliant database, and learn about two open-source unit testing frameworks for SQL Server. One of these frameworks (tSQLt) is sweet, but RedGate’s SQL Test adds an extra layer of goodness on top, which we’ll also look into.
Rich Dudley is a Senior Software Engineer and technical lead at Quicken Loans, responsible for the development of the next-generation ODS and MDM hubs. Rich has presented over 100 talks at more than 70 user groups and conferences. In addition to being a co-organizer of PGH.NET, Rich is an ASP Insider, a Friend of RedGate, a Packt and Pluralsight author, and a published scientist.