The Guru's Guide to SQL Server Stored Procedures, XML, and HTML
Ken Henderson, Ron SoukupBooks.org participates in affiliate programs including Bookshop.org and the Amazon Services LLC Associates Program. We may earn a commission from qualifying purchases made through links on this page, at no additional cost to you.
Overview
The Microsoft Transact-SQL programming language has become an increasingly popular solution for developers seeking to build powerful and scalable distributed SQL Server applications. This follow-up to the widely acclaimed The Guru's Guide to Transact-SQL covers current subjects critical to successful SQL Server application development in depth, while leading developers to new heights in their overall programming skills.
Blending theoretical detail with practical application, this comprehensive reference begins by providing a foundational overview of SQL Server stored procedure programming. From there, the book moves on to best practices and design considerations before progressing to advanced topics -- providing the most complete coverage of SQL Server stored procedure programming available in one source. Topics such as extended procedures, OLE Automation, database design, and XML are covered in detail, while the book spotlights undocumented language features and brings the first application of design patterns to SQL. The preview of.NET and a groundbreaking way to add arrays to Transact-SQL make for the most thorough and engaging read published to date on SQL Server programming.
The Guru's Guide to SQL Server Stored Procedures, XML, and HTML includes sample projects with complete source code suitable for plugging into real world applications. Additional highlights include:End-to-end coverage of stored procedure construction, best practices, and common conventions.
In-depth coverage of "procedural" objects, including triggers, views, and user-defined functions.
A comprehensive discussion of employing HTML and XML in SQL Server applications, as well as an introduction to Microsoft's new .NET platform.
Expert advice on debugging and profiling stored procedure code.
Step-by-step instructions on how to create advanced stored procedure objects including extended stored procedures and administrative procedures.
A behind-the-scenes look at undocumented Transact-SQL elements and coding tricks.
Software engineering essays addressing the work environment, evolutionary code development, and software testing.
An accompanying CD-ROM contains the book's source code along with several handy database administration tools. More than 600 code files, programming utilities, extended procedures, and SQL scripts demonstrate the real power of SQL Server programming and provide a tremendous value to the reader.
Both comprehensive and practical, The Guru's Guide to SQL Server Stored Procedures, XML, and HTML provides developers with a complete tool set for becoming expert stored procedure programmers and better software practitioners.
Synopsis
The Guru's Guide to SQL Server Stored Procedures, XML, and HTML A Book/CD-ROM Package
Ken W. Henderson
SQL Server developers: reach the next level!
Practical techniques and example code help SQL Server developers build more powerful, robust applications -- fast! The follow-up guide to Ken Henderson's universally praised, best-selling The Guru's Guide to Transact-SQL. CD-ROM contains extensive source code library including valuable code that makes queries run faster. SQL Server developers worldwide raved about Ken Henderson's The Guru's Guide to Transact-SQL: its exceptionally clear, conversational explanations, and its powerfully useful projects and code examples. This book helps SQL Server developers take the next step -- building more powerful, robust applications than ever before. Henderson identifies several key areas of SQL Server development that offer the greatest power -- and then covers each of them in exceptional detail. The book includes especially thorough coverage of Transact-SQL stored procedure programming, including features such as extended procedures, database design, and XML that are often disregarded in competitive books. Henderson introduces a method he has developed to add arrays to T-SQL, something previously thought impossible. He offers an ideal balance of theory and code, gradually building on basic techniques to create increasingly sophisticated solutions, and teaching the philosophy of Transact-SQL programming alongside syntax and technique. An accompanying CD-ROM includes extensive source code, including valuable proprietary code that makes T-SQL queries run faster. For every SQL Server developer.
Ken Henderson is a nationally recognized consultant and leading database practitioner whose clients include the U. S. Air Force, the U. S. Navy, H&R Block, Travelers Insurance, J.P. Morgan, the CIA, Owens-Corning, and CAN Insurance. A frequent magazine contributor and conference speaker, he is author of six previous books, including the best selling The Guru's Guide to Transact-SQL, which received universal rave reviews.
Booknews
Explores the nuances and quirks in SQL Server's stored procedure programming language, Transact-SQL. Written for advanced programmers, the book delves into the intricacies of database design, triggers, view objects, user-defined functions, extended storage procedures, and administrative storage procedures. The author also explains how to translate data stored in SQL Server databases into HTML and XML. The CD-ROM contains SQL scripts and programming utilities. Annotation c. Book News, Inc., Portland, OR (booknews.com)
Editorials
From Barnes & Noble
The Barnes & Noble ReviewIf you're an experienced SQL Server developer and you want to become a great one, here's your book: The Guru's Guide to SQL Server Stored Procedures, XML, and HTML. Chances are, you've already read (or at least heard of) Ken Henderson's classic The Guru's Guide to Transact-SQL. This is his long-awaited follow-up -- and it's been worth the wait.
Thought you couldn't implement arrays in T-SQL? Think again: Henderson shows you how. Never seen design patterns applied to T-SQL? Now you have -- and you'll be able to use these patterns from the get-go.
You'll find best practices and conventions for effective stored procedure development, debugging, profiling, and performance optimization, as well as expert techniques for creating triggers, views, and user-defined functions. The book includes a full section on using XML with SQL Server, covering queries, data retrieval, and the use of OPENXML, which allowing you to handle XML in relational database formats and pass XML documents to T-SQL stored procedures.
The CD-ROM brings together more than 600 code files: SQL scripts, programming utilities, extended procedures, database administration tools, and more. Between the code and the insights, T-SQL developers will find this book to be a gold mine. (Bill Camarda)
Bill Camarda is a consultant, writer, and web/multimedia content developer with nearly 20 years' experience in helping technology companies deploy and market advanced software, computing, and networking products and services. He served for nearly ten years as vice president of a New Jerseybased marketing company, where he supervised a wide range of graphics and web design projects. His 15 books include Special Edition Using Word 2000 and Upgrading & Fixing Networks For Dummies®, Second Edition.
Explores the nuances and quirks in SQL Server's stored procedure programming language, Transact-SQL. Written for advanced programmers, the book delves into the intricacies of database design, triggers, view objects, user-defined functions, extended storage procedures, and administrative storage procedures. The author also explains how to translate data stored in SQL Server databases into HTML and XML. The CD-ROM contains SQL scripts and programming utilities. Annotation c. Book News, Inc., Portland, OR (booknews.com)