Mike,

No one said that the logic to determine whether or not the trader was qualified for a margin account wouldn't also be represented in the database. As a matter...

Agreed... I think I'll go have some now. We have our Boston-area "geek dinner" tonight

http://nerddinner.com/blogs/boston/archive/2005/08/17/6816.aspx

One of the main points of my talk is to implement encapsulation and think of stored procedures as black-box APIs

Peter,

You going to be at PASS? We clearly need to have a beer

It's not about trusting a team, or teamwork, or anything like that.

It's about the fact that we're all human. I don't trust developers, DBAs, management, or even myself, to...

Do you trust the developers that will be working on the application next year?

Do you trust the outsourced developers that your company is going to hire in two years?

Do you...

They're the same thing. A business rule is a data validation rule if the business is represented in the form of data.

Example: Client X has been approved for...

I see no reason that your example would require more than one stored procedure. You should be able to encapsulate that logic -- somehow -- so that it's data-driven...

Actually, that's exactly correct!

These rules are none of the application's business. The application shouldn't rely on them in any way (that is to say, the application should trust the...

Buy more boxes. How much is your business worth if your data is trash?

If your "business logic" is changing on an application-by-application basis, it is not business logic. It's application logic. Which does not belong in the database.

Business logic -- logic...

Some of these issues can be addressed using TSQLMacro, a project I created a while ago:

http://www.datamanipulation.net/tsqlmacro

One specific group of problems I thought of is centralization of commonly-used bits of...

Huh? Who needs to understand the game? Drink enough beers and it comes naturally... At least, that's how we do it in Boston

I agree with Steve, but I guess it could depend on your definition of "server." A server can mean either a physical computer ("the server"), or a piece of...

Can you talk about what you did to actually test the product? What kind of environment did you run it in? What results did you see?