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