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

William R. Stanek (Author)

Book Description

ISBN-10: 8120329201 | ISBN-13: 978-0735621077 | Publication Date: November 30, 2005

Portable and precise, this pocket-sized guide delivers immediate answers for the day-to-day administration of SQL Server 2005. Zero in on core support and maintenance tasks using quick-reference tables, instructions, and lists. You’ll get the precise information you need to solve problems and get the job done whether you’re at your desk or in the field!

Get fast facts to:

• Install, configure, and tune SQL Server
• Administer servers and server groups
• Manage and optimize schemas, tables, indexes, and views
• Create logins, configure permissions, assign roles, and perform other essential security tasks
• Import, export, and transform data from various sources
• Implement replication and data merging, and manage data publication and subscription
• Plan and implement a comprehensive backup and recovery strategy
• Monitor server activity and resolve performance issues
• Take charge of automation and maintenance

Editorial Reviews

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

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: 544 pages
• Publisher: Microsoft Press (November 30, 2005)
• Language: English
• ISBN-10: 8120329201
• ISBN-13: 978-0735621077
• ASIN: 0735621071
• Product Dimensions: 8 x 5.7 x 1.4 inches
• Shipping Weight: 1.6 pounds
• Average Customer Review: 4.3 out of 5 stars  See all reviews (15 customer reviews)
• Amazon Best Sellers Rank: #726,300 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

25 of 25 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)   

This review is from: Microsoft SQL Server(TM) 2005 Administrator's Pocket Consultant (Pro-Administrator's Pocket Consultant) (Paperback)

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.

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

By 

Martin Bell (MVP) (UK) - See all my reviews

This review is from: Microsoft SQL Server(TM) 2005 Administrator's Pocket Consultant (Pro-Administrator's Pocket Consultant) (Paperback)

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

19 of 20 people found the following review helpful:

5.0 out of 5 stars Another Stanek Winner, November 14, 2006

By 

Shannon Drake - See all my reviews
(REAL NAME)   

This review is from: Microsoft SQL Server(TM) 2005 Administrator's Pocket Consultant (Pro-Administrator's Pocket Consultant) (Paperback)

I only recently got involved with SQL Server, when work required that I shift gears after our department downsized. Therefore I was not familiar with all of the nuances of SQL Server. In true William Stanek fashion, however, this book smoothly got this newbie very familiar with the features of SQL Server, which I am finding to be a lot more than I ever thought there would be, quite truthfully, I was not expecting it to be so complicated. The book starts out explaining the SQL Server administrations, and teaches some special characteristics for selecting hardware, choosing editions, and using the GUI and CLI tools. There is a lengthy explanation on SQL Server roles and integrating roles, planning for deploying, and setting up SQL Server. I really liked how the author drew the distinction between all the nuances of security, access and configuration. The massive chapter on tuning and optimizing goes into great depth. I never really appreciated the power of SQL Server until I read this chapters on data transformation, replications, transactions. I never knew before I read this book that SQL Server had features for log shipping and mirroring. Part Three and Part Four are where I've spent so much time reading lately. Since this book is 550 information packed pages, I can't review all of it for you. However, I find it an INDISPENSIBLE SQL Server tool. I always find the answers I need in Stanek's books!