Shop DJ Furby!
Enjoy fast, free delivery, exclusive deals, and award-winning movies & TV shows.
Buy new:
-43% $17.21
FREE delivery July 5 - 9 on orders shipped by Amazon over $35
Ships from: Amazon.com
Sold by: Amazon.com
$17.21 with 43 percent savings
List Price: $29.99
Get Fast, Free Shipping with Amazon Prime FREE Returns
FREE delivery July 5 - 9 on orders shipped by Amazon over $35
Or fastest delivery Saturday, July 5
Available to ship in 1-2 days
$$17.21 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$17.21
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Ships from
Amazon.com
Amazon.com
Ships from
Amazon.com
Sold by
Amazon.com
Amazon.com
Sold by
Amazon.com
Payment
Secure transaction
Your transaction is secure
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
$2.42
Item in good condition. Textbooks may not include supplemental items i.e. CDs, access codes etc... Item in good condition. Textbooks may not include supplemental items i.e. CDs, access codes etc... See less
$3.98 delivery Wednesday, July 9. Details
Or fastest delivery July 3 - 8. Details
Only 1 left in stock - order soon.
$$17.21 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$17.21
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Access codes and supplements are not guaranteed with used items.
Ships from and sold by glenthebookseller.
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera - scan the code below and download the Kindle app.

QR code to download the Kindle App

Follow the author

Alex Kuznetsov
Follow
Something went wrong. Please try your request again later.

Defensive Database Programming with SQL Server

by Alex Kuznetsov (Author)
4.6 out of 5 stars 9 ratings
{"desktop_buybox_group_1":[{"displayPrice":"$17.21","priceAmount":17.21,"currencySymbol":"$","integerValue":"17","decimalSeparator":".","fractionalValue":"21","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"ya75oxjuPWhEZCyT%2B87q8sW3qzgBJFsMVGab0pK9cpD7LvtafLNfslC1TrNM8lTTQRs56Pxmjg0IYCS4oDz5lm%2FjuiDv3SqBCOs2Di99CF0mtsCy5f960XYU2h%2F13L1B5bPN2%2B80ItY%3D","locale":"en-US","buyingOptionType":"NEW","aapiBuyingOptionIndex":0}, {"displayPrice":"$2.42","priceAmount":2.42,"currencySymbol":"$","integerValue":"2","decimalSeparator":".","fractionalValue":"42","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"ya75oxjuPWhEZCyT%2B87q8sW3qzgBJFsMnL%2F0Ji7Ib4vMON7%2FeiOmg8waacC%2BolrbXa8rFtoqyXpSCLj%2BY9resWGVXvE0K3eGkvsv8dpfxjYbXeOZez0c2pUYNL%2B4y2W%2Be7%2BcGwvN1EjU5n2BFdbwlquZDKy9VEN5iQUL6O1tpaOLpr9%2FWAEveYoY49fCOAC8","locale":"en-US","buyingOptionType":"USED","aapiBuyingOptionIndex":1}]}

Purchase options and add-ons

The goal of Defensive Programming is to produce resilient code that responds gracefully to the unexpected. To the SQL Server programmer, this means T-SQL code that behaves consistently and predictably in cases of unexpected usage, doesn't break under concurrent loads, and survives predictable changes to database schemas and settings. Inside this book, you will find dozens of practical, defensive programming techniques that will improve the quality of your T-SQL code and increase its resilience and robustness.
Read more
  Report an issue with this product or seller
Previous slide of product details
  1. ISBN-10
    1906434492
  2. ISBN-13
    978-1906434496
  3. Publisher
    Red Gate Books
  4. Publication date
    May 31, 2010
  5. Language
    English
  6. Dimensions
    6.14 x 0.81 x 9.21 inches
  7. Print length
    394 pages
Next slide of product details

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.

Product details

  • Publisher ‏ : ‎ Red Gate Books
  • Publication date ‏ : ‎ May 31, 2010
  • Language ‏ : ‎ English
  • Print length ‏ : ‎ 394 pages
  • ISBN-10 ‏ : ‎ 1906434492
  • ISBN-13 ‏ : ‎ 978-1906434496
  • Item Weight ‏ : ‎ 1.24 pounds
  • Dimensions ‏ : ‎ 6.14 x 0.81 x 9.21 inches
  • Customer Reviews:
    4.6 out of 5 stars 9 ratings

About the author

Follow authors to get new release updates, plus improved recommendations.
Alex Kuznetsov

Alex Kuznetsov

Brief content visible, double tap to read full content.
Full content visible, double tap to read brief content.

Discover more of the author’s books, see similar authors, read book recommendations and more.

Customer reviews

4.6 out of 5 stars
9 global ratings

Review this product

Share your thoughts with other customers
Write a customer review

Top reviews from the United States

  • Rand E. Gerald
    5.0 out of 5 stars Excellent book
    Reviewed in the United States on April 13, 2011
    Format: PaperbackVerified 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?
    One person found this helpful
    Helpful
     Report
  • Alejandro Mesa
    5.0 out of 5 stars When TRY ... CATCH is not enough.
    Reviewed in the United States on October 21, 2010
    Format: PaperbackVerified 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.
    One person found this helpful
    Helpful
     Report
  • Plamen Ratchev
    5.0 out of 5 stars Great reading for database practitioners
    Reviewed in the United States on January 28, 2011
    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.
    2 people found this helpful
    Helpful
     Report
  • H. Treftz
    5.0 out of 5 stars Useful and Informative....
    Reviewed in the United States on June 16, 2010
    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.
    6 people found this helpful
    Helpful
     Report
  • JRGWV
    5.0 out of 5 stars Defensive SQL Server programming 'gotchas'
    Reviewed in the United States on November 14, 2010
    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.
    Helpful
     Report

Top reviews from other countries

  • PW
    4.0 out of 5 stars A valuable read for experienced SQL developers
    Reviewed in the United Kingdom on February 13, 2014
    Format: PaperbackVerified Purchase
    Defensive programming is not a new idea but has been around for 30+ years. This book applies the tenets of it to database programming to produce more robust code that is safe to run in unexpected situations.

    The subject of this book is to some degree also covered in other books on SQL development, where authors usually recommend to avoid 'risky' practices that might unexpectedly break one day, e.g., after an update of server software. However, it's usually not covered at depth because it's a rather special subject that will mainly appeal to expert developers who have already mastered all the basics of SQL and database programming.

    The book focuses on a special, advanced subject, and therefore it is most useful for experienced SQL developers. In it the author looks into a number of typical pitfalls that most SQL programmers will experience the hard way one day in their careers. He offers valuable, practical advice how to avoid these pitfalls before they hurt. The text is well-written and clearly the author knows the subject very well and has significant experience in the field. Some of the practices highlighted in this book and discouraged as 'potentially risky' by the author are of the type that a 'good' programmer will not do anyway. As I myself know only too well often this is more inspired by gut-feeling than really solid knowledge, experience or systematic experimentation.

    This book fills the gap between gut-feeling and knowledge in selected areas of SQL development by pointing out why the gut-feeling is indeed justified, why and in what way the practices are potentially problematic, what their impact may be if things go wrong, and how the risk can be avoided and at what price.

    In my view the book will be a valuable read for most experienced SQL developers.
    Report