• goodguy (11/8/2010)


    I believe that programmers, especially freelancers like me, need to embrace basic sql admin skills in order to leverage their output. The reason they have not done so so far is NOT that they can't be bothered, BUT rather that they DO NOT KNOW where to start. They dont know if a simpler, easier way exists for acquiring these skills.

    That is why I asked if we could get an abridged lesson covering the important topics in moderate detail.

    Hrm, you have a point there. I would think, however, that instead of an abridged lesson, you would be better off with an abridged lesson plan. Something that would highlight what was important, a brief blurb of why, and then some dicussion, or links, to those who have already said what needs to be understood well.

    For the record, in defence of programmers, I have to say that while DBAs are expert at administering and maintaining database servers, few of them would have comparable skills in database design/development, which remains a forte of teh best programmers. So, we are not complete dunderheads in the world of databases.

    In terms of database design, I would have to disagree heavily here. Most front end developers code (nowadays, anyway) to the object oriented structures they carry through the code. These iterative structures are usually horribly de-normalized to the database mentality. It was worse 'back when', when I saw tables dedicated to a web/app page. While you may not be a dunderhead ( :w00t: ) and the folks you have in mind aren't, I've ran into many that were. The design was logical, sound from their perspective, connected into views intelligently... and made me cry from a database design perspective.

    So... no, I must disagree with you that design and development at the database level remains a forte of 'the best programmers'. The average Database developer (DBA, since they get thrown into that role, too) has done, on average, a better job then all but the best of the application developers I've seen. This is, of course, my experience. I've contracted at about 16 companies at this point in the last 8 years, however, so I feel I've got some breadth there. At the same time, I've gotten a bit of a reputation with a few firms as a firestomper, so I may be seeing more than my fair share of horrible designs. 😀


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA