Microsoft SQL Server 2012 Pocket Consultant

Portable and precise, this pocket-sized guide delivers ready answers for the day-to-day administration of SQL Server. Zero in on core support and maintenance tasks using quick-reference tables, instructions, and lists. You’ll get the focused information you need to save time and get the job done—whether at your desk or in the field!

Get fast facts to:

• Manage SQL Server services and clients
• Configure, manage, and tune servers
• Implement policy-based management
• Administer security and access
• Monitor server activity and tune performance
• Automate maintenance
• Perform backups and recovery

Table of Contents

Part I: Microsoft SQL Server 2012 Essentials
Chapter 1: Managing Your SQL Servers
Chapter 2: Managing SQL Server ­Services and Clients

Part II: Microsoft SQL Server 2012 Management and Security
Chapter 3: Implementing Policy-Based Management
Chapter 4: Configuring and Tuning Your SQL Servers
Chapter 5: Tuning and Linking Your SQL Servers
Chapter 6: Database Administration ­Essentials
Chapter 7: Implementing SQL Server 2012 Security

Part III: Microsoft SQL Server 2012 Data Management
Chapter 8: Manipulating Schemas, ­Tables, and Views
Chapter 9: Using Indexes, Constraints, and Partitions

Part IV: Microsoft SQL Server 2012 Optimization, Maintenance, and Recovery
Chapter 10: Automating and Maintaining SQL Server 2012
Chapter 11: SQL Server 2012 Backup and Recovery
Chapter 12: SQL Server 2012 Profiling and Monitoring