The Guru's Guide to SQL Server Stored Procedures, XML, and HTML Paperback – 27 Dec 2001
- Choose from over 13,000 locations across the UK
- Prime members get unlimited deliveries at no additional cost
- Find your preferred location and add it to your address book
- Dispatch to this address when you check out
Customers who bought this item also bought
What other items do customers buy after viewing this item?
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Would you like to tell us about a lower price?
If you are a seller for this product, would you like to suggest updates through seller support?
From the Back Cover
"This is a book that deserves a prominent place by anyone who aspires to be a real professional developer of SQL Server applications."
--from the Foreword by Ron Soukup
The message of this book is that building stored procedures in Transact-SQL is very much like building programs in any other language. It requires the same type of skill, planning, attention to detail, and overall grasp of technology that successful development in other languages requires. To master Transact-SQL, one must first master the fundamental concepts of software development, then build on this foundation by embracing and studying Transact-SQL as a programming language in its own right. This book teaches you how to do that and more.
More than just a catalog of coding tricks and syntax subtleties, The Guru's Guide to SQL Server(TM) Stored Procedures, XML, and HTML explores the philosophy of Transact-SQL programming. It teaches readers how to apply this philosophy in order to develop their own coding techniques and discover their own solutions to real-world programming problems. A follow-up to the widely acclaimed The Guru's Guide to Transact-SQL, this book 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.
Blending theoretical detail with practical application, this comprehensive reference begins with a foundational overview of SQL Server(TM) stored procedure programming. From there, the focus moves on to best practices and design considerations before progressing to advanced topics and a general philosophy of software craftsmanship. In all, this book provides the most complete coverage of SQL Server stored procedure programming available in one source.
Topics such as user-defined functions, views, triggers, extended procedures, error handling, OLE Automation, database design, and XML are covered in detail. The book spotlights undocumented language features and brings the first application of design patterns to the SQL language. The preview of .NET and a groundbreaking approach to adding arrays to Transact-SQL make for the most thorough and engaging read published to date on SQL Server programming.
The accompanying CD-ROM contains the book's source code. More than 700 SQL scripts, programming utilities, and extended procedures provide a veritable treasure trove of high-quality example code.
Theoretically sound, yet immensely practical, The Guru's Guide to SQL Server(TM) Stored Procedures, XML, and HTML provides developers with the tools they need to become expert stored procedure programmers and better software engineers.
About the Author
Ken Henderson, a nationally recognized consultant and leading DBMS practitioner, consults on high-end client/server projects for such customers as the U.S. Air Force, the U.S. Navy, H&R Block, Travelers Insurance, J.P. Morgan, the CIA, Owens-Corning, and CNA Insurance. He is the author of five previous books on client/server and DBMS development, a frequent magazine contributor to such publications as Software Development Magazine and DBMS Magazine, and a speaker at technical conferences.
Top customer reviews
For *just* good developers, this book might be a little too hardcore.
If you're looking for a good book that covers more than just the basics, but is not pitched at gurus, then I'd recommended Robert Vieira's book instead.
If you liked the book Inside SQL Server 2000 by Delaney, then this book is for you.
Most helpful customer reviews on Amazon.com
The first chapter, the overview of stored procedures, is almost a complete replica of the stored procedures chapter in the previous book. The XML chapter is out of date and not very deep. He has this whole triumphant diatribe about .NET that isn't worth reading.
Many points in this book don't stand the test of time. He's got sharp criticism for 2002-era web apps and praises ASP.NET but look where we are in 2015 - ASP.NET didn't exactly take the world over by storm. He talks about how XML might someday supplant HTML as the language of the web - another flop. There are whole pages in the HTML section with a giant "X" through them for some unknown reason. Part of me wonders whether this book is even WORTH updating, to tell you the truth.
Overall very disappointing.
I bought this book because I am now working more with the topics that are supposed to be covered by this book, Stored Procedures, XLM, and HTML. I was impressed with how his first book had quickly and easily improved my skills and was interested in seeing what he could do for me in the new arena. Unfortunately it didn't work out.
In spite of the titles, the two books are barely related to each other. This book is a "why-you-do-it-this-way" book with a lot of philosophy and best-practice stuff and relatively few of the tips and tricks that I valued so highly in the first book. Unfortunately this information isn't that valuable now because the state of the art has kept changing and much of what he discusses either isn't relevant anymore or is now blindingly obvious.
But the problem with the book goes deeper than that. The extraordinary value of the first book was that it hit to Ken Henderson's strengths; very clear writing about very small topics with obvious and immediate payback for the reader. This book unfortunately tends to emphasize his weaknesses; poor organization, wandering off topic, and frequently saying too much that adds very little.
That's not to say that there aren't good reasons to buy this book, he's still a good clear author and there aren't enough of them in the technical writing field today. I particularly valued the essays at the end of the book and there are lots of valuable little nuggets that can be found throughout the entire book, just don't buy this book with the expectation that it will be the motherlode that his first book was.
Aside from the great technical information, Ken included several chapters on his philosophy of the art of programming, opinions and viewpoints on .NET, XML, suitable environments in which to work, and great stories of life as a programmer/writer/thinker. Very thought provoking, Ken has become one of those that I look up to and have great admiration for. I was lucky enough to hear him speak at a local SQL Server group in Dallas last year - if you get a chance to see him, go. Mr Henderson, I promise not to send you too many emails going forward. Thanks.
Look for similar items by category
- Books > Computing & Internet > Databases > Applications
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Programming > Languages
- Books > Computing & Internet > Web Development > Web Scripting & Programming