Mehr lesen
Informationen zum Autor 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. Klappentext 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 Zusammenfassung Whether you handle Microsoft[registered] SQL Server[registered] 2008 and SQL Server[registered] 2008 R2 administration for 50 users or 5000! this guide focuses on what you need to do to get the job done quickly. It helps you get facts to: plan! deploy! and configure SQL Server[registered] 2008 R2; and perform backups and recovery. Inhaltsverzeichnis 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 ...
