[Искра]

Pro SQL Server 2012 Administration, 2nd Edition


Год: 2012 (May)
Автор: Ken Simmons , Sylvester Carstarphen
Издательство: Apress
ISBN: 978-1-4302-3915-4
Серия: The Expert's Voice In SQL Server
Язык: Английский
Формат: PDF/EPUB
Качество: Изначально компьютерное (eBook)
Интерактивное оглавление: Да
Количество страниц: 494
Описание: Pro SQL Server 2012 Administration addresses all aspects of database administration, regardless of the size of the implementation. Install SQL Server 2012 and create new database environments. Develop a sound backup strategy for your database. Perform recovery as needed, which many consider to be job #1. Authors Ken Simmons and Sylvester Carstarphen also help you automate your work through the use of policy-based management. Performance optimization gets good coverage, so that you can render assistance when developers need help with problem queries.

Rare among database and other technical books is solid guidance on the people side of the equation. Success as a database administrator comes from working well with others, becoming involved in the community, and building the right combination of technical knowledge and people skills to solve problems and get things done professionally and amicably. Simmons and Carstarphen pay special attention to these aspects of the job in this new edition of their comprehensive book on SQL Server administration.

What you’ll learn:

Install SQL Server 2012 and create new databases
Implement backup & recovery strategies to protect your database, and your job
Diagnose and resolve query performance problems
Apply policy-based management for consistency across all databases in an organization
Turn every interaction with a client, manager or executive into a stepping-stone towards career success

1. What’s New?
2. Pre-Install Considerations
3. Choosing a High-Availability Solution
4. Installing and Upgrading
5. Post Installation
6. Multi-Server Administration
7. Security
8. Administering Database Objects
9. Indexing for Performance
10. Managing Backups
11. Restore and Recovery Strategies
12. Automating Routine Maintenance
13. Monitoring Your Server
14. Auditing
15. Extended Events Interface
16. Managing Query Performance
17. Secrets to Excelling as a Professional DBA