HAPPY BOOKSGIVING
Use code BOOKSGIVING during checkout to save 40%-55% on books and eBooks. Shop now.
Register your product to gain access to bonus material or receive a coupon.
This eBook includes the following formats, accessible from your Account page after purchase:
EPUB The open industry format known for its reflowable content and usability on supported mobile devices.
PDF The popular standard, used most often with the free Acrobat® Reader® software.
This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.
If you need to deploy, manage, or secure Microsoft SQL Server 2008, this is the complete, fast-paced, task-based reference you’ve been searching for. Authored by a world-class expert on SQL Server in the enterprise, this book goes far beyond the basics, taking on the complex tasks that DBAs need to make the most of Microsoft’s flagship database platform. SQL Server MVP, Ross Mistry presents proven techniques for SQL Server 2008 installation, upgrades, backup/restore, data transfer, indexing, high availability, security, and much more. He draws on extensive testing in high-profile production environments to offer step-by-step solutions and powerful tips you won’t find anywhere else. Every chapter begins with a section identifying SQL Server 2008’s most significant new improvements, and concludes with a convenient summary of best practices. Each chapter also outlines the benefits of leveraging Windows Server 2008.
Understand how to:Hilary Cotter – SQL Server MVP
John Welch – SQL Server MVP
Marco Shaw – PowerShell MVP
Maciej Pilecki – SQL Server MVP
Shirmattie Seenarine – Technical Writer
Introduction
1 Installing or Upgrading to the SQL Server 2008
2 Administering the SQL Server 2008 Database Engine
3 Creating Packages and Transferring Data with
4 Managing and Optimizing SQL Server 2008 Indexes
5 Administering SQL Server 2008 Full-Text Search
6 SQL Server 2008 Maintenance Practices
7 Backing Up and Restoring the SQL Server 2008
8 Hardening a SQL Server Implementation
9 Administering SQL Server Security and Authorization
10 Administering Policy Based Management
11 Encrypting SQL Server Data and Communications
12 Implementing and Managing Failover Clustering
13 Administering and Managing Database Mirroring
14 Implementing and Managing Log Shipping
15 Implementing and Administering SQL Server Replication
16 Managing Workloads and Consumption with
17 Monitoring SQL Server 2008 with Native Tools
18 Proactively Monitoring SQL Server 2008 with System
19 Performance Tuning and Troubleshooting SQL Server 2008
20 Administering SQL Server 2008 with PowerShell
21 Consolidating and Virtualizing SQL Server 2008 with Hyper-V
Summary
Best Practices
Index