Microsoft SQL Server 2012 Management and Administration
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:
What people are saying - Write a review
We haven't found any reviews in the usual places.
Administering and Configuring the Database Engine
Backing Up and Restoring SQL Server 2012 Databases
Creating Packages and Transferring Data OnPremise
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
MultiInstance Management Consolidation
Managing Workloads with Resource Governor
Administering SQL Server Security
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
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
Active Directory additional administrator AdventureWorks2012 database AlwaysOn Availability Groups application best practice BitLocker BitLocker Drive Encryption certificate chapter click OK client clustered index column compression connect create data files data warehouse Database Engine database mirroring DBAs default dialog box disk enable encryption endpoints Engine Tuning example failover cluster feature filegroup FILESTREAM folder Follow these steps high availability implementation instance of SQL ISCSI leverage log file login Maintenance Plan Microsoft Microsoft SQL Server Monitor node nonclustered index Object Explorer operating system option package partition password performance query recovery model replication Rightclick role schema secondary replicas Server Audit Server Core Server Management Studio snapshot specify SQL Server 2012 SQL Server Agent SQL Server instance SQL Server Management SQL Server system stored procedures tasks tempdb tool transaction log transactional replication TransactSQL troubleshooting updates upgrade view code image Windows Server 2008 Wizard