THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Alexander Kuznetsov

Additional links for my presentation on defensive database programming.

Yesterday I delivered a session named "Develop T-SQL defensively" at East Iowa SQL Saturday. Thanks to those who attended, and many thanks to Michelle Ufford, Chris Leonard, Ed Leighton-Dick, and other volunteers, who organized the event.

Here are the links with more information and more repro scripts, more or less in the order following the order of the presentation.

Basic Defensive Database Programming Techniques Summarizing previous posts about defensive database programming Happy programming!
Published Sunday, September 19, 2010 2:29 PM by Alexander Kuznetsov



KenJ said:

You gave a really good presentation, too.  You showed so many subtle errors in "safe" looking code that I thought I was seeing bugs where there were none by the time you were done.  I may never look at a query the same way again!

September 26, 2010 8:04 PM
New Comments to this post are disabled

About Alexander Kuznetsov

Alex Kuznetsov has been working with object oriented languages, mostly C# and C++, as well as with databases for more than a decade. He has worked with Sybase, SQL Server, Oracle and DB2. He regularly blogs on, mostly about database unit testing, defensive programming, and query optimization. Alex has written a book entitled "Defensive Database Programming with Transact-SQL" and several articles on and Currently he works as an agile developer.

This Blog


Privacy Statement