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...