Martin Reid
mwp.reid at qub.ac.uk
Sat Nov 11 12:32:50 CST 2006
Happy Birthday Arthur. As you know someoen with 6 children would never see a stack of notes so unable to grant your wish (<: Funny just working on a design and for the first time I will be using three tiers. Classes for the Data (Thanks to JC) a business logic tier and .NET presentation. Well actually .NET for the whole thing. Should be interesting as I have done none of this before. But in general I would agree with you. As much as possible on the server in the form of SPs and UDFs etc. Martin Martin WP Reid Training and Assessment Unit Riddle Hall Belfast tel: 02890 974477 ________________________________ From: dba-sqlserver-bounces at databaseadvisors.com on behalf of artful at rogers.com Sent: Sat 11/11/2006 17:43 To: dba-SQLServer Subject: [dba-SQLServer] Front-End or Back-End or Middle-Tier Solutions As my birthday approaches, I like to revisit one or two cherished assumptions and call them into question. Sometimes I learn something new, sometimes I just confirm the assumptions. For as long as I've been involved with databases that allow sprocs and UDFs, I have held the cherished belief that everything the back-end can do, the back-end should do. But I am aware that a lot of folks don't agree with this, and it's not because they're fools. I even know one seasoned DBA who lives at the other end of the spectrum on this argument -- he designs databases to contain the absolute minimum required. He uses Referential Integrity of course, and stored procedures, but anything remotely resembling business logic (that is, anything other than select, insert, delete, update) he believes should reside in either the middle tier or the front end, and anything remotely resembling presentation should reside in the front-end. As an example of the latter, he says crosstabs (or PIVOTs in SQL 2005 lingo) should not be done in the back end, but rather left up to the front end. I'm wondering where you listers stand on this spectrum. Incidentally, my 59th birthday is November 15. Large stacks of currency will be gratefully received. Arthur _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com <http://www.databaseadvisors.com/>