September 2012
Intermediate to advanced
912 pages
24h 34m
English
Overview
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
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.