Pro SQL Server 2008 XML

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

• 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

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.

Pro SQL Server 2008 XML is one of a very few books to go deeply into SQL Server's increasingly extensive XML feature-set. XML is a critical technology in today's world, and SQL Server developers and administrators cannot afford ignorance of what XML has to offer in that area. Readers will want Michael Coles' excellent book to keep their skill set current with what SQL Server has to author. Michael delivers in spades, giving a clear explanation not only of XML in SQL Server, but also by touching on the broader picture of how Microsoft's XML feature set relates to international standards.

Michael Coles has over 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 received a bachelor’s of science (magna cum laude) in information technology from American Intercontinental University. A member of the United States Army Reserve, he was activated for two years following 9/11.