May 2010 - Posts

• Dynamic Unpivot : SSIS Nugget

  A question on the SSIS forum earlier today asked: I need to dynamically unpivot some set of columns in my source file. Every month there is one new column and its set of Values. I want to unpivot it without editing my SSIS packages that is deployed Let’s Read More... Posted Saturday, May 29, 2010 8:10 AM by jamiet | 12 Comments Filed under: nugget, sql server integration services, ssis, Unpivot

• Subscribable World Cup 2010 Calendar

  I bang on quite a lot on this blog about ways in which data can get published over the web and one of the most interesting ways, in my opinion, of publishing data in a structured manner that is well understood is to use the iCalendar specification . There Read More... Posted Tuesday, May 25, 2010 10:02 PM by jamiet | 7 Comments Filed under: iCalendar, random waffle

• Inequality joins, Asynchronous transformations and Lookups : SSIS

  It is pretty much accepted by SQL Server Integration Services (SSIS) developers that synchronous transformations are generally quicker than asynchronous transformations (for a description of synchronous and asynchronous transformations go read Asynchronous Read More... Posted Friday, May 14, 2010 11:13 PM by jamiet | 15 Comments Filed under: sql server integration services, ssis, video, dataflow, lookup, Merge Join

• Five things SSIS should drop

  There’s a current SQL Server meme going round entitled Five things SQL Server should drop and, whilst no-one tagged me to write anything, I couldn’t resist doing the same for SQL Server Integration Services. So, without further ado, here are five things Read More... Posted Tuesday, May 11, 2010 6:22 PM by jamiet | 15 Comments Filed under: sql server integration services, ssis

• Is SQL Azure a newbies springboard?

  Earlier today I was considering the various SQL Server platforms that are available today and I wondered aloud, wonder how long until the majority of #sqlserver newcomers use @ sqlazure instead of installing locally Let me explain. My first experience Read More... Posted Thursday, May 06, 2010 9:20 PM by jamiet | 6 Comments Filed under: sql server, SQL Azure, Project Houston