ISBN 9788126518975,Professional Microsoft Sql Server 2008 Administration

Professional Microsoft Sql Server 2008 Administration



Wiley India Pvt Ltd

Publication Year 2008

ISBN 9788126518975

ISBN-10 8126518979


Number of Pages 912 Pages
Language (English)

Computer programming

This book is a how-to guide for experienced DBAs. The book is loaded with unique tips, tricks and workarounds for handling the most difficult SQL Server admen issues, including: Managing and monitoring SQL Server Automating administration Security Change management Performance tuning Scaling and replication Clustering Backup and recovery About the Author Brian Knight, SQL Server MVP, MCDBA is a database manager at Fidelity National Financial and a co-founder of He has worked with SQL Server for 10 years and has written several SQL Server books, including Wrox' Professional SQL Server 2005 Integration Services. Ketan Patel is a Development Manager for the Business Intelligence Center of Excellence group at Microsoft. He has worked with SQL Server and other Microsoft technologies for more than 10 years, and has presented at TechEd. Ross Loforte is a SQL technology architect at the Microsoft Technology Center Chicago who specializes in Microsoft SQL Server solutions. He has more than 16 years experience developing, managing, and architecting SQL solutions on large, mission-critical database platforms. Ross presents at TechEd, SQL PASS, Gartner, TDWI, and other conferences. TABLE OF CONTENTS Chapter 1: SQL server 2008 architecture Chapter 2: SQL server 2008 Installation Best practices Chapter 3: Upgrading SQL server 2008 Best practices Chapter 4: Managing ans 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 2008 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: Backing and recovery Chapter 19: SQL server 2008 Log shipping Chapter 20: Clustering SQL server 2008 Index