Fun night with Atlanta MDF
Just got back from presenting at the Atlanta MDF User Group (SQL Server et al for those not in the know). I had a blast talking about hte SQL Server 2005 CLR Integration. The presentation is available at my site here.
One first theme came out of the night: “The CLR Integration is just another tool. Please don’t push your business objects into the database…”
So to sum up what I said at the talk. In my opinion, there are several sweet spots for CLR code to be used in the datbase:
- Stored Procedures/Functions where T-SQL falters; like string manipulation or computationally intensive code.
- Managed User Defined Types for small pieces of data that would be helped with behaviors (SqlMethods).
- Custom Aggregations: Writing your own MIN/MAX/COUNT. This is huge IMHO.
I want to thank everyone who attended…