You are previewing Microsoft® SQL Server 2012 Management and Administration, Second Edition.
O'Reilly logo
Microsoft® SQL Server 2012 Management and Administration, Second Edition

Book Description

If you need to deploy, manage, or secure Microsoft SQL Server 2012, this is the complete, fast-paced, task-based reference you’ve been searching for. Authored by a worldclass expert on running SQL Server in the enterprise, this book goes far beyond the basics, taking on the complex tasks that DBAs need to make the most of Microsoft’s first cloud-enabled database platform. Designed for maximum practical usability, it’s packed with expert tips and up-to-date real-world configuration guidance you simply won’t find anywhere else.

As someone who helped influence the design of SQL Server 2012 and drawing on many months of beta testing, Ross Mistry provides immediately usable solutions for installation and upgrades, management and monitoring, performance and availability, security, consolidation, virtualization, troubleshooting, and more. Mistry identifies new features and corresponding best practices in every chapter, helping you take full advantage of new SQL Server innovations ranging from private cloud support to AlwaysOn Availability Groups.

Understand how to:

  • Efficiently install or upgrade the SQL Server 2012 database engine

  • Administer and configure database engine settings, storage, I/O, and partitioning

  • Transfer data on-premise or to the cloud

  • Manage and optimize indexes

  • Learn how to consolidate, virtualize and optimize SQL Server for Private Clouds

  • Harden and audit SQL Server 2012 environments

  • Administer security and authorization, including new Contained Databases

  • Encrypt data and communications

  • Design and deploy new AlwaysOn high-availability and disaster recovery features

  • Implement maintenance best practices, including Policy-Based Management

Table of Contents

  1. Title Page
  2. Copyright Page
  3. Contents at a Glance
  4. Table of Contents
  5. About the Author
  6. Dedication
  7. Acknowledgments
  8. We Want to Hear from You!
  9. Reader Services
  10. Introduction
  11. Part I: SQL Server 2012 Database Engine Administration and Management Topics
    1. Chapter 1. Installing or Upgrading the Database Engine to SQL Server 2012
    2. Chapter 2. Administering and Configuring the Database Engine Settings
    3. Chapter 3. Administering Storage, I/O, and Partitioning
    4. Chapter 4. Creating Packages and Transferring Data On-Premise and to the Cloud
    5. Chapter 5. Managing and Optimizing SQL Server 2012 Indexes
    6. Chapter 6. Backing Up and Restoring SQL Server 2012 Databases
  12. Part II: Hardening, Auditing, and Securing SQL Server 2012
    1. Chapter 7. Hardening and Auditing a SQL Server 2012 Implementation
    2. Chapter 8. Administering SQL Server Security and Authorization
    3. Chapter 9. Encrypting SQL Server 2012 Data and Communications
  13. Part III: SQL Server 2012 AlwaysOn High-Availability and Disaster Recovery Alternatives
    1. Chapter 10. Implementing and Managing AlwaysOn Availability Groups
    2. Chapter 11. Implementing and Managing AlwaysOn Failover Clustering Instances
    3. Chapter 12. Implementing and Managing Database Mirroring
    4. Chapter 13. Implementing and Managing Replication
  14. Part IV: Performance Tuning, Monitoring, Troubleshooting, and Maintenance
    1. Chapter 14. Performance Tuning and Troubleshooting SQL Server 2012
    2. Chapter 15. Monitoring SQL Server 2012
    3. Chapter 16. SQL Server 2012 Maintenance Practices
  15. Part V: Multi-Instance Management, Consolidation, and Private Clouds
    1. Chapter 17. Implementing and Managing Policy-Based Management
    2. Chapter 18. Managing Workloads with Resource Governor
    3. Chapter 19. Consolidation, Virtualization, and Private Clouds
  16. Index