SQL Server Performance

  • Home
  • Articles
  • Forums
  • Tips
  • Training
  • FAQ's
  • Blogs
  • Software
  • Books
  • About Us
RSS Feeds
Sign in | Join


USEFUL SITES :

ASP.NET Tutorials
Windows and SQL Azure Tutorials
Cloud Hosting Magazine
SharePoint Tutorials
Windows Server Help

Write for Us

Share your SQL Server knowledge with others and raise your profile in the community More...
Latest Articles

A High Level Comparison Between Oracle and SQL Server - Part ...
A High Level Comparison Between Oracle and SQL Server - Part ...
A High Level Comparison Between Oracle and SQL Server - Part ...
A High Level Comparison Between Oracle and SQL Server

More     
 
Latest FAQ's

Add Node to A SQL Server failover Cluster failed with invalid ...
SQL Server Destination remote server error
Setting Up Data And Log Files For SQL Server
Will Check Constraints Improve Database Performance?

More     
   
Latest Software Reviews

dbForge Review
Spotlight on ApexSQL Diff - Server-based database comparison tool ...
Spotlight on ApexSQL Data Diff - Server-based database comparison tool ...
Spotlight on ApexSQL Doc 2008

More     

books >> sql server 2000 books >> SQL Server 2000 XML Distilled

SQL Server 2000 XML Distilled


Apr 15, 2003

Book Review

SQL Server 2000 XML Distilled
by Kevin Williams, Daryl Barnes, Bryant Likes, and others
Copyright 2002
Curlingstone Publishing

 

SQL Server 2000 XML Distilled Find out more about this book,
or purchase it, from Amazon.com

XML, whether we like it or not, is a topic that DBAs and SQL developers must soon learn to master. While SQL Server 2000 has built-in XML-related functionality, it will be the next version of SQL Server that will really bring XML to the forefront for those involved in SQL Server.

But many companies are not waiting until the next version of SQL Server before they make the move to XML, many are doing so today. And to help fulfill the black hole of SQL Server XML knowledge is a new book called SQL Server 2000 XML Distilled. This is not a book for those new to SQL Server or XML, but a book designed for those DBAs and SQL developers who are already familiar with the SQL Server and XML and who want to learn how to make them work together. In other words, this is not a beginner's book, but a book designed for those who want to get their hands dirty writing SQL Server-based XML applications, including SQL Server web services.

Here's what the book covers:

  • SQL Server, XML, and the DBA

  • Architecture and Setup

  • Mapping SQL Server to XML

  • FOR XML

  • URL Queries and Template Queries

  • Annotating XML Schemas

  • XML Views

  • XPath Queries

  • Mapping XML to SQL Server

  • OPENXML

  • Updategrams

  • SQLXML Bulk Load

  • Programmatic Access with SQLXML

  • Web Services in SQL Server 2000

  • Case Study: Detecting Web Site Clients

  • Case Study: BizTalk Integration

  • The Future -- Emergent Technologies

One of the best things about this book is that it has been written by people who have actually used SQL Server and XML. It includes useful and practical information, not just a lot of dry talk about XML standards and how wonderful they are. In essence, the book tells you how to use SQL Server XML in the real world, getting down to the details of how to make it work.

While there is no entire chapter devoted to XML and SQL Server performance, there are sections of the book that discuss this often overlooked topic. Just as you develop applications with Transact-SQL, and must consider performance at the very beginning to ensure top performance, the same is true when developing XML-based applications.

If you want to learn how to take advantage of SQL Server 2000's XML capabilities, I highly recommend this book. If you are brand new to XML, you may want to read a basic primer on XML before reading this book, as this book assumes you already know the basics.


        








C# Help and Tutorials | PHP MySQL Tutorial | Sharepoint Tutorial | Azure Tutorial | Cloud Hosting Magazine | ASP.NET Tutorials | Windows Server Help | Windows Phone Pro | Silverlight Ace | Visual Studio Tutorials | Home | Peformance Articles | Audit Articles | Business Intelligence Articles | Clustering Articles | Developer Articles | Reporting Services Articles | DBA Articles | ASP.NET / ADO.NET Articles | SQL Server Training Videos | DBA FAQ's | Developer Peformance FAQ's | DBA Peformance FAQ's | Developer FAQ's | Clustering FAQ's | Error Messages | Audit Tool Reviews | Backup Tool Reviews | Coding Tool Reviews | Compare Tool Reviews | Documentation Tool Reviews | Design Tool Reviews | Monitoring Tool Reviews | Log Tool Reviews | Reporting Tool Reviews | Clustering Tool Reviews | Security Tool Reviews | Change Management Tool Reviews | Remote Access Tool Reviews | Book Reviews | Security Tool Reviews | ADO.NET / ASP.NET | Administration | Analysis/OLAP Services | Application Development | Configuration | Components | ETL | Hardware | High Availability | Hints | Index | Misc | Operating Systems | Performance Tuning | Replication | T-SQL | Views


              © 2010 Jude O'Kelly. All rights reserved