Click here to monitor SSC

Author Profile

Greg Lucas

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 Database Development – Why 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 Database Development – Why Bother?

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...

Why Join

Over 400,000 Microsoft professionals subscribe to the Simple-Talk technical journal. Join today, it's fast, simple, free and secure.