fregatepllada (9/11/2014)
halifaxdal (9/5/2014)
Nice article and nice experiment, but unfortunately from security perspective I am not able to even give the needed SQL# a try simply because SQL# has lots highly restricted features like CLR, Assembly, ...
Like I said you could this in COM way without enabling CLR in your SQL Server;-)
http://stackoverflow.com/questions/15523789/sql-email-verification-function-using-regex%5B/quote%5D
But then you still have to enable 'OLE Automation', which is obsolete, slower, and less secure than 'CLR Integration'. And the user needs to be in the sysadmin server role. I am not sure of there being any benefit to using the sp_OA* functions, nor do I suspect that any company concerned about "security implications" of CLR would be ok with enabling the OLE Automation stuff.
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR