SQL Server 2008 introduces many new features that will change database administration procedures; many DBAs will be forced to migrate to SQL Server 2008. This book teaches you how to develop the skills required to successfully administer a SQL Server 2008 database; no prior experience is required. The material covers 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, as well as major SQL Server 2008 components including Integration Services, Reporting Services, Analysis Services, and Service Broker.
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.
Overview
SQL Server 2008 introduces many new features that will change database administration procedures; many DBAs will be forced to migrate to SQL Server 2008. This book teaches you how to develop the skills required to successfully administer a SQL Server 2008 database; no prior experience is required. The material covers system installation and configuration/architecting, implementing and monitoring security controls, configuring and managing network communications, automating administration tasks, disaster ...