Beginning Sql Server 2005 Administration

0.0

Beginning SQL Server 2005 Administration teaches new and existing database professionals to develop the skills required to successfully administer a SQL Server 2005 database. No prior SQL Server experience is required. The authors begin with a quick overview of SQL Server 2005, including its set of management tools, and its database components. It then moves quickly to the tutorial, covering such topics as: System installation and configuration/architecting Implementing and monitoring security controls Managing EndPoints Automating administration tasks Disaster prevention and recovery Performance monitoring Optimizing and ensuring high availability Each chapter begins with a quick overview of the related technologies, followed by a real-world example, with step-by-step instructions that demonstrate how to leverage the technology. The last five chapters of the book address more specialized topics that many novice DBAs will likely face, including configuration, management, and security of: SQL Server Integrations Services Notification Services Service Broker Replication Common Language Runtime The companion website provides all of the code examples for download, plus links to useful sites. About The Author Dan Wood is an Operations Manager and DBA, Microsoft SQL Server Specialist and Trainer for Netdesk Corporation, a Microsoft Gold Certified Partner for Learning Solutions. Dan has been a Microsoft Certified Professional and Trainer since 1999; he is co-author of Beginning Transact-SQL from WROX. Chris Leiter is a Trainer for Netdesk Corporation. Chris's role at Netdesk is focused on Systems Administration and Security. Chris has been a Microsoft Certified Professional since 1997, and a Trainer since 2001. Paul Turley is a Senior Consultant for Hitachi Consulting, where he architects and develops database systems. He has been a Microsoft Certified Professional and Trainer since 1996, and lead author of Beginning Transact-SQL With SQL Server 2000 and 2005, Professional SQL Server Reporting Services (1st and 2nd editions), and other Wrox database titles. Table Of Contents Introduction Who This Book Is For What This Book Covers How This Book Is Structured What You Need to Use This Book Conventions Source Code Errata p2p.wrox.com Introducing SQL Server 2005 Installing SQL Server 2005 SQL Server 2005 Tools SQL Server 2005 Storage Architecture SQL Server 2005 Databases SQL Server 2005 Security Configuring SQL Server Network Communication Automating Administrative Tasks Disaster Prevention and Recovery Monitoring SQL Server for Performance SQL Server High Availability Administering SQL CLR Programming Objects Introduction to SQL Server 2005 Integration Services Introduction to SQL Server 2005 Notification Services Introduction to the Service Broker Introduction to Replication Summary Appendix A: Exercise Answers Index