Quote:

And now I'm taking a SQL Server 2000 programming course and M$ own best practice (take that for what it's worth) says "Business Logic should be in the database". Conisder the source, though.



Did whoever told you that provide some authoritive proof that that is Microsoft's own best practice ?

I'm sure it was there best practice a few years ago, but every indication from them over the last few years (for example from their recent sample code) leads me to believe that their position has shifted.

Quote:

2. The database will likely be SQL Server 2005
4. Our team is quite inexperienced with T-SQL.



One interesting thing to note is that with SQL Server 2005 you can use C#, VB.NET and other .NET managed code instead of T-SQL for stored procedures. I haven't used it yet, so I have no idea how well it performs.

http://www.codeproject.com/cs/database/CLR_Integration.asp

Of course using managed code stored proceedures is the perfect way to lock yourselves into Microsoft's database forever...

And for the record, no the database is typically not the right place for business logic.


Edited by andy (13/12/2005 04:30)
_________________________
Remind me to change my signature to something more interesting someday