Welcome to EMC Consulting Blogs Sign in | Join | Help

Browse by Tags

All Tags » c# » SQL CLR
  • Getting SQL Certificates Directly from the Database

    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 ...
    Posted to Simon Munro (Weblog) by simon.munro on December 12, 2008
  • Digging in the SQL CLR Litterbox

    When the SQL CLR, a technology enabling .net assemblies to be called from within SQL Server, was released in 2005 a collective gasp went up from DBAs all around the world.  And rightly so, the idea that developers would be writing rogue little .net apps than run inside the database is worrying - DBAs wouldn't be able to scrutinise the code ...
    Posted to Simon Munro (Weblog) by simon.munro on November 12, 2008
Powered by Community Server (Personal Edition), by Telligent Systems