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

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

Sankar Reddy — Fri, 18 Jun 2010 20:31:55 GMT

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.

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

Alexander Kuznetsov — Fri, 18 Jun 2010 20:44:23 GMT

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.

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

Sankar Reddy — Fri, 18 Jun 2010 21:45:05 GMT

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

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

Alejandro Mesa — Sat, 19 Jun 2010 02:01:13 GMT

Alex,

Congratulations on finishing your book!!!

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

AMB

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

James Luetkehoelter — Sat, 19 Jun 2010 04:25:28 GMT

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

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

Adam Machanic — Sat, 19 Jun 2010 11:22:49 GMT

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

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

Aaron Bertrand — Mon, 21 Jun 2010 02:27:31 GMT

Thanks Alex! Just ordered my print copy.

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

Alexander Kuznetsov — Mon, 21 Jun 2010 12:11:05 GMT

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

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

Piotr Rodak — Mon, 21 Jun 2010 19:04:47 GMT

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

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

Alexander Kuznetsov — Tue, 22 Jun 2010 13:45:53 GMT

Thank you, Piotr!

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

AaronBertrand — Wed, 23 Jun 2010 17:20:30 GMT

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

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

Madhivanan — Mon, 28 Jun 2010 15:15:45 GMT

Congratulations Alex