Microsoft SQL Server 2012 Pocket Consultant

; Introduction; Who Is This Book For?; How Is This Book Organized?; What Is SQL Server 2012?; System Requirements; Conventions Used in This Book; Other Resources; Support and Feedback; Microsoft SQL Server 2012 Essentials; Chapter 1: Managing Your SQL Servers; 1.1 Using SQL Server Management Studio; 1.2 Managing SQL Server Groups; 1.3 Managing Servers; 1.4 Using Windows PowerShell for SQL Server Management; 1.5 Starting, Stopping, and Configuring SQL Server Agent; 1.6 Starting, Stopping, and Configuring MSDTC; 1.7 Managing SQL Server Startup; 1.8 Managing Server Activity; Chapter 2: Managing SQL Server Services and Clients; 2.1 Managing SQL Server Component Feature Access; 2.2 Managing the Network and SQL Server Native Client Configuration; 2.3 Understanding the Services Configuration; 2.4 Configuring SQL Server Services; Microsoft SQL Server 2012 Management and Security; Chapter 3: Implementing Policy-Based Management; 3.1 Introducing Policy-Based Management; 3.2 Working with Policy-Based Management; 3.3 Configuring Central Management Servers; 3.4 Managing Policies Throughout the Enterprise; Chapter 4: Configuring and Tuning Your SQL Servers; 4.1 Accessing SQL Server Configuration Data; 4.2 Techniques for Managing SQL Server Configuration Options; 4.3 Configuring SQL Server with Stored Procedures; Chapter 5: Tuning and Linking Your SQL Servers; 5.1 SQL Server Management Studio Essentials; 5.2 Working with Linked Servers and Distributed Data; 5.3 Configuring Authentication and Auditing; 5.4 Tuning Memory Usage; 5.5 Configuring Processors and Parallel Processing; 5.6 Configuring Threading, Priority, and Fibers; 5.7 Configuring User and Remote Connections; 5.8 Managing Server Settings; 5.9 Managing Database Settings; 5.10 Managing Linked Servers; 5.11 Troubleshooting Configuration Problems; Chapter 6: Database Administration Essentials; 6.1 Database Files and Logs; 6.2 Database Administration Basics; 6.3 Creating Databases; 6.4 Altering Databases and Their Options; 6.5 Managing Database and Log Size; 6.6 Manipulating Databases; 6.7 Tips and Techniques; Chapter 7: Implementing SQL Server 2012 Security; 7.1 Overview of SQL Server 2012 Security; 7.2 SQL Server 2012 Authentication Modes; 7.3 Special-Purpose Logins and Users; 7.4 Permissions; 7.5 Roles; 7.6 Managing Server Logins; 7.7 Configuring Server Roles; 7.8 Controlling Database Access and Administration; 7.9 Managing Database Permissions; Microsoft SQL Server 2012 Data Management; Chapter 8: Manipulating Schemas, Tables, and Views; 8.1 Working with Schemas; 8.2 Getting Started with Tables; 8.3 Table Essentials; 8.4 Working with Tables; 8.5 Managing Table Values; 8.6 Using Views; Chapter 9: Using Indexes, Constraints, and Partitions; 9.1 Creating and Managing Indexes; 9.2 Working with Columnstore Indexes; 9.3 Column Constraints and Rules; 9.4 Creating Partitioned Tables and Indexes; 9.5 Compressing Tables, Indexes, and Partitions; Microsoft SQL Server 2012 Optimization, Maintenance, and Recovery; Chapter 10: Automating and Maintaining SQL Server 2012; 10.1 Database Automation and Maintenance; 10.2 Using Database Mail; 10.3 Using SQL Server Agent; 10.4 Managing Alerts; 10.5 Managing Operators; 10.6 Scheduling Jobs; 10.7 Automating Routine Server-to-Server Administration Tasks; 10.8 Multiserver Administration; 10.9 Database Maintenance; Chapter 11: SQL Server 2012 Backup and Recovery; 11.1 Creating a Backup and Recovery Plan; 11.2 Selecting Backup Devices and Media; 11.3 Using Backup Strategies; 11.4 Creating a Backup Device; 11.5 Performing Backups; 11.6 Restoring a Database; 11.7 Restoring the master Database; Chapter 12: SQL Server 2012 Profiling and Monitoring; 12.1 Monitoring Server Performance and Activity; 12.2 Working with Replication Monitor; 12.3 Working with the Event Logs; 12.4 Monitoring SQL Server Performance; 12.5 Configuring a Management Data Warehouse; 12.6 Solving Performance Problems with Profiler; About the Author; About the Technical Reviewer;