Professional SQL Server 2005 XML focuses on using the new and advanced SQL Server 2005 XML features to get the most out of SQL Server 2005 and XML. The book makes extensive use of examples to solve solutions that programmers face on an everyday basis. After a brief introduction to the new SQL Server 2005 XML features, to get all readers onto an equal prerequisite footing, the book dives into the following main topics:

• A brief discussion on how Schemas apply to SQL Server XML
• Deep discussion on SQL Server 2005 XML (both from the server and client side)
• using XSLT to render the XML Data that is retrieved from SQL Server, particularly for ASP.NET
• SQL Server and Soap (this is important because a lot of the web services technology (soap, etc) is now built into SQL Server 2005
• SQL Server and XML Security
• SQL Server and .Net
• SQL Server 2005 XML best practices
• Putting our new found knowledge to work with a case study

• Introduction to SQL Server 2005 XML
  • Chapter 1: What's New in Version 2.0 of the .NET Framework for XML
  • Chapter 2: What's New in SQL Server 2005 XML
  • Chapter 3: Installing SQL Server 2005
• Server-Side XML Processing in SQL Server 2005
  • Chapter 4: xml data type
  • Chapter 5: Querying and Modifying XML Data in SQL Server 2005
  • Chapter 6: Indexing XML Data in SQL Server 2005
  • Chapter 7: XML Schemas in SQL Server 2005
  • Chapter 8: Transact-SQL Enhancements to FOR XML and OPENXML
  • Chapter 9: CLR Support in SQL Server 2005
• Client-Side XML Processing in SQL Server 2005
  • Chapter 10: Client-Side Support for the xml data type
  • Chapter 11: Client-Side XML Processing with SQLXML 4.0
  • Chapter 12: Creating and Querying XML Views
  • Chapter 13: Updating the XML View Using Updategrams
  • Chapter 14: Bulk Loading XML Data Through the XML View
  • Chapter 15: SQLXML Data Access Methods
  • Chapter 16: Using XSLT in SQL Server 2005
• SQL Server 2005, SqlXml, and SOAP
  • Chapter 17: Web Service (SOAP) Support in SQL Server 2005
  • Chapter 18: SOAP at the Client
  • Chapter 19: Web Service Description Language (WSDL)
• SQL Server 2005 and Visual Studio 2005
  • Chapter 20: SQL Server 2005 SQLXML Managed Classes
  • Chapter 21: Working with Assemblies
  • Chapter 22: Creating .NET Routines
  • Chapter 23: ADO.NET
  • Chapter 24: ADO.NET 2.0 Guidelines and Best Practices
  • Chapter 25: Case Study - Putting It All Together
  • Appendix A: XQuery in SQL Server 2005