Scripting XML and WMI for Microsoft SQL Server 2000: Professional Developer's Guide

By Tobias Martinsson and Martinsson

A quick-start guide to mastering all of SQL Server 2000's hot new Web development and database programming features 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, scalable database applications optimized 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 powerful 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 cool database applications and to optimize database performance.

• Format: Paperback
• Language: English
• ISBN: 0471399515
• ISBN13: 9780471399513
• Release Date: January 2001
• Publisher: Wiley
• Length: 432 Pages
• Weight: 1.69 lbs.
• Dimensions: 9.2" x 1.0" x 7.5"

Customer Reviews

Get it for the WMI coverage

I read Mr. Martinsson's other book, ActivePerl, and I really enjoy his writing style. I guess some people get it, and some don't. This book is especially strong if you are interested in WMI. While it touches on XML, it may be misleading to put XML first in the title. Nonetheless, it is an excellent treatment of scripting for SQL Server 2000 ...

Good Book

Wanted to learn programming SQL Server 2000 with WMI. I'm a programmer, so the book's approach fits me. WMI text and samples worked for me. I learned WMI. I'm happy.XML is not what I bought it for. I know MSXML, XSLT, XPath, yada yada yada. But I found some stuff I can use with ADO and MSXML. It's a bonus.Another bonus: the code samples are available in Perl. Found them on the CD-ROM next to the VBScript samples. A pleasant surprise because the booktext shows example-code in VBScript.

Welcome and very highly recommended

Scripting XML And WMI For Microsoft SQL Server 2000 is a quick-start guide to programming with SQL 2000's powerful programming features. Readers will learn how to install the SQL Server and the WMI SQL Server Administration Provider; configure the IIS and SQL Server to work together; stream XML from SQL Server over HTTP; retrieve XML data using the right syntax; crate XML schemas and use them to locate SQL Server data; build and update relational database tables with XML; script WMI using the object-model of WMI scripting API; use the WMI Query Language; Manage SQL Server through WMI, and more. The accompanying CD-ROM contains all the examples and scripts from the book in both VBScript and Perl. Scripting XML And WMI For Microsoft SQL Server 2000 is a welcome and very highly recommended addition to the SQL Server reference shelf.

Helpful, but not a primer.

This is one most interestingly targeted books you'll find on SQL Server 2000 yet. It is a straight-forward approach to two topics -- XML and WMI -- that have yet to get much helpful documentation. I've found this book good overall, but like the Author's other book "ActivePerl with ASP and ADO," the depth of some of the materal is "no-frills." I think this book makes a great complement to some other XML and SQL Server titles because it ties these topics together in one neat, easy and quick to read package. If you need depth, consider combining this with other related titles.