专业 SQL Server 2005 Administration盘 Professional SQL Server 2005 Administration

分類: 图书,进口原版书,科学与技术 Science & Techology ,
作者: Brian Knight著
出 版 社: John Wiley & Sons
出版时间: 2006-1-1字数:版次: 1页数: 734印刷时间: 2006/12/01开本:印次:纸张: 胶版纸I S B N : 9780470055205包装: 平装编辑推荐
作者简介:
Brian Knight, SQL Server MVP, MCSE
内容简介
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.
目录
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.