Geek Sync Webcast : Writing Effective Unit Tests

Presenter: Sebastian Meine
Share This:  Facebook Twitter LinkedIn

Writing automated unit tests sounds simple enough. Instead of manually testing out your stored procedure, you just write a little bit of code to call the procedure and then make sure it did what it was supposed to do. It turns out, things in real life are not that simple.

Automated unit tests come with the promise to not only reduce the number of software defects but to also minimize the overall cost of software maintenance. If you’ve tried automated unit testing, you probably have been in a situation where ensuring that all the tests stayed “alive” after a simple requirements change cost significantly more time and effort than implementing the change itself. In fact, many teams abandon the idea of automated testing quickly, because they just can’t keep up maintaining the tests. So – how is this going to save us time and money? By writing “crisp” unit tests.

While this session is using the T-SQL language and the tSQLt framework for examples, the lessons learned apply to any programming language and testing tool.

About Sebastian Meine:

Sebastian is the founder and SQL Stylist at sqlity.net llc. After earning his PhD in Computer Science and spending seven years architecting DBs for a fortune 50 company, he founded sqlity.net to fully engage in his passion for SQL Server. Sebastian helps clients tighten the security of their databases, enhance data access performance and improve their development skills and code quality. Sebastian is a published author, public speaker and the president of the Philadelphia SQLpass chapter.

Register for Free Webcast
*
*
*
*
*