LaRock DBA Survivor

Become a Rock Star DBA
1. ed
ISBN: 978-1-4302-2788-5
Verlag: Apress
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 250 Seiten

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. Author Thomas 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. Focuses 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).

Autoren/Hrsg.

Larock, Thomas

Inhaltsverzeichnis

1;Title Page;1
2;Copyright Page;2
3;Contents at a Glance;4
4;Table of Contents;5
5;Foreword;10
6;About the Author;12
7;About the Technical Reviewers;13
8;Acknowledgments;14
9;Introduction;15
10;Chapter 1 How Did I Get Here?;16
10.1;My Journey;16
10.1.1;Early Lessons;17
10.1.2;Early Career;18
10.1.3;Luck, Preparation, and Opportunity;19
10.1.4;Community;20
10.2;Other Journeys;20
10.2.1;Pharmacist;21
10.2.2;Hotel Manager;21
10.2.3;Estimating Supervisor;21
10.2.4;MUMPS Programmer;21
10.3;Your Journey;22
10.3.1;Get Prepared;23
10.3.2;Get Trained;24
10.3.3;Get Certified;24
10.3.4;Now Go and Get Your Opportunity!;25
10.4;Staying Focused;26
11;Chapter 2 Now What Do I Do?;27
11.1;What You Have in Common with the President;27
11.2;Your Initial Checklist;28
11.2.1;Create a List of Servers;30
11.2.2;Check Database Backups;31
11.2.3;Verify That You Can Restore;32
11.2.4;Build a List of Customers;32
11.2.5;List the “Most Important” Databases;33
11.2.6;List Upcoming Projects and Deliverables;34
11.2.7;Establish Environmental Baselines;34
11.2.8;Compose Your Recovery Plan;35
11.3;You Have Your Info, Now What?;36
11.3.1;Meet with Your Manager;36
11.3.2;Meet with the Developers;37
11.3.3;Meet with the Server Administrators;37
11.3.4;Meet with Your Customers;38
11.4;Is That Alert Serious?;39
11.5;Should I Look Into That Alert?;40
11.5.1;Review the Alert System;40
11.5.2;Ask the Developers;41
11.5.3;Ask the Server Administrators;41
11.5.4;Ask Your Customers;41
11.6;Hi, Want to Grab Some Lunch?;42
11.6.1;Meeting by Eating;42
11.6.2;Politicking, or Not;43
11.6.3;Dealing with Introversion;43
11.6.3.1;Accept That Nothing Is Wrong;43
11.6.3.2;Take Care of Yourself;44
11.6.3.3;Be Open and Straightforward;44
11.6.3.4;Join Some Organizations;44
11.6.3.5;Accept That Nothing Is Wrong;45
11.7;Track Your Progress;46
11.8;Get Proactive;46
12;Chapter 3 Some Basics;48
12.1;Introduction to RAID;49
12.1.1;Why Is RAID So Important?;49
12.1.2;RAID for Performance;50
12.1.3;RAID for Fault Tolerance;51
12.1.3.1;RAID 0;52
12.1.3.2;RAID 1;52
12.1.3.3;RAID 5;53
12.1.3.4;RAID 1+0;53
12.1.4;Which RAID Level Do You Want?;54
12.1.5;Your Needs;54
12.2;The ABCs of SANs for DBAs;55
12.2.1;Why RAID 5 Might Work for You;56
12.2.2;The Lost Art of Benchmarking;57
12.2.3;It’s All About the Spindles, Baby;58
12.3;High Availability Options;59
12.3.1;Clustering;59
12.3.2;Log Shipping;61
12.3.3;Replication;62
12.3.3.1;Transactional Replication;63
12.3.3.2;Merge Replication;63
12.3.3.3;Snapshot Replication;64
12.3.4;Database Mirroring;64
12.4;Disaster Recovery Planning;65
12.4.1;DR Testing;66
12.4.2;Carnegie Hall;67
12.5;Networks Are Like Bathrooms;68
12.5.1;Call a Plumber;68
12.5.2;Fix It Now!;69
12.6;DBA Stands For . . .;69
12.6.1;People Will Resist Change;70
12.6.2;Having Standards and Processes Is Not a Bad Thing;72
12.6.3;People Will Blame What They Do Not Understand;73
12.7;Blame vs. Credit;74
12.8;The Need to Be Right vs. Being Liked;75
13;Chapter 4 A Development ServerIs a Production Serverto a Developer;76
13.1;Why Developers Are So Needy;77
13.1.1;Under Pressure;77
13.1.2;Business Needs;78
13.1.3;SQL Knowledge;79
13.2;Service-Level Agreements;80
13.2.1;Being a Good Customer;81
13.2.2;Communication Is Key;82
13.3;Managing Expectations;83
13.3.1;No One Cares About Effort;84
13.3.2;Let’s Talk;84
13.3.3;Get Involved Early;85
13.3.4;Communicate Your Actions;86
13.3.4.1;You Are Not Fast Enough;86
13.3.4.2;You Did It Wrong;86
13.3.4.3;Be Responsive and Responsible;87
13.3.5;Time Management;88
13.3.5.1;Develop a Routine;88
13.3.5.2;Stress Relief;89
13.3.5.3;To-Do Lists;90
13.3.5.4;Chunks;90
13.3.5.5;Know When to Say No;91
13.3.6;Chris Hansen and Code Reviews;91
14;Chapter 5 Production Support;93
14.1;Service-Level Agreements;94
14.1.1;I Thought We Had an Agreement?;95
14.1.2;Get to Know What You Do;95
14.1.3;Be Nice;96
14.2;Establish Support Process;97
14.2.1;Define Process;98
14.2.2;Publish Process;99
14.2.3;Remind and Enforce;99
14.3;Work/Life Balance;100
14.3.1;Communication;100
14.3.2;Protect Your Private Time;101
14.3.3;Happy Fun Play Time;101
14.4;Outsourcing;102
14.4.1;Quality of Work;103
14.4.2;Language Barriers;104
14.4.3;Security;105
14.4.4;Job Security;105
14.4.5;All Good Things;106
15;Chapter 6 Basic Troubleshooting;107
15.1;CSI: SQL;107
15.1.1;Incidents;108
15.1.2;Interrogations;109
15.1.3;Surveillance;109
15.2;Common Bottlenecks;110
15.2.1;Disk;111
15.2.2;Memory;111
15.2.3;CPU;112
15.3;Available Tools;112
15.3.1;Reliability and Performance Monitor;112
15.3.1.1;Disk I/O;114
15.3.1.1.1;SQLServer:PhysicalDisk;114
15.3.1.1.2;SQLServer:Buffer Manager;115
15.3.1.2;Memory;115
15.3.1.3;CPU;115
15.4;Activity Monitor;116
15.4.1;Disk I/O;116
15.4.2;Memory;117
15.4.3;CPU;117
15.5;Dynamic Management Views (DMVs);117
15.5.1;Disk I/O;118
15.5.2;Memory;119
15.5.3;CPU;119
15.6;Wait Stats;120
15.6.1;Disk I/O;121
15.6.2;Memory;121
15.6.3;CPU;122
15.7;SQL Profiler;122
15.7.1;Disk I/O;125
15.7.2;Memory;125
15.7.3;CPU;126
15.8;Web Sites;126
15.8.1;Search Engines;127
15.8.2;Forums;127
15.8.3;Technical Resources;128
16;Chapter 7 Where’s the Buffet?;129
16.1;Food Can Be a Drug;130
16.1.1;Emotional Eating;130
16.1.2;Unconscious Eating;131
16.1.3;Overcoming Bad Habits;132
16.2;Social Gatherings;133
16.2.1;Breakfast;133
16.2.2;Lunch;135
16.2.3;Happy Hours;136
16.2.4;Traveling;136
16.3;Exercise;137
16.3.1;Extra Steps;138
16.3.2;The Need for Regular Exercise;138
16.3.3;Sleep;139
16.3.4;Calories;140
16.4;Life Is Good, but It’s Better with Bacon;140
17;Chapter 8 Training, Get YouSome of That;143
17.1;Reasons for Training;144
17.1.1;Professional Development;145
17.1.2;Changing Roles;145
17.1.3;Piloting New Systems;146
17.1.4;Customer Satisfaction;146
17.2;Employee Benefits;146
17.2.1;Job Satisfaction;147
17.2.2;Employee Motivation;147
17.2.3;Process Efficiencies;147
17.2.4;Time Management;147
17.2.5;Communication Skills;148
17.3;Business Benefits;148
17.3.1;Improved Morale;149
17.3.2;Reduced Turnover;149
17.3.3;Reduced Risk;149
17.3.4;Staying Competitive;149
17.4;Training Resources;149
17.4.1;Web Sites;150
17.4.2;Self-Training;150
17.4.3;Volunteering;151
17.4.4;In-Service Training;151
17.4.5;Professional Associations;151
17.4.6;Continuing Education;152
17.4.7;Classroom Training;152
17.4.8;Certifications;152
17.5;Building Your Case;153
17.5.1;Determine Your Training Needs;154
17.5.2;Determine How Many People Need the Training;154
17.5.3;Determine Which Options Will Be Used;154
17.5.4;Calculate the Associated Costs/Expenses;155
17.5.5;Determine the Benefits of Training;155
17.5.6;Determine the Cost Savings;155
17.5.7;Measure Your Results!;156
18;Chapter 9 Connect. Learn. Share.;157
18.1;Communication;157
18.1.1;Start Reading;158
18.1.2;Start Attending;159
18.1.3;Start Writing;160
18.1.4;Start Speaking;162
18.2;Professional Associations;163
18.2.1;Latest Trade Information;164
18.2.2;Writing Opportunities;165
18.2.3;Speaking Opportunities;165
18.2.4;Networking;165
18.3;Networking Basics;166
18.3.1;Building Your Network;166
18.3.2;Feeling Comfortable;167
18.3.3;How to Approach Others;168
18.3.4;Choosing the Right Room;169
18.3.5;Making It Easier;169
19;Chapter 10 Summary;171
19.1;Getting There;171
19.2;Being There;172
19.3;Staying There;172
20;Index;174