Loading…
Agile2019 has ended
Wednesday, August 7 • 15:45 - 17:00
Hey, You Got Your TDD in my SQL DB! (Jeff McKenzie) popular

Sign up or log in to save this to your schedule and see who's attending!

Limited Capacity seats available


Abstract:
When should we test our data? From an application development perspective, a unit test against a database isn't a unit test at all. Which makes sense -- connected systems introduce overhead and dependency, both of which reduce stability and decrease productivity during test-driven development (TDD). But if we wait for integration testing, critical functionality can get missed. In this session, we will discuss strategies for filling the data testing gap, directly within a Microsoft SQL Server environment. If you do a lot of work in T-SQL but aren't familiar with TDD, you'll learn the why and how of test-first development. If you're accomplished with unit tests, but never tried them in your database, you'll learn how to apply familiar concepts like setup, mocking, and assertion. We'll spend most of our time walking through a solution based on a real-world project, specifically using the open source tSQLt database unit testing framework.

Learning Outcomes:
  • what TDD is
  • benefits of TDD
  • the practice of TDD
  • how to obtain and install the tSQLt unit testing framework in SQL Server
  • how to write unit tests in SQL using the tSQLt framework
  • experience walking through an example scenario

Attachments:

Speakers
avatar for Jeff McKenzie

Jeff McKenzie

Practice Manager, Insight Digital Innovation
Jeff McKenzie has worked in software development for nearly twenty years, in both freelance and full-time capacities, as a developer and team leader. He enjoys helping others solve problems through technology, whether it's the small business getting on the web for the first time... Read More →


Wednesday August 7, 2019 15:45 - 17:00
National Harbor 3

Attendees (56)