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


DBAs Need to Learn to Develop


DBAs Need to Learn to Develop

Author
Message
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36242 Visits: 18751
Comments posted to this topic are about the item DBAs Need to Learn to Develop

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
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: 45241 Visits: 39927
Considering the "DBAs" that I've interviewed in the last six months, I'd say they shouldn't take the time learning more about development... they should first learn how to be a bloody DBA. Blink

--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
Gary Varga
Gary Varga
SSCrazy Eights
SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)

Group: General Forum Members
Points: 8374 Visits: 6161
There are too many people in the technical side of IT who do not have a foundation in IT knowledge. We should all understand binary, logic, declarative programming, functional programming, distributed systems etc. The level of understanding depends upon what role(s) we need to perform but we must all have a broad understanding of the basics.

Oh, and Jeff, too true Crazy

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Dalkeith
Dalkeith
SSC-Enthusiastic
SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)

Group: General Forum Members
Points: 162 Visits: 1105
Absolutely all Developers should have a clear understanding of primary and foreign keys and the idea of relationships between tables and how the differences between different query types. ( I used to take this as given )

Likewise DBAs would benefit from a solid understanding of how FKIDs work in things like Combi Boxes and how subtle changes in UI design can massively improve the usability of their databases and how often users need multiple views of the same information. Also how important it is to the user of responsive design.

We've recently bought a system and when you edit a record it performs a delete and create ON the SQL record wiping the PKID on the header record. A complete pain in the a*** this is designed in through lack of forethought by the developer. Technically its not an error its just the wrong design. They just assumed we were never going to try and relate that record to another table.
joe.eager
joe.eager
Valued Member
Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)

Group: General Forum Members
Points: 54 Visits: 467
Dalkeith (1/7/2014)
Absolutely all Developers should have a clear understanding of primary and foreign keys and the idea of relationships between tables and how the differences between different query types. ( I used to take this as given )

DBAs would benefit from a solid understanding of how FKIDs work in things like Combi Boxes and how subtle changes in UI design can massively improve the usability of their databases and how often users need multiple views of the same information. Also how important it is to the user of response design.

We've recently bought a system and when you edit a record it performs a delete and create ON the SQL record wiping the PKID on the header record. A complete pain in the A*** this is designed in through lack of forethougth by the developer. Technically its not an error its just the wrong design. They just assumed we were never going to try and relate that record to another table.


I've seen a few systems that do things like that. More often than not it comes from an ORM approach with a developer not wanting to understand database development
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: 45241 Visits: 39927
Gary Varga (1/7/2014)
There are too many people in the technical side of IT who do not have a foundation in IT knowledge. We should all understand binary, logic, declarative programming, functional programming, distributed systems etc. The level of understanding depends upon what role(s) we need to perform but we must all have a broad understanding of the basics.

Oh, and Jeff, too true Crazy


Ohhhh... don't get me started. :-) You said "binary" and "logic". I think that Computer Science and similar degrees should require folks to take a "hand assembled machine language programming" course in the first year and be bounced from the program if they don't get at least a 3.5. They should also have to "three five" a course in technical writing and communication skills.

--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
BJ Hermsen
BJ Hermsen
SSC-Addicted
SSC-Addicted (487 reputation)SSC-Addicted (487 reputation)SSC-Addicted (487 reputation)SSC-Addicted (487 reputation)SSC-Addicted (487 reputation)SSC-Addicted (487 reputation)SSC-Addicted (487 reputation)SSC-Addicted (487 reputation)

Group: General Forum Members
Points: 487 Visits: 880
I think that a DBA can benefit significanlty having developer skills much like I think a developer can benefit significantly having DBA skills. I do however believe strongly that they should be more focussed on their actual role and use the ansillary skills as a perk\benefit not a dependency. You can always interact better with other folks if you can understand their perspective a bit.

I would be lost without the small dev abilities I have.

I do however think that more emphasis should be placed on communication, troubleshooting and research. A certified DBA has proven one thing to me. They can read and recite a book. While I know some will find that comment insulting, that is all that is required to pass a test. Now that does not mean that all certified DBAs read a book to take the test. Some may have adequate experience only to be able to pass however that is likely slim. Certifying on a platform validates that you have a baseline of knowledge to improve upon your skills of troubleshooting, research and communication. A quality DBA can be more nimble with better skills at learning and reacting to new situations on the fly than knowing a discreet list of answers. Development skills simply build the portfolio of background abilities and though processes.
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36242 Visits: 18751
Jeff Moden (1/6/2014)
Considering the "DBAs" that I've interviewed in the last six months, I'd say they shouldn't take the time learning more about development... they should first learn how to be a bloody DBA. Blink


For sure, but that doesn't mean they shouldn't also learn development skills after.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
eccentricDBA
eccentricDBA
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1595 Visits: 1335
I agree that a DBA should learn how to develop. At the very least they should learn how to use a scripting language (dos batch, bash, cscript, vbscript, perl, powershell). The goal of a DBA is to have a consistent repeatable environment and having the ability to write enough code to automate that process only helps to make you a better DBA.
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: 45241 Visits: 39927
eccentricDBA (1/7/2014)
I agree that a DBA should learn how to develop. At the very least they should learn how to use a scripting language (dos batch, bash, cscript, vbscript, perl, powershell). The goal of a DBA is to have a consistent repeatable environment and having the ability to write enough code to automate that process only helps to make you a better DBA.


You left out the most important scripting language of them all for a DBA... T-SQL. I'm shocked and mortified at the number of people that have "DBA" on their resume that can't do a simple joined update.

--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
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