SQL Server 2000 Administration [With CDROM]

As the authors stated in chapter 1, the book is written with experienced network administrators in mind. They try to explain the theory behind SQL and do so by bringing in-depth and well-founded information followed with tips and tricks from hands on experience. Accordingly this book is not suited for people who are completely new to this topic. The book is divided into 13 chapters, The first chapter, installation, explains the process of installing the SQL server in a fashioned manner.Chapter tow, system architecture of SQL, give in depth knowledge of net-library, command parser, storage engine, lock manager, memory, cache and checkpoints, disk i/o, the default databases objects and system tables.Chapter three, security, includes server logins, database users, server and database roles, database, statement and object permission, security using views and sp. The other 10 chapters are devides into the following capters; Data structure, Distribution and transferring of data, Backup solutions, Restore, Monitoring and optimization, Automating SQL, Replication, Troubleshooting and understanding of TSQL.I have used both Sybex and MS press book for my SQL certs. They provide a lot of lab simulations but they lack the in-depth knowledge needed to pass the exam. There are some conflicting use of the two words SQL Server 7 and SQL 2000. I suppose the bad typo can bring some confusion while reading the book, but it is so obvious and are easy to spot. The typo mistakes forced me to give the book only 4 stars, but I will highly recommend this book to anyone who is dipping into the mcdba track and other SQL interested people out there.This book along with Professional SQL Server 2000 Programmingby rob vieira, will make your life a lot easyer and provide you all the knowlege you can hadle for months to come.