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:

  1. Stored Procedures/Functions where T-SQL falters; like string manipulation or computationally intensive code.
  2. Managed User Defined Types for small pieces of data that would be helped with behaviors (SqlMethods).
  3. Custom Aggregations: Writing your own MIN/MAX/COUNT.  This is huge IMHO.

I want to thank everyone who attended....

Comments:

Great Presentation. I learned a lot more in that concise presentation than I have in the last few weeks of experimenting with VS 2k5 - Yukon/SQL 2k5.

-E
http://www.cyanbane.com

Cyanbane (Posted Tuesday, April 12, 2005 )

Yep - good info. BTW to answer my own question, I did some quick tests today, and yes you can access embedded assembly references from a SQL assembly even under the "SAFE" permission level. One thing it *doesn't* like however is to have updateable static properties... so you can't do things like caching or singleton-based stats without using "UNSAFE" permission level. Bummer.

Keith Rome (Posted Tuesday, April 12, 2005 )

Really sorry to miss that meeting Shawn. Wedding planning + a million interviews slammed me. Bummer, maybe you'll give it again sometime for another group?

Paul Lockwood (Posted Tuesday, April 12, 2005 )


 



 
Save Cancel