30th September - 2nd October 2010

University of York

Gold sponsors
Silver sponsors
Bronze sponsors

Effective test-driven database development

Part I: Technical challenges and best practices for Database TDD (30 mins)

  • Why database TDD is hard
  • What can we do to make it easier
  • Best practices for stored procedure unit testing
  • Best practices for Java/.NET integration tests that involve a database

Part II: DbFit technical demo (20 mins)

  • Why DbFit succeeded where x-Unit style tools have failed
  • Effectively testing stored procedures
  • managing relational data during a test
  • Using DbFit to prepare data or verify the test results for Java/.NET integration tests
  • Covering legacy code with tests
Q&A (10 mins)

This talk was previously presented at the Agile 2008 conference in Toronto.

Speaker focus

Gojko Adzic

gojko-adzic-large.jpg

Gojko Adzic runs Neuri Ltd, a UK-based consultancy that helps companies build better software by introducing agile practices and tools and improving communication between software teams, stakeholders and clients. His programming story so far includes equity and energy trading, mobile positioning, e-commerce, betting and gaming and complex configuration management.

Gojko is the author of several popular printed and online guides on acceptance testing, including Bridging the Communication Gap, Test Driven .NET Development with Fitnesse and Getting Fit with .NET, and more than 200 articles about programming, operating systems, the Internet and new technologies published in various online and print magazines. He is the primary contributor to the DbFIT database testing library which is used by banks, insurance companies and bookmakers worldwide.

Gojko Adzic's blog http://gojko.net



Downloads

File Type Ext ContentName
Presentation .ppt Slide Deck
<< 1 >> 

Other sessions from this conference

AddIns for SSMS - build your own
Comparing Azure storage and SQL Data Services
Data Mining and SSIS - makes sense.
Data Warehouse Data Modelling
Data Warehousing features in SQL 2008
Database Maintenance Optimization
Designing Effective Aggregations in Analysis Services 2008
End to End Report Creation and Management in SQL Server Reporting Services 2008
High Availability in SQL Server 2008
Implementing Clustering using SQL Server
Instrumenting, Monitoring and Auditing of SSIS ETL Solutions
Making the SQL developer one of the family with Visual Studio Team System
Message in a bottle: Service Broker from 1 to 100 in 75 minutes!
NHibernate – Open Source Object Relational Mapping (ORM)
Performance Optimization with SQL Server 2008
Performance Tuning your TSQL
Securing and Hardening a SQL Server Implementation - Notes from the Field
SQL Server Architecture: The life of a query
SQL Server’s storage engine
SSIS by example
SSIS Nuggets Live
Stop throwing hardware at the problem !
Understanding ADO.NET Data Services
Understanding Graphical Execution Plans
Universal calculated measures in MDX queries
Upgrading To SQL Server 2005 & 2008: Notes & Best Practices
What’s New in SQL Server 2008 T-SQL