Stored procedures are great as you don't have to alter your ColdFusion code at all when you want to update how something is processed (database wise) in your system. They are also great for importing data from other systems using things like DTS packages since all of the control logic for creating and updating records in your system are stored at the database level. Of course one could argue that importing data via XML and web services is a superior method.
Our DBAs don't write SQL. At least not for the applications and systems we develop. We will have them create the database on one of our servers in order to setup all of the maintenance routines they like, but the full database design is at the Analyst / Programmers disposal because design of tables, functions, and stored procedures are at our level and not an administrative level. The Administrator part of a DBAs title seems to imply that he will administer your database instead of providing a means of slowing down your progress like a government level paper work style administrator, heh. Kier Simmons Analyst/Programmer [cid:[email protected]]<http://www.giveblood.org/> Phone: 713-791-6619 Toll Free: 1-888-482-5663 Fax: 713-791-6681 www.giveblood.org<http://www.giveblood.org/> ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Aaron Rouse Sent: Tuesday, December 16, 2008 10:15 AM To: [email protected] Subject: [houcfug] Re: Help with an issue I have worked with a lot of Oracle DBAs over the years and not to toot my own horn but I can say with 100% confidence that I wrote far better SQL than any one of them were capable of. I am sure there are ones that are tons better than I, but my experience thus far has been that the DBAs are good at keeping the databases up and going but not good at all at writing SQL. On Tue, Dec 16, 2008 at 10:01 AM, Robert L. Stewart <[email protected]<mailto:[email protected]>> wrote: Shane, Sounds like you have had bad experiences with DBA's. I am sorry about that, but, doing stored procedures is the better way to go. Yes, it is sometimes faster to circumvent going through the DBA. if there is one, for things. But, they are a specialist like you are for CF. Generally, they can write better SQL that you or another CF programmer. It is their job. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [email protected] For more options, visit http://groups.google.com/group/houcfug?hl=en -~----------~----~----~----~------~----~------~--~---
<<inline: image001.gif>>
