Professional Microsoft SQL Server 2008 Administration
Published on 31. October 2008
Book
Paperback/Softback
912 pages
978-0-470-24796-9 (ISBN)
Description
Loaded with unique tips, tricks and workarounds for handling the most difficult SQL Server admin issues, Professional Microsoft SQL Server 2008 Administration is a how-to guide for experienced DBAs. Understand how to manage and monitor the SQL Server, automated administration, security, change management, performance tuning, scaling and replication, clustering, and backup and recovery. This updated edition includes new information about Change Data Capture, Performance Studio, Query Governor, and new techniques for monitoring and policy management so that you can have the latest and most comprehensive information at your fingertips.
More details
Product info
Paperback
Edition
1. Auflage
Language
English
Place of publication
United States
Publishing group
John Wiley & Sons Inc
Target group
Professional and scholarly
Product notice
Paperback (trade)
Unsewn / adhesive bound
Dimensions
Height: 235 mm
Width: 191 mm
Thickness: 48 mm
Weight
1669 gr
ISBN-13
978-0-470-24796-9 (9780470247969)
Schweitzer Classification
Other editions
Additional editions
Brian Knight | Ketan Patel | Wayne Snyder
Professional Microsoft SQL Server 2008 Administration
E-Book
02/2011
Wrox
€52.99
Available for download
Brian Knight | Ketan Patel | Wayne Snyder
Professional Microsoft SQL Server 2008 Administration
E-Book
11/2008
Wrox
€52.99
Available for download
Persons
Brian Knight, SQL Server MVP, MCDBA is a database manager at Fidelity National Financial and a co-founder of SQLServerCentral.com. 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.
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.
Content
Forward.
Chapter 1. SQL Server 2005 Architecture.
Chapter 2. SQL Server 2005 Installation Best Practices.
Chapter 3. Upgrading SQL Server 2008 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.