Monthly Archives: May 2014

MS Excel MVP Amsterdam Summit 2014

It’s been a busy few days! I’ve just returned from the European Excel MVP Summit hosted by Microsoft Netherlands in Amsterdam. It’s the second MVP Summit I’ve been to and this one was every bit as good as the Global … Continue reading

Posted in Microsoft Excel | Tagged | Leave a comment

FREQUENCY() Post Updated

I’ve updated an old post on counting distinct, unique and successive values using the FREQUENCY() function. I was participating on a thread over at Chandoo.org when an answer from Haseeb Avarakkan made me realise that my formula could be improved from: … Continue reading

Advertisement

Posted in Microsoft Excel | Tagged , , | Leave a comment

Enforcing Mutex On A SQL Server Database

I’ve been working on a project which involved several different components. These components had the potential to interact with a SQL Server database at the same time and  I had to come up with a way of ensuring that each … Continue reading

Posted in Microsoft SQL Server, Visual C# | Tagged , , | 3 Comments