Hey, You Got Your TDD in MySQL DB: CodeMash

Data testing is crucial for robust application development. Are you testing your database effectively? A common misconception is that unit testing against a database truly represents a unit test. In reality, database connections introduce dependencies and overhead, hindering stability and slowing down your development process, especially when using test-driven development (TDD). Waiting until integration testing can leave critical functionality untested.

This session, led by Jeff McKenzie, provides practical strategies to bridge the data testing gap directly within a Microsoft SQL Server environment. Whether you're proficient in T-SQL but new to TDD, or already skilled in unit testing but haven't explored database unit tests, this session is for you.

Learn the why and how of test-first development. You'll discover how to apply familiar unit testing concepts – like setup, mocking, and assertion – to your database code. The core of this session involves a real-world project walkthrough, demonstrating the power of the open-source tSQLt database unit testing framework. Master data testing and improve your application's reliability.

• Test-Driven Development (TDD) for SQL Server
• Database Unit Testing with Microsoft SQL Server
• tSQLt Framework: A practical guide
• Unit Testing in T-SQL
• Data Testing Strategies
• Mocking and Assertions in Database Tests
• Improve Application Stability
• Reduce Development Time
• Real-world SQL Server Testing Example