SQL Server 7.0 Administrator's Pocket Consultant (Paperback, illustrated edition)

The practical, portable guide to SQL Server 7.0 for busy IT professionals!

MICROSOFT® SQL SERVER™ 7.0 ADMINISTRATOR’S POCKET CONSULTANT is the hands-on, immediate reference you need as you deal with the details of Microsoft SQL Server administration in small, medium, and large organizations. Ideal at the desk or on the go from server to server, this fast-answers guide focuses on what you need to do in specific situations as you support and manage Microsoft SQL Server 7.0. It provides easy-to-read tables, lists, commands, and step-by-step instructions as it covers topics such as:

• Administration Fundamentals—running SQL Server, advanced configuration, memory management, logging, and auditing
• Server Administration—managing databases, servers and server groups; core database administration, and SQL Server 7.0 security
• Data Administration—database backup and recovery, administering distributed data and remote servers, and data replication
• Performance, Optimization, and Maintenance—profiling and monitoring SQL Server, indexing and optimization, automation, and database maintenance
• Advanced Database Administration—creating tables, querying and modifying data, transactions, locks, stored procedures, cursors, and triggers