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.
I worked on a project that made moderate use of this. Worked alright; biggest problem was convincing DBAs/IT to enable it.
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