The guide takes you through today's multitiered system architectures, providing an overview of COM as well as Microsoft Transaction Server (MTS) for transaction management on the middle tier. Several chapters demonstrate common administrative and programming tasks using both wizards and Transact-SQL for building tables, queries, and views.
Further sections show how to implement a physical database in SQL Server 7. (The full coverage of SQL Server 7 configuration settings stands out as excellent material.) Information on SQL Server data types and data validation through constraints and rules follows, along with some superior information on leveraging the power of stored procedures and triggers.
Later the author presents a short case study for a simple three-tiered database application using a Visual Basic 6 module on the middle tier. He briefly touches on Internet-related issues with a quick tour of tools such as Visual InterDev and the SQL Server Web Assistant Wizard. Final chapters offer tips for testing, optimizing, and administering SQL Server 7.
This book is best at introducing what's new and improved in SQL Server 7, with an emphasis on simpler administration and the server's potential to make use of the middle tier in today's enterprise systems. --Richard Dragan