Greg M Lucas (blog | twitter) has worked with SQL Server for over twelve years, starting with v7, including experience as a production DBA and senior developer. He is currently working as a freelance Development DBA with a focus on design and development using T-SQL, C# and SSIS.
He is particularly interested in database change management best practice and in applying agile techniques, especially TDD, within the database development arena.
Greg now has a dedicated page on his blog where you can easily find all his articles and tutorials on test-driven database development with tSQLt at http://datacentricity.net/tsqlt.
Test-Driven Development (TDD) has a good track record in application development, but is less well-established in database development work. This is set to change with the arrival of test frameworks that use SQL, and a plug-in for SQL Server Management Studio. Greg Lucas explains why.… Read more
Test-Driven Development is a practice that can bring many benefits, including better design, and less-buggy code, but is it relevant to database development, where the process of development tends to me much more interactive, and the culture more test-oriented? Greg reviews the support for TDD for Databases, and suggests that it is worth giving it a try for the range of advantages it can bring to team-working.… Read more