I am always a little surprised to see people using DTS still with SISS out there. Then of course every time I have to do something on the few projects I am using MSSQL with then I tend to gripe at SISS and wondering why did it have to get so overcomplicated for what I am wanting to do. :) At one point in time we had to actually provide SQL scripts to our DBAs to do anything at all in our projects that used Oracle. The only thing the DBA did, in regards to each application, was create the username and password then ran the SQL scripts for us in the production environment. If a script failed all you got back was a note saying it failed with maybe the Oracle error. Now days it has "improved" we just run the scripts ourselves in the production environment.
On Tue, Dec 16, 2008 at 10:53 AM, Kier Simmons <[email protected]>wrote: > 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 > <http://www.giveblood.org/> > > Phone: > > 713-791-6619 > > Toll Free: > > 1-888-482-5663 > > Fax: > > 713-791-6681 > > 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]> 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. > > > > ------------------------------ > This e-mail message and any files transmitted with it are confidential > and intended solely for the use of the individual or entity to which > they are addressed. If you are not the intended recipient or an > authorized representative of the intended recipient, you are hereby > notified > that any review, dissemination, or copying of this message and its > attachments or the information contained herein is prohibited. If you have > received this message in error, please notify the sender by return > e-mail and delete this e-mail message from your computer. Thank you. > > > > -- Aaron Rouse http://www.happyhacker.com/ --~--~---------~--~----~------------~-------~--~----~ 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>>
