Professional SQL Server 2005 XML

  • Discusses SQL Server 2005 XML from the server and client sides
  • Examines using XSLT to render the XML data that is retrieved from SQL Server, particularly for ASP.NET
  • Addresses SQL Server relationship with schemas, SOAP, XML security, and .NET
  • Makes extensive use of examples to solve problems that programmers face on an everyday basis and features Server 2005 XML best practices

Biography

Scott Klein is a software developer and architect, and his passion for SQL Server, .NET, and all things XML led him to Greenville, South Carolina, where he currently works as a SQL/.NET developer for CSI, a software solutions company. He has written several articles for TopXML (www.TopXLM.com) and is a frequent speaker at SQL Server and .NET user groups around Greenville and the surrounding areas. When he is not sitting in front of a computer or spending time with his family, he can usually be found aboard his Yamaha at the local motocross track.

Table of Contents

Introduction.

Part I: 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.

Part II: 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.

Part III: 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.

Part IV: 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).

Part V: 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.

Index.

Twitter Feed

  • rohan_p RT @Techworld_AU: Gear and gadgets at @CeBITAUS 2012, Sydney http://t.co/J1Sch1sX #cebit2012
    1 day, 1 hour
  • Techworld_AU Gear and gadgets at @CeBITAUS 2012, Sydney http://t.co/J1Sch1sX #cebit2012
    1 day, 2 hours
  • HamishBarwick CeBIT 2012: Will NBN speed up freight delivery times? http://t.co/gaZyjOlH #cw #cio #tw #CeBIT2012 #nbn
    1 day, 21 hours
  • HamishBarwick CeBIT 2012: NAB calls for mobile app security overhaul http://t.co/3Z3ZPUPq #cw #cio #tw #CeBIT2012 #infosec
    2 days
  • rohan_p RT @Techworld_AU: BigPond Games Arena, Games Shop hit by hackers http://t.co/OXNPeDfL #bigpond #infosec #security
    2 days, 3 hours

Whitepapers

- + c

Latest News

- + c
more