Book description
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.
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
Table of contents
- Title
- Dedication
- Contents at a Glance
- Contents
- About the Authors
-
PART 1: Introducing Microsoft SQL Server 2012
- Chapter 1: New Features Overview
-
Chapter 2: Pre-lnstallation Considerations
- Choosing a SQL Server Edition
- SQL Server 2012 Licenses
- Determining Hardware Requirements
- Determining CPU Needs
- Disk Subsystems
- Determining RAID Levels
- Final Disk Storage Configuration
- Determining Memory Requirements
- Choosing the Server
- SQL Server Consolidation
- Consolidation with Virtual Servers
- Summary
- Chapter 3: Choosing a High-Availability Solution
- PART 2: Getting Started
-
PART 3: Administering Microsoft SQL Server 2012
- Chapter 6: Multi-Server Administration
- Chapter 7: Managing Security Within the Database Engine
- Chapter 8: Working with Database Objects
- Chapter 9: Indexing for Performance
- Chapter 10: Managing Backups
-
Chapter 11: Restore and Recovery Strategies
- Restore Vocabulary
- The Importance of Recovery Models
- Practicing Your Recovery Strategy
- Types of Restores
- Restoring Full Backups
- Restoring Transaction Logs
- Restoring Differential Backups
- Restoring Files and Filegroups
- Restoring Pages
- Piecemeal Restores
- Restoring Snapshots
- RESTORE HEADERONLY
- RESTORE FILELISTONLY
- RESTORE VERIFYONLY
- Online Recoveries
- Restore Considerations
- Recovery Examples
- Summary
- Chapter 12: Automating Routine Maintenance
-
PART 4: Troubleshooting and Tuning
- Chapter 13: Monitoring Your Server
- Chapter 14: Auditing SQL Server
- Chapter 15: Extended Events Interface
-
Chapter 16: Managing Query Performance
- Correlating Profiler and Performance Monitor
- Finding Problematic Queries Using DMVs
- Finding Similar Queries Using DMVs
- Optimizing for Specific Parameter Values
- Forcing Index Seeks
- Forcing Index Scans
- Forcing a Specific Execution Plan
- Adding Hints Through Plan Guides
- Managing Resources with the Resource Governor
- Monitoring Resource Governor
- Summary
- Chapter 17: Secrets to Excelling as a Professional DBA
- Chapter 18: What’s Next?
- Index
Product information
- Title: Pro SQL Server 2012 Administration
- Author(s):
- Release date: May 2012
- Publisher(s): Apress
- ISBN: 9781430239154
You might also like
book
Beginning SQL Server 2012 Administration
Beginning SQL Server 2012 Administration provides the essential skills and knowledge needed to begin a successful …
book
Microsoft® SQL Server 2012 Unleashed
Buy the print version of¿ and get the eBook version for free! eBook version includes chapters …
book
Microsoft® SQL Server 2012 Management and Administration, Second Edition
If you need to deploy, manage, or secure Microsoft SQL Server 2012, this is the complete, …
book
Beginning SQL Server 2012 for Developers
Beginning SQL Server 2012 for Developers is the perfect book for developers new to SQL Server …