Microsoft SQL Server 2005 Management and Administration, which is based on Service Pack 2, addresses the challenges database administrators regularly meet on the SQL Server 2005 by providing more detailed guidance in the areas of management, administration, security, and monitoring. Unlike others, this book includes not only administration and management details of the Database Engine, but also coverage of other SQL Server 2005 components often overlooked, including Analysis Services, Reporting Services, and more. Understanding how? Configure and tune the Database Engine, Reporting Services, Analysis Services, Integration Services, and Notification Services Harden SQL Server implementation Implement SQL Server highavailability alternatives, such as Failover Clustering, Log Shipping, Database Mirroring, and Replication Monitor SQL Server 2005 infrastructure with Operations Manager 2007, including how to configure SQL Server Management Pack and install Operations Manager 2007 automatically SQL Server routine maintenance Encrypt SQL Server data and communications, including setting performance song Certificate Authority and issue the SQL Server environment Create Integration Services packages and transfer data On the Web: Download bonus chapters from www.informit.com/title/9780672329562 Introduction 1 Part I Components of SQL Server Provider 1 SQL Server 2005 Database Engine Operator 11 2 Operator SQL Server Analysis Services 2005 67 3 Organizer SQL Server 1999 Reporting Services 2005 4 Organizers SQL Server 2005 Notification Services 149 5 Organizers SQL Server 2005 Integration Services 183 6 organizers Replication SQL Server 209 Part II Managing SQL Server 2005 7 Performing SQL Server 2005 Health Check 261 8 SQL Server 2005 Maintenance Practices 289 9 Managing and Optimizing SQL Server 2005 317 Index 10 Managing Full-Text Catalogs 353 11 Creating package and Transferring Data 387 Part III Securing the SQL Server Implementation 12 Hardening SQL Server 2005 Environment 435 13 Operator Security SQL Server 469 14 Encrypting SQL Server Data and Communications 509 The following chapters are located online: Part IV SQL Server 2005 Overview (located online) 15 SQL Server 2005 Technology Primer 537 16 Tools of Trade 571 Part V Disaster Recovery and High Availability (located online) 17 Backing Up and Restoring SQL Server 2005 Environment 597 18 Administration and Managing Failover Clustering 647 19 Administration and Management of Database Mirroring 691 20 Administration and Managing Log Shipping 721 Part VI Monitoring and Troubleshooting SQL Server (located online) 21 Monitoring SQL Server 2005 753 22 Performance Tuning and Troubleshooting SQL Server 2005 787 Appendix SQL Server 2005 Management and Administration 821