Presentation Materials: TDD – Thwarting Database Defects
Abstract
It’s bad enough to spend hours finding and fixing database defects, explaining to the rest of the team what went wrong and trying to clean up the mess. It’s even worse when a defect causes the end-user to make a bad decision. Database defects are far too costly and most testing practices do not adequately detect or prevent them. This presentation introduces tSQLt, a framework for automated database unit testing. You’ll learn techniques to write SQL code that is resilient to defects and is easier to change and maintain.
Downloads
Other Resources
- tSQLt Website: http://tSQLt.org
- tSQLt Mailing List: tsqlt@googlegroups.com
- TestDrivenDatabases Website: http://www.testdrivendatabases.com/
- sqlity.net Website: http://sqlity.net
- Curiously Correct Website: http://curiouslycorrect.com
Class Announcement
Newsletter Sign Up
2 Responses to Presentation Materials: TDD – Thwarting Database Defects
Leave a Reply
You must be logged in to post a comment.
We know how to make a database fast. We’ll help you do the same.
From the sqlity.net blog
-
How to identify the SQL Server Service Account in T-SQL
-
How to Change a SQL Login’s Password
-
Hash Algorithms – How does SQL Server store Passwords?
-
B+Trees – How SQL Server Indexes are Stored on Disk
-
How to Re-Create a Login with only a Hashed Password
-
The Hidden SQL Server Gem: UPDATE from SELECT
-
A Join A Day – Nested Joins
-
Determine the Uptime of a SQL Server Instance
-
A Join A Day – The Left Anti Semi Join
-
Log Reuse Waits Explained: LOG_BACKUP
Pingback: 2011-11-05: TDD – Thwarting Database Defects – SQL Saturday #96 Washington DC | sqlity.net
Pingback: 2012-10-08: TDD - Thwarting Database Defects - SQL in the City, Boston 2012 - sqlity.net » sqlity.net | sqlity.net