Welcome to EMC Consulting Blogs

October 2008 - Posts

• XML Shredding, Hashing and Binary Conversion in SQL 2008

  I have a requirement to move data between two databases, but before sending all the data we want to compare the rows that are needed first.  So the implementation calls for the generation of a hash of important (but not necessarily key) fields in Read More... Posted 30 October 2008 10:48 by simon.munro | 0 Comments Filed under: SQL Server, XML, SQL Server 2008

• The People-People Impedance Mismatch

  I can picture a scene in the early nineties... Programmer:  "Look at this cool app, it is written 'Object Oriented'" Manager: "I see. But it doesn't seem to do much" Programmer: "Yes, but... it has objects, polymorphism, Read More... Posted 26 October 2008 21:08 by simon.munro | 3 Comments Filed under: People, Data Access

• Comparing Arrays with LINQ

  I needed to compare the contents of two arrays to see if they were the same.  Obviously Equals won't work because they are different objects and although it would be easy enough to write a little routine to iterate through the arrays I thought that Read More... Posted 23 October 2008 09:41 by simon.munro | 2 Comments Filed under: C#, LINQ

• I Suck at Mushroom Management

  With all the gravity of putting things out onto the Internet and never being able to take them back, I have made my proclamation that I have a management weakness - an almost complete inability to be able to mushroom manage with any degree on competence Read More... Posted 20 October 2008 17:08 by simon.munro | 3 Comments Filed under: Delivery, Project Management, Agile

• Brokering Innovation in SQL Server

  Here <<removed>> are my slides and source code for the London SQL Server User Group Meeting on the 16th October and thanks to everyone who attended and the positive feedback. Remember that if you are downloading these files after attending Read More... Posted 16 October 2008 15:29 by simon.munro | 7 Comments Filed under: SQL Server, User Group