Customer Reviews

2 Reviews
5 star:    (0)
4 star:
3 star:    (0)
2 star:    (0)
1 star:    (0)
Average Customer Review
Share your thoughts with other customers
Create your own review
Most Helpful First | Newest First

1 of 1 people found the following review helpful
4.0 out of 5 stars very good stab at a difficult subject, 2 Sept. 2010
This is a very good book that is based on practical experience. Reading it would save you trying days of coding and testing. I am very pleased to have read it and advise any sql coder to go through it.

It is very specific to sql server, rather than generic theory that may or may not apply to your installation.

Covers so many good ideas that will take years to understand and learn. some of which I am generally aware of but have not understood in details. Such as the behaviour of set and select.

Attempt to solve the problem with code reuse which is an almost impossible problem. SQL code is routinely duplicated to maintain a good performance (e.g. scalar functions aren't used - i've coded them in then out when things slowed down), so here there are some practical suggestions that should help the disillusioned.

I don't think i can fault it in any of the examples apart from a couple of typos it is very well written, at times there seem to be pages and pages of code with slightly different versions, but I guess that gives a very clear and step by step examples to prove solid points.

OK, I am not sure about de-normalising for sake of enforcing business logic in constraints, I am not sure if i can get this passed the architecture team (they will want to keep business rules in the application layer - despite the arguments in the book to the contrary), still I am really impressed with the creative approach (don't know if anyone else thought of doing this before), and will try to apply - but only if I can see the benefits outweigh the data duplication and the additional code complexity and its a big ask...

Although I have 10 years of sql but most of which spend on sql 2000, so in some way this was a useful read to see 2008 features put to use.

Also having part of the book as a free download is very generous, I hope (but doubt) redgate is paying some good money towards it.

Lastly, I wanted to get the last two chapters but its seems that I have to wait and can't find the guy's email to moan about it...
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No

4.0 out of 5 stars A valuable read for experienced SQL developers, 13 Feb. 2014
PW (Manchester, UK) - See all my reviews
Verified Purchase(What is this?)
This review is from: Defensive Database Programming with SQL Server (Paperback)
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.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No

Most Helpful First | Newest First

This product

Defensive Database Programming with SQL Server
Defensive Database Programming with SQL Server by Alex Kuznetsov (Paperback - 31 May 2010)
Used & New from: £11.43
Add to wishlist See buying options
Only search this product's reviews