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
- Title Page
- Copyright Page
- Contents at a Glance
- Table of Contents
- About the Author
- Dedication
- Acknowledgments
- We Want to Hear from You!
- Reader Services
- Introduction
-
Part I: SQL Server 2012 Database Engine Administration and Management Topics
- Chapter 1. Installing or Upgrading the Database Engine to SQL Server 2012
- Chapter 2. Administering and Configuring the Database Engine Settings
- Chapter 3. Administering Storage, I/O, and Partitioning
- Chapter 4. Creating Packages and Transferring Data On-Premise and to the Cloud
- Chapter 5. Managing and Optimizing SQL Server 2012 Indexes
- Chapter 6. Backing Up and Restoring SQL Server 2012 Databases
- Part II: Hardening, Auditing, and Securing SQL Server 2012
- Part III: SQL Server 2012 AlwaysOn High-Availability and Disaster Recovery Alternatives
- Part IV: Performance Tuning, Monitoring, Troubleshooting, and Maintenance
- Part V: Multi-Instance Management, Consolidation, and Private Clouds
- Index
Product information
- Title: Microsoft® SQL Server 2012 Management and Administration, Second Edition
- Author(s):
- Release date: September 2012
- Publisher(s): Sams
- ISBN: 9780132977661
You might also like
book
Beginning SQL Server 2012 Administration
Beginning SQL Server 2012 Administration provides the essential skills and knowledge needed to begin a successful …
book
SQL Server 2008 Administration in Action
SQL Server 2008 Administration in Action offers over 100 DBA-tested, high-value, best practices that will help …
book
Pro SQL Server 2012 Integration Services
Pro SQL Server 2012 Integration Services teaches how to take advantage of the powerful extract, transform, …
book
Pro SQL Server 2012 Practices
Pro SQL Server 2012 Practices Edition is an anthology of high-end wisdom from a group of …