Andres Aguiar's Weblog

Just My Code

SQL Server Yukon - Why put logic into the database?

At last, someone from Microsoft who is brave enough to suggest that putting the business logic in the database may be a good option in some scenarios.

The idea that all the work MS is putting in Yukon/CLR integration is just to write UDTs and UDFs, or 'things that cannot be written in T-SQL', like encyrption, does not make a lot of sense.

Posted: Mar 17 2004, 10:44 PM by aaguiar | with 4 comment(s)

Comments

Kent Tegels said:

While I agree with you that that it's a good thing to see it written about, I'm not going to rush to do it. Let see how things actually pan out first in terms of sustainability, patterns and practices before we put all of our eggs in one basket, ok?
# March 17, 2004 11:26 PM

TrackBack said:

You have been Taken Out! Comments about your posting in this link. Thanks!
# March 18, 2004 9:05 PM

Doug Reilly said:

I think if there is a Yukon MSDE version, it will replace a whole class of Windwos services I have created in the past to do things like monitor the network, run updates, etc.
# March 19, 2004 9:05 AM

Bauq said:

Agree. Sometimes it makes sense to do so.
# April 30, 2004 5:41 PM