Description
Springer Pro SQL Server 2012 Administration by Ken Simmons, Sylvester Carstarphen
Pro SQL Server 2012 Administration is a one-stop source for all the knowledge you'll need to professionally manage a database under Microsoft SQL Server 2012. SQL Server administration is a complex field requiring an unusually broad and well-rounded skill set. A good database administrator must be part system administrator, part database design expert, and part SQL tuning optimization guru. Above all, he or she must be capable of restoring a damaged database at any time. Database administration requires excellent people skills for dealing with management and clients, and solid technical skills for dealing with the hardware and the software._x000D__x000D_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. _x000D__x000D_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._x000D__x000D__x000D__x000D_Helps you manage a SQL Server 2012 database at professional level _x000D_Covers the gamut of database administration skills _x000D_Provides guidance on performance optimization_x000D_ Table of contents :- _x000D_
What's New? _x000D_
Pre-Install Considerations _x000D_
Choosing a High-Availability Solution _x000D_
Installing and Upgrading _x000D_
Post Installation _x000D_
Multi-Server Administration _x000D_
Security _x000D_
Administering Database Objects _x000D_
Indexing for Performance _x000D_
Managing Backups _x000D_
Restore and Recovery Strategies _x000D_
Automating Routine Maintenance _x000D_
Monitoring Your Server _x000D_
Auditing _x000D_
Extended Events Interface _x000D_
Managing Query Performance _x000D_
Secrets to Excelling as a Professional DBA _x000D_
What's Next?_x000D_