<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQLServerCentral.com
»
Editorials
»
How Do You Handle the Stress of Being a DBA?
78 posts, Page 1 of 8
1
2
3
4
5
»
»»
How Do You Handle the Stress of Being a DBA?
Rate Topic
Display Mode
Topic Options
Author
Message
bradmcgehee@hotmail.com
bradmcgehee@hotmail.com
Posted Wednesday, January 20, 2010 8:16 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:08 PM
Points: 175,
Visits: 719
Comments posted to this topic are about the item
How Do You Handle the Stress of Being a DBA?
Brad M. McGehee
Microsoft SQL Server MVP
Director of DBA Education, Red Gate Software
www.bradmcgehee.com
Post #850971
arun.sas
arun.sas
Posted Wednesday, January 20, 2010 9:23 PM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, April 19, 2012 10:25 PM
Points: 1,231,
Visits: 3,483
Hi,
A news from new co-worker in the lunch, they have the server in one location and another sister office access the application by the 2mbps RF connection just 40 kms away from headquarters. Most of the time from other location end users says the application found slow in process. Finally they conduct the analysis, in there the application vendors raised the trick questions to them that “is the same bad procedures run quickly in the server location?” .then the ball move to the infra team, they shows the big chart, says the density and other unknown terminology that’s 2 mbps is enough. The ball waiting for the top officials play, most of them in the HQ have the hollow effect on the sister office.
At last what happen you known! He asked,
I say, I don’t know,
"so I am here" he says,
I say to him “Be prepare to mobile!”
Post #850985
Henrico Bekker
Henrico Bekker
Posted Wednesday, January 20, 2010 9:25 PM
SSCommitted
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:24 AM
Points: 1,871,
Visits: 2,692
Hi Brad, interesting topic, but also very relevant!
As the only DBA in our environment, I have the privilige of running the show myself, and everyone else relying on my advice and assistance.....but....things arent always that easy..
I found by coming in a hour earlier than anyone, "prepping" the environment for their use, checking the jobs, making sure our dev environment is updated etc ensures that I am free to monitor all activities through the day.
I constantly check all processes running against the DB's so ensure optimal performance for the end users, but also to make sure the developers arent pushing code that could cause problems, block, delete etc...
On a daily basis I try to send them at least one tip/trick from a best practise point of view...
Myself and the current developers enherited a shaky system, with "weird" procedures, so applying best practise from day one was the only way to go forward..what has been done, cannot be undone (without hours of work, testing - you know the drill).
Stopping anyone who is not playing nice with my DB's is also fun, and I got the clearance from Management to do so (
)
I think it is each DBA's responsibility to look after his DB's as if they were his/her children, and wouldnt let anything bad happen to them, to make sure they are warm (online), not being teased (hammered with "select *'s "), and not being abused....
I feel - the less manual maintenance I have to do through the day, the more time I have to play cop when it matters.
Oh, and lastly, on the subject of Dev's not respecting you.... whenever you try to point out a fault from their side, always, but always back it up with proof, or tests to indicate, that they are wrong indeed, and that will get you some respect...
----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Post #850986
Eichpeel
Eichpeel
Posted Wednesday, January 20, 2010 10:12 PM
SSChasing Mays
Group: General Forum Members
Last Login: Monday, July 02, 2012 2:29 PM
Points: 633,
Visits: 256
How to handle the stress? Not sure... but my way of dealing with it is: "keep things in perspective". I am not saying I take my job lightly. In fact, I take it very seriously and I hate to get a SQL notifications telling me one of my jobs has failed but...
Keep in mind what is important in life is absolutely vital to staying sane: pictures of the kids on my desk, running between 50 to 80 miles a week, talking to my parents and surrounding myself with true friends has helped me tremendously to deal with stressful work.
As far as solving issues in a calm and composed manner, listening carefully to issues when they come up, getting advice from very experienced SQL developers and DBA from SQL Server Central, reading very free PDF from Red Gate and Phil Factors' blog, and mentor less experiences developers are keys to keeping a serene piece of mind.
That's my take on it. Eager to read more answers.
"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999
Post #851000
F. Dwarf
F. Dwarf
Posted Wednesday, January 20, 2010 10:38 PM
SSC Veteran
Group: General Forum Members
Last Login: 2 days ago @ 2:45 PM
Points: 236,
Visits: 377
I train tae kwon do 3 times a week. I've found that kicking other people and being kicked by them in a controlled environment relieves all the stress
Oh, and I cook too; but only when I'm in the mood for it
Post #851012
SQLRNNR
SQLRNNR
Posted Wednesday, January 20, 2010 10:50 PM
SSCoach
Group: General Forum Members
Last Login: Monday, May 20, 2013 1:07 PM
Points: 18,733,
Visits: 12,332
Some good things I like to do include User Group participation like the local PASS chapter, SSC participation, exercise and flat out getting away from work.
There is also the big picture piece of it, knowing that when a project is finished and it runs smoothly - you get the sense of accomplishment for having a piece of the projects success.
Jason
AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #851016
arun.sas
arun.sas
Posted Wednesday, January 20, 2010 10:56 PM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, April 19, 2012 10:25 PM
Points: 1,231,
Visits: 3,483
Aaron Gonzalez-394690 (1/20/2010)
I train tae kwon do 3 times a week. I've found that kicking other people and being kicked by them in a controlled environment relieves all the stress
Good potential stress controlled by Technical Knock Out, who is the referee in your game?
Post #851020
Harvey Camm
Harvey Camm
Posted Thursday, January 21, 2010 1:02 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, April 10, 2013 6:39 AM
Points: 108,
Visits: 154
Compartmentalise: I try to give all I've got but not all the time - when I'm away from the office I grow veg and do the family stuff, separate the home and office and give all you can to each in due course.
Harvey
Post #851064
Ben Moorhouse
Ben Moorhouse
Posted Thursday, January 21, 2010 1:49 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, March 09, 2012 2:36 AM
Points: 171,
Visits: 442
I ride a motorbike to and from work which relaxes me nicely on the way home to my family.
Whilst at work though, it became regular practice for me to be given a project and asked for a completion date, only for it to be completely ignored and a much shorter deadline given. I'd then take the stress and try anything to get it done, fail quite a lot of the time and get a bad review as a result.
Now I document what is involved and their individual timescales (x2 to allow for problems) and if they want to shorten the deadline I tell them that some work needs to be removed, because those individual deadlines are not adjustable.
Don't get me wrong - I wouldn't take the micky with the timescales I set, I generally end up finishing a little bit before the deadline. At the same time, I'm no longer taking on the stress because someone's promised someone else that a piece of work will be done in a week.
Post #851079
Lempster
Lempster
Posted Thursday, January 21, 2010 2:32 AM
UDP Broadcaster
Group: General Forum Members
Last Login: Tuesday, May 21, 2013 8:40 AM
Points: 1,450,
Visits: 760
Harvey Camm (1/21/2010)
Compartmentalise: I try to give all I've got but not all the time - when I'm away from the office I grow veg and do the family stuff, separate the home and office and give all you can to each in due course.
Harvey
I couldn't agree more! I also try to end each working day with a completed task, however small, rather than leaving something mid-flow. To quote Blur 'it gives me an enormous sense of wellbeing'
In my experience a major factor of stress for a DBA is not being taken seriously, not so much as an individual, but in terms of the job we do; sad to say, but the majority of companies I've worked for tend to see DBAs as more of a necessary evil rather than essential members of an IT team.......maybe that's just a reflection on my poor choices of employer though!
Lempster
Post #851093
« Prev Topic
|
Next Topic »
78 posts, Page 1 of 8
1
2
3
4
5
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
