Welcome to EMC Consulting Blogs

January 2005 - Posts

• SSIS: Beware of transactions

  Regular readers of my blog may have read about the investigative work I have been doing around transactions in SQL Server Integration Services and may also have downloaded my example package from here . Recently I was demo-ing this package to some of Read More... Posted 31 January 2005 14:11 by jamie.thomson | 9 Comments Filed under: SQL Server Integration Services, SSIS

• SSAS: Migrating Analysis Services 2000 to Analysis Services 2005 - Part 2

  It seems there's been some significant interest in an earlier post regarding some of the work my colleague Mick Horne has been doing on AS2005. Mick's provided some more detail about what he's been doing, including hardware specs as requested from one Read More... Posted 24 January 2005 22:21 by jamie.thomson | 0 Comments Filed under: SQL Server 2005

• Are you a geek?

  Find out here . Yours truly got: I am 16% Geek. I wanna be a geek. But I'm not. Why would I even want to be one. Do I think it's fun? I should try writting an online test application at 1 am in my underwear Take the Geek Test @ FualiDotCom which I'm pretty Read More... Posted 24 January 2005 20:23 by jamie.thomson | 1 Comments Filed under: Inane Waffle

• XML Support in SQL Server 2005 - Part 1

  Just a short note about an article published here that gives an excellent overview of XML support in SQL2005. I thought there'd be a few people out there that would want to know about this. -Jamie Read More... Posted 20 January 2005 12:00 by jamie.thomson | 0 Comments Filed under: SQL Server 2005

• SSIS: Event occurence order

  I was intrigued to know in which order the: OnPreExecute OnPostExecute OnPreValidate OnPostValidate events get raised by tasks/containers within an SSIS package so I put together a dead simple package that popped up a msgbox each time one of these events Read More... Posted 13 January 2005 20:41 by jamie.thomson | 4 Comments Filed under: SQL Server Integration Services, SSIS

• SSIS: Beware of copying and pasting script tasks

  SSIS easily enables you to copy and paste tasks into different parts of your package, or even into other packages. I was doing this recently with script tasks and found something that you should be aware of. Copying and pasting a script task means that Read More... Posted 13 January 2005 09:38 by jamie.thomson | 1 Comments Filed under: SQL Server Integration Services, SSIS, Scripting

• T-SQL: Deriving start and end date from a single effective date

  The Problem! My colleague Karl Grainger has had a T-SQL problem today that we spent a bit of brain power figuring out so I figured it was worth blogging about. The situation was that he had a slowly changing dimension that had an effective date on each Read More... Posted 10 January 2005 11:22 by jamie.thomson | 6 Comments Filed under: SQL Server, T-SQL, slowly changing dimensions

• SSAS: Migrating Analysis Services 2000 to Analysis Services 2005

  A colleague of mine, Mick Horne, has recently been working on migrating one of our existing service offerings from Analysis Services 2000 to Analysis Services 2005 and found some interesting things that are worth sharing. Mick doesn't have a blog of his Read More... Posted 06 January 2005 10:40 by jamie.thomson | 15 Comments Filed under: SQL Server 2005

• SSIS: More on transactions

  Following on from my earlier post regarding transactions in SSIS 2005 I have written an article explaining the principles in a bit more depth. You can view the article here at SQLServerCentral.com . The article contains a worked explanation of transactions Read More... Posted 03 January 2005 10:12 by jamie.thomson | 0 Comments Filed under: SQL Server Integration Services, SSIS