Alex Kuznetsov Defensive Error Handling TRY...CATCH error handling in SQL Server has certain limitations and inconsistencies that will trap the unwary developer, used to the more feature-rich error handling of... 28 October 2010 35 min read
Alex Kuznetsov Developing Modifications that Survive Concurrency You can create a database under the assumption that SQL looks after all the problems of concurrency. It will probably work fine under test conditions:... 22 June 2010 40 min read
Alex Kuznetsov Basic Defensive Database Programming Techniques We can all recognise good-quality database code: It doesn't break with every change in the server's configuration, or on upgrade. It isn't affected by concurrent... 31 March 2010 36 min read
Alex Kuznetsov Defensive Database Programming 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... 22 February 2010 3 min read
