Microsoft SQL Server 2012 Management and Administration

Front Cover
Sams Publishing, Sep 6, 2012 - Computers - 984 pages
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


What people are saying - Write a review

We haven't found any reviews in the usual places.


Consolidation Virtualization and Private Clouds
Administering and Configuring the Database Engine
Best Practices
Backing Up and Restoring SQL Server 2012 Databases
Creating Packages and Transferring Data OnPremise
Best Practices
The exact link to the OLTP and data warehouse
Administering SQL Server 2012 Security and Authorization 9 Encrypting SQL Server 2012 Data and Communications
Managing Failover Clusters from a Windows Server 2008
Implementing and Managing Database Mirroring
Implementing and Managing Replication
Performance Tuning Monitoring Troubleshooting
Monitoring SQL Server 2012
Best Practices
MultiInstance Management Consolidation
Managing Workloads with Resource Governor

Administering SQL Server Security
Best Practices
SQL Server 2012 AlwaysOn HighAvailability and Disaster Recovery Alternatives 10 Implementing and Managing AlwaysOn Availability Groups 11...
Implementing and Managing AlwaysOn Failover Cluster
Additional Elements of AlwaysOn Failover Cluster
Implementing a SingleInstance SQL Server 2012 Failover
Multisubnet SQL Server 2012 Failover Cluster Overview
Managing Failover Clusters from a SQL Server 2012
Best Practices
Understanding Consolidation Virtualization and Private
Planning Your Implementation of HyperV
Installation of the Microsoft HyperV Server Role
Installing a SQL Server 2012 Guest Operating System
Launching a HyperV Guest Session

Other editions - View all

Common terms and phrases

About the author (2012)

Ross Mistry is an author, public speaker, principal enterprise architect, and veteran in the Silicon Valley. He has published numerous books and articles and frequently speaks at conferences worldwide.

With more than 15 years of experience, Ross has been a trusted advisor providing strategic guidance for many C-level executives and has been responsible for planning and implementing technology solutions for some of the largest companies in the world. He has taken on the lead architect role for many Silicon Valley internet startups and Fortune 100 organizations, including Network Appliance, McAfee, The Sharper Image, Visa, CIBC, Levi’s, Wells Fargo, and Intel. He specializes in data platform, business productivity, unified communications, core infrastructure, and private cloud.

At Microsoft, Ross is a director and principal enterprise architect at the Microsoft Technology Centers (MTCs). The MTCs are collaborative environments that provide access to innovative technologies and world-class expertise, giving organizations the ability to envision, design, and deploy solutions to meet their exact needs. He is currently in the process of launching and leading the first MTC in Canada.

Ross is an active participant in the SQL Server community. He comanaged the main Microsoft SQL Server Twitter account @SQLServer and frequently speaks at technology conferences around the world. He has recently spoken at TechEd, PASS Summit, SQL Connections, and SQL BITS. He is a series author and has formulated many best practices and written many whitepapers and articles for Microsoft, SQL Server Magazine, and

Bibliographic information