Defensive Database Programming
By Alex Kuznetsov
The goal of Defensive Programming is to produce resilient code that responds gracefully to the unexpected.
To the SQL Server programmer, this means T-SQL code that behaves consistently and predictably in cases of unexpected usage, doesn't break under concurrent loads, and survives predictable changes to database schemas and settings.
Inside this book, you will find dozens of practical, defensive programming techniques that will improve the quality of your T-SQL code and increase its resilience and robustness.
Defensive SQL is something I've nattered about before and this morning FatherJack tweeted about his blog review of this free eBook, so I thought I'd better check it out. I haven't done much more than flick through the contents page, but at a glimpse it looks like it'll have some helpful hints and tips.