Your Account | Cart Cart | Wish List | Help | Gold Box
SearchBrowse
Subjects
BestsellersThe New York Times®
Best Sellers
MagazinesCorporate
Accounts
e-books
& docs
Bargain
Books
Used
Books
Textbooks
Search     
Web Search
View CartWish ListYour AccountHelp
Join Amazon Prime and ship Two-Day for free and Overnight for $3.99. Already a member? Sign in .

book Information
  Explore this item
   buying info
   customer reviews
   editorial reviews
   search inside

Listmania!


Microsoft SQL Server 2000 Clinic: A list by Zechristof, The Doctor is in

Add your List


Ready to buy?


Sign in to turn on 1-Click ordering.
a9.com   A9.com users save 1.57% on Amazon. Learn how.

Don't have one?
We'll set one up for you.
The Guru's Guide to SQL Server Stored Procedures, XML, and HTML (With CD-ROM)
by Ken Henderson "Working from the assumption that the human brain learns by associating new data with what it already knows, we'll spend this chapter building a base..." (more)
SIPs: srv sendmsg, spid ecid status loginame, srv senddone, orphaned transactions, srv paraminfo (more)
CAPs: Stored Procedure Primer, Alfreds Futterkiste, Query Analyzer, Books Online, Ana Trujillo Emparedados (more)


List Price: $59.99
Price: $39.59 and this item ships for FREE with Super Saver Shipping. See details
You Save: $20.40 (34%)
Availability: Usually ships within 24 hours. Ships from and sold by Amazon.com.

Want it delivered Tuesday, August 9? Choose One-Day Shipping at checkout. See details
Edition: Paperback


Better Together
Buy this book with The Guru's Guide to Transact-SQL by Ken Henderson today!
plus
Total List Price: $119.98
Buy Together Today: $78.11


Links you might be interested in
man shoes
maternity
mac
sandals
underwear

Editorial Reviews
Book Info
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.

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.



0201700468B11262001

See all Editorial Reviews

Product Details
  • Paperback: 576 pages
  • Publisher: Addison-Wesley Professional; 1st edition (December 27, 2001)
  • Language: English
  • ISBN: 0201700468
  • Product Dimensions: 9.2 x 7.4 x 1.6 inches
  • Shipping Weight: 2.6 pounds. (View shipping rates and policies)
  • Average Customer Review: based on 79 reviews.
  • Amazon.com Sales Rank: #19,698 in Books
    (Publishers and authors: improve your sales)

Inside This Book (learn more)
First Sentence:
Working from the assumption that the human brain learns by associating new data with what it already knows, we'll spend this chapter building a base framework onto which we can assemble the knowledge conveyed by the remainder of the book. Read the first page
Statistically Improbable Phrases (SIPs): (learn more)
srv sendmsg, spid ecid status loginame, srv senddone, orphaned transactions, srv paraminfo, xml proc, idx value, srv setcoldata, xml preparedocument, srv pfield, srv paramlen, srv paramtype, srv rpcparams, srv describe, fulltext resource, srv sendrow, trace queue, source code management system, fillfactor setting, result set listing, objid int, int identity, table aliases, stored procedure programming, generate test data
Capitalized Phrases (CAPs): (learn more)
Stored Procedure Primer, Alfreds Futterkiste, Query Analyzer, Books Online, Ana Trujillo Emparedados, Visual Basic, Performance Considerations, Enterprise Manager, Order Details, Undocumented Procedures, Suggested Conventions, Evolutionary Development, Coming Revolution, Customers Customerld, Microsoft Press, Entity-Relationship Modeling, Retreiving Data, Visual Studio, Tenant Number, Property Number, Wilman Kala, Call Number, Sonny Cried, Source Formatting, Nightingale Sang
New! 
Books on Related Topics | Concordance | Text Stats
Browse Sample Pages:
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover | Surprise Me!
Search Inside This Book:

Spotlight Reviews
Write an online review and share your thoughts with other customers.

103 of 123 people found the following review helpful:

Another great Ken Henderson SQL book, March 7, 2002
Reviewer:John Lennox (Hampton Falls, NH USA) - See all my reviews
I bought the first Guru's Guide -- The Guru's Guide to Transact SQL -- as a way to fine-tune my SQL skills when I began a new job as a SQL Server Admin / Developer. Nearly two years later, I still find myself reaching for that book for almost every unique SQL problem that I encounter, and I am rarely disappointed. When I saw that Henderson had written another SQL book, I expected another winner. I was not disappointed.

The coverage of stored procedures, user-defined functions, and XML was first-rate. And the relatively short chapter on .NET was loaded with reasons why every SQL Server developer should be embracing this new techology.

The Essays on Software Engineering were extremely well-written. The intermingling of personal experiences and reflection with the technical details of the topics was done just right. It added a certain amount of relevance to the section that made it feel less like a theoretical lecture and more like the sharing of information by a well-respected colleague. One who has obviously experienced these things and knows what he is talking about. On the surface, these essays may seem a bit out of place in a book about Stored Procedures and XML but, in fact, they fit very well with the overall theme of the book: SQL and Stored Procedure development is "real" software engineering and needs to be treated as such if you are going to be good at it.

Was this review helpful to you?  YesNo (Report this)



113 of 132 people found the following review helpful:

Henderson takes it to a new level, January 12, 2002
Reviewer:Donald Farris (Jersey City, NJ USA) - See all my reviews
I never thought I'd say this but this book is even better than the first Gurus Guide book! Henderson cuts loose and just writes. It feels like you've got the guru sitting right next to as you read.

As with his first book, Henderson runs a tight ship with this one. There's no fluff or other filler material. Instead, you just get the goods, and you get them by the boatload.

My fav things about this one are:

* Extended Proc coverage. I've always wondered how to build these. The coverage in this book is absolutely excellent. It could be a book unto itself.

* XML coverage. I've never seen a better cut-to-the-chase introduction to XML and the XML features in SQL Server. It's a wonderful, hands-on tutorial written by a master.

* Emphasis on treating transact-sql as a real language. Henderson stresses this over and over and he's right. This book is every bit as good as the high-end programming books that feature languages like C++ and Java.

* Essays on software engineering. These are some of the best technical writing I've ever read.

I don't think you could spend your money on a better SQL Server book.

DjF

Was this review helpful to you?  YesNo (Report this)



Customer Reviews
Average Customer Review:
Write an online review and share your thoughts with other customers.

2 of 3 people found the following review helpful:

This is the book for SQL Developers/DBAs, March 25, 2005
Reviewer:Elijah Li (California) - See all my reviews
(REAL NAME)   
I have about $2000 worth of the book on asp.net, cfml, Microsoft SQL server, Oracle DB book, and other tech related books. Most of the books I had are poorly written and the authors are trying to make "quick buck". This book is very well written and in-depth of Microsoft SQL Server. Highly recommanded!

Was this review helpful to you?  YesNo (Report this)



2 of 2 people found the following review helpful:

Essential, March 18, 2005
Reviewer:Charles McNutt (Avondale, AZ) - See all my reviews
This book is essential for those building solutions with Sql Svr. It is really a developer's take on how to create applications based on the world's best database. There are chapters on database design, source code control, design patterns, testing, and many, many others. The SqlXml info is the deepest and best of any of the SQl books I have found. I highly recommend this book.

Was this review helpful to you?  YesNo (Report this)



5 of 5 people found the following review helpful:

Excellent on some topics, unfocused overall, November 8, 2004
Reviewer:Jack D. Herrington "engineer and author" (Silicon Valley, CA) - See all my reviews
(TOP 500 REVIEWER)    (REAL NAME)   
There is a lot to like in this book. The chapter on database design is fantastic. The chapter on views is excellent as well. But overall the book veering off topic now and again, which adds to it's girth (760 pages.)

The book starts with a very solid introduction to stored procedures. As I say, the database design portion of the first part is probably worth the price of admission on it's own.

Part two is titled objects, which is a little deceptive since the chapter mainly covers functions, triggers, stored procedures and other structural elements.

Part three is where the book gets into XML and HTML. There is some introductory material on XML and XSL which is too brief to be a complete introduction for someone. That material is better presented in other books. But the material on XML queries direct to the SQL server is unique and valuable.

Part four on advanced topics has some good chapters. In particular the section on query optimization is well done and serves as a good introduction to the topic. But this part is where the book veers off course and into topics like testing, refactoring, XP, and an introduction to the .NET framework and C#. It's all interesting, but it's covered better in other books and the book overall could be shorter and more focused were it not for these sections.

Another downside is that Illustrations are a little underused. But the downsides aside, this is a great book, specifically for the first two parts including the excellent section on database design.

Was this review helpful to you?  YesNo (Report this)



6 of 12 people found the following review helpful:

Not useful for SQLXML, May 29, 2004
Reviewer:James Goodman (Great Lakes, USA) - See all my reviews
The XML coverage in this book is not useful for anyone interested in doing full blown XML development. XPATH routines and the amount of time spent on transforming and xquery are not sufficient to get beyond a beginner's stage. There are many beginners writing simple tabular represenations of a table in xml, you may be able to pull that off with this material. But any true development with browser based user input and interactive sqlxml programming simply does not exist in this book. I wish my job only required me to know what is in this book!!! I run a large healthcare IT and we are far far beyond this outdated material. In fact this book is behind the w3c standards and will not even work as shown for what little there is here. My 15 world class programmers have told me this is the last book and series they would turn to for anything. There is no reference material for any arguments or things you don't want to have to open yet another browser session for, when my guys are running 10 to 15 screens doing development. Any good book will spend the pages this one does on the "essays" of no value listing the indispensible tables of values any programmer needs at his fingertips.
Very weak on XML and SQL in general.

Was this review helpful to you?  YesNo (Report this)


See all 79 customer reviews...



Listmania!

So You'd Like to...


Look for similar items by subject

Where's My Stuff?
• Track your recent orders.
• View or change your orders in Your Account.
Shipping & Returns
• See our shipping rates & policies.
Return an item (here's our Returns Policy).
Need Help?
• Forgot your password? Click here.
Redeem or buy a gift certificate.
Visit our Help department.
Search   for     

Amazon.com Home   |   Directory of All Stores

Our International Sites: Canada  |  United Kingdom  |  Germany  |  Japan  |  France  |  China

Contact Us   |   Help   |   Shopping Cart   |   Your Account   |   Sell Items   |   1-Click Settings

Investor Relations   |   Press Releases   |   Careers

Conditions of Use | Privacy Notice © 1996-2005, Amazon.com, Inc. or its affiliates