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
Microsoft SQL Server 2014 Unleashed
The industry’s most complete, useful, and up-to-date guide to SQL Server 2014. You’ll find start-to-finish coverage …
book
Microsoft SQL Server 2019: A Beginner's Guide, Seventh Edition, 7th Edition
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, …
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 Bible
Harness the powerful new SQL Server 2012 Microsoft SQL Server 2012 is the most significant update …