addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupsimageimagesinstagramlinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1outlookpersonStartprice-ribbonImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruseryahoo

Database code is application code, so test it!

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.

Join or login to comment.

  • A former member
    A former member

    I have to miss out today. I'm sick. Will the presentation be uploaded to the MIGANG website?

    September 17, 2014

Our Sponsors

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy