Professional Microsoft SQL server 2008 administration -(E-BOOK)
Brian Knight ... [et al.].
- Indianapolis, IN : Wiley Pub., c2009.
- xxxii, 878 p. : ill. ; 24 cm.
- Wrox professional guides .
- Wrox professional guides. .
"Wrox programmer to programmer"--Cover.
Introduction (Page-xxix)Chapter 1: SQL Server 2008 Architecture (Page-1),Chapter 2: SQL Server 2008 Installation Best Practices (Page-35),Chapter 3: Upgrading SQL Server 2008 Best Practices (Page-63),Chapter 4: Managing and Troubleshooting the Database Engine (Page-97),Chapter 5: Automating SQL Server (Page-129),Chapter 6: Integration Services Administration and Performance Tuning (Page-175),Chapter 7: Analysis Services Administration and Performance Tuning (Page-207),Chapter 8:Administering the Development Features (Page-237),Chapter 9: Securing the Database Engine (Page-329),Chapter 10: Change Management (Page-383)Chapter 11: Configuring the Server for Optimal Performance(Page- 413),Chapter 12: Optimizing SQL Server 2008 (Page-455),Chapter 13: Monitoring Your SQL Server (Page-497), Chapter 14: Performance Tuning T-SQL (Page-555),Chapter 15: Indexing Your Database (page-605),Chapter 16: Replication (Page-653),Chapter 17: Database Mirroring (Page-683),Chapter 18: Backup and Recovery (Page-731),Chapter 19: SQL Server 2008 Log Shipping (Page-779),Chapter 20: Clustering SQL Server 2008 (Page-807).
This book is a how-to guide for experienced DBAs. The book is loaded with unique tips, tricks and workarounds for handling the most difficult SQL Server admin issues, including: managing and monitoring SQL Server, automating administration, security, change management, performance tuning, scaling and replication, clustering, backup and recovery.