Start reading Pro SQL Server 2008 XML (Expert's Voice) on your Kindle in under a minute. Don't have a Kindle? Get your Kindle here or start reading now with a free Kindle Reading App.

Deliver to your Kindle or other device


Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Sorry, this item is not available in
Image not available for
Image not available

Pro SQL Server 2008 XML (Expert's Voice) [Kindle Edition]

Michael Coles

Print List Price: £51.45
Kindle Price: £45.59 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £5.86 (11%)
* Unlike print books, digital books are subject to VAT.

Free Kindle Reading App Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.

To get the free app, enter your e-mail address or mobile phone number.


Amazon Price New from Used from
Kindle Edition £45.59  
Hardcover --  
Paperback £51.45  
Kindle Books Summer Sale
Kindle Summer Sale: Books from 99p
Browse over 600 titles from best-selling authors, including Neil Gaiman, John Grisham, Jeffrey Archer, Veronica Roth and Sylvia Day. >Shop now

Book Description

Knowledge and ability to apply XML are de rigueur in today's world, and SQL Server developers and administrators are no exception to that rule. Pro SQL Server 2008 XML is your key to unlocking the powerful XML feature set first introduced in SQL Server 2005 and since refined in SQL Server 2008. Author Michael Coles shows how to store XML using SQL Server's built in XML data type. Learn to query and manipulate XML data using standard technologies such as XQuery and XSLT. No SQL Server database professional can afford to be without knowledge of the XML feature set. Pro SQL Server 2008 XML delivers on the knowledge that you need to remain competitive in your career. Shows how to store, query, and manipulate XML documents in SQL Server Provides step by step examples showing best practices and advanced features Accurately discusses how SQL Server's XML feature set stacks up against the ISO XML standards What you'll learn Store XML documents using SQL Server's built in XML data type Query those stored documents using SQL/XML and XQuery Manipulate and transform XML using XSLT and XPath Understand how SQL Server's XML support compares to the ISO XML standards Create SOAP endpoints for use in web services applications Create primary and secondary XML indexes to improve performance of XML queries Who this book is for SQL Server SQL/T SQL developers and .NET developers who want to take advantage of the specific server side XML functionality available in SQL Server 2008.

Product Description

About the Author

Michael Coles has more than a decade's experience designing and administering SQL Server databases. A prolific writer of articles on all aspects of SQL Server, particularly on the expert use of T-SQL, he holds MCDBA and MCP certifications. He graduated magna cum laude with a bachelor of science degree in information technology from American Intercontinental University in Georgia. A member of the United States Army Reserve, he was activated for two years following 9/11.

Product details

  • Format: Kindle Edition
  • File Size: 5877 KB
  • Print Length: 496 pages
  • Publisher: Apress; 1 edition (18 May 2008)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B001CSP5AO
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • Enhanced Typesetting: Not Enabled
  • Amazon Bestsellers Rank: #801,006 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?

More About the Author

Discover books, learn about writers, and more.

Customer Reviews

There are no customer reviews yet on
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on (beta) 4.4 out of 5 stars  7 reviews
7 of 7 people found the following review helpful
5.0 out of 5 stars Ultimate XML Reference for SQL Server 2008 23 Jun. 2008
By A. Rocco - Published on
The Pro SQL Server 2008 XML book dives right into the details of XML from the first page. This book was written by a developer for developers, and the author goes to great lengths to demonstrate all the concepts presented in the book. In my opinion, this book scores highly in many areas.

The author assumes a basic knowledge of SQL, but he thoroughly explains every step of SQL Server's XML functionality along the way. The book even compares and contrasts the SQL Server implementation of XML to the W3C and ISO standards, pointing out where the SQL Server implementation differs.

However, while the book assumes this basic understanding, any developer interested in getting the most out of SQL Server's XML functions will find the book both informative and enjoyable. The author goes to great lengths to explain XML and why it's relevant in the database. This is absolutely the best reference for SQL Server XML that I've seen.

The author provides what he calls "Cross-Platform Tips" at various points to call attention to limitations of the SQL Server implementation, or areas where it differs from the standards. These types of tips, generously portioned throughout the book, are designed to keep people from wasting hours trying to figure out why the XQuery code sample they copied from the Internet (or some other source) isn't working as advertised on SQL Server. While this book is written for SQL Server 2008, much of the functionality described works with (or is similar to) SQL Server 2005 functionality (as the author points out, some notable exceptions include the added support for Geography Markup Language "GML", and the FLWOR statement "let" clause). As the book explains, the difference between SQL Server 2005 XML functionality and SQL Server 2008 XML functionality is not nearly as large as the leap was from SQL 2000 to 2005. New SQL Server 2008 features aside, this book works equally well as a reference to SQL Server 2005 XML functionality!

Another thing I like about this book is that the author builds on the code samples from one chapter to the next. There is a particularly detailed example of a hierarchical "bill of materials" that the author continually adds newly introduced functionality to over the course of a few chapters. He uses this example to demonstrate how to layer XML functionality to build an intricate application from a very basic premise. I really like the fact that this book provides examples and addresses the problems that most books go out of their way to avoid. Where many books give you a simple top-down hierarchical organization chart that's been done 100 times by 100 different people, this book gives you recursive XML Schemas. Instead of just rehashing the well-advertised SQL Server limitation that Document Type Definitions can't be used to validate your XML this book gives you working examples of code to get around the issue. The book provides many more real world examples, with some pretty intriguing ideas as well (like grabbing an XML RSS feed or searching eBay directly from SQL Server). A nice bonus: Almost all examples are designed to run directly in the AdventureWorks 2008 sample database, and all are freely downloadable from the publisher's website.

And this book doesn't just stop at the server. The author provides analysis of client-side tools including LINQ to XML, SQLXML, HTTP SOAP Endpoints, and a wide supporting cast of XML support tools - many that are provided "out of the box" with SQL Server.

This is the ultimate reference for all things XML on SQL Server 2008.
1 of 1 people found the following review helpful
5.0 out of 5 stars Excellent!. Finally a book that brings so many answers to your questions!! 12 Jun. 2008
By Rosa M. Lopez - Published on
I was amazed to see how well this book explain the concept of Spatial Data and all different techniques of loading and transforming XML from diverse format and systems. It shows so many examples at a very granular level. This book is a "must read" for everyone that has any interest on learning great powerful XML techniques on SQL Server 2008. It is definitely great!

Rosa Lopez
MS Information Systems
1 of 1 people found the following review helpful
5.0 out of 5 stars Book. Pro SQL Server 2008 XML 5 Nov. 2009
By Serguei - Published on
Format:Paperback|Verified Purchase
Arrived in time == fact;
"as new" condition == true;
5 stars == is my take.

I found the book helpful and useful.
Let me rephrase it: I could not find a better coverage of the subject elsewhere.
I wish us to see more on the subject (XPath, XQuery) both:
- the best practices (apart from particular DB engine);
- what are the choices out there: XML native DB including.
2 of 3 people found the following review helpful
3.0 out of 5 stars Kindle experience 25 Oct. 2009
By Magnus Salgo - Published on
Format:Kindle Edition
I have been reading this book on a Kindle and it works but it is not excellent. The structure of the book is good you get explanation of XML and how it works. The problem I feel I would like to have a more "concentrated" book. in this book XML XSD XSLT etc should be explained but the language in the book is as it is in many computer books a little bit to talkative. I would preffer a book that focus on SQL Servers implementation of XML and not in a half stringent way tries to explain XSD et al.

Reading in a Kindle I would like to have more links, better pictures (Kindle support for zooming in picture is not good), a more compact book where .query is explained in just one place.

I recommend the book but there are areas that can be improved.
5.0 out of 5 stars Fantastic Book 4 Feb. 2010
By Denny - Published on
This book is a fantastic resource when learning to work with XML within the SQL Server.
Were these reviews helpful?   Let us know

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category