Effective Unit Testing for SQL Server by Gavin Campbell

GroupBy – Free SQL Server Training

Content provided by Brent Ozar. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Brent Ozar or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.

6y ago 50:41

MP3•Episode home

Archived series ("Inactive feed" status)

When? This feed was archived on January 29, 2020 15:10 (4y ago). Last successful fetch was on October 18, 2019 15:18 (4+ y ago)

Why? Inactive feed status. Our servers were unable to retrieve a valid podcast feed for a sustained period.

What now? You might be able to find a more up-to-date version using the search function. This series will no longer be checked for updates. If you believe this to be in error, please check if the publisher's feed link below is valid and contact support to request the feed be restored or if you have any other concerns about this.

There are tools available from Microsoft, as well as from a number of third party vendors, to ease the process of integrating database unit testing into your development environments and your continuous delivery pipeline.

This session isn't about any of those tools, but is an attempt to get back to basics - with the open source tSQLt framework - and address questions such as:

Why is database unit testing important?
Why is database unit testing difficult?
What do I need to test?
What do I not need to test?
What does a "good" unit test look like?

No particular experience of automated testing is required, we'll be talking about database testing "from the ground up". A good grasp of Transact-SQL constructs will be helpful in understanding the examples.

74 episodes

#Prog Languages #Science #Database #Sqlserver #Training #Brent Ozar #Tech #Podcasting Education #Communities #Development