Editorial Review:Product Description:Get thorough coverage of SQL Server 2000—including extended XML capabilities and VS.NET updates with this expertly written resource. Learn to harness the full benefits of modular programming, and achieve faster execution and a reduction of network traffic. Included are a sample database and an end-to-end solution for a Web search engine.
Availability: Usually ships in 24 hours
Related Items:
see more
Related Items:
Customer Reviews
Average Rating:
-
Good but Missing Query Reference
I'm a developer with a degree in CS and 10 years' experience. I bought this book for an SQL Server 2000 project, because I've got more experience with mysql which has slightly different syntax and doesn't support stored procedures.
I guess I just assumed this book would contain query syntax reference. But it doesn't. It is very thorough on stored procedures and xml and I'm sure I will be glad I have it.
But-
If you don't already have one, you will still need to get a query syntax reference.
Rating: -
Matthew Reinbold on behalf of the Salt Lake City ColdFusion User's Group (SLCFUG)
-as read by Mike Tazelaar
This is an informative and comprehensive book.
There are many realistic examples and suggestions that help solve complex and everyday SQL problems quickly.
This book supplies everything that you need for stored procedure development - from naming conventions to methods to deploy changes in production.
Additional software to help with code management is also available on author's web site.
Several ways to accomplish a given task are described, with pro's and con's for each. Sunderic includes not only "how", but "why and why not".
This book contains not only stored procedures, but triggers, user-defined functions, XML and more.
If you write or maintain apps that use SQL Server or train people to do this, this book is a "must have"!
Rating: 
-
Disapointed reader
My choice of this book was based on the reviews written here. After reading the book i wonder if the reviewers actually read the book. It is presented as book that should supply the reader with essential skills on programming stored procedures and using the ms sql 2000 server for XML output and .NET platform integration. But it is nothing more then a purely written book, that has more to say about visual inter Dev then visual studio.net ore visul studio 2003. Beside that it also describes avanced topics in general terms of no use to the developer, that wants to get the job done propperly. This is evident to everybody that actually read the book: As the subjects get more interesting - and complicated- the examples grows rapidly while the explainations scrimp to af few lines. The writter also left out basic commands as 'ref' and 'out' on parameters, which makes me wonder what else he left out. He also tries to give idees on how to develop in a distributed environment, but leaves out every important pitfall, that one has to be aware of in a multi processor environment. I cant imagine a distributed system where where every db runs on a server with only one processor - the system will be way to expensive, read your db lincences and you will know why. All togehter i got the impression that the writter pieced the book together from readings that didn't give him the sufficient knowledge to complete this book in a propper way. It is a waste of my time and money.
I'am sorry about my english - I'am in a hurry and pissed off.
Rating: 
-
Lucid and thorough -- VERY worthwhile
It bothers me that many of the best books on the latest Microsoft technology (.Net, SQL Server) are written by non-native-English speakers. I am amazed by the quality of writing by Francesco Balena and Dino Esposito, and now I would add Dejan Sunderic to my list of favorite authors.
This book is beautifully lucid, broad in scope, and thorough. If you need access to an intelligent treatment of Transact-SQL in its various applications (stored procedures, triggers, XML, etc.), you should seriously consider this book. Your money and time would be well spent!
Rating: -
Great resource for SQL/XML
Extremely helpful for SQL/XML. Great examples. Very simple to understand. Author has an interative way of writing. Last 4 chapters are a must read for any SQL developer.