Date: Tuesday, July 15th
Sponsor: Microsoft
Refreshments: Pizza / Soda
Give-A-Ways: Books / T-shirts
Topic: TDD Principles for Database Development
Success in object-oriented agile development is currently being achieved with a technique known as test driven development (TDD). In database development however, TDD practices are not wide-spread and development teams struggle with applying the TDD principles to the SQL language. This is a problem, because it leads to poorly tested code. In turn, not having the appropriate test cases, makes it difficult to improve your existing database design. Not implementing TDD practices in the database, overtime, leads to a decaying architecture and can hinder the evolution of the overall application.
This presentation will discuss ways to enable software developers to use TDD to develop in databases. Beginning with a case study of a successful project that employed database TDD, presenters will then provide examples on specific TDD techniques that borrow from similar techniques in OO development. In addition to an overview of writing simple database test cases, you will see demonstrations on the effective use of techniques like mock procedures, fake tables and stub records. Guidance will also be provided on situations in which these techniques are inappropriate.
For additional information on this presentation, please see http://submissions.agile2008.org/node/2936
About the Presenters:
Dennis Lloyd Jr
I have been working professionally in software development for over 10 years. My recent focus has been applying agile software techniques to database and object-oriented development. Over the next year, I will be investigating how agile practices apply to intelligent systems projects with emphasis on TDD in a natural language processing program. I have a bachelor's in Information Technology from Rochester Institute of Technology and master's in Software Engineering with a minor in BioInformatics from Penn State.
Sebastian Meine
After receiving his PhD in Computer Science, Sebastian joined Siemens Medical Solutions USA as a software developer. Sebastian has been an active part in the transition of Siemens to the Agile development process focusing primarily on the creation of frameworks for testing database code and performance testing and tuning. He has been sought out to speak at several technical conferences in the US and Germany about UnitTesting of database code and performance tuning of SQL Server.
For additional information on these presenters, please see http://sqlity.net/