Free Ebook Video Training

Thursday, February 5, 2009

Professional SQL Server 2005 XML

book cover

This book is for developers with a desire to learn about this new and exciting technology and how it can be a benefit in their environment. While a previous knowledge of SQLServer 2000, T-SQL, and previous versions of SQLXMLwill come in handy, it is certainly not a perquisite to reading this book. Adecent understanding about XMLand related technologies (such as XQuery) will also be useful when reading this book, but it isn’t necessary.

MS is serious about XMLand it could not be more evident than with the release of SQLServer 2005, supporting a full-blown new xml data type. This new data type can be used as a column or in variables and stored procedures. It also supports technologies such as XQuery and XMLData Manipulation Language, which provides full query and data modification capabilities on the xml data type.

The same focus has been taken to support the new xml data type on the client, and significant changes and enhancements have been made in version 2.0 of the .NET Framework as well as Visual Studio 2005. Why put all the work into the backend when you can’t utilize it from the client? For this reason, this the focus of the book’s energy is on those changes and improvements.

MS also made some significant improvements to SQLXML, and SQLServer 2005 comes with SQLXML4.0. The majority of these changes were made to support the new xml data type, but some improvements were also made in the security and performance areas to give you a better experience when dealing with XML.

TABLE OF CONTENT:
Chapter 01: What’s New in Version 2.0 of the .NET Framework for XML
Chapter 02: What’s New in SQL Server 2005 XML
Chapter 03: Installing SQL Server 2005
Chapter 04: xml data type
Chapter 05: Querying and Modifying XML Data in SQL Server 2005
Chapter 06: Indexing XML Data in SQL Server 2005
Chapter 07: XML Schemas in SQL Server 2005
Chapter 08: Transact-SQL Enhancements to FOR XML and OPENXML
Chapter 09: CLR Support 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
Chapter 17: Web Service (SOAP) Support in SQL Server 2005
Chapter 18: SOAP at the Client
Chapter 19: Web Service Description Language (WSDL)
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

http://rapidshare.com/files/57472252/orpsstwofivex.rar&nbsp

Password:ganelon

No comments:

This site does not store any files on its server.We only index and link to content provided by other sites. In case of any query/objection regarding copyright or piracy, please inform us at youzhny197@gmail.com, we will immediately respond to you.