: Thomas LaRock
: DBA Survivor Become a Rock Star DBA
: Apress
: 9781430227885
: 1
: CHF 42.30
:
: Informatik
: English
: 250
: Wasserzeichen/DRM
: PC/MAC/eReader/Tablet
: PDF

DBA Survivor is a book to help new database administrators understand more about the world of database administration. More and more people are moving into the DBA profession, and many are looking for a getting-started guide. Blogs are written about how to be an exceptional DBA and what to do in your first 100 days. This book takes a different approach, injecting some humor into helping you understand how to hit the ground running, and most importantly how to survive as a DBA.

And it's not just survival that matters. AuthorThomas LaRock wants much more for you than mere survival. He wants you to have excellence, competence, visibility, confidence, and service. These are the traits and characteristics of DBAs who truly succeed and become respected in their profession. Don't settle for just muddling through your job each day. Strive to excel. Aim to make a difference, for your clients, and for your colleagues.

  • Focuse on the soft skills that distinguish truly exceptional DBAs
  • Takes a humorous approach to keep readers engaged
  • Written by a SQL Server 'Most Valuable Professional' and board member of PASS


Thomas LaRock is a seasoned information technology professional with over a decade of technical and management experience. Currently serving as a senior database administrator for Confio Software, Thomas has progressed through several roles in his career including programmer, analyst, and database administrator. Thomas holds a master of science degree in mathematics from Washington State University and is a member of the Usability Professionals Association. Thomas currently serves on the board of directors for the Professional Association for SQL Server (PASS), and is also a SQL Server 'Most Valuable Professional'. Thomas can also be found blogging at http://thomaslarock.com and is the author of DBA Survivor: Become a Rock Star DBA (http://www.dbasurvivor.com).
Title Page1
Copyright Page2
Contents at a Glance4
Table of Contents5
Foreword10
About the Author12
About the Technical Reviewers13
Acknowledgments14
Introduction15
Chapter 1 How Did I Get Here?16
My Journey16
Early Lessons17
Early Career18
Luck, Preparation, and Opportunity19
Community20
Other Journeys20
Pharmacist21
Hotel Manager21
Estimating Supervisor21
MUMPS Programmer21
Your Journey22
Get Prepared23
Get Trained24
Get Certified24
Now Go and Get Your Opportunity!25
Staying Focused26
Chapter 2 Now What Do I Do?27
What You Have in Common with the President27
Your Initial Checklist28
Create a List of Servers30
Check Database Backups31
Verify That You Can Restore32
Build a List of Customers32
List the Most Important Databases33
List Upcoming Projects and Deliverables34
Establish Environmental Baselines34
Compose Your Recovery Plan35
You Have Your Info, Now What?36
Meet with Your Manager36
Meet with the Developers37
Meet with the Server Administrators37
Meet with Your Customers38
Is That Alert Serious?39
Should I Look Into That Alert?40
Review the Alert System40
Ask the Developers41
Ask the Server Administrators41
Ask Your Customers41
Hi, Want to Grab Some Lunch?42
Meeting by Eating42
Politicking, or Not43
Dealing with Introversion43
Accept That Nothing Is Wrong43
Take Care of Yourself44
Be Open and Straightforward44
Join Some Organizations44
Accept That Nothing Is Wrong45
Track Your Progress46
Get Proactive46
Chapter 3 Some Basics48
Introduction to RAID49
Why Is RAID So Important?49
RAID for Performance50
RAID for Fault Tolerance51
RAID 052
RAID 152
RAID 553
RAID 1+053
Which RAID Level Do You Want?54
Your Needs54
The ABCs of SANs for DBAs55
Why RAID 5 Might Work for You56
The Lost Art of Benchmarking57
It s All About the Spindles, Baby58
High Availability Options59
Clustering59
Log Shipping61
Replication62
Transactional Replication63
Merge Replication63
Snapshot Replication64
Database Mirroring64
Disaster Recovery Planning65
DR Testing66
Carnegie Hall67
Networks Are Like Bathrooms68
Call a Plumber68
Fix It Now!69
DBA Stands For . . .69
People Will Resist Change70
Having Standards and Processes Is Not a Bad Thing72
People Will Blame What They Do Not Understand73
Blame vs. Credit74
The Need to Be Right vs. Being Liked75
Chapter 4 A Development ServerIs a Production Serverto a Developer76
Why Developers Are So Needy77
Under Pressure77
Business Needs78
SQL Knowledge79
Service-Level Agreements80
Being a Good Customer81
Communication Is Key82
Managing Expectations83
No One Cares About Effort84
Let s Talk84
Get Involved Early85
Communicate Your Actions86
You Are Not Fast Enough86
You Did It Wrong86
Be Responsive and Responsible87
Time Management88
Develop a Routine88
Stress Relief89
To-Do Lists90
Chunks90
Know When to Say No91
Chris Hansen and Code Reviews91
Chapter 5 Production Support93
Service-Level Agreements94
I Thought We Had an Agreement?95
Get to Know What You Do95
Be Nice96
Establish Support Process97
Define Process98
Publish Process99
Remind and Enforce99
Work/Life Balance100
Communication100
Protect Your Private Time101
Happy Fun Play Time101
Outsourcing102
Quality of Work103
Language Barriers104
Security105
Job Security105
All Good Things106
Chapter 6 Basic Troubleshooting107
CSI: SQL107
Incidents108
Interrogations109
Surveillance109
Common Bottlenecks110
Disk111
Memory111
CPU112
Available Tools112
Reliability and Performance Monitor112
Disk I/O114
SQLServer:PhysicalDisk114
SQLServer:Buffer Manager115
Memory115
CPU115
Activity Monitor116
Disk I/O116
Memory117
CPU117
Dynamic Management Views (DMVs)