Gary Varga (10/23/2014)
Yet Another DBA (10/23/2014)
...Just as well .Net assemblies can be added to SQL it gets over a lot of problems.Not sure that I like the thought of being forced to enable and use CLR assemblies to fix T-SQL. It seems like a risky work around. Possibly valid or rather valid work around in some circumstances but it does increase the surface of attack.
True, but this sort of thing can be declared as SAFE which keep the risks to a minimum. Some DBAs I have worked with will never enable this type of thing on the grounds that they dont understand what is in the assemble. Not that they query what is in a service pack, or review all the TSLQ code that goes into the database.