Programming Books C Java PHP Python Learn more Browse Programming Books

Sorry, this item is not available in
Image not available for
Image not available

To view this video download Flash Player


Sign in to turn on 1-Click ordering
More Buying Choices
Have one to sell? Sell yours here
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(R) SQL Server(R) 2008 Administrator's Pocket Consultant [Paperback]

by William Stanek
4.6 out of 5 stars  See all reviews (14 customer reviews)

List Price: $44.99
Price: $30.59 & FREE Shipping on orders over $35. Details
You Save: $14.40 (32%)
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
Only 4 left in stock (more on the way).
Ships from and sold by Gift-wrap available.
Want it tomorrow, April 25? Choose One-Day Shipping at checkout. Details
Free Two-Day Shipping for College Students with Amazon Student


Amazon Price New from Used from
Kindle Edition --  
Paperback $26.35  
Paperback, May 1, 2010 $30.59  
Sell Us Your Books
Get up to 80% back when you sell us your books, even if you didn't buy them at Amazon. Learn more

Book Description

May 1, 2010 073562738X 978-0735627383 2

From the author and series editor of the immensely popular ADMINISTRATOR'S POCKET CONSULTANT series from Microsoft Press-this pocket-size guide delivers fast, accurate answers on the spot for IT professionals.

Microsoft SQL Server 2008 Administrator's Pocket Consultant, 2nd Edition is the ideal concise, immediate reference you'll want with you at all times as you deal with Microsoft SQL Server 2008 and SQL Server 2008 R2 administration. Whether you handle administration for 50 users or 5000, this hands-on, fast answers guide focuses on what you need to do to get the job done quickly. With extensive easy-to-read tables, lists, and step-by-step instructions, it's the portable, readable guide that you consistently save you time and minimize system downtime by giving you the right information right now. Get fast facts to:

  • Plan, deploy, and configure SQL Server 2008 R2
  • Administer server and surface security, access, and network configuration
  • Import, export, transform, and replicate data
  • Use SQL Server Management Studio for core administrative tasks
  • Manipulate schemas, tables, indexes, and views
  • Automate maintenance and implement policy-based management
  • Monitor server activity and tune performance
  • Manage log shipping and database mirroring
  • Perform backups and recovery

Frequently Bought Together

Microsoft(R) SQL Server(R) 2008 Administrator's Pocket Consultant + Windows Server 2008 Administrator's Pocket Consultant (2nd Edition)
Price for both: $54.53

Buy the selected items together

Editorial Reviews

About the Author

William R. Stanek is a Microsoft MVP with 20+ years of experience in systems management and advanced programming. He is an award-winning author who’s written more than 100 books, including Windows Server 2012 Pocket Consultant and Microsoft SQL Server 2012 Pocket Consultant.

Product Details

  • Paperback: 800 pages
  • Publisher: Microsoft Press; 2 edition (May 1, 2010)
  • Language: English
  • ISBN-10: 073562738X
  • ISBN-13: 978-0735627383
  • Product Dimensions: 8.1 x 5.5 x 1.7 inches
  • Shipping Weight: 1.9 pounds (View shipping rates and policies)
  • Average Customer Review: 4.6 out of 5 stars  See all reviews (14 customer reviews)
  • Amazon Best Sellers Rank: #230,109 in Books (See Top 100 in Books)

More About the Author

William Stanek is the author of many books for Microsoft and other publishers. Over the years, his practical advice has helped millions of programmers, developers, and network engineers all over the world. Dubbed 'A Face Behind the Future' in 1996 by The Olympian, William's been helping to shape the future of the written word for over two decades. William's 150th book was published in 2013.

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.

Please visit to find links to stay in touch with William. Join William Stanek and over 50,000 fans on Facebook at and on Twitter at William also writes as Robert Stanek. To learn more about Ruin Mist, Magic Lands, Bugville Critters, visit

William R. Stanek ( 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 its sequel, Web Publishing Unleashed, helped establish him as a leader and innovator in technical writing.

Customer Reviews

4.6 out of 5 stars
4.6 out of 5 stars
Most Helpful Customer Reviews
14 of 15 people found the following review helpful
4.0 out of 5 stars Great review for an Oracle DBA April 11, 2009
Format:Paperback|Verified Purchase
Well, I am not a SQL Server DBA. I am an Oracle DBA. But as all Oracle DBAs know, there are more SQL Server databases at Oracle sites then ever before. So, it makes sense to see what is going on over there in SQL Server land.

This is a good book for me - a DBA, not a developer. I did not want a 'how to create an online bookstore with SQL Server' type of book. What I wanted was DBA-info. I was looking for features, commands, syntax, uses, notes, etc.

I think this is a good reference for anyone trying to get info about SQL Server. And for me, a DBA who does not write code, this is a very good book.
Was this review helpful to you?
9 of 10 people found the following review helpful
William Stanek is the #1 Windows authority for a reason, his books are excellent and packed with useful information. This 696-page book is no exception. As with Stanek'sMicrosoft Exchange Server 2007 Administrator's Pocket Consultant Second Edition, I don't see how any SQL admin can live without this book. We're so understaffed and I jump around so many different servers I couldn't function without this.
Comment | 
Was this review helpful to you?
7 of 8 people found the following review helpful
5.0 out of 5 stars Helpful is an understatement April 26, 2009
Format:Paperback|Verified Purchase
First thing I was not that familiar with SQL. I have done minor queries but that was it. Besides that I have had nothing to do with SQL. My boss then decided I should start administering our SQL server because the other 15 machines I administer was just not enough and it is the same as a server 2003 machine right? Whatever.
I bought this book with the hopes it could help me with the day to day operations backup of the database, run clean-ups, etc. This book came back aces. The very first section I looked up was backup. It walked me through step by step explaining everything. The next section was restoration. So I tried it. I created a VM and followed the steps shown. Restored perfectly. I could not be happier.
Everything I have tried in this book has worked the way it was supposed to. It is easy to follow and does not go off in techno babble until it tells you a definition.
I think this is required for anyone administering a SQL Server 2008 machine.
Comment | 
Was this review helpful to you?
2 of 2 people found the following review helpful
5.0 out of 5 stars Great Reference Book January 9, 2011
By George
I always liked the Administrator Pocket Consultant series having several of them, going all the way back to Windows 2000. They are half the height and width of a regular book, but packed full on information (this one at almost 700 pages). The title really says what the book is and what it is good for. It is a great reference book.

I am not a DBA, but a developer that at times must work SQL Server. The book gives enough of an explanation to perform the required tasks and understand what I am doing and why. Need to know how to do something or forgot how to do something, a quick look up and you have the answer. The book is straight forward, informative and easy to understand. There are lots of examples and step by step instructions. Even though it more of a reference book, I like just opening it up and reading a section.
Comment | 
Was this review helpful to you?
2 of 2 people found the following review helpful
5.0 out of 5 stars Excellent points March 17, 2009
By J. Tu
Format:Paperback|Verified Purchase
Straight forward, useful and practical value! Easy to understand, well, not totally. At some parts I wish there were drawings and charts to help readers better understand. I recommend it.
Comment | 
Was this review helpful to you?
4 of 5 people found the following review helpful
3.0 out of 5 stars Awful book binding February 17, 2011
The content of the book is excellent but the manufacturing is terrible. Pages are falling out and the spine of the book has separated right down the middle. Very poor quality control and design by Microsoft makes it hard to recommend this book, it simply does not stand up to day-to-day wear and tear. Perhaps there is a hardback version available...?
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
5.0 out of 5 stars Good Resource February 11, 2011
Format:Paperback|Verified Purchase
As a rule I buy all the pocket admin books for SQL as they come out. I do Technical Assistannce and have found these to be a valuable resource time and time again. Sometimes I need to dig a bit deeper for syntax or other details, but for me this is always the place I first start looking.
Comment | 
Was this review helpful to you?
Most Recent Customer Reviews
5.0 out of 5 stars A Great Reference and Quick Training Guide
I administer a SQL Server, but have no practical training. This reference was recommended by an experienced MS SQL administrator whose lecture I attended, and I found The Pocket... Read more
Published 14 months ago by Jim
4.0 out of 5 stars Good book, very handy!
I had an unexpected gap (like 2 years!) between the two prerequisite classes and the actual exams for SQL Server certification. This book was helpful as I got caught up. Read more
Published 16 months ago by James Patterson
5.0 out of 5 stars Deserves ongoing recommendation for any administrator of the SQL...
Microsoft SQL Server 2008 deserves ongoing recommendation for any administrator of the SQL server environment. Read more
Published on August 14, 2010 by Midwest Book Review
5.0 out of 5 stars Excellent SQL 2008 Administrator reference
I needed a SQL Server 2008 administration book for both learning and for reference at work. Stanek has other books out that are very good. Read more
Published on January 6, 2010 by anon
3.0 out of 5 stars Good for beginners
I am not a beginner and so I was not fascinated by the book. I bought it so that I can prepare for the exam 70-450 to get the MCITP - Database Administrator 2008 as this was a... Read more
Published on December 25, 2009 by V. Kottooru
5.0 out of 5 stars No better manual for SQL Server admin
Once again, Stanek has written the bible for the current SQL Server. Best reference out there. I've used all of Stanek's Administrator's Pocket Consultants.
Published on February 18, 2009 by Lisa Burke
Search Customer Reviews
Only search this product's reviews

What Other Items Do Customers Buy After Viewing This Item?


Have something you'd like to share about this product?
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for Similar Items by Category