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

Shawn Wildermuth
Author, Teacher, and Coach

My Courses

Wilder Minds Training
Vue.js by Example (New Lower Price)
Bootstrap 4 by Example (New Lower Price)
Intro to Font Awesome 5 (Free Course)
Building an API with ASP.NET Core (New Course)
Building a Web App with ASP.NET Core, MVC6, EF Core, Bootstrap and Angular (updated for 2.2)
Less: Getting Started (New)
Using Visual Studio Code for ASP.NET Core Projects
Implementing ASP.NET Web API

Application Name WilderBlog Environment Name Production
Application Ver v4.0.30319 Runtime Framework x86
App Path D:\home\site\wwwroot\ Runtime Version .NET Core 4.6.27817.01
Operating System Microsoft Windows 10.0.14393 Runtime Arch X86