| 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.
A reference and tutorial offering readers everything needed to take advantage of SQL Server 2000 technology, from programming to WMI-classes. The CD-ROM contains all of the examples from the text in VBScript and Perl. System requirements not listed. Softcover.
The first topic is Extensible Markup Language (XML) support in the database server. Database records are typically returned in flat, relational row sets. Today, however, it is possible to also return object-oriented, hierarchical XML document fragments from SQL Server. This technology is incorporated by both the Internet Information Services (IIS) and Microsoft Data Access Components (MDACs). Additionally, SQL Server's Transact SQL makes it possible to insert, update, and delete database records using XML document fragments. My goal with this book is to help you bring this technology into your professional development environment.
The second topic is SQL Server administration (using Windows Management Instrumentation [WMI]). WMI is the management infrastructure of choice for all Windows platforms. WMI provides a consistent interface for both local and remote administration tasks, making it extremely easy to use. As an SQL Server administrator, I think that you will find WMI intuitive to work with both locally and in distributed systems. Moreover, the WMI skills that you learn can be used to leverage systems management where WMI is supported.
A Windows developer who wants to learn the XML and WMI features of SQL Server should read this book. I do not assume that you understand XML or WMI; rather, I will tell you that a basic knowledge of SQL Server and relational databases is helpful. Furthermore, the WMI class reference will in places require a bit more than just a basic knowledge of SQL Server before it can be fully utilized. It is fortunately merciful on details. |