Agile development practices can speed the development of applications and increase the rate at which you can deploy features for your customers. But unless you include a high level of test coverage in your code, these practices can also increase the number of bugs that are released. Databases can be particularly challenging for developers. This session examines database refactorings that introduce bugs, which are detected by automated tests. This approach allows developers to rapidly fix their code before a customer is affected.
These are the demos shown in this talk.
- Adding test data inline
- Added test data in a procedure
- Adding test data from a separate set of tables.
- Exclusions to SQL Cop or other tests with Extended Properties.
- Using FakeFunction
- Using SpyProcedure
- The boundary issues with multiple requirements for a function.
- 0-1-Some testing
- Catching dependencies.
Here are the downloads for the talk.