Realistic, concise, complete: all the answers DBAs need to succeed with the SQL ServerŪ 2012 ('Denali') database engine in the enterprise
Reflects many months of beta/pre-beta testing in mission-critical environments.
Provides complete solutions for SQL Server 2012 installation, upgrades, management, monitoring, recovery, troubleshooting, and more
Identifies new features and best practices in every chapter.
Packed with expert tips and configurations from a Microsoft Enterprise Architect
This is the most complete, fast-paced, task-based reference for DBAs who need to deploy, manage, and secure Microsoft SQL Server 2012. Written 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:
Managing memory, processors, and new FileTables.
Using new Contained Databases to streamline data deployment.
Leveraging full-text search.
Managing backup/restore.
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