Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


DBA Dreams


DBA Dreams

Author
Message
Louis Davidson (@drsql)
Louis Davidson (@drsql)
SSC Journeyman
SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)

Group: General Forum Members
Points: 83 Visits: 109
Comments posted to this topic are about the item DBA Dreams



phonetictalk
phonetictalk
Old Hand
Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)

Group: General Forum Members
Points: 321 Visits: 1610
"I've encountered DBAs who seemed ill equipped to administer a home grocery list and checkbook"

This made me laugh out loud. Thankfully I haven't encountered such DBAs.

Leonard
Madison, WI
jay-h
jay-h
SSC Eights!
SSC Eights! (925 reputation)SSC Eights! (925 reputation)SSC Eights! (925 reputation)SSC Eights! (925 reputation)SSC Eights! (925 reputation)SSC Eights! (925 reputation)SSC Eights! (925 reputation)SSC Eights! (925 reputation)

Group: General Forum Members
Points: 925 Visits: 2222
In a job that is, for the most part, worthy-but-dull, rather than the stuff of dreams

Most good jobs are like that. Glamor is transient, but the enjoyment of doing something well, regardless of the field, is what makes it rewarding.

There is a huge amount of work required to keep society running. The trick is to find a niche where one is comfortable.

BTW, I often suspect that can be a poor choice to choose a job that is also your hobby/passion. If you love photography, will you love it so much when most of your time is doing ad photos for Randy's car lot or filling weekend after weekend with schlocky weddings? If you love music, will it be so much fun when you've got to hit the Motel 6 lounge for your 4 nights a week gig, whether you feel up to it or not?

Even if you get to the more glamorous parts of your field, you still lose the control you had when it was a hobby. The freedom to do what you want, when you want, if you want.

...

-- FORTRAN manual for Xerox Computers --
SQLRNNR
SQLRNNR
SSC-Insane
SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)

Group: General Forum Members
Points: 21075 Visits: 18259
phonetictalk (3/2/2014)
"I've encountered DBAs who seemed ill equipped to administer a home grocery list and checkbook"

This made me laugh out loud. Thankfully I haven't encountered such DBAs.


Yeah that is funny until you come across those DBAs. I have come across more than my share of them as well.



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


SQL RNNR

Posting Performance Based Questions - Gail Shaw

Jeff Moden
Jeff Moden
SSC-Forever
SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)

Group: General Forum Members
Points: 45137 Visits: 39923
SQLRNNR (3/3/2014)
phonetictalk (3/2/2014)
"I've encountered DBAs who seemed ill equipped to administer a home grocery list and checkbook"

This made me laugh out loud. Thankfully I haven't encountered such DBAs.


Yeah that is funny until you come across those DBAs. I have come across more than my share of them as well.


Out of the 20 or so "devleopers" and the 4 "dbas" I've interviewed in the last 2 years or so, only 4 (we got two recently) of the developers knew how to get the current date and time using T-SQL. None of the DBAs knew. Also, none of the DBAs knew the difference between a Clustered Index and a Non-Clustered Index nor how to do native backups.

According to their resumes, these are people that all claim to have at least 5 years of experience (most of the DBAs were closer to 10 years of experience) and all of the DBA resumes claimed expertise in "tuning queries".

I thought I'd get over being sick about it but these people have been working in what I believe to be some fairly critical companies. I don't know how they surived for as long as they did and I'm still sick about it because there are more like them out there taking "care" of medical records, payroll, etc, etc.

--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.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Wink

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
phonetictalk
phonetictalk
Old Hand
Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)

Group: General Forum Members
Points: 321 Visits: 1610
Jeff Moden (3/3/2014)
SQLRNNR (3/3/2014)
phonetictalk (3/2/2014)
"I've encountered DBAs who seemed ill equipped to administer a home grocery list and checkbook"

This made me laugh out loud. Thankfully I haven't encountered such DBAs.


Yeah that is funny until you come across those DBAs. I have come across more than my share of them as well.


Out of the 20 or so "devleopers" and the 4 "dbas" I've interviewed in the last 2 years or so, only 4 (we got two recently) of the developers knew how to get the current date and time using T-SQL. None of the DBAs knew. Also, none of the DBAs knew the difference between a Clustered Index and a Non-Clustered Index nor how to do native backups.

According to their resumes, these are people that all claim to have at least 5 years of experience (most of the DBAs were closer to 10 years of experience) and all of the DBA resumes claimed expertise in "tuning queries".

I thought I'd get over being sick about it but these people have been working in what I believe to be some fairly critical companies. I don't know how they surived for as long as they did and I'm still sick about it because there are more like them out there taking "care" of medical records, payroll, etc, etc.


That is quite frightening. Wow.

Leonard
Madison, WI
Louis Davidson (@drsql)
Louis Davidson (@drsql)
SSC Journeyman
SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)

Group: General Forum Members
Points: 83 Visits: 109
phonetictalk (3/2/2014)
"I've encountered DBAs who seemed ill equipped to administer a home grocery list and checkbook"

This made me laugh out loud. Thankfully I haven't encountered such DBAs.


That must be nice. It is clearly an exaggeration of sorts, poetic license if you will, but I agree with SQLRNNR and Jeff, there are plenty of people out there that are lucky SQL Server is such a solid platform these days.. A big crash and they would be out of a job (and hopefully not because their company no longer could exist)



Louis Davidson (@drsql)
Louis Davidson (@drsql)
SSC Journeyman
SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)

Group: General Forum Members
Points: 83 Visits: 109
jay-h (3/3/2014)
In a job that is, for the most part, worthy-but-dull, rather than the stuff of dreams

Most good jobs are like that. Glamor is transient, but the enjoyment of doing something well, regardless of the field, is what makes it rewarding.



The hardest part for me at times is taking a back seat to developers... All because our work is kind of hidden...

jay-h (3/3/2014)


BTW, I often suspect that can be a poor choice to choose a job that is also your hobby/passion. If you love photography, will you love it so much when most of your time is doing ad photos for Randy's car lot or filling weekend after weekend with schlocky weddings? If you love music, will it be so much fun when you've got to hit the Motel 6 lounge for your 4 nights a week gig, whether you feel up to it or not?



My next (or next next) blog is going to be at least somewhat about this very topic. I think it really depends on the person. I think there are a great deal of folks who are happy to sing for fun and work. You can tell those musicians that last the longest are doing it for fun. Elvis Costello often complains about the business, but just loves making music.

I know Tom LaRock has his rockstar blogger list (http://thomaslarock.com/rankings/) which I still barely make, but I personally have never wanted to be a rock star, since most of them flame out. I want to be a folk star. People who stay hungry for what they do and love it, are happy doing it during the day, and at night. But it has to come from a love of what you are doing, not just out of a sense that you "ought" to be spending tons of time, or even worse, out of "greed", where you are just pushing yourself to be great because you want to be amazing and make a boatload of money.

But if you can choose a job that overlaps with what you love to do, going to work will be just as much fun as going on vacation (other than meetings, managers, budgets and all of that... but hey, you do need to make a living)



GoofyGuy
GoofyGuy
SSC-Addicted
SSC-Addicted (409 reputation)SSC-Addicted (409 reputation)SSC-Addicted (409 reputation)SSC-Addicted (409 reputation)SSC-Addicted (409 reputation)SSC-Addicted (409 reputation)SSC-Addicted (409 reputation)SSC-Addicted (409 reputation)

Group: General Forum Members
Points: 409 Visits: 971
Lous Davidson wrote:

I've encountered DBAs who seemed ill equipped to administer a home grocery list and checkbook.

What surprises me is the number of DBAs these days who have very slender SQL skills. Once upon a time, long, long ago (when DB2 ruled the Earth), most DBAs possessed SQL knowledge which put that of nearly every developer in the shade. DBAs knew not just DDL forwards and backwards, but DML as well.

I'm not sure why that's changed, but changed it has.
Yet Another DBA
Yet Another DBA
SSC Veteran
SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)

Group: General Forum Members
Points: 204 Visits: 1207
Jeff Moden (3/3/2014)
SQLRNNR (3/3/2014)
phonetictalk (3/2/2014)
"I've encountered DBAs who seemed ill equipped to administer a home grocery list and checkbook"

This made me laugh out loud. Thankfully I haven't encountered such DBAs.


Yeah that is funny until you come across those DBAs. I have come across more than my share of them as well.


Out of the 20 or so "devleopers" and the 4 "dbas" I've interviewed in the last 2 years or so, only 4 (we got two recently) of the developers knew how to get the current date and time using T-SQL. None of the DBAs knew. Also, none of the DBAs knew the difference between a Clustered Index and a Non-Clustered Index nor how to do native backups.

....


I have interviewed people for DBA positions and have had them not knowing what a null is/ biggest query they have ever written being 25 lines/ not knowing about point in time recovery. So technically poor, but management wanting them because their people skills and we dont need brilliant DBAs because things dont go wrong..

I always prefer the person who seems genuinely interested in databases with a few holes in their knowledge than someone who has better knowledge and only wants to play with the latest whiz-bang toys
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