My book is complete, many thanks to Hugo, Tony, and many others!

Alex,

How different is the book listed in amazon from the one listed on simple-talk?

http://www.simple-talk.com/books/sql-books/defensive-database-programming/

http://www.amazon.com/Defensive-Database-Programming-SQL-Server/dp/1906434492/ref=cm_cr_pr_product_top

A quick look tells me that ISBN numbers are different but the titles are same.

Sankar,

The printed/kindle editions have two more chapters:

Ch. 09: Concurrent Queries and Transaction Isolation Levels

A query that works splendidly in isolation can often fail miserably when put to work in

a live OLTP system, with real life concurrency. To make a bad situation worse, in many

cases such errors are subtle and intermittent, and therefore very difficult to reproduce

and understand. This chapter considers the case of reporting queries running against

tables that are being simultaneously modified, demonstrates how inconsistent results

can be returned, assesses the impact of various isolation levels, and considers how best

the defensive programmer can defend data integrity, while minimizing deadlocks.

Ch. 10: Developing Modifications that Survive Concurrency

Just like queries, modifications that work perfectly well in the isolated world of the

test database, can suddenly start misbehaving intermittently when run in a production

environment under conditions of concurrent access. The chapter covers some of the

problems that might occur when "competing" connections try to simultaneously update

the same data, and how to avoid them:

• lost modifications, a.k.a. lost updates – such problems occur when modifications

performed by one connection are overwritten by another; they typically occur

silently, and no errors are raised.

• resource contention errors – such as deadlocks and lock timeouts

• primary key and unique constraint violations – such problems occur when

different modifications attempt to insert one and the same row.

Thanks Alex. I will get my copy then. Your work has been invaluable to the community. Great Job.

Alex,

Congratulations on finishing your book!!!

I already ordered a copy, and I am sure I will enjoy reading it.

AMB

Gratz! Having been through the process I know what a feat it is getting something published - looking forward to it!

Congrats, Alex! I can't wait to check it out.

Thanks Alex!  Just ordered my print copy.

Thanks, Sankar, Alejandro, James, Adam, and Aaron!

Hey Alex, congrats on finishing the book, great job!

:)

Thank you, Piotr!

Received today.  Flattered to have been mentioned in the acknowledgments.  Thanks Alex!

Congratulations Alex

Alexander, We searched Amazon for the Kindle edition of your book without success?  Is it available there, or can you offer a different source?  Direct from you, maybe?

Robin,

I do not think there is Kindle edition.