The Guru's Guide to SQL Server Stored Procedures, XML, and HTML

The Guru's Guide to SQL Server Stored Procedures, XML, and HTML

5.0 6
by Ken Henderson
     
 

ISBN-10: 0201700468

ISBN-13: 9780201700466

Pub. Date: 01/28/2002

Publisher: Addison-Wesley

"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,

…  See more details below

Overview

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

0201700468B11262001

Read More

Product Details

ISBN-13:
9780201700466
Publisher:
Addison-Wesley
Publication date:
01/28/2002
Edition description:
BK&CD-ROM
Pages:
800
Sales rank:
772,427
Product dimensions:
7.40(w) x 9.20(h) x 1.70(d)

Related Subjects

Table of Contents

Preface.

Introduction.

I. THE BASICS.

1. Stored Procedure Primer.

2. Suggested Conventions.

3. Common Design Patterns.

4. Source Code Management.

5. Database Design.

6. Data Volumes.

II. OBJECTS.

7. Error Handling.

8. Triggers.

9. Views.

10. User-Defined Functions.

III. HTML, XML, AND .NET.

11. HTML.

12. Introduction to XML.

13. XML and SQL Server: HTTP Queries.

14. XML and SQL Server: Retrieving Data.

15. XML and SQL Server: OPENXML.

16. Introduction to .NET.

IV. ADVANCED TOPICS.

17. Performance Considerations.

18. Debugging and Profiling.

19. Automation.

20. Extended Stored Procedures.

21. Administrative Stored Procedures.

22. Undocumented Code.

23. Arrays.

V. ESSAYS ON SOFTWARE ENGINEERING.

24. Create a Workable Environment.

25. Make Small Changes.

26. Test Your Work.

Index. 0201700468T10152001

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >

The Guru's Guide to SQL Server Stored Procedures, XML, and HTML 5 out of 5 based on 0 ratings. 6 reviews.
Guest More than 1 year ago
I own all three of Ken Henderson's SQL Server books. They stand apart from the rest of the crowd as the best books available on their respective subjects. Henderson takes a fresh approach to teaching that other authors would do well to emulate. What do I mean exactly? I mean this: Every point of any significance that is raised is illustrated with code when possible. There are hundreds of code examples in each of Henderson's books - many times what you usually see in DBA or programming books. No details are glosssed over. If you really want to know how something works or what the best approach is to doing something, you need these books. Another thing that is great about these books is how easy to read they are. Complex subjects are regularly broached with explanations and teaching that practically anyone could understand. Topics that trip up other authors or that they skip altogether are discussed in terms that anyone can grasp. It is difficult to convey just how important this is, but suffice it to say that the books are simply easy to read. If you want to know SQL Server at an expert level, you need look no further. Get all three of Henderson's books and read them cover-to-cover.
Guest More than 1 year ago
This book will challenge you to rethink your approach to developing in Transact-SQL. Henderson teaches that Transact-SQL is as a real a language as traditional languages such as C++ and VB and offers ample evidence to support this. He covers the whole gamut of the Transact-SQL programming spectrum -- from design patterns, to version control, to views, triggers, and UDFs, to xprocs, OLE Automation, and many others. He finishes up with a wonderful three-chapter set on his philosophy about software engineering as it relates to Transact-SQL programming. All in all, you won't find a better book on mastering the Transact-SQL language at any price.
Guest More than 1 year ago
This book blew me away. From the 700+ code samples to the engaging prose, this is the best technical book I've ever found. Henderson deserves an award for this one - it's that good. Some high points:

- Production-quality example code - lot's of it

- Sage advice and commentary throughout

- Engaging prose and witty asides

- The chapter on .NET - no one has ever said it better

- The chapters on SQLXML - could be a book unto themselves

- The emphasis on treating Transact-SQL like a 'real' language -- a well thought out and reasoned argumented that pursuaded me and my entire team

- The Foreword by Ron Soukup - when I read that Foreword, I knew I had to have the book. I wasn't disappointed.

You can't go wrong with this one. Get it and get it today.

Guest More than 1 year ago
The book covers so many challenging subjects with such ease. It starts out with a primer on stored procedures. It devotes chapters to database design, triggers, views, UDF's, XML, and .NET, to list some of the topics. Once you read Mr. Henderson's book, you see there is so much to learn about SQL Server. I especially liked the chapter on UDF's. If you've ever searched for a better alternative to the builtin Soundex function, Mr. Henderson provides *the* best Soundex solution for SQL Server. In fact, that alone makes the book worthwhile. And let's not forget his listing and explanation of dozens of undocumented functions and features in SQL Server.
Guest More than 1 year ago
Ever since Sql Server 2K shipped I've been looking for the ultimate XML-on-Sql Server book. Now I have finally found it. I just spent the last week working from start to finish through the XML chapters and have gone from being a complete novice to pretty fair XML-SQL developer. I took some of the techiques the author shows and put in place in my work. Not only is the book instructive, the copious code samples have value apart from the book. All I can say is: thank you for writing this book. It was exactly what I needed.
Guest More than 1 year ago
Ken Henderson's writing style is so natural and friendly. The book is quite an easy read, yet Mr. Henderson is able to convey some very technical content... While sharing stored procedures is almost always good - there are times when plan sharing can hurt performance. If you do not understand how to tell when plan sharing can be bad, Ken's book will get you up to speed. The second half of the book is related to XML and SQL Server/XML integration... If you are one of the many, many database guys out there who say 'I just don't get the XML thing.', then this book will be your guide.. Great job, Ken.!!