Ted Cooper-351490 (5/8/2013)
Awesome delivery. Great problem and solution. Would like to see a solution generating PDFs with barcodes.To the nay sayers with compaints about processing and security I say, get over it! If the software can do it, let it be done.
If you can't keep your database secure, don't keep a secure database.
If you can't process some extra CPU cycles, then get another CPU! The cycles have to go somewhere right? Shall we ask about the overhead of running it through SQLCLR? Run it through a SQL Express instance CLR assembly somewhere else?
Excellent article, topic and discussion. Thanks.
BWAAA_HAAA!!!! The only thing I don't like about this article (I don't really care for SQLCLR because of the abuse that has been heaped upon it but will tolerate good stuff. I'd have to test the stuff in the article, of course!:-D) is that the script turns xp_CmdShell and Ole Automation Procedures off instead of checking to see if they were on to begin with. Not all of us suffer the delusion that having these things turned off provides any more than a 3ms hurdle that a potential attacker is already prepared to jump. Doesn't anyone realize that only those with "SA" can run these things (well, unless someone was dumb enough to grant privs to individuals through proxies)?
--Jeff Moden
Change is inevitable... Change for the better is not.