Actions for Pro SQL Server 2012 administration

Email RIS file
Bookmark
Report an Issue

Pro SQL Server 2012 administration / Ken Simmons, Sylvester Carstarphen

Author
Simmons, Ken
Published
Berkeley, CA : Apress, [2012]
New York : Distributed to the Book trade worldwide by Springer
Copyright Date
©2012
Edition
Second edition.
Physical Description
1 online resource : color illustrations
Additional Creators
Carstarphen, Sylvester
Access Online

Availability

I Want It
I Want It

Finding items...

Series
Contents
Part 1. Introducing Microsoft SQL Server 2012 -- New Features Overview -- Pre-Installation Considerations -- Choosing a High-Availability Solution-- Part 2. Getting Started -- Installing and Upgrading -- Post-Installation-- Part 3. Administering Microsoft SQL Server 2012 -- Multi-Server Administration -- Managing Security Within the Database Engine -- Working with Database Objects -- Indexing for Performance -- Managing Backups -- Restore and Recovery Strategies -- Automating Routine Maintenance-- Part 4. Troubleshooting and Tuning -- Monitoring Your Server -- Auditing SQL Server -- Extended Events Interface -- Managing Query Performance -- Secrets to Excelling as a Professional DBA -- What's Next? -- Ken Simmons and Sylvester Carstarphen.
Summary
Annotation 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 administrato 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. 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. Helps you manage a SQL Server 2012 database at professional level. Covers the gamut of database administration skills. Provides guidance on performance optimization. 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. Who this book is for: Pro SQL Server 2012 Administration is aimed at junior and seasoned database administrators who are looking to develop their knowledge and skill set in Microsoft SQL Server 2012. Readers should already have some exposure to databases in general, or to SQL Server in specific.
Subject(s)
Other Subject(s)
Genre(s)
ISBN
9781430239161 (electronic bk.)
1430239166 (electronic bk.)
9781430239154
1430239158
Digital File Characteristics
PDF
text file
Note
Includes index.
Part Of
Springer eBooks
View MARC record | catkey: 37425625