Microsoft SQL Server 2008 Administrator's Pocket Consultant

Microsoft SQL Server 2008 Administrator's Pocket Consultant

by William Stanek

NOOK Book(eBook)

$20.49 $35.99 Save 43% Current price is $20.49, Original price is $35.99. You Save 43%.
View All Available Formats & Editions
Available on Compatible NOOK Devices and the free NOOK Apps.
Want a NOOK ? Explore Now


Microsoft SQL Server 2008 Administrator's Pocket Consultant by William Stanek

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

Product Details

ISBN-13: 9780735646087
Publisher: Pearson Education
Publication date: 04/21/2010
Series: Pocket Consultant
Sold by: Barnes & Noble
Format: NOOK Book
Pages: 800
File size: 10 MB

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.

Table of Contents

  • Acknowledgments
  • Introduction
  • Chapter 1: SQL Server 2008 Administration Overview
  • Chapter 2: Deploying SQL Server 2008
  • Chapter 3: Managing the Surface Security, Access, and Network Configuration
  • Chapter 4: Configuring and Tuning SQL Server 2008
  • Chapter 5: Managing the Enterprise
  • Chapter 6: Implementing Policy-Based Management
  • Chapter 7: Configuring SQL Server with SQL Server Management Studio
  • Chapter 8: Core Database Administration
  • Chapter 9: Managing SQL Server 2008 Security
  • Chapter 10: Manipulating Schemas, Tables, Indexes, and Views
  • Chapter 11: Importing, Exporting, and Transforming Data
  • Chapter 12: Linked Servers and Distributed Transactions
  • Chapter 13: Implementing Snapshot, Merge, and Transactional Replication
  • Chapter 14: Profiling and Monitoring SQL Server 2008
  • Chapter 15: Backing Up and Recovering SQL Server 2008
  • Chapter 16: Database Automation and Maintenance
  • Chapter 17: Managing Log Shipping and Database Mirroring

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews