MCSE. Administering Microsoft SQL Server 7

This is a great guide to passing Microsoft's System Administration for Microsoft SQL Server 7 exam - and every bit as valuable once you've passed the exam and you're running an SQL Server system. Written by a top SQL Server expert, the book starts with an overview of SQL Server 7 and SQL fundamentals, then shows how to build database objects - including tables, views, database roles, stored procedures, indexes, and more. It reviews key SQL Server components, including the Distributed Transaction Coordinator, SQL Server Agent, SQL Mail, Replication Monitor, Data Transformation Packages and more. From start to finish, it delivers comprehensive guidance on planning, installing, configuring and optimizing SQL Server 7. The book includes test questions at the end of each chapter, sample texts in the appendix, access to an interactive training Web site - even a free CBT Systems course on the CD-ROM, worth $225!