Free Ebook Video Training

Saturday, December 6, 2008

Administrator’s Guide to SQL Server 2005

Administrators Guide to SQL Server 2005

Administrator's Guide to SQL Server 2005

This book has one goal: to help database administrators and their managers run SQL Server 2005 with maximum efficiency, reliability, and performance. Renowned SQL Server expert Buck Woody covers every facet of database administration, from installation and configuration through maintaining enterprise-class business intelligence environments.

If you’re a new SQL Server administrator, Buck will help you master core tasks rapidly—and avoid costly mistakes that only show up when it’s too late. If you’re familiar with previous versions of SQL Server, he’ll get you up-to-speed fast on everything new that matters, from high availability improvements and Integration Services to the SQL Server Management Studio. Whatever your background, you’ll find best practices, real-world scenarios, and easy-to-use automation scripts—all grounded in Buck’s unsurpassed SQL Server knowledge.

• Timesaving tips, practical applications, and start-to-finish examples throughout

• Understand the key “decision points” at every stage of your SQL Server deployment

• Perform day-to-day maintenance more efficiently, from hotfixes to backup/recovery

• Automate maintenance tasks with the SQL Server Agent

• Establish and audit security on SQL Server 2005 and the underlying Windows Server platform

• Monitor and optimize SQL Server: baselining, profiling, index strategies, query refactoring, and more

• Maximize availability using replication, clustering, mirroring, and SQL Server’s new online indexing

• Leverage important new improvements in Integration Services and Reporting Services

• Use Analysis Services to support enterprise-class Business Intelligence deployments

• Even set up a simple configuration of SQL Server 2005 for free—legally!

Foreword xviii

Chapter 1: Installation and Configuration 1

Chapter 2: Architecture and Tools 35

Chapter 3: Maintenance and Automation 99

Chapter 4: Security 173

Chapter 5: Monitoring and Optimization 237

Chapter 6: High Availability 295

Chapter 7: Notification Services and the Service Broker 365

Chapter 8: Integration Services 399

Chapter 9: Reporting Services 451

Chapter 10: Analysis Services 515

Appendix A: Upgrading to SQL Server 2005 581

Index 605

About the Author

Buck Woody has been working with technology since he built his first computer (with 1 whole kilobyte of RAM) in 1980. He has worked every position from the help desk to software design, with stops along the way as an IT manager here and there. He has been a database administrator since 1995, when he managed an Oracle system on an HP 9000. Buck also served for five years as the president of the Tampa SQL Server User Group (TSUG). He is a Microsoft MVP (2006, SQL Server) and holds the MSCE and MCDBA certifications. He currently works at Jabil Circuit as a database architect and hosts a weekly “Guide” for SQL Server at InformIT.com.

download

No comments:

This site does not store any files on its server.We only index and link to content provided by other sites. In case of any query/objection regarding copyright or piracy, please inform us at youzhny197@gmail.com, we will immediately respond to you.