Microsoft SQL Server 2008 Administrator's Pocket Consultant

Acknowledgments; Introduction; Who Is This Book For?; How Is This Book Organized?; Conventions Used in This Book; Other Resources; Support for This Book; We Want to Hear from You; Chapter 1: SQL Server 2008 Administration Overview; 1.1 SQL Server 2008 and Your Hardware; 1.2 SQL Server 2008 Editions; 1.3 SQL Server and Windows; 1.4 Using the Graphical Administration Tools; 1.5 Using the Command-Line Tools; 1.6 Using SQL Server PowerShell; Chapter 2: Deploying SQL Server 2008; 2.1 SQL Server Integration Roles; 2.2 Planning for Your SQL Server 2008 Deployment; 2.3 Running and Modifying SQL Server Setup; Chapter 3: Managing the Surface Security, Access, and Network Configuration; 3.1 Managing SQL Server Component Feature Access; 3.2 Configuring SQL Server Services; 3.3 Managing the Network and SQL Server Native Client Configuration; Chapter 4: Configuring and Tuning SQL Server 2008; 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: Managing the Enterprise; 5.1 Using SQL Server Management Studio; 5.2 Managing SQL Server Groups; 5.3 Managing Servers; 5.4 Using Windows PowerShell for SQL Server Management; 5.5 Starting, Stopping, and Configuring SQL Server Agent; 5.6 Starting, Stopping, and Configuring Microsoft Distributed Transaction Coordinator; 5.7 Managing SQL Server Startup; 5.8 Managing Server Activity; Chapter 6: Implementing Policy-Based Management; 6.1 Introducing Policy-Based Management; 6.2 Working with Policy-Based Management; 6.3 Managing Policies Throughout the Enterprise; Chapter 7: Configuring SQL Server with SQL Server Management Studio; 7.1 SQL Server Management Studio Essentials; 7.2 Configuring Authentication and Auditing; 7.3 Tuning Memory Usage; 7.4 Configuring Processors and Parallel Processing; 7.5 Configuring Threading, Priority, and Fibers; 7.6 Configuring User and Remote Connections; 7.7 Managing Server Settings; 7.8 Managing Database Settings; 7.9 Adding and Removing Active Directory Information; 7.10 Troubleshooting Configuration Problems; Chapter 8: Core Database Administration; 8.1 Database Files and Logs; 8.2 Database Administration Basics; 8.3 Creating Databases; 8.4 Altering Databases and Their Options; 8.5 Managing Database and Log Size; 8.6 Manipulating Databases; 8.7 Tips and Techniques; Chapter 9: Managing SQL Server 2008 Security; 9.1 Overview of SQL Server 2008 Security; 9.2 SQL Server 2008 Authentication Modes; 9.3 Special-Purpose Logins and Users; 9.4 Permissions; 9.5 Statement Permissions; 9.6 Roles; 9.7 Managing Server Logins; 9.8 Configuring Server Roles; 9.9 Controlling Database Access and Administration; 9.10 Managing Database Permissions; Chapter 10: Manipulating Schemas, Tables, Indexes, and Views; 10.1 Working with Schemas; 10.2 Getting Started with Tables; 10.3 Table Essentials; 10.4 Working with Tables; 10.5 Managing Table Values; 10.6 Using Views; 10.7 Creating and Managing Indexes; 10.8 Column Constraints and Rules; 10.9 Creating Partitioned Tables and Indexes; 10.10 Compressing Tables, Indexes, and Partitions; Chapter 11: Importing, Exporting, and Transforming Data; 11.1 Working with Integration Services; 11.2 Creating Packages with the SQL Server Import And Export Wizard; 11.3 Understanding BCP; 11.4 BCP Scripts; 11.5 Using the BULK INSERT Command; Chapter 12: Linked Servers and Distributed Transactions; 12.1 Working with Linked Servers and Distributed Data; 12.2 Managing Linked Servers; Chapter 13: Implementing Snapshot, Merge, and Transactional Replication; 13.1 An Overview of Replication; 13.2 Planning for Replication; 13.3 Distributor Administration; 13.4 Creating and Managing Publications; 13.5 Subscribing to a Publication; Chapter 14: Profiling and Monitoring SQL Server 2008; 14.1 Monitoring Server Performance and Activity; 14.2 Working with Replication Monitor; 14.3 Working with the Event Logs; 14.4 Monitoring SQL Server Performance; 14.5 Configuring a Management Data Warehouse; 14.6 Solving Performance Problems with Profiler; Chapter 15: Backing Up and Recovering SQL Server 2008; 15.1 Creating a Backup and Recovery Plan; 15.2 Selecting Backup Devices and Media; 15.3 Using Backup Strategies; 15.4 Creating a Backup Device; 15.5 Performing Backups; 15.6 Restoring a Database; 15.7 Restoring the master Database; Chapter 16: Database Automation and Maintenance; 16.1 Overview of Database Automation and Maintenance; 16.2 Using Database Mail; 16.3 Using SQL Server Agent; 16.4 Managing Alerts; 16.5 Managing Operators; 16.6 Scheduling Jobs; 16.7 Automating Routine Server-to-Server Administration Tasks; 16.8 Multiserver Administration; 16.9 Database Maintenance; Chapter 17: Managing Log Shipping and Database Mirroring; 17.1 Log Shipping; 1111117.2 Database Mirroring; 17.3 Using Mirroring and Log Shipping;