This is an email I wrote recently.
SUBJECT: this is worth a reread it might help with the whole zero downtime issue
I think that a more normal DB and an ORM layer will make stored procedures obsolete except for some rudimentary functions. But it’s still going to take some discipline along with some deep acceptance and understanding.
However one thing I have discovered about “things:
The internet became one of the great equalizers where anyone can profess to be as smart as Date, Coad, Yordon, Knuth and few will disagree.
I’ve also learned that Scrum, Kanban, and particularly Agile are also great equalizers. The team has a set point and all members have equal say. Even the most junior and uninformed members can significantly lower the set point.It was in response to a comment made my a college student in response to a comment I had posted. The student tried to impose his opinion; not because he know more or had some clear and concise, non-subjective point… but because he said so.