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


What Counts for a DBA: Amnesia


What Counts for a DBA: Amnesia

Author
Message
Louis Davidson (@drsql)
Louis Davidson (@drsql)
SSC-Enthusiastic
SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)

Group: General Forum Members
Points: 167 Visits: 109
Comments posted to this topic are about the item What Counts for a DBA: Amnesia



emmchild
emmchild
SSC-Enthusiastic
SSC-Enthusiastic (118 reputation)SSC-Enthusiastic (118 reputation)SSC-Enthusiastic (118 reputation)SSC-Enthusiastic (118 reputation)SSC-Enthusiastic (118 reputation)SSC-Enthusiastic (118 reputation)SSC-Enthusiastic (118 reputation)SSC-Enthusiastic (118 reputation)

Group: General Forum Members
Points: 118 Visits: 408
Bravo Louis!

I will share this with my team. I currently practice a valuable piece of information you gave me years ago. You said don't design based on how much work its going to take to complete the solution. This post is an excellent approach to that philosophy. Focusing on the original problem and selectively ignoring things that don't work is the way to maintaining sanity.

So many of the problems that exist are the result of improvisation that didn't really solve the original problem on a long term basis. Thanks for your leadership!



Jack Vamvas
Jack Vamvas
Valued Member
Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)

Group: General Forum Members
Points: 59 Visits: 329
Good article. The DBA job is significantly easier in the long run , if discipline and sound priniples are applied.
Many DBAs are pragmatic - i.e they work in a resource constrained environment - with the number one priority being to keep Production systems alive.
This leads to short cuts and sometime pain the future

Jack Vamvas
sqlserver-dba.com
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)

Group: General Forum Members
Points: 87476 Visits: 41116
Jack Vamvas (1/6/2013)
Good article. The DBA job is significantly easier in the long run , if discipline and sound priniples are applied.
Many DBAs are pragmatic - i.e they work in a resource constrained environment - with the number one priority being to keep Production systems alive.
This leads to short cuts and sometime pain the future


How do you figure that trying to keep Production systems alive "leads to short cuts"?

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)

Group: General Forum Members
Points: 87476 Visits: 41116
What I've found is that a DBA is usually the voice-of-one against many and that the DBA is usually the only one with a mind out for silly little things like performance, scalability, useablility, archivability, and ease of modification. I certainly can't speak for all DBAs but thank goodness I don't actually have amnesia so that I can remember all of the seemingly little stupid things that have caused huge pains in the future. You know... little things we've suggested like "No. Loan Number from a bank isn't good enough to be a Primary Key" or "No. No permutation of first and last name is good enough to be a Primary Key" or "No. Storing multiple addresses and phone numbers on a single row in the Customer table is a really bad idea".

I think that any DBA that has developed a sense of amnesia has yet another hard lesson to learn. ;-)

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Sineetha Parveen
Sineetha Parveen
SSC-Addicted
SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)

Group: General Forum Members
Points: 426 Visits: 119
Nice article Louis
Jack Vamvas
Jack Vamvas
Valued Member
Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)

Group: General Forum Members
Points: 59 Visits: 329
@Jeff - "short cuts" , in this context means : a) Increasing time pressure on the Production DBA with limited time to plan and apply principles adequately. b) Many DBAs I know , are frustrated by increased responsibilities but with insufficient increased resources to tackle these responsibilities.

Maintaining Production environments in a complex , constantly changing environment , with SAN , network, VM - upgrades, fixpacks - creates extra workload for the DBA - regarding troubleshooting , capacity planning etc. As a result , developers in lower environments don't receive the necessary attention from the DBAs.

Jack Vamvas
sqlserver-dba.com
TravisDBA
TravisDBA
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2016 Visits: 3069
Jeff Moden (1/6/2013)
What I've found is that a DBA is usually the voice-of-one against many and that the DBA is usually the only one with a mind out for silly little things like performance, scalability, useablility, archivability, and ease of modification.


I can definitely agree with this. Many times, we are the only voice of reason that protects the integrity of the production databases which we are the caretakers of. Managers, developers, BI folks, etc tend to want what they want when they want it. I have a big sign over my desk for all to see that states: "This is NOT Burger King. You can't always get it your way.":-D

"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"
Louis Davidson (@drsql)
Louis Davidson (@drsql)
SSC-Enthusiastic
SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)

Group: General Forum Members
Points: 167 Visits: 109
@jeff moden,

So, I should note that I don't indicate that you should forget everything you know Smile Just that "we have to forget the pain of past failures".

If you are a sports fan, you can think of it just like a receiver. They have a difficult job in that they have to concentrate on the ball coming to them and protecting it once they catch it, but "forget" that they are about to be hit by a small freight train sized opponent, and that the last time they did it hurt really so bad they dropped the ball and lost the game.

They still should remember the lesson of that failure (that they have to protect the ball), but not dwell on the failure or they will do everything they can to not be in the position to even catch the ball so they won't get hurt.

Failure is a big part of the educational process (http://www.simple-talk.com/blogs/2011/04/16/what-counts-for-a-dba-failure/) but failure can lead you in two ways and fear will hopefully not be the one you choose.



SQLRNNR
SQLRNNR
SSC-Dedicated
SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)

Group: General Forum Members
Points: 32803 Visits: 18559
Jeff Moden (1/6/2013)
What I've found is that a DBA is usually the voice-of-one against many and that the DBA is usually the only one with a mind out for silly little things like performance, scalability, useablility, archivability, and ease of modification.


+1



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

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