Introduction. 1. Introducing SQL Server 2008. 2. Installing SQL Server 2008. 3. SQL Server 2008 Tools. 4. SQL Server 2008 Storage Architecture. 5. SQL Server 2008 Databases. 6. SQL Server 2009 Security. 7. Configuring SQL Server Network Communication. 8. Automating Adminstrative Tasks. 9. Disaster Prevention and Recovery. 10. Monitoring SQL Server. 11. Optmizing SQL Server. 12. SQL Server High Availability. 13. Introduction to Replication. 14. Introduction to the Common Language Runtime. 15. An Adminstrator's Guide to Business Intelligence. 16. Introduction to SQL Server Integration Services. 17. Introduction to SQL Server Analysis Services. 18. Introduction to SQL Server Reporting Services. 19. Introduction to the Service Broker. Index.

Beginning SQL Server 2008 Administration  teaches new and existing database professionals to develop the skills required to successfully administer a SQL Server 2008 database.  No prior SQL Server experience is required. The authors begin with a quick overview of SQL Server 2008, 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.       Configuring and managing network communications.       Automating administration tasks.       Disaster prevention and recovery.       Performance monitoring.       Optimizing and ensuring high availability. Each chapter begins with a quick overview of the related technoogies, followed by a real-world example, with step-by-step instructions that demonstrate how to leverage the technology.   The last major section of the book--which has been significantly revised and expanded--addresses more specialized SQL Server components that many novice DBAs will need to understand.   Most importantly, this includes the Microsoft Business Intelligence toolset:  SQL Server Integration Services SQL Server Reporting Services SQL Server Analysis Services, and  Service Broker The companion webiste provides all of the code examples for download, plus links to useful sites.