Welcome to EMC Consulting Blogs

September 2006 - Posts

• VSTS4DBP: Post-deployment scripts for deploying static data

  I have written a few posts on the upcoming Visual Studio Team System for Database Professionals product (more succinctly known as Data Dude) and of late I have been using the product more and more. Its still in beta and as such there are a few bugs still Read More... Posted 27 September 2006 15:42 by jamie.thomson | 1 Comments Filed under: Visual Studio Team System For Database Professionals, datadude, Team System

• Live.com

  On 13th September Live.com went, well, live as you can read here on the Livecom spaces blog . For those that don't know, Windows Live is Microsoft's Ray-Ozzie-driven attempt to catch Google in the online stakes and Live.com is the standard bearer Read More... Posted 22 September 2006 14:34 by jamie.thomson | 2 Comments Filed under: Windows Live, Microsoft

• OLE DB: Cannot connect using Microsoft OLE DB Provider for Oracle

  I've had a nasty little problem today and thought it was worth sharing. I've been trying to use the Microsoft OLE DB Provider for Oracle to connect to some Oracle databases but it was failing with the error: "Test connection failed because Read More... Posted 19 September 2006 23:24 by jamie.thomson | 6 Comments Filed under: Inane Waffle, Oracle

• SSIS Book Review: Microsoft SQL Server 2005 Integration Services by Kirk Haselden

  Recently I got hold of a copy of Kirk Haselden's book "Microsoft SQL Server 2005 Integration Services" For those that don't know, Kirk was the Development Manager for SQL Server Integration Services 2005 so what he doesn't know about Read More... Posted 19 September 2006 13:33 by jamie.thomson | 2 Comments Filed under: SQL Server Integration Services, SSIS

• VSTS4DBP: Introductory video for Visual Studio Team Suite for Database Professionals

  JumpstartTV has a new video that gives a quick 5-minute introduction to Visual Studio Team System for Database Professionals . The video has been recorded by Sachin Rekhi , a Program Manager on the VSTS4DB team and Sachin talks about it a little here Read More... Posted 18 September 2006 09:56 by jamie.thomson | 0 Comments Filed under: Visual Studio Team System For Database Professionals, datadude, Team System

• Leave Home

  This post isn't strictly the sort of thing we're supposed to put on our blogs here at Conchango but hopefully the powers that be will indulge me for a bit. My big news that I've been waiting to unveil for quite a while now until it was all Read More... Posted 17 September 2006 10:33 by jamie.thomson | 0 Comments Filed under: Inane Waffle

• SSIS: Checking if a row exists and if it does, has it changed?

  I've been writing about SSIS for quite some time now and probably one of the more popular articles post I have written is this one: Get all from Table A that isn't in Table B ( http://www.sqlis.com/default.aspx?311 ) which I wrote way back in Read More... Posted 12 September 2006 21:31 by jamie.thomson | 99 Comments Filed under: SQL Server 2005, SQL Server Integration Services, SSIS, Dataflow Task, lookup Attachment(s): UpdateAndInsert.zip

• SSIS: Rank Transform

  With the advent of SQL Server 2005, Microsoft provided three new T-SQL windowing functions that will turn out to be highly beneficial to T-SQL developers. They are: ROW_NUMBER (Which I have talked about previously here ) RANK DENSE_RANK It occurred to Read More... Posted 12 September 2006 13:36 by jamie.thomson | 6 Comments Filed under: SQL Server 2005, SQL Server Integration Services, Conchango, SSIS, Dataflow Task Attachment(s): RankTransform.zip

• SSIS: Webcast: How to use the DataReader Source and the OLE DB Source objects in SQL Server 2005 Integration Services

  Just a short note to tell you about a webcast that is coming up on 25th October 2006. "How to use the DataReader Source and the OLE DB Source objects in SQL Server 2005 Integration Services" The subject matter will be (it says 'ere): This Read More... Posted 06 September 2006 20:54 by jamie.thomson | 0 Comments Filed under: SQL Server 2005, SQL Server Integration Services, SSIS, ole db source adapter, Datareader source adapter, Dataflow Task

• Changing system tables and INFORMATION_SCHEMA views

  We all know what system tables are right? They are the tables within the master database that hold the metadata of all the objects stored in our SQL Server. In SQL2005 an extra set of views called the sys views has been provided on top of the system tables Read More... Posted 06 September 2006 20:43 by jamie.thomson | 2 Comments Filed under: SQL Server 2005, SQL Server Integration Services, SSIS, Nugget