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.
The trouble with database management systems (DBMSs) is that there are so many of them. If you work as a roving consultant, you have to understand how several distinct DBMSs work. Even if you work for a typical large organization with autonomous units, you'll have to understand how various servers do their jobs. Microsoft SQL Server 7.0 Administrator'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 a particular administrative task in Microsoft SQL Server 7. The book explains the key facts and procedures for setting up and modifying databases, configuring users and groups, setting up replication schemes, importing data, and doing 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'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).About the Author:
William R. Stanek is an award-winning author who's written more than 100 books, including Windows Server 2012 Inside Out, Windows 8 Administration Pocket Consultant, and Microsoft SQL Server 2012 Pocket Consultant. He is the series editor for the Pocket Consultant line of books.
Descrizione libro Microsoft Press. PAPERBACK. Condizione libro: New. 0735605963 Ask about discounted shipping available when multiple items are purchased at the same time. FAST, RELIABLE, GUARANTEED and happily SHIPPED WITHIN 1 BUSINESS DAY!. Codice libro della libreria BX17-0683
Descrizione libro Microsoft Press 1999-10-29, 1999. PAPERBACK. Condizione libro: New. 0735605963 BRAND NEW. Over 1,000,000 satisfied customers since 1997! We ship daily M-F. Choose expedited shipping (if available) for much faster delivery. Delivery confirmation on all US orders. Codice libro della libreria Z0735605963ZN
Descrizione libro Microsoft Press, 1999. Paperback. Condizione libro: New. Codice libro della libreria DADAX0735605963
Descrizione libro Condizione libro: Brand New. Book Condition: Brand New. Codice libro della libreria 97807356059611.0
Descrizione libro Microsoft Press, 1999. Paperback. Condizione libro: New. book. Codice libro della libreria 0735605963