Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

Qty:1
  • List Price: $29.99
  • Save: $6.40 (21%)
FREE Shipping on orders over $35.
Temporarily out of stock.
Order now and we'll deliver when available.
Order now and we'll deliver when available. We'll e-mail you with an estimated delivery date as soon as we have more information. Your account will only be charged when we ship the item.
Details
Ships from and sold by Amazon.com. Gift-wrap available.
Defensive Database Progra... has been added to your Cart
+ $3.99 shipping
Condition: Used: Good
Comment: Connecting readers with great books since 1972. Used books may not include companion materials, some shelf wear, may contain highlighting/notes, may not include cdrom or access codes. Customer service is our top priority!
Sell yours for a Gift Card
We'll buy it for $2.26
Learn More
Trade in now
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

Defensive Database Programming with SQL Server Paperback – May 31, 2010

5 out of 5 stars 5 customer reviews

See all 2 formats and editions Hide other formats and editions
Price
New from Used from
Paperback
"Please retry"
$23.59
$17.93 $11.70

Top 20 lists in Books
Top 20 lists in Books
View the top 20 best sellers of all time, the most reviewed books of all time and some of our editors' favorite picks. Learn more
$23.59 FREE Shipping on orders over $35. Temporarily out of stock. Order now and we'll deliver when available. We'll e-mail you with an estimated delivery date as soon as we have more information. Your account will only be charged when we ship the item. Ships from and sold by Amazon.com. Gift-wrap available.

Frequently Bought Together

  • Defensive Database Programming with SQL Server
  • +
  • SQL Server Concurrency
  • +
  • SQL Server Execution Plans
Total price: $77.51
Buy the selected items together

Editorial Reviews

About the Author

Alex Kuznetsov has been working with object oriented languages and databases for more than a decade. He has worked with Sybase, SQL Server, Oracle and DB2. He regularly blogs on sqlblog.com, mostly about database unit testing, defensive programming, and query optimization.

Alex has written multiple articles on simple-talk.com and devx.com, and contributed a chapter to "MVP Deep Dives" book. Currently he works with DRW Trading Group in Chicago, where he leads a team of developers, practicing agile development, defensive programming, and database unit testing every day. In his leisure time Alex prepares for and runs ultramarathons.

NO_CONTENT_IN_FEATURE

Image
Looking for the Audiobook Edition?
Tell us that you'd like this title to be produced as an audiobook, and we'll alert our colleagues at Audible.com. If you are the author or rights holder, let Audible help you produce the audiobook: Learn more at ACX.com.

Product Details

  • Paperback: 394 pages
  • Publisher: Red gate books (May 31, 2010)
  • Language: English
  • ISBN-10: 1906434492
  • ISBN-13: 978-1906434496
  • Product Dimensions: 6.1 x 0.8 x 9.2 inches
  • Shipping Weight: 14.4 ounces (View shipping rates and policies)
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (5 customer reviews)
  • Amazon Best Sellers Rank: #1,231,158 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

5 star
100%
4 star
0%
3 star
0%
2 star
0%
1 star
0%
See all 5 customer reviews
Share your thoughts with other customers

Top Customer Reviews

Format: Paperback
I have worked with SQL Server as a developer and a programmer for over 15 years so I have read a lot of books about the product and T-SQL. This is one of the most informative books I have read on SQL in a long time because it made me think a little differently when looking at code. It presented me with situations I haven't seen before (for example a connection setting it's own rowcount explicitly) and the implications that could have.

It really makes you think about the what-if, what happens if your caller does something unexpected and what you might do to mitigate this risk. There are not a whole lot of SQL Server programming books that I learn something from anymore, this was one of them.
Comment 6 of 6 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
This is excellent work on a very important topic. Defensive programming is very often misunderstood, especially in the database world.

Alex deals with this "inconvenient" topic using very practical approach. Instead of filling pages with theory and reasons why defensive programming is good, he dives right into simple examples from the daily work of every database professional. We have all seen (and ignored) many of these issues, but demonstrating how this affects our code and how simple it is to avoid these problems makes this book shine. It is not a complete catalog of defensive techniques, rather a good collection of examples to illustrate the need for defensive coding and applicable methods. It builds the mindset to think proactively and create robust solutions.

The book includes coverage of the following topics: basic defensive technique, code vulnerabilities, changes to database objects, upgrades, reusing code, data integrity and constraints, error handling, concurrency.

"Defensive Database Programming with SQL Server" should be required reading for all SQL practitioners.
Comment 2 of 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
I really enjoyed reading "Defensive Database Programming with SQL Server", and I would recommend it to any SQL Server developer. My favorite chapter was "Chapter 7: "Advanced Use of Constraints", where the author demonstrates the power of the declarative part of the model.

This is not a book for beginners that want to learn about T-SQL language, but if you are already familiar with the language then you will learn about best practices for making your program more robust.

Walk with the author through those situations that can make your code to break. Being aware of these situations is a good start, learning how to defend your code from them is what this book is all about.
Comment 1 of 1 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
I was at a presentation by the author about this subject last year (March 2010) even before the book was published. Unfortunately, the book was not published until several months later. If I recall correctly, I ordered it on a pre-release basis. I have not been disappointed.

If you go through the book you will very likely find reference to oversights that you may have made in the past and how to avoid them in the future.

The only negative I can say about the book is that I wish that it had more of the author's helpful hints. A good subject, perhaps, for a Volume 2.

By the way - where did the author get that beautiful cover photo? Where was it taken?
Comment 1 of 1 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
This is a great book to read for all levels, as it exposes techniques to test and defend against common mistakes and vulnerabilities that TSQL lends itself too. The book provides lots of example code that you can walk through to get the hands-on experience, to prove to yourself how the code works. The book also offers some brevity, so that you can quickly move through the chapters. One of the parts I enjoyed was the explanation of triggers, constraints and when different situations call for using them. Another chapter of interest was the Defensive Error Handling, which shows some of the limitations of the Try Catch error handling in SQL Server 2005 and 2008. Overall, I found this book to be very helpful and I will begin using some of the takeaways I found immediately.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

What Other Items Do Customers Buy After Viewing This Item?