Microsoft SQL Server 2008 Administrator's Pocket Consultant [Perfect Paperback]

William R. Stanek (Author)

Book Description

ISBN-10: 0735625891 | ISBN-13: 978-0735625891 | Publication Date: September 19, 2008 | Edition: 1

Get the practical, pocket-sized guide for IT professionals who need to administer, maintain, and optimize SQL Server 2008. Written by award-winning author William Stanek, this portable reference delivers essential details for using SQL Server 2008 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!
Key Book Benefits
Provides fast facts and immediate reference for administering SQL Server 2008 Delivers must-know details for taking advantage of the improved scalability, security features, and management tools in SQL Server 2008 Features concise tables, easy-to-scan lists, and step-by-step instructions for fast answers, wherever you need them

Editorial Reviews

About the Author

William R. Stanek is a Microsoft Most Valuable Professional with more than 20 years of experience in systems management and advanced programming. He is an award-winning author who s written more than 65 books, including WINDOWS SERVER® 2008 INSIDE OUT. He is series editor for the ADMINISTRATOR'S POCKET CONSULTANT line of books.

Product Details

• Perfect Paperback: 672 pages
• Publisher: Microsoft Press; 1 edition (September 19, 2008)
• Language: English
• ISBN-10: 0735625891
• ISBN-13: 978-0735625891
• 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 (12 customer reviews)
• Amazon Best Sellers Rank: #433,339 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

Most Helpful Customer Reviews

10 of 11 people found the following review helpful:

4.0 out of 5 stars Great review for an Oracle DBA, April 11, 2009

By 

Earl D. Shaffer "OracleMan" (USA) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: Microsoft SQL Server 2008 Administrator's Pocket Consultant (Perfect Paperback)

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.

9 of 10 people found the following review helpful:

5.0 out of 5 stars Packed with useful information and lots of T-SQL examples, January 4, 2009

By 

Ben Robson (Ft. Worth, TX USA) - See all my reviews
(REAL NAME)   

This review is from: Microsoft SQL Server 2008 Administrator's Pocket Consultant (Perfect Paperback)

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.

7 of 8 people found the following review helpful:

5.0 out of 5 stars Helpful is an understatement, April 26, 2009

By 

D. Hanes "blcslv" (Wheeling, WV USA) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: Microsoft SQL Server 2008 Administrator's Pocket Consultant (Perfect Paperback)

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.