RE: DBA's that tune duhveloper's SQL

I have to agree.

Here's my usual:

1. What is wrong with X statement?
2. Given Y ERD, how do I get z query result?
3. Normalize j model.
4. Explain transactions. Why are they important, and what do they provide?

> -----Original Message-----
> From: Stephane Paquette [mailto:stephane.paquette_at_standardlife.ca]
> Sent: Tuesday, April 15, 2003 7:09 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: DBA's that tune duhveloper's SQL
>
>
> Jared,
>
> You really ask about Codd, Date and the 12 rules for
> developpers ? That's a hard screening.
>
> I thought I was tough by asking about dynamic sql and the 3
> first normalization forms.
>
>
> Stephane
>
> -----Original Message-----
> Jared.Still_at_radisys.com
> Sent: Monday, April 14, 2003 8:04 PM
> To: Multiple recipients of list ORACLE-L
>
>
> On the contrary.
>
> The only developers we currently have are for Lotus Notes.
>
> The last couple rounds of interviews for developers, I have
> not been able to find a single one that knew:
>
> * who Date or Codd are
> * had heard of the 12 rules that the perfect RDBMS must
> enforce ( also by Codd )
> * bind variables . In defense of a couple of them, they knew the
> concept.
>
> Several of them had a hard time with
>
> * normalization
> * writing simple SQL statements requiring a 2 way join
>
> When I say simple, I mean that given the definitions of 2
> tables and a requirement, some could not come up with:
>
> select e.name, e.dept
> from emp e, dept d
> where e.dept = d.dept
>
> All were MS weenies.
>
> Now we get to go through it again.
>
> I'm going to be more demanding this time.
>
> Jared
>
>
>
>
>
>
> Paula_Stankus_at_doh.state.fl.us
> Sent by: root_at_fatcity.com
> 04/14/2003 01:13 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> cc:
> Subject: RE: DBA's that tune duhveloper's SQL
>
>
> Lucky you Jared. Apparently you haven't had to deal with
> some of the new breed of developers that don't understand RI,
> write their COTS packages in their garage using SQL Server
> then automagically expect it will scale. I think it must be
> a matter of the organization you work for. If you are lucky
> enough to work for one that is willing to pay well for good
> developers and to train them and keep them - God Bless Ya.
> If your not - don't feel bad - you are not alone and you are
> definitely picking up some good skills in tuning SQL. Oracle OCP DBA
>
> -----Original Message-----
> Sent: Monday, April 14, 2003 2:44 PM
> To: Multiple recipients of list ORACLE-L
>
> Deborah,
> The problem is that you are working with a duhveloper.
> DBA's don't generally need to tune a developers code.
> Jared
>
>
>
>
>
> "IT - Database (Do Not Use)" <dbamail_at_police.edmonton.ab.ca>
> Sent by: root_at_fatcity.com 04/14/2003 10:29 AM Please
> respond to ORACLE-L
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> cc:
> Subject: DBA's that tune duhveloper's SQL
>
> We have a consultant doing some work at our site and he
> claims that in most shops the DBA's have the responsibility
> of tuning duhvelopers code. I
>
> find that hard to believe. I was wondering if maybe I am out
> of touch.....do most of you also tune all your duhvelopers
> code??? I can see
>
> working together with them if there are issue but have the
> responsibility of tuning all developer code....EGAD when
> would I have time to be a DBA. ;
>
> )
> Deborah Csongradi OCP
> Senior Database Administrator
> Edmonton Police Service
> Office: (780) 421-3567
> Fax: (780) 421-3363
> "Desire is the starting point of all achievements. Not hope;
> not wish, but
>
> a keen pulsating desire which transcends everything."
> CONFIDENTIALITY CAUTION: This message is intended only for
> the use of the individual or entity to which it has been
> addressed and may contain information that is privileged
>
> and confidential. If you are not the intended recipient, or
> the employee or agent responsible for delivering the message
> to the intended recipient,
>
> you are hereby notified that any dissemination, distribution
> or copying of
>
> this communication is strictly prohibited. If this
> communication has been
>
> received in error, respond immediately via telephone or
> return e-mail, and
>
> delete all copies of this material.
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: Jared.Still_at_radisys.com
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> and in the message BODY, include a line containing: UNSUB
> ORACLE-L (or the name of mailing list you want to be removed
> from). You may also send the HELP command for other
> information (like subscribing).
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: Jared.Still_at_radisys.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> and in the message BODY, include a line containing: UNSUB
> ORACLE-L (or the name of mailing list you want to be removed
> from). You may also send the HELP command for other
> information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Stephane Paquette
> INET: stephane.paquette_at_standardlife.ca
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> and in the message BODY, include a line containing: UNSUB
> ORACLE-L (or the name of mailing list you want to be removed
> from). You may also send the HELP command for other
> information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeremy Pulcifer
  INET: Jeremy.Pulcifer_at_kadiri.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).