SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


More Tips for New (and old) DBAs


More Tips for New (and old) DBAs

Author
Message
SQLBOT
SQLBOT
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1412 Visits: 836
Comments posted to this topic are about the item More Tips for New (and old) DBAs

Craig Outcalt



Tips for new DBAs: http://www.sqlservercentral.com/articles/Career/64632
My other articles: http://www.sqlservercentral.com/Authors/Articles/Craig_Outcalt/560258
george sibbald
george sibbald
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16884 Visits: 13695
Craig, interesting article, particularly the just say no and passing on problems bit. As we all know when there are performance problems the database always gets blamed first, so having to refer on problems once we have checked things out is not uncommon.

On the just say no section, one of our main interview questions is to ask what the interviewee would do if they received a request over the phone to delete data, if they say they would do it and don't start going on about proper change procedures and backout plans we get worried.

Also management backing for refusing ad-hoc requests is needed all the way up the chain. In service companies this is not often forthcoming and someone will eventually cave in to keep the client happy, so you can end up getting it in the ear from both ends. That doesn't mean the DBA should just give in though, its part of the job to protect the data and take the brickbats.

Hopefully you will avoid any pork chops on the cursor comment, Smile as DBA housekeeping jobs are probably the one area they are a good way to do things, with the elapsed time being dominated by the dynamic SQL generated (backup,reindex, checkdb) rather than the loop process itself.

---------------------------------------------------------------------
SuperDBA-207096
SuperDBA-207096
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2547 Visits: 711
Nice article!

Lots of good advice, I particularly like the advice about learning T-SQL... and the fact that Cursors have their place, and DBA code is one of the places where it could be ok to use a cursor...

Mark
Scott Abrants
Scott Abrants
SSC Veteran
SSC Veteran (275 reputation)SSC Veteran (275 reputation)SSC Veteran (275 reputation)SSC Veteran (275 reputation)SSC Veteran (275 reputation)SSC Veteran (275 reputation)SSC Veteran (275 reputation)SSC Veteran (275 reputation)

Group: General Forum Members
Points: 275 Visits: 405
Very nicely done and covers some difficult topics - primarily the topic about saying NO. It is just as much of an art, as it is a technical dance, to be an effective DBA and you bring that to light in this article.
Andy Steinke
Andy Steinke
SSC Journeyman
SSC Journeyman (92 reputation)SSC Journeyman (92 reputation)SSC Journeyman (92 reputation)SSC Journeyman (92 reputation)SSC Journeyman (92 reputation)SSC Journeyman (92 reputation)SSC Journeyman (92 reputation)SSC Journeyman (92 reputation)

Group: General Forum Members
Points: 92 Visits: 675
Your organization needs to suppoort saying no; it's easy to say this from an ivory tower perspective but you have to have management and executive support. At some companies the culture simply is that you will do what you need to do to help. If you try to single handedly change this without the power to do it (and DBAs are often staff, not management) it can adversely affect your career.

However, the article was spot on in general. A DBA needs to think before the perform any task and that seems to be the main message, one that is often difficult for junior DBAs to pick up. Part of the value a DBA provides is adding the extra filter and layer of protection to the systems.
SQLBOT
SQLBOT
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1412 Visits: 836
Andy Steinke (1/12/2009)
Your organization needs to suppoort saying no; it's easy to say this from an ivory tower perspective but you have to have management and executive support.


This is very true and in the case where management support does not exist, a case needs to be made to get the attitudes, procedures and culture shifted. By not supporting production stability and strongly defined processes the organization is stunting its capabilities (and may not know it).

Thanks for your comments!

~BOT

Craig Outcalt



Tips for new DBAs: http://www.sqlservercentral.com/articles/Career/64632
My other articles: http://www.sqlservercentral.com/Authors/Articles/Craig_Outcalt/560258
george sibbald
george sibbald
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16884 Visits: 13695
SQLBOT (1/12/2009)
Andy Steinke (1/12/2009)
Your organization needs to suppoort saying no; it's easy to say this from an ivory tower perspective but you have to have management and executive support.


This is very true and in the case where management support does not exist, a case needs to be made to get the attitudes, procedures and culture shifted. By not supporting production stability and strongly defined processes the organization is stunting its capabilities (and may not know it).

Thanks for your comments!

~BOT


couldn't agree more, but be prepared to be unpopular with the wrong people! So this is not a task that should be left to a junior DBA.

---------------------------------------------------------------------
george sibbald
george sibbald
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16884 Visits: 13695
is it just me or is this thread not appearing in 'active threads' or 'my posts'?

---------------------------------------------------------------------
Rob Symonds
Rob Symonds
SSC-Addicted
SSC-Addicted (499 reputation)SSC-Addicted (499 reputation)SSC-Addicted (499 reputation)SSC-Addicted (499 reputation)SSC-Addicted (499 reputation)SSC-Addicted (499 reputation)SSC-Addicted (499 reputation)SSC-Addicted (499 reputation)

Group: General Forum Members
Points: 499 Visits: 500
... be prepared to be unpopular with the wrong people!


Some people say no and couldn't get the right people to stand behind them or support them even if they offered gifts and bribes. Some people however can say no and everybody lines up behind them to support their decision, regardless of whether management support currently exists or not. We've all seen this.

In my experience it's not a matter of having a good argument. You can talk X + Y = Z all you want but it rarely persuades. It's something else. I have some ideas. But I'm curious to see what other people think.
george sibbald
george sibbald
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16884 Visits: 13695
Rob Symonds (1/12/2009)
... be prepared to be unpopular with the wrong people!


In my experience it's not a matter of having a good argument. You can talk X + Y = Z all you want but it rarely persuades. It's something else. I have some ideas. But I'm curious to see what other people think.



gut reaction - if the management do not understand the technical issues or do not have respect for technical people per se, they are less likely to support them

Also, if they want to appear proactive to the client trying to circumvent procedures, it's easier to kick your own people. i.e. its a cop out.

---------------------------------------------------------------------
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search