I'm not a fan of SISS or 2005 or Microsoft in general as they seem to find ways to increase development time and frustrate developers with each new incarnation of their development environments. This is why I love me some ColdFusion and Oracle. Luckily our Oracle DBA is part of the development team unlike the DBAs for our SQL servers 2000 and 2005 which is really just part of their broader LAN admin role.
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 11:07 AM To: [email protected] Subject: [houcfug] Re: Help with an issue 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]<mailto:[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 [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]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Aaron Rouse Sent: Tuesday, December 16, 2008 10:15 AM To: [email protected]<mailto:[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. ________________________________ 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>>
