Pro SQL Server 2008 Administration - Brossura

Simmons, Ken

Brossura

ISBN 10: 1430223731 ISBN 13: 9781430223733

Casa editrice: Apress, 2010

Riassunto

Pro SQL Server 2008 Administration is critical for database administrators seeking in-depth knowledge on administering SQL Server 2008. This book covers the impact of the new features available in SQL Server 2008 specifically targeted for database administrators, along with the tried-and-true advanced techniques required to support and maintain Microsoft SQL Server.

• Introduces new administration features of SQL Server 2008
• Shows how to manage a SQL Server 2008 database at professional level
• Provides guidance on performance optimization

What you’ll learn

• Take advantage of the new administrative features in SQL Server 2008
• Make intelligent decisions when choosing an installation or upgrade path
• Define and implement database policies to create a consistent, predictable environment throughout the organization
• Automate repetitive Tasks for increased productivity
• Create baseline monitors using Performance Monitor, Profiler, and System Dynamic Management views
• Identify and resolve long-running, I/O, and CPU-intensive queries

Who this book is for

This book is for junior and seasoned database administrators who are looking to develop their knowledge and skill set in Microsoft SQL Server 2008.

Table of Contents

1. New Feature Overview
2. Pre-Installation Considerations
3. Choosing a High Availability Solution
4. Installing Microsoft SQL Server 2008
5. Upgrading to Microsoft SQL Server 2008
6. Post Installation
7. Multi-Server Administration
8. Managing Security within the Database Engine
9. Administering Database Objects
10. Indexing for Performance
11. Managing Backups
12. Restore and Recovery Strategies
13. Automating Routine Maintenance
14. Monitoring Your Server
15. Auditing SQL Server
16. Managing Query Performance
17. Secrets to Excelling as a Professional DBA
18. What's Next?

Su questo libro

L'autore

Ken Simmons is a database administrator and developer specializing in Microsoft SQL Server and .NET. He is currently working with a global electronic payment service provider in Columbus, Georgia. He has been working in the IT industry since 2000 and holds certifications for MCP, MCAD, MCSD, MCDBA, and MCTS for SQL 2005. Ken is highly active in the online community and often participates in the SQL forums on MSDN and SQLServerCentral. He enjoys sharing tips that he discovers by writing articles for SQLServerCentral and MSSQLTips.com. He has also formed an SQL Server Users Group in Columbus, Georgia, for SQL Server professionals to come together to share knowledge and resources. When he is not working, Ken enjoys traveling with his wife, Susan, and son, Nathan, and can often be found on a cruise ship, at a Disney resort, or at the beach in his hometown of Pensacola, Florida.

Contenuti

1. New Feature Overview
2. Pre-Installation Considerations
3. Choosing a High Availability Solution
4. Installing Microsoft SQL Server 2008
5. Upgrading to Microsoft SQL Server 2008
6. Post Installation
7. Multi-Server Administration
8. Managing Security within the Database Engine
9. Administering Database Objects
10. Indexing for Performance
11. Managing Backups
12. Restore and Recovery Strategies
13. Automating Routine Maintenance
14. Monitoring Your Server
15. Auditing SQL Server
16. Managing Query Performance
17. Secrets to Excelling as a Professional DBA
18. What's Next?

Dettagli dell?edizione

• Editore: Apress
• Data di pubblicazione: 2010
• ISBN 10: 1430223731
• ISBN 13: 9781430223733
• Rilegatura: Copertina flessibile
• Lingua: Inglese
• Numero edizione: 1
• Numero di pagine: 592