| ||||||||||||
There are lots of procedures to follow in these pages, but the most valuable stuff here may prove to be the tables that list options and commands. A typical table in the section on user permissions lists the effects of the eight permissions (CREATE TABLE, CREATE VIEW, and so on) that an administrator can bestow upon a user. You'll also find the command-line examples handy--you can quickly locate a command line that imports data with bcp and use it on your machine. Concise, utilitarian Transact-SQL listings serve a similar purpose. --David Wall
Topics covered: The specifications and procedures an administrator needs on hand to effectively operate SQL Server 7. The operation of SQL Server itself (including configuration of groups and security options) and the maintenance of data (which includes backups, restorations, and replication).
William R. Stanek has over 20 years of hands-on experience with advanced programming and development. He has written nearly 100 books including: Microsoft Windows Vista Administrator's Pocket Consultant, Windows Server 2008 Inside Out, Microsoft Exchange Server 2007 Administrator's Pocket Consultant 2nd Edition, and Microsoft IIS 7.0 Administrator's Pocket Consultant (all from Microsoft Press). He also wrote MCSE Core Exams in a Nutshell and Windows Vista: The Definitive Guide for O'Reilly.
Product Details
Would you like to update product info or give feedback on images?
|
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
10 of 10 people found the following review helpful:
5.0 out of 5 stars
Undecided?,
This review is from: Microsoft SQL Server(TM) 7.0 Administrator's Pocket Consultant (Administrator Pkt Consultant) (Paperback)
First time I saw this book I wasn't sure. I thumbed through it and it looked really good. I went home logged on and searched for Sql books. I bought another book based on reviews. Few weeks ago after getting nowhere with the other book. I bought this book. The rest as they say is history. I am now a firm believer (I've even bought two other books in this series)! If you want to learn Sql server this is the best book. I use it just about every day and it has come to the rescue more than once.Buy this book you won't be disappointed!
8 of 8 people found the following review helpful:
5.0 out of 5 stars
A Great Field Reference!,
By
This review is from: Microsoft SQL Server(TM) 7.0 Administrator's Pocket Consultant (Administrator Pkt Consultant) (Paperback)
First, this is not a "teach yourself book" it is a reference, geared toward field engineers. With that said, this is a fabulous carry everywhere reference (small; roughly 8"x5"x1" in size) that has just about everything you need to know (from a DBA perspective, that is) for maintaining/installing/etc. SQL Server 7.0. The book is broken into four sections: I. Administration Fundamentals - Configuring and Tuning II. Administration - Managing Enterprise, Core DBA, Security III.Data Administration - Backup/Recovery, Import/Export, Distributed Data/Remote Servers, Replication IV. Performance, Optimization, and Maintenance - Monitoring/Profiling, Creating Tables/Indexes, DB Automation/Maintenance Having worked with SQL Server for several years now, I have always dreamed of having a book that summarized (with examples) all aspects of installation and maintenance (and wasn't a 4" thick luggable). Stanek has done it. The contents are well laid out with a very thorough index. Examples are well laid out (step-by-step) to get you through what-ever issue you are working with. The book contains stored procedure calls, but is not a Transact-SQL manual (actually it would be nice if the author would come out with a T-SQL Admin Pocket Guide also!). I consider this a must-have for every SQL Server DBA's library. It will not gather dust, but instead become VERY dog-eared.
9 of 10 people found the following review helpful:
4.0 out of 5 stars
Good Handy Reference,
By
This review is from: Microsoft SQL Server(TM) 7.0 Administrator's Pocket Consultant (Administrator Pkt Consultant) (Paperback)
I would say that this is a good addition to a DBA's library. It is small and light yet includes a lot of information. You can read it from cover to cover to get an overview or use it as a reference. It gives an overview and then the syntax and steps for doing each of the major DBA activities. I was able to find some information that I have not found anywhere else, viz., the role of log files for the tempdb database. I would recommend this book.
Share your thoughts with other customers: Create your own review
|
|
|
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items. |
|
This product's forum
Active discussions in related forums
Search Customer Discussions
|
Related forums
|