SQL Server has a lot of features, functions, and power.


One of the little used but highly useful features is called SQL Server CLR.


This allows one to write a C# DLL program that can be called by a SQL Server function to do custom data transformations.

This is one I wrote that decodes JSON automatically.

Highly useful!

And runs great in multiple production environments!