9780672336003

This is the most complete, fast-paced, task-based reference for DBAs who need to deploy, manage, and secure Microsoft SQL Server 2012. Authored by a world-class architect who now crafts SQL Server solutions for Microsoft's largest Silicon Valley customers, it goes far beyond the basics, taking on the complex tasks that DBAs need to succeed with SQL Server 2012 in mission-critical environments. Ross Mistry draws on extensive testing in large production environments to offer step-by-step solutions and tips readers won't find anywhere else. Every chapter identifies SQL Server 2012's most valuable new improvements, and concludes with a convenient summary of best practices. Coverage includes: * Choosing the right installation or upgrade strategies * Managing memory, processors, auditing, database files, autogrowth, and new FileTables * Using new Contained Databases to streamline data deployment * Leveraging full-text search * Managing backup/restore * Working with Utility Control Points * Implementing consolidation, virtualization, and the private cloud * Using the Policy Based Framework to manage compliance and configuration * Managing workloads and consumption with the new Resource Governor * Hardening SQL Server environments * Utilizing SQL Server authorization and encryption * Operating new AlwaysOn Availability Groups * Using Failover Clustering, Database Mirroring, Replication, and other enterprise capabilities * Monitoring and troubleshooting SQL Server 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 Techtarget.com.

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Amazon no longer offers textbook rentals. We do!

Microsoft SQL Server 2012 Management and Administration

Microsoft SQL Server 2012 Management and Administration

0672336006

Summary

Author Biography

Table of Contents

Supplemental Materials