Welcome to EMC Consulting Blogs

April 2009 - Posts

• Installation order for Visual Studio 2008 SP1, Team Explorer and SQL Server 2008

  FYI Yesterday I received a new hard drive for my laptop and, as is customary, spent a long lonnnng time installing lots of software onto it. Everything was going well until I came to install SQL Server 2008 developer edition which refused to begin installation Read More... Posted 23 April 2009 13:18 by jamie.thomson | 2 Comments

• Normaliser Component v2 : SSIS

  About 18 months ago I made available a custom SSIS component called the “Normaliser Component” which I’d been intending to upgrade for use with SSIS2008 but had not yet gotten around to doing. Earlier this week I got an email from someone asking me if Read More... Posted 23 April 2009 12:31 by jamie.thomson | 4 Comments

• ExecuteSQLExecutingQuery : SSIS Nugget

  One of the great things about working with complex software tools is that no matter how often you use them there is always something you don’t know. Today I learnt such a thing about SQL Server Integration Services (SSIS) courtesy of Doug Laudenschlager’s Read More... Posted 14 April 2009 10:24 by jamie.thomson | 2 Comments

• Programmable in-memory aggregations

  Just recently I was doodling in Visual Studio, writing some .Net code (dangerous, I know). The stuff I was doing wasn’t particularly process intensive but it WAS data intensive; by that I mean I was looping over a collection of entities (let’s pretend Read More... Posted 08 April 2009 16:57 by jamie.thomson | 8 Comments Filed under: Business Intelligence, .Net

• SQLBits session feedback

  I’ve just received my session feedback for my SSIS Nuggets Live session at SQLBits 4 which happened 7 days ago. I’m quite pleased with the marks I received but moreover I had some great written feedback as well, some of which I’ll take the opportunity Read More... Posted 04 April 2009 17:06 by jamie.thomson | 1 Comments Filed under: SQL Server Integration Services, SSIS, SQLBits, ssis nuggets live