Professional SQL Server 2005 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
- 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.
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.
|Download Code Files for All Chapters
These downloads are stored in a compressed .rar format. You may need to download a free trial version of WinRAR, which has the capability to uncompress .rar and .zip files.
|109.79 KB||Click to Download|
|Download Code Files for Chapter 3||475 bytes||Click to Download|
|Download Code Files for Chapter 4||471 bytes||Click to Download|
|Download Code Files for Chapter 5||1.27 KB||Click to Download|
|Download Code Files for Chapter 8||45.38 KB||Click to Download|
|Download Code Files for Chapter 9||1.32 KB||Click to Download|
|Download Code Files for Chapter 10||2.16 KB||Click to Download|
|Download Code Files for Chapter 12||953 bytes||Click to Download|
|Download Code Files for Chapter 13||24.13 KB||Click to Download|
|Download Code Files for Chapter 14||11.71 KB||Click to Download|
|Download Code Files for Chapter 15||12.04 KB||Click to Download|
|Download Code Files for Chapter 16||475 bytes||Click to Download|
|Download Code Files for Chapter 17||9.76 KB||Click to Download|
Do you think you've discovered an error in this book? Please check the list of errata below to see if we've already addressed the error. If not, please submit the error via our Errata Form. We will attempt to verify your error; if you're right, we will post a correction below.
in the Synonyms section, second paragraph, last line:
Notice the "s" is missing in the first spelling of "Database."
|76||Error in Text
3rd Paragraph, last line reads:
"...should be turned off. This will help reduce your area of exposure to external and potentially internal treats brought on by your developers."
|664||Error in Text
4th paragrapgh, 6th line:
...how much time you thing the upgrade will take...
...how much time you think the upgrade will take...