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 ...

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 ...

As the PCD2008 hangovers wore off the announcements of the week were overshadowed by the apparent axing of LINQ to SQL.  It all started with a post by Tim Mallalieu, where he stated : We’re making significant investments in the Entity Framework such that as of .NET 4.0 the Entity Framework will be our recommended data access solution for ...