SQL Server 2000's new XML features, Windows Management Instrumentation (WMI) and scripting capabilities make it easier than ever for Web developers to create and manage flexible, scaleable database applications optimised for the Internet, especially e-commerce applications. This quick-start guide is for Web developers and database programmers who need to get up to speed on these new features. It begins with a no-frills tutorial on SQL programming basics and all the new SQL features. Then, step-by-step, it shows readers how to use those features to build database applications and to optimise database performance.

In this Professional Developer Guide, readers learn how to install the SQL Server and the WMI SQL Server Administration Provider; configure the IIS and SQL Server to work together. Detailed information helps the programmer to stream XML from SQL Server over HTTP; retrieve XML data using the right syntax; create XML schemas and use them to locate SQL Server data. In clear, accessible language the reader learns to build and update relational database tables with XML; script WMI using the object-model of WMI scripting API, use the WMI Query Language and manage SQL Server through WMI. This is a good book and I would highly recommend it to Web Developers.