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

Building a Web App with ASP.NET Core, MVC6, EF Core, Bootstrap and Angular (updated for 2.0)
Using Visual Studio Code for ASP.NET Core Projects (new)
Implementing and Securing an API with ASP.NET Core
Building a Web App with ASP.NET Core, MVC6, EF Core and AngularJS
Building a Web App with ASP.NET5, MVC6, EF7, and AngularJS (Retired)
Best Practices in ASP.NET: Entities, Validation, and View Models
Webstorm Fundamentals
Front-End Web Development Quick Start
Lessons from Real World .NET Code Reviews
Node.js for .NET Developers

Application Name WilderBlog Environment Name Production
Application Ver Runtime Framework .NETCoreApp,Version=v2.0
App Path D:\home\site\wwwroot\ Runtime Version .NET Core 4.6.26020.03
Operating System Microsoft Windows 10.0.14393 Runtime Arch X86