http://www.sqlservercentral.com/Articles tagged XML, SQL Server 7, 2000 posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks! http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/2003/04/18http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/The core components to Microsoft XML parser have been updated and released to market. The update contains many bug fixes, new features and enhancements to performance. http://www.sqlservercentral.com/redirect/articles/655/2002/04/05http://www.sqlservercentral.com/redirect/articles/655/Last week Andy started a discussion of the various ways you can reduce the number of round trips to the server. This week he continues by looking at a method he used recently to do client side caching of data to eliminate the round trip altogether. Gotta read it! http://www.sqlservercentral.com/articles/Performance+Tuning/reducingroundtripspart2/588/2002/02/06http://www.sqlservercentral.com/articles/Performance+Tuning/reducingroundtripspart2/588/This article describes how to monitor Microsoft SMTP usage using SQL Server 2000 and XML. http://www.sqlservercentral.com/articles/Basics/smtpxml/541/2001/11/29http://www.sqlservercentral.com/articles/Basics/smtpxml/541/Microsoft® SQL Server 2000 introduced several new features for querying database tables and receiving the results as an XML document. Web release 1 of SQLXML (XML for SQL Server) added Updategrams and XML Bulk Load functionality, as well as a host of other features to the SQL Server 2000 base. http://www.sqlservercentral.com/redirect/articles/485/2001/10/29http://www.sqlservercentral.com/redirect/articles/485/With XML support in SQL Server 2000, you can query SQL over HTTP with a URL, bring the data down to the browser, and manipulate it on the client machine. By adding Internet Explorer 5.0 to the mix and using XSL to convert the XML to HTML, you can lighten the load on your database server. Going still one step further, by using Vector Markup Language you can even create drawings on the fly using the data from your SQL queries. http://www.sqlservercentral.com/redirect/articles/241/2001/06/26http://www.sqlservercentral.com/redirect/articles/241/