His special attention to security and performance makes a great reference that will remain relevant for some time.? Chip Andrews,? CISSP, MCDBA, Director of Security Research and Development Special Ops, Inc. SQL 2005 is the most exciting upgrade to come out of Redmond in years;? This book will help you get up and running quickly to take full advantage of it! It gives you all you need to take advantage of everything SQL 2005 has to offer, and it's a lot!? ? Doug Ellis, Area Technical Manager, Cognos ? Buck Woody provides insight into the administration of SQL Server 2005 that all developers and database administrators will find useful, the book assumes very little knowledge by providing the DBA 101? part that will not alienate readers experience while providing the necessary introduction to topics for those who are less experienced.? ? Doug Holland C, Visual # MVP, Precision Objects SQL Server? 2005 was a landmark release and this title did an amazing job of hitting everything new in SQL 2005. Nepomnjashiy, DBA SQL Server, NeoSystems Northwest A strong introduction to? Administration of SQL 2005. Buck? Conversational writing style makes it fun and refreshing contrast to most books written by today's technology.? ? Brad Russell, MCDBA, Visionary Integration Professionals The, Complete 100% Useful Practical Guide for Every SQL Server 2005 DBA! This book has one purpose: to help database administrators and their managers run SQL Server 2005 with maximum efficiency, reliability, and performance. If you? Return a new SQL Server administrator, Buck will help you master core tasks rapidly and avoid? Costly mistakes that only show up when it? Too late. Whatever your background, you? 'll Find best practices, real world scenarios, and easy to use automation scripts? All knowledge is based on Buck's unsurpassed SQL Server?. ? Establish and audit security on SQL Server 2005 and Windows Server platforms that underlie ? Monitor and optimize SQL Server: baselining, profile, index strategies, query refactoring, and more ? Maximize availability using replication, clustering, mirroring, and SQL Server? s new online indexing ? Even set up a simple configuration of SQL Server 2005 for free? Legal! Preface xvii Chapter 1: Installation and Configuration 1 Chapter 2: Architecture and Tools 35 Chapter 3: Maintenance and Automation 99 Chapter 4: Security 173 Chapter 5: Monitoring and Optimization 237 Chapter 6: High Availability 295 Chapter 7: Notification Services and Service Broker 365 Chapter 8: Integration Services 399 Chapter 9: Reporting Services 451 Chapter 10: Analysis Services 515 Appendix A: Upgrade to SQL Server 2005 581 Index 605