Buy Used
Used - Good See details
$3.99 & eligible for FREE Super Saver Shipping on orders over $25. Details

or
Sign in to turn on 1-Click ordering.
 
   
Have one to sell? Sell yours here
Microsoft  SQL Server(TM) 7.0 Administrator's Pocket Consultant (Administrator Pkt Consultant)
 
 
Tell the Publisher!
I'd like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Microsoft SQL Server(TM) 7.0 Administrator's Pocket Consultant (Administrator Pkt Consultant) [Paperback]

William R. Stanek (Author)
4.5 out of 5 stars  See all reviews (11 customer reviews)


Available from these sellers.


Formats

Amazon Price New from Used from
Paperback --  

Book Description

Administrator Pkt Consultant October 29, 1999
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.

Editorial Reviews

Amazon.com Review

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

  • Paperback: 500 pages
  • Publisher: Microsoft Press (October 29, 1999)
  • Language: English
  • ISBN-10: 0735605963
  • ISBN-13: 978-0735605961
  • Product Dimensions: 7.8 x 5.5 x 0.7 inches
  • Shipping Weight: 15.2 ounces
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (11 customer reviews)
  • Amazon Best Sellers Rank: #3,342,023 in Books (See Top 100 in Books)

More About the Author

William has over 20 years of hands-on experience with advanced programming and development. He is a leading technology expert, an award-winning author, and a pretty-darn-good instructional trainer. Over the years, his practical advice has helped millions of programmers, developers, and network engineers all over the world. He has written more than 100 books. Find William on Facebook at http://www.facebook.com/WilliamStanekAuthor.

William has been involved in the commercial Internet community since 1991. His core business and technology experience comes from over 11 years of military service. He has substantial experience in developing server technology, encryption, and Internet solutions. He has written many technical white papers and training courses on a wide variety of topics. He frequently serves as a subject matter expert and consultant.

William has an MS with distinction in information systems and a BS in computer science, magna cum laude. He is proud to have served in the Persian Gulf War as a combat crewmember on an electronic warfare aircraft. He flew on numerous combat missions into Iraq and was awarded nine medals for his wartime service, including one of the United States of America's highest flying honors, the Air Force Distinguished Flying Cross. Currently, he resides in the Pacific Northwest with his wife and children.

William recently rediscovered his love of the great outdoors. When he's not writing, teaching, or making presentations, he can be found hiking, biking, backpacking, traveling, or trekking in search of adventure.

Follow William on Twitter at http://twitter.com/WilliamStanek. William also writes as Robert Stanek. To learn more about Ruin Mist, Magic Lands, Bugville Critters, visit http://www.bugvillecritters.com/.

William R. Stanek (www.williamstanek.com) lived in Japan from 1985 to 1989. He traveled extensively and made many friends. While living in Japan, he spent much of his free time in Aomori (青森), Hachinohe (八戸), Misawa (三沢), and Tokyo (東京). He misses the wonderful food and drink and the good friends he made. He says, "On break, I traveled all over. On the island of Hokkaidô in Sapporo they have these wonderful Ice Festivals. My favorite thing about spring was the Cherry Blossom Festival. I'd take day trips to Aomori (青森) and Hachinohe (八戸) all the time. While in Japan, I studied kendo, the Japanese language, and Buddhism."

William lived in Europe from 1989 to 1991. During that time, he lived in Germany (mostly) and had several extended stays in the UK and Scotland including deployments to Mildenhall, UK. He spent his time in the UK travelling, and especially enjoyed his visits to Cambridge and London. He's been a football (soccer) fan since he was old enough to kick a ball and especially enjoyed being in Kaiserslautern for the championships. He misses the wonderful food and drink and the good friends he made. He says, "There's nothing like Fridays at the pub or Saturday market."

William lived in Hawaii from 1991 to 1996. During that time, he worked shift-work at Kunia Field Station, attended Hawaii Pacific University and University of Hawaii, and spent a lot of time at the beach. He and his wife's first child was born in Hawaii. William's writing career began in Hawaii when his first book, Electronic Publishing Unleashed, was published in 1995. The runaway success of that book and it's sequel, Web Publishing Unleashed, helped establish him as a leader and innovator in technical writing.

 

Customer Reviews

11 Reviews
5 star:
 (6)
4 star:
 (4)
3 star:
 (1)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
4.5 out of 5 stars (11 customer reviews)
 
 
 
 
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?, April 8, 2000
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!

Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


8 of 8 people found the following review helpful:
5.0 out of 5 stars A Great Field Reference!, August 24, 2000
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.

Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


9 of 10 people found the following review helpful:
4.0 out of 5 stars Good Handy Reference, March 7, 2000
By 
Neeraj Gupta (Ithaca, NY, U.S.A.) - See all my reviews
(REAL NAME)   
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.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No

Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews









Only search this product's reviews



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
Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
existing backup set, related properties dialog box, trace queue, remote server connections, unresolved transactions, database automation, activity snapshot, last complete backup, transactional replication, linked server, replaying traces, multiple backup devices, inactive entries, transaction log backups, merge replication, pull subscriptions, secondary data files, disable publishing, event forwarding, startup account, database permissions, nested triggers, snapshot agent, snapshot replication, server registration
Key Phrases - Capitalized Phrases (CAPs): (learn more)
Enterprise Manager, Server Agent, Query Analyzer, Administration Fundamentals, Service Manager, Microsoft Windows, Choose the Tools, Managing the Enterprise, Server Profiler, Create And Manage Publications, Admin Console, Design Table, Data Transformation Services, Net Send, Server Backup, Server Desktop, All Tasks, Microsoft Search, Server Login Properties, Administration Overview, Configure Publishing, Create Trace Wizard, Access the General, Backup Wizard, Click the Management
New!
Books on Related Topics | Concordance | Text Stats
Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
Search Inside This Book:

Citations (learn more)
This book cites 1 book:
 
2 books cite this book:



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.
Your tags: Add your first tag
 

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 Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 


Active discussions in related forums
Search Customer Discussions
Search all Amazon discussions
   
Related forums


Listmania!


Create a Listmania! list

So You'd Like to...


Create a guide


Look for Similar Items by Category


Look for Similar Items by Subject