| |
| |
| 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 | |
| |
| |
| |
| Managing Your SQL Servers | |
| |
| |
| |
| Using SQL Server Management Studio | |
| |
| |
| |
| Managing SQL Server Groups | |
| |
| |
| |
| Managing Servers | |
| |
| |
| |
| Using Windows PowerShell for SQL Server Management | |
| |
| |
| |
| Starting, Stopping, and Configuring SQL Server Agent | |
| |
| |
| |
| Starting, Stopping, and Configuring MSDTC | |
| |
| |
| |
| Managing SQL Server Startup | |
| |
| |
| |
| Managing Server Activity | |
| |
| |
| |
| Managing SQL Server Services and Clients | |
| |
| |
| |
| Managing SQL Server Component Feature Access | |
| |
| |
| |
| Managing the Network and SQL Server Native Client Configuration | |
| |
| |
| |
| Understanding the Services Configuration | |
| |
| |
| |
| Configuring SQL Server Services; Microsoft SQL Server 2012 Management and Security | |
| |
| |
| |
| Implementing Policy-Based Management | |
| |
| |
| |
| Introducing Policy-Based Management | |
| |
| |
| |
| Working with Policy-Based Management | |
| |
| |
| |
| Configuring Central Management Servers | |
| |
| |
| |
| Managing Policies Throughout the Enterprise | |
| |
| |
| |
| Configuring and Tuning Your SQL Servers | |
| |
| |
| |
| Accessing SQL Server Configuration Data | |
| |
| |
| |
| Techniques for Managing SQL Server Configuration Options | |
| |
| |
| |
| Configuring SQL Server with Stored Procedures | |
| |
| |
| |
| Tuning and Linking Your SQL Servers | |
| |
| |
| |
| SQL Server Management Studio Essentials | |
| |
| |
| |
| Working with Linked Servers and Distributed Data | |
| |
| |
| |
| Configuring Authentication and Auditing | |
| |
| |
| |
| Tuning Memory Usage | |
| |
| |
| |
| Configuring Processors and Parallel Processing | |
| |
| |
| |
| Configuring Threading, Priority, and Fibers | |
| |
| |
| |
| Configuring User and Remote Connections | |
| |
| |
| |
| Managing Server Settings | |
| |
| |
| |
| Managing Database Settings | |
| |
| |
| |
| Managing Linked Servers | |
| |
| |
| |
| Troubleshooting Configuration Problems | |
| |
| |
| |
| Database Administration Essentials | |
| |
| |
| |
| Database Files and Logs | |
| |
| |
| |
| Database Administration Basics | |
| |
| |
| |
| Creating Databases | |
| |
| |
| |
| Altering Databases and Their Options | |
| |
| |
| |
| Managing Database and Log Size | |
| |
| |
| |
| Manipulating Databases | |
| |
| |
| |
| Tips and Techniques | |
| |
| |
| |
| Implementing SQL Server 2012 Security | |
| |
| |
| |
| Overview of SQL Server 2012 Security | |
| |
| |
| |
| SQL Server 2012 Authentication Modes | |
| |
| |
| |
| Special-Purpose Logins and Users | |
| |
| |
| |
| Permissions | |
| |
| |
| |
| Roles | |
| |
| |
| |
| Managing Server Logins | |
| |
| |
| |
| Configuring Server Roles | |
| |
| |
| |
| Controlling Database Access and Administration | |
| |
| |
| |
| Managing Database Permissions; Microsoft SQL Server 2012 Data Management | |
| |
| |
| |
| Manipulating Schemas, Tables, and Views | |
| |
| |
| |
| Working with Schemas | |
| |
| |
| |
| Getting Started with Tables | |
| |
| |
| |
| Table Essentials | |
| |
| |
| |
| Working with Tables | |
| |
| |
| |
| Managing Table Values | |
| |
| |
| |
| Using Views | |
| |
| |
| |
| Using Indexes, Constraints, and Partitions | |
| |
| |
| |
| Creating and Managing Indexes | |
| |
| |
| |
| Working with Columnstore Indexes | |
| |
| |
| |
| Column Constraints and Rules | |
| |
| |
| |
| Creating Partitioned Tables and Indexes | |
| |
| |
| |
| Compressing Tables, Indexes, and Partitions; Microsoft SQL Server 2012 Optimization, Maintenance, and Recovery | |
| |
| |
| |
| Automating and Maintaining SQL Server 2012 | |
| |
| |
| |
| Database Automation and Maintenance | |
| |
| |
| |
| Using Database Mail | |
| |
| |
| |
| Using SQL Server Agent | |
| |
| |
| |
| Managing Alerts | |
| |
| |
| |
| Managing Operators | |
| |
| |
| |
| Scheduling Jobs | |
| |
| |
| |
| Automating Routine Server-to-Server Administration Tasks | |
| |
| |
| |
| Multiserver Administration | |
| |
| |
| |
| Database Maintenance | |
| |
| |
| |
| SQL Server 2012 Backup and Recovery | |
| |
| |
| |
| Creating a Backup and Recovery Plan | |
| |
| |
| |
| Selecting Backup Devices and Media | |
| |
| |
| |
| Using Backup Strategies | |
| |
| |
| |
| Creating a Backup Device | |
| |
| |
| |
| Performing Backups | |
| |
| |
| |
| Restoring a Database | |
| |
| |
| |
| Restoring the master Database | |
| |
| |
| |
| SQL Server 2012 Profiling and Monitoring | |
| |
| |
| |
| Monitoring Server Performance and Activity | |
| |
| |
| |
| Working with Replication Monitor | |
| |
| |
| |
| Working with the Event Logs | |
| |
| |
| |
| Monitoring SQL Server Performance | |
| |
| |
| |
| Configuring a Management Data Warehouse | |
| |
| |
| |
| Solving Performance Problems with Profiler | |
| |
| |
| About the Author | |
| |
| |
| About the Technical Reviewer | |