There is no Esri ST_GEOMETRY implementation in SQL-Server because Microsoft does not support
the ability to create 3rd-party SQL language extensions (aka "blades", "extenders", "cartridges").
If it were technically feasible, it would likely have been done.
Please do not double-post.
- V