Join Amazon Prime and ship Two-Day for free and Overnight for $3.99. Already a member? Sign in.

 

or
Sign in to turn on 1-Click ordering.
 
 
More Buying Choices
59 used & new from $10.07
Have one to sell? Sell yours here
 
   
Microsoft SQL Server(TM) 2005 Administrator's Pocket Consultant (Pro-Administrator's Pocket Consultant)
 
 
Share your own customer images
Search inside this book
Tell the Publisher!
I’d like to read this book on Kindle

Don’t have a Kindle? Get yours here.
 
  

Microsoft SQL Server(TM) 2005 Administrator's Pocket Consultant (Pro-Administrator's Pocket Consultant) (Paperback)

by William R. Stanek (Author) "Microsoft SQL Server 2005 completely redefines the SQL Server database platform and provides the bedrock foundation on which small, medium, and large organizations can build..." (more)
Key Phrases: Server Management Studio, Object Explorer, None None (more...)
4.5 out of 5 stars See all reviews (19 customer reviews)
List Price: $29.99
Price: $19.79 & eligible for FREE Super Saver Shipping on orders over $25. Details
You Save: $10.20 (34%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Upgrade this book for $5.99 more, and you can read, search, and annotate every page online. See details
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.

Want it delivered Friday, July 17? Choose One-Day Shipping at checkout. Details
33 new from $11.99 26 used from $10.07
Microsoft Press
More from Microsoft Press
Make the most of your investment in Microsoft technology with books from the Microsoft Press Learning Center.

Special Offers and Product Promotions

Frequently Bought Together

Microsoft SQL Server(TM) 2005 Administrator's Pocket Consultant (Pro-Administrator's Pocket Consultant) + Microsoft® SQL Server(TM) 2005 Administrator's Companion (Pro - Administrator's Companion) + Microsoft SQL Server 2005 Unleashed
Price For All Three: $98.07

Show availability and shipping details

Customers Who Bought This Item Also Bought

MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification)

MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification)

by Solid Quality Learning
3.9 out of 5 stars (45)  $37.79
Microsoft SQL Server 2005 Unleashed

Microsoft SQL Server 2005 Unleashed

by Ray Rankins
4.4 out of 5 stars (20)  $40.49
Beginning SQL Server 2005 Administration

Beginning SQL Server 2005 Administration

by Dan Wood
4.4 out of 5 stars (7)  $26.39
Microsoft® IIS 6.0 Administrator's Pocket Consultant (IT-Administrator's Pocket Consultant)

Microsoft® IIS 6.0 Administrator's Pocket Consultant (IT-Administrator's Pocket Consultant)

by William R. Stanek
4.9 out of 5 stars (16)  $19.79
Microsoft® Windows Server(TM) 2003 Administrator's Pocket Consultant, Second Edition

Microsoft® Windows Server(TM) 2003 Administrator's Pocket Consultant, Second Edition

by William R. Stanek
4.6 out of 5 stars (44)  $19.79
› Explore similar items

Editorial Reviews

Product Description
Here’s the utterly practical, pocket-sized reference for IT professionals who need to administer, optimize, and maintain Microsoft SQL Server 2005 in their organization. This unique guide provides essential details for using Microsoft SQL Server 2005 to help protect and manage your company’s data—whether automating tasks; creating indexes and views; performing backups and recovery; replicating transactions; tuning performance; managing server activity; importing and exporting data; or performing other key tasks. Featuring quick-reference tables, lists, and step-by-step instructions, this handy, one-stop guide provides fast, accurate answers on the spot—whether you’re at your desk or in the field!

From the Publisher
The popular ADMINISTRATOR’S POCKET CONSULTANT series from Microsoft Press delivers fast, accurate answers on the spot for IT professionals.

Key Book Benefits:

• Provides fast facts and immediate reference for administering SQL Server 2005

• Delivers must-know details for taking advantage of the improved scalability, security features, and management tools in SQL Server 2005

• Features concise tables, easy-to-scan lists, and step-by-step instructions for fast answers, wherever you need them

See all Editorial Reviews

Product Details

  • Paperback: 544 pages
  • Publisher: Microsoft Press (November 30, 2005)
  • Language: English
  • ISBN-10: 0735621071
  • ISBN-13: 978-0735621077
  • Product Dimensions: 8 x 5.4 x 1.4 inches
  • Shipping Weight: 1.6 pounds (View shipping rates and policies)
  • Average Customer Review: 4.5 out of 5 stars See all reviews (19 customer reviews)
  • Amazon.com Sales Rank: #238,934 in Books (See Bestsellers in Books)

    •  Would you like to update product info or give feedback on images?
Front Cover | Table of Contents | First Pages | Index | Surprise Me!
Search Inside This Book:
Inside This Book (learn more)
First Sentence:
Microsoft SQL Server 2005 completely redefines the SQL Server database platform and provides the bedrock foundation on which small, medium, and large organizations can build their next generation IT infrastructure. Read the first page
Key Phrases - Capitalized Phrases (CAPs): (learn more)
Server Management Studio, Object Explorer, None None, Server Properties, Server Configuration Manager, Performance Monitor, Cancel Figure, Server Import And Export Wizard, Reporting Services, Native Client, Replication Monitor, Shared Memory, Snapshot Agent, Distributed Transaction Coordinator, Notification Services, New Query, Distribution Agent, All Programs, Active Directory, Add Table, Under the Databases, Windows Server, Delete Object, Analysis Server, Program Files
New!
Books on Related Topics | Concordance | Text Stats
Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Surprise Me!
Search Inside This Book:

Books on Related Topics (learn more)
 
 

What Do Customers Ultimately Buy After Viewing This Item?

Microsoft SQL Server(TM) 2005 Administrator's Pocket Consultant (Pro-Administrator's Pocket Consultant)
76% buy the item featured on this page:
Microsoft SQL Server(TM) 2005 Administrator's Pocket Consultant (Pro-Administrator's Pocket Consultant) 4.5 out of 5 stars (19)
$19.79
Microsoft® SQL Server(TM) 2005 Administrator's Companion (Pro - Administrator's Companion)
11% buy
Microsoft® SQL Server(TM) 2005 Administrator's Companion (Pro - Administrator's Companion) 4.7 out of 5 stars (7)
$37.79
Microsoft SQL Server 2005 Unleashed
6% buy
Microsoft SQL Server 2005 Unleashed 4.4 out of 5 stars (20)
$40.49
MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification)
5% buy
MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification) 3.9 out of 5 stars (45)
$37.79
Explore similar items

Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
Check the boxes next to the tags you consider relevant or enter your own tags in the field below.
(6)
(3)
(2)
(1)
See all 5 tags...

Your tags: Add your first tag
 
See most popular tags
Help others find this product — tag it for Amazon search
No one has tagged this product for Amazon search yet. Why not be the first to suggest a search for which it should appear?

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

19 Reviews
5 star:
 (15)
4 star:
 (1)
3 star:
 (1)
2 star:
 (1)
1 star:
 (1)
 
 
 
 
 
Average Customer Review
4.5 out of 5 stars (19 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
24 of 24 people found the following review helpful:
5.0 out of 5 stars THE ONE SQL SERVER BOOK EVERYONE SHOULD HAVE, May 22, 2006
By Dale Wagner (Albuquerque, NM USA) - See all my reviews
(REAL NAME)   
I picked up Stanek's SQL Server 2005 Administrator's Pocket Consultant and Windows Server 2003 Inside Out at the same time, and have found them both to be excellent. If there's one SQL Server book every developer, programmer and administrator should have, it's this one--I haven't found a better one and I've read half a dozen so far. Stanek has a gift for getting to the point, explaining the most complex concepts in ways that are easy to understand. He seems to pack a 1,000 pages of info into 550 pages. SQL Server 2005 Administrator's Pocket Consultant has a strong focus on security, configuration, optimization, and troubleshooting. Throughout the book, there's excellent coverage of T-SQL and I prefer the way T-SQL is covered in context in this book to the way it's covered in the separate T-SQL book I bought (and no longer use). Beyond core database administration, which this book covers better than any other book, it also covers full-text search, indexes, integration services (creating packages), linked servers, distributed transactions, replication, publications, etc. The maintenance chapters are some of the strongest with complete coverage of profiling, monitoring, optimizing, backup, recovery, log shipping, database mirroring, automation, etc. Thank you Mr. Stanek for an excellent book.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
22 of 23 people found the following review helpful:
5.0 out of 5 stars Microsoft SQL Server 2005 Administrator's Pocket Consultant , January 31, 2006
With a new set of tools, Administering SQL 2005 is quite different to previous versions this book provides a very useful overview of the new graphical administration programs, as well as detailing many of the commonly used administration stored procedures.

The book is very readable and I especially like the side notes, which come in Note, Tip, Caution, Real World and Best Practice forms. These give very useful practical information, which will help you avoid some the common problems that get posted to online newsgroups.

The book covers all aspects of administering SQL Server 2005 and will provide a handy reference to anyone whose function it is to maintain a SQL 2005 system.


Martin Bell (SQL Server MVP)
1/28/2006
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
17 of 17 people found the following review helpful:
5.0 out of 5 stars Terrific resource!, November 3, 2006
Picked this up a few months back and have practically read it cover to cover already during our SQL upgrade/transition. In large part thanks to this book, I didn't run into any problems planning for or implementing our deployment. Chapters 2 on deploying SQL was a great help, as was the first chapter overview. Chapters 3 and 4 provide comprehensive details on configuration and tuning.

Excellent coverage of views and available stored procedures. Excellent coverage of database mirroring with full details on deploying, planning, and implementing. Also excellent coverage of log shipping and using log shipping with database mirroring.

With our servers up and running I spent a lot of time lately in chapter 8 to 10. Chapter 8 is on logins, users, roles, and permissions. Chapter 9 is on schemas, tables, view, and indexes. Chapter 10 is on importing, exporting, and transforming data. It's all covered clearly and concisely.

Next I'm working my way to profiling and monitoring for optimization and then to getting our backup plans final. This is all covered in chapters 13 to 15 and what I've read so far has been extremely helpful. This is a terrific resource.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


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

5.0 out of 5 stars Hardly a pocket book
It clearly defies the title but does provide with very useful information. I am quite impressed. I have read this book as a pro. And is recommended only for pros. Read more
Published 18 months ago by Kumar Kaji

5.0 out of 5 stars A must have!
This handy pocket consultant is a must have for administrators and developers. It delivers exactly what is promised: a handy guide for daily administration. Read more
Published 23 months ago by Wayne A. Gorman

5.0 out of 5 stars Excellent resource for DBAs
SQL Server 2005 Administrator's Pocket Consultant is an excellent reference for DBAs and System Administrators planning to implement and maintain SQL Server 2005. Read more
Published on July 11, 2007 by S. Keisser

5.0 out of 5 stars EXCELLENT BOOK FOR ADMINISTRATORS AND DEVELOPERS
Sometimes when I read reviews people have written I wonder if they've actually read the book or simply thumbed through it in a bookstore or did a search of the pages. Read more
Published on January 9, 2007 by N. Burke

4.0 out of 5 stars Basic things for beginners
This book is clearly targeted for the beginners and it is a good reference for them. Also, if you are an experienced SQL 2000 DBA/developer and want to get basic but neccessary... Read more
Published on January 5, 2007 by Jaewoo Kim

5.0 out of 5 stars GREAT MANUAL!
After reading this book, I felt like I had to stand up or at least applaud. It was really a masterpiece: extremely concise yet pretty comprehensive, easy to understand, and... Read more
Published on December 26, 2006 by S. James Phillips

5.0 out of 5 stars An Excellent Reference Tool
This is the book that should have been in the box. is absolutely right! I bought this book before we upgraded from SQL 2000 to SQL 2005. Read more
Published on November 16, 2006 by J. L. Katzenbach

5.0 out of 5 stars Another Stanek Winner
I only recently got involved with SQL Server, when work required that I shift gears after our department downsized. Read more
Published on November 14, 2006 by Shannon Drake

5.0 out of 5 stars Packed with details
Pound for pound, this book packs in more details than any other I've found. No book on a subject can cover everything you need to know, but this one comes close for... Read more
Published on November 14, 2006 by L. Hayes

2.0 out of 5 stars Some things missing
What happened to encryption? That is a great new feature in SQL 2005..hard to believe its not mentioned in the guide.
Published on November 14, 2006 by L. Koewing

Only search this product's reviews


Customer Discussions

 Beta (What's this?)
New! See all customer communities, and bookmark your communities to keep track of them.
This product's forum (0 discussions)
  Discussion Replies Latest Post
  No discussions yet

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


Active discussions in related forums
   

Product Information from the Amapedia Community

Beta (What's this?)

Look for Similar Items by Category

Up to 50% Off Chocolates

Leonidas Chocolates Sale
Save up to 50% on gourmet chocolates from Ghirardelli, Godiva, Leonidas Belgian Chocolates, and more from Amazon Gourmet.
 

Best Books of 2008

Best of 2008
Find our top 100 editors' picks as well as customers' favorites in dozens of categories in our Best Books of 2008 Store.
  

Dive into Summer Reading

Summer Reading for Kids and Teens
Don't even think about hitting the beach without browsing the books in our Summer Reading Store. Discover bestsellers, paperback picks, beach reads, and more terrific titles all summer long.
 

Bestsellers in Home Improvement

Updated hourly

Winchester 2201788
1.Winchester 22-01788 2.5-Inch Blade Pakka Wood Double Bolster Fine Edge Lock-Back Knife Gerber
$20.76
2.PUR CRF-950Z 2-Stage Water Pitcher Replacement Filter, 3-Pack PUR
$29.99 $19.99

›See more bestsellers

  

 

Feedback

If you need help or have a question for Customer Service, contact us.
 Would you like to update product info or give feedback on images?
Is there any other feedback you would like to provide?

Your comments can help make our site better for everyone.


Where's My Stuff?

Shipping & Returns

Need Help?

Your Recent History

  (What's this?)
You have no recently viewed items or searches.

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.

Look to the right column to find helpful suggestions for your shopping session.
Continue shopping: Top Sellers
Free
Free by Chris Anderson
3.5 out of 5 stars (13)$0.00
 Paranoia
Paranoia by Joseph Finder
4.1 out of 5 stars (200)$0.00
 My Soul to Lose
My Soul to Lose by Rachel Vincent
4.2 out of 5 stars (4)$0.00
 Glenn Beck's Common Sense
Glenn Beck's Common Sense by Glenn Beck
3.8 out of 5 stars (282)$6.59

amazon.com Amazon.com Home  |   Directory of All Stores
International Sites:  Canada  |  United Kingdom  |  Germany  |  Japan  |  France  |  China
Business Programs: Sell on Amazon  |  Build an eCommerce Site  |  Advertise With Us  |  Developer Services  |  Self-Publish with Us
Help  |  View Cart  |  Your Account  |  1-Click Settings
Investor Relations  |  Press Releases  |  Careers at Amazon  |  Join Associates  |  Join Advantage
Conditions of Use | Privacy Notice © 1996-2009, Amazon.com, Inc. or its affiliates