- Paperback: 362 pages
- Publisher: Microsoft Press,U.S.; illustrated edition edition (1 Oct 1999)
- Language English
- ISBN-10: 0735605963
- ISBN-13: 978-0735605961
- Product Dimensions: 19.8 x 14 x 1.8 cm
- Amazon Bestsellers Rank: 1,767,522 in Books (See Top 100 in Books)
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Plus, get an extra £5 Gift Certificate when you trade in books worth £10 or more before June 30, 2012. Visit the Books Trade-In Store for more details. |
Product details |
More About the Author
Product Description
Amazon.co.uk Review
The trouble with database management systems (DBMSs) is that there are so many of them. If you work as a roving consultant, you are certain to have to understand how several DBMSs work. Even if you are an employee of a typical large organisation with autonomous units, you'll have to understand how various servers do their jobs. Microsoft SQL Server 7.0 Adminstrator's Pocket Consultant exists to help you on those days when, coming from an Oracle or Sybase job, you have to remember how to do some administrative task in Microsoft SQL Server 7.0. It explains the key facts and procedures needed to set up and modify databases, configure users and groups, set up replication schemes, import data, and do the rest of a SQL Server administrator's job.
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 will 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, amazon.com
Topics covered: The specifications and procedures an administrator needs to have on hand in order to effectively operate an installation of Microsoft SQL Server 7.0. Areas that receive attention include the operation of SQL Server itself (including configuration of groups and security options) and the maintenance of data (which includes backups, restorations, and replication).
Product Description
Ideal at the desk or as a portable reference for the office, this book provides database administrators with hands-on reference needed to solve problems with a concise, direct approach, and delivers quick reference support for infrequently used steps and hands-on tasks.
Inside This Book
(Learn More)
First Sentence
Microsoft SQL Server 7.0 is the most powerful version of SQL Server ever created. Read the first page
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Microsoft SQL Server 7.0 is the most powerful version of SQL Server ever created. Read the first page
Explore More
Concordance
Browse Sample PagesConcordance
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
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 organise and find favourite items. |
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Reviews
There are no customer reviews yet on Amazon.co.uk.
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
11 reviews
10 of 10 people found the following review helpful
Undecided?
9 April 2000
Format: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
A Great Field Reference!
24 Aug 2000
Format: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
Good Handy Reference
8 Mar 2000
Format: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.
Were these reviews helpful?
Let us know
Listmania!
Look for similar items by category
- Books > Computing & Internet > Databases > Applications > SQL > Microsoft SQL Server
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Networking & Security > Network Topics > LANs
- Books > Computing & Internet > Networking & Security > Network Topics > Microsoft Windows
- Books > Computing & Internet > Web Development > Web-server Software > Microsoft
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
