Professional Microsoft SQL Server 2012 Administration

CONTENTS

Chapter 1: SQL Server 2012 Architecture

SQL Server 2012 Ecosystem

New Important Features in 2012

SQL Server Architecture

Editions of SQL Server

Summary

Chapter 2: Installing SQL Server 2012 Best Practices

Planning the System

Installing SQL Server

Installing Analysis Services

Installing PowerPivot for SharePoint

Burning in the System

Post-Install Configuration

Uninstalling SQL Server

Troubleshooting a Failed Install

Summary

Chapter 3: Upgrading SQL Server 2012 Best Practices

Why Upgrade to SQL Server 2012?

Upgrading to SQL Server 2012

Pre-Upgrade Steps and Tools

Backward Compatibility

SQL Server Component Considerations

Post-Upgrade Checks

Summary

Chapter 4: Managing and Troubleshooting the Database Engine

Configuration and Administration Tools

Troubleshooting Tools

Management Studio

Monitoring Processes in T-SQL

Multiserver Management

Trace Flags

Getting Help from Support

Summary

Chapter 5: Automating SQL Server

Maintenance Plans

Automating SQL Server with SQL Server Agent

SQL Server Agent Security

Configuring SQL Server Agent

Database Mail

Multiserver Administration

Summary

Chapter 6: Service Broker in SQL Server 2012

Asynchronous Messaging

Configuring SQL Server Service Broker

Using SQL Server Service Broker

Summary

Chapter 7: SQL Server CLR Integration

Introduction to the CLR

Creating CLR Assemblies

Securing CLR

Performance Monitoring

Summary

Chapter 8: Securing the Database Instance

Authentication Types

Authorizing Securables

Row Level Security

Summary

Chapter 9: ...