SQL Server 7.0 Administrator's Pocket Consultant - Softcover

Wynkoop, Stephen

Softcover

ISBN 10: 0735605963 ISBN 13: 9780735605961

Publisher: Microsoft Press,U.S., 1999

Synopsis

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.

About this title

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).

Edition details

• Publisher: Microsoft Press,U.S.
• Publication date: 1999
• Language: English
• ISBN 10: 0735605963
• ISBN 13: 9780735605961
• Binding: Paperback
• Edition number: 1
• Number of pages: 362