Welcome to EMC Consulting Blogs

I have a requirement, for service broker endpoints and queues, to automate the creation of a certificate on one server and load them up on another.  The manual way of doing this is something like this: 1. Use CREATE CERTIFICATE to create a self signed certificate, something like: CREATE CERTIFICATE SomeCertificateA WITH ...

I wrote an article for the September 2006 issue of SQL Server Standard magazine:   The version that was finally published was a very cut down version with minimal code snippets.  This was for obvious reasons; they had to fit the content onto small columns in the magazine.  For the readers who would prefer the more verbose ...

There is some literature out there that says it is possible to impersonate the current user’s logon for external access (file system, registry, etc.) in SQL/CLR sprocs, but not much in the way of sample code.  As I have crossed this bridge, I thought I should share the knowledge.  This now works with assemblies catalogued as ...