|
Professional SQL Server 2005 Administration (Wrox Professional Guides)
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. What you will learn from this book: how to use some of the more advanced concepts of installation; techniques for properly administering development features such as SQL CLR; ways to secure your SQL Server from common threats; how to choose the right hardware configuration; best practices for backing up and recovering your database; and, step-by-step guidelines for clustering your SQL Server. Who this book is for? This book is for experienced developers and database administrators who plan to administer or are already administering an SQL Server 2005 system and its business intelligence features. Wrox Professional guides are planned and written by working technologists to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.
Contents:
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.
Brief Description:
SQL Server 2005 is the leap forward for SQL Server. This book shows you how to navigate the changed landscape of SQL Server administration. It offers you best practices, tips and tricks, and workarounds.
|
