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....

Application Name WilderBlog Environment Name Production
Application Ver Runtime Framework .NETCoreApp,Version=v1.1
App Path D:\home\site\wwwroot Runtime Version .NET Core 4.6.25211.01
Operating System Microsoft Windows 6.2.9200 Runtime Arch X86