Click here to Skip to main content
14,737,245 members
Home » Discussions » C#
   

C#

 
AnswerRe: How to use ISortable Pin
stancrm4-Aug-08 21:18
Memberstancrm4-Aug-08 21:18 
QuestionGraphicsPath Pin
cocoonwls4-Aug-08 19:32
Membercocoonwls4-Aug-08 19:32 
AnswerRe: GraphicsPath Pin
cocoonwls5-Aug-08 0:53
Membercocoonwls5-Aug-08 0:53 
AnswerRe: GraphicsPath Pin
mav.northwind5-Aug-08 2:57
Membermav.northwind5-Aug-08 2:57 
GeneralRe: GraphicsPath Pin
cocoonwls5-Aug-08 18:17
Membercocoonwls5-Aug-08 18:17 
QuestionBitshifting question Pin
threemp34-Aug-08 16:10
Memberthreemp34-Aug-08 16:10 
AnswerRe: Bitshifting question Pin
Mark Salsbery4-Aug-08 16:26
MemberMark Salsbery4-Aug-08 16:26 
GeneralI need to explain to our VP why trying to do everything in Stored Procedures is a bad idea [modified] Pin
Togakangaroo4-Aug-08 14:55
MemberTogakangaroo4-Aug-08 14:55 
Hi,I've got a doozy.
I am the only developer at a fairly large company with a very small IT department.
I was asked to write a small application (sends out notifications when contracts are about to expire - slightly more complicated than that.)
Our previous programmer had been in a word terrible, and since taking charge I had explained enough to my well-meaning but non-technical that he understands vaguely the benefits of OOP, doing things in a modern programming language, and library reuse. He came to me with a concern today - our VP, another well meaning guy but someone who hasn't programmed since the early days of COBOL - wants everything to be done in PL/SQL stored procedures to 'keep as much of our programming in one place' and to have 'fewer applications to maintain' (wtf, right?). My boss could not convince him otherwise and asked me to create a powerpoint presentation on the issue.


I am planning on the following slides:
Benefits of using a modern programming langauge:
Library Reusability (domain object libraires)
Maintenance Clarity
Maintenance Testing (automated tests)
Maintnenace People Cost (nobody programs in PL/SQL! where are they going to find people?)
Tools available (debuggers, etc.)
N-Tier Architecture
Why People Use Stored Procedures - for each one the premise, why its not exactly correct, and why it doesn't apply to us
--User authorizations to use certain ones (we have one user with all authorizations enabled)
--Speed (our bottleneck is overuse of ajax, plus its not really true)
--Security SQL/Injection (parameterized sql and sometimes our SPs build sql as text and then eval it - sigh)

Any advice for doing this presentation? I am really worried that if I have to do this in PL/SQL this is going to become a trend and I will have to quit.

modified on Monday, August 4, 2008 8:16 PM

GeneralRe: I need to explain to our VP why trying to do everything in Stored Procedures is a bad idea Pin
PIEBALDconsult4-Aug-08 18:15
professionalPIEBALDconsult4-Aug-08 18:15 
GeneralRe: I need to explain to our VP why trying to do everything in Stored Procedures is a bad idea Pin
N a v a n e e t h4-Aug-08 19:26
MemberN a v a n e e t h4-Aug-08 19:26 
GeneralRe: I need to explain to our VP why trying to do everything in Stored Procedures is a bad idea Pin
Mycroft Holmes4-Aug-08 21:31
professionalMycroft Holmes4-Aug-08 21:31 
GeneralRe: I need to explain to our VP why trying to do everything in Stored Procedures is a bad idea Pin
N a v a n e e t h4-Aug-08 19:28
MemberN a v a n e e t h4-Aug-08 19:28 
GeneralRe: I need to explain to our VP why trying to do everything in Stored Procedures is a bad idea Pin
Togakangaroo5-Aug-08 3:16
MemberTogakangaroo5-Aug-08 3:16 
GeneralRe: I need to explain to our VP why trying to do everything in Stored Procedures is a bad idea Pin
darkelv4-Aug-08 20:22
Memberdarkelv4-Aug-08 20:22 
GeneralRe: I need to explain to our VP why trying to do everything in Stored Procedures is a bad idea Pin
leppie4-Aug-08 21:07
Memberleppie4-Aug-08 21:07 
JokeRe: I need to explain to our VP why trying to do everything in Stored Procedures is a bad idea Pin
Harvey Saayman4-Aug-08 23:58
MemberHarvey Saayman4-Aug-08 23:58 
GeneralRe: I need to explain to our VP why trying to do everything in Stored Procedures is a bad idea Pin
PIEBALDconsult5-Aug-08 4:14
professionalPIEBALDconsult5-Aug-08 4:14 
GeneralRe: I need to explain to our VP why trying to do everything in Stored Procedures is a bad idea Pin
leppie5-Aug-08 4:56
Memberleppie5-Aug-08 4:56 
GeneralRe: I need to explain to our VP why trying to do everything in Stored Procedures is a bad idea Pin
Ashfield4-Aug-08 22:16
MemberAshfield4-Aug-08 22:16 
GeneralRe: I need to explain to our VP why trying to do everything in Stored Procedures is a bad idea Pin
PIEBALDconsult5-Aug-08 4:24
professionalPIEBALDconsult5-Aug-08 4:24 
GeneralRe: I need to explain to our VP why trying to do everything in Stored Procedures is a bad idea Pin
Ashfield5-Aug-08 9:26
MemberAshfield5-Aug-08 9:26 
GeneralRe: I need to explain to our VP why trying to do everything in Stored Procedures is a bad idea Pin
Guffa4-Aug-08 22:42
MemberGuffa4-Aug-08 22:42 
GeneralRe: I need to explain to our VP why trying to do everything in Stored Procedures is a bad idea Pin
PIEBALDconsult5-Aug-08 4:26
professionalPIEBALDconsult5-Aug-08 4:26 
GeneralRe: I need to explain to our VP why trying to do everything in Stored Procedures is a bad idea Pin
nelsonpaixao5-Aug-08 14:32
Membernelsonpaixao5-Aug-08 14:32 
QuestionHow to finalize an object with an internal Thread ? Pin
ofeririko4-Aug-08 12:38
Memberofeririko4-Aug-08 12:38 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.