Professional SQL Server 2005 Administration
Год: 2007
Автор:Knight B., Patel K.
Жанр: Учебное пособие
Издательство: Wrox
ISBN: 0470055200, 978-0470055205
Язык: Английский
Формат: CHM
Качество: Изначально компьютерное (eBook)
Количество страниц: 768
Описание: SQL Server 2005 is the largest leap forward for SQL Server since its inception. With this update comes new features that will challenge even the most experienced SQL Server DBAs. Written by a team of some of the best SQL Server experts in the industry, this comprehensive tutorial shows you how to navigate the vastly changed landscape of the SQL Server administration.
Drawing on their own first-hand experiences to offer you best practices, unique tips and tricks, and useful workarounds, the authors help you handle even the most difficult SQL Server 2005 administration issues, including blocking and locking. You'll learn how to fine-tune queries you've already written, automate redundant monitoring and maintenance tasks, and use hidden tools so that you can quickly get over the learning curve of how to configure and administer SQL Server 2005.
Оглавление
Introduction
Chapter 1 - SQL Server 2005 Architecture
Chapter 2 - SQL Server 2005 Installation Best Practices
Chapter 3 - Upgrading SQL Server 2005 Best Practices
Chapter 4 - Managing and Troubleshooting the Database Engine
Chapter 5 - Automating SQL Server
Chapter 6 - Integration Services Administration and Performance Tuning
Chapter 7 - Analysis Services Administration and Performance Tuning
Chapter 8 - Administering the Development Features
Chapter 9 - Securing the Database Engine
Chapter 10 - Change Management
Chapter 11 - Configuring the Server for Optimal Performance
Chapter 12 - Optimizing SQL Server 2005
Chapter 13 - Monitoring Your SQL Server
Chapter 14 - Performance Tuning T-SQL
Chapter 15 - Indexing Your Database
Chapter 16 - Replication
Chapter 17 - Database Mirroring
Chapter 18 - Backup and Recovery
Chapter 19 - SQL Server 2005 Log Shipping
Chapter 20 - Clustering SQL Server 2005
Appendix A - Raymond James Lab Report
Index
Опубликовано группой
