Microsoft SQL Server 2012 Management and Administration

Part I. SQL Server 2012 Database Engine Administration and Management Topics 1. Installing and Upgrading to SQL Server 2012 2. Administering the SQL Server 2012 Database Engine 3. Copying and Transferring Data or Databases 4. Managing and Optimizing SQL Server 2012 Indexes 5. Managing Data Compression and Table Partitions. 6. SQL Server 2012 Maintenance Practices 7. Backing up and Restoring a Database Part II. Application and Multi-Instance Management 8. Implementing and Managing a Utility Control Point 9. Implementing and Managing Data-Tier Applications 10. Consolidation, Virtualization and Private Cloud 11. Administering Policy Based Management 12. Managing Workloads and Consumption with Resource Governor Part III. Securing the SQL Server Implementation 13. Hardening a SQL Server Environment 14. Administering SQL Server Authorization 15. Encrypting SQL Server Data and Communications Part IV. SQL Server 2012 High Availability Alternatives 16. Administering and Managing AlwaysOn Availability Groups 17. Administering and Managing Failover Clustering 18. Administering and Managing Database Mirroring 19. Administering and Managing Log Shipping 20. Administering Replication Part IV. Monitoring and Troubleshooting SQL Server 21. Monitoring SQL Server 2012 22. Performance Tuning and Troubleshooting SQL Server 2012