Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to control developers writting better SQL

Re: How to control developers writting better SQL

From: Steven Hauser <hause011_at_garnet.tc.umn.edu>
Date: 31 Oct 2000 11:24:00 -0600
Message-ID: <8tmv7g$64r$1@garnet.tc.umn.edu>

It seems to me that software engineering is more the subject of this thread.

What engineering techniques can be used to make good systems? Well, read a book or two and check out people who successfully develop code.

Some basics that never fail to amaze:
SEPARATE DEVELOPMENT FROM PRODUCTION SYSTEMS. Yeah, basic, but many do not do this at all.

USE CONFIGURATION MANAGEMENT. Source code control and methods of packaging and moving code from development to production. Again, elemental and many times ignored.

REVIEW AND TEST CODE. Many times never done. Specific techniques for databases are easily figured out. Check the optimizer, trace, time, lock contention, etc. Review code by others, not one developer, test by others not the person who wrote the code.

Many people think they are above such mundane techniques and think they are too special and talented to be "constrained". They usually leave broken systems and cost overruns in their wake.

Chaos can create chaos. I call that chaos theory.

-- 

---------------------------------------------------------
Steven Hauser email: hause011@tc.umn.edu URL: http://www.sofbot.com/
---------------------------------------------------------
Received on Tue Oct 31 2000 - 11:24:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US