The Essential DBA Playbook for Optimized SQL Server Management
The Essential DBA Playbook for Optimized SQL Server Management
Abstract
Whether you’re taking a position as a DBA at a new company or you’ve been
with your current company for years, you may be facing the same challenge:
not having the optimal hardware, software, workflow or culture you need to
run a smooth environment. In fact, it’s often quite the opposite: the department
may have poor security practices, nonexistent disaster recovery plans, poor
documentation and substandard hardware or network configuration. Then
there are the cultural or organizational challenges: poor management, underresourced departments or poorly thought-out processes.
While it would be impractical to formulate a strategy for every possible situation,
you can put in place a handful of strategies to overcome panic and methodically
focus on issues within your control. “The Essential DBA Playbook for Optimized
SQL Server Management” explains how, in three chapters:
• Chapter 1: Assessing Your SQL Server Environment — The first step is to
assess the SQL Server environment. An initial database infrastructure status
check is necessary for sustained, optimized database management.
• Chapter 2: Establishing Effective Backup and Recovery — The next step is to
establish effective backup and recovery, keeping in mind high availability and
disaster recovery best practices.
• Chapter 3: Ongoing SQL Server Management Optimization — Finally, you
need to maintain your optimization efforts by communicating effectively,
stabilizing the environment and taking advantage of automation.
This e-book covers assessing your SQL Server environment.
III
2015 Dell. All rights reserved. | Share:
Chapter 1
Assessing Your
SQL Server
Environment
1
2015 Dell. All rights reserved.
Please complete the form to gain access to this content