[laudable-logic]

Maybe sorta off-topic, but does anybody have any stories to tell about successes/fails with the .NET CLR in MSSQL?

I worked on a project that made moderate use of this. Worked alright; biggest problem was convincing DBAs/IT to enable it.

https://en.m.wikipedia.org/wiki/SQL_CLR

[somurzakov]

I can't think of an example where CLR integration would be beneficial.

Probably integrating ML model inference, written in ML.NET could be use case, but we have SQL with ML Server with r/python support now, so.

The problem with CLR is that you need to know and understand sql engine internals in order to write good C# code for CLR integration, otherwise your clr code will be blocking the sql engine