Search results matching tags 'SQL Saturday' and 'Defensive programming'

Additional links for my presentation on defensive database programming.

Alexander Kuznetsov — Sun, 19 Sep 2010 18:29:00 GMT

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!

Repro scripts and more info for my presentation on concurrency

Alexander Kuznetsov — Sun, 19 Sep 2010 18:10:00 GMT

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

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

Selects under READ COMMITTED and REPEATABLE READ may return incorrect results.

Reproducing deadlocks involving only one table

Retrying after deadlocks leads to lost updates

Patterns that do not work as expected.

Developing Modifications that Survive Concurrency

And, finally, Erland Sommarskog's article Arrays and lists in SQL

SQL Saturday coming to Chicago on Apr 17!

Alexander Kuznetsov — Thu, 11 Feb 2010 22:08:00 GMT

The schedule is so interesting that I want to get a clone and be in two sessions at the same time. I think of this event as our local PASS Summit Lite – all the benefits like attending sessions and meeting interesting people, but without having to put business demands on hold, and no hassle of traveling two time zones west. I am honored to present at this event. I love both programming defensively and speaking about it. Come to think of it, just a year and a half ago I wanted to learn more, Googled up “defensive database programming”, and got no results found whatsoever. I am diligently filling the void.