Product Description
Teaches that stored procedure development does not occur in a vacuum–it involves a wide variety of skills, subjects, and technologies–and helps the reader become a better software engineer, not just a stored procedure expert. The most complete coverage of SQL Server stored procedure programming available in one source. Softcover. CD-ROM included.
The Guru’s Guide to SQL Server Stored Procedures, XML, and HTML


I showed this to my students and it scared the s**t out of them. An extremely counter-productive experience!
Rating: 2 / 5
The book is superb in explaining stored procedures and triggers. However, it has nothing to do wiht .NET. If you want to learn how to call stored procedures from .NET, then you definitely don’t want to buy this book.
Rating: 4 / 5
Finally a book that gives you, in the same chapter, a way to do arrays in SQL, and an excellent example of how to use extended stored procedures, and system functions.
When I search for a good book, I look at a lot of books on the shelves, and often notice that many books just duplicate information readily available at “Books on line” or MSDN. This one doesn’t do that. It explores a lot of topics that, although they do not appear immediatly useful, sooner or later will save you a lot of time.
And that’s what I look for when I buy a book! This extra wealth of information that makes a difference when you have to program something of higher complexity that usual.
Rating: 5 / 5
You need this book if:
- Your new to XML and want to get up to speed with it
- Your a Sql Svr dba or user and want to learn about its XML features
- Your a developer and want to get the most out of Sql Svr’s XML features
- Your a developer and want to learn stored proc authorship from a master
All in all the best buy for Sql Svr that there is.
Rating: 5 / 5
I was really struggling with xml and sql server until I found this book. This book pulled it all together for me. It’s worth the money for that alone.
The xml intro chapter is the most to the point tutorial on xml I’ve found even in whole books on the subject.
If you add to this the fact that stored procedure programming is drilled into as are several other relevant topics you have a book that every sql person should read.
I also really enjoyed the essays at the end of the book. Very good stuff that I’ve read more than once. Not specifically related to sql server but still good reads.
Rating: 5 / 5