Microsoft SQL Server 7.0 DBA Survival Guide [With Contains Checklists, DBA Assistant & the Estimator]

by Orryn Sledge

Book Overview

This guide is organized into sections that comprise the various jobs and tasks the DBA performs. It aims to: provide the knowledge to adminster a SQL Server database; offer real-world insight and... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0672312263
• ISBN13: 9780672312267
• Release Date: January 1999
• Publisher: Sams
• Length: 1080 Pages
• Weight: 4.00 lbs.
• Dimensions: 2.3" x 7.4" x 9.1"

Customer Reviews

A Great Reference With a Focus on How To Do Things

I was thrown into SQL Server work with no training and no mentors. This book was a great help. When you have to make something happen and there is no one around to ask you can generally find what you need here. I was pleased that the writing is clear and easy to follow even when dealing with obscure subjects.I have used this book to solve problems and to research configuration settings when troubleshooting performance issues. At over 1000 pages I am not sure I could have survived reading it as a study guide and it is really not suited for that. But if you want a resource that goes into pretty good depth on subjects, this is an excellent book to consult.

Delivers the goods - the best SQL server book - buy it

A comprehensive guide to all aspects of SQL server which is clearly written in an accessible style. This book has helped me transfer my existing DBA skills in Informix/Ingres to SQL server. I liked the worked examples which help greatly in understanding key features such as backup and restore. One niggle is that the section covering master databse recovery omits the fact that the database must be in single user mode (sqlservr.exe -m). I can also recommend:- Microsoft SQL Server 7.0 Administrator's Pocket Consultant - Microsoft Press The Guru's Guide to Transact SQL - Henderson

I have found this book to be indispensible

I love this book. My background is a little unusual -- I've been running Linux for 7 years, and I know very little about running MS servers. I had worked with MySQL, but never with a fully featured commercial SQL engine. When I started running MS-SQL, the confusing part was the administration, not the actual SQL database operations. And this book told me everything I needed to know. It's easy to look up practical "HOWTO" style advice. If you need to setup security, they tell you how. If you need to backup your db (and who doesn't?) they tell you how. If you need to set up replication (which is cooler and more complicated than you'd think) they tell you how. It's easy to find what you need and make it happen with a minimum of hassles and floundering. The discussion of indexes alone is probably worth buying the book. If you run MS-SQL, you should buy this book.

Very Good Reference Book

I am new to SQL7. I ordered 3 books to help me on the job. This was the most comprehensive of them. I needed help on DTS and SQL Agent, and it was easy to find. This book does not assume a lower level of SQL knowledge, so I could find help on some complex issues. Very good.

Kudos

I swore by the version 6.5 edition of this book and couldn't wait for this new edition. I'm responsible for many SQL servers worldwide and whenever I travel for an emergency, this book is the only text that goes along with me. This book is a godsend.