Welcome to EMC Consulting Blogs

Browse by Tags

• .NET
• Azure
• C#
• Cloud
• cloud computing
• Data Access
• Database
• SQL Server
• SQL Server 2008
• User Group

• Catfax – SQL CLR, WCF and Windows Azure

  In future, more and more solutions will have data that is not stored directly in a SQL database but rather in cloud EAV (Entity Attribute Value) data stores, caches, client storage, document databases and so on.  Usually it is the existing DBA’s Read More... Posted 08 July 2009 20:50 by simon.munro | 1 Comments Filed under: SQL Server, Data Access, SQL Server 2008, SQL CLR, Azure, Cloud, cloud computing, Database

• DBA Baiting

  Jamie and I gave presentations last night at the London SQL Server users group.  It was a good evening but I think I managed to upset about half the people there.  I suppose when your first two slides are these… …then you can expect a bit of Read More... Posted 22 May 2009 12:08 by simon.munro | 2 Comments Filed under: SQL Server, User Group, SQL CLR, Azure, cloud computing

• 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 Read More... Posted 12 December 2008 17:33 by simon.munro | 0 Comments Filed under: SQL Server, C#, SQL Server 2008, SQL CLR, .NET

• 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 Read More... Posted 12 November 2008 17:13 by simon.munro | 1 Comments Filed under: SQL Server, C#, Data Access, SQL CLR