Welcome to EMC Consulting Blogs

August 2008 - Posts

• SSIS: Parent package configurations. Yay or nay?

  A few of my fellow SSIS MVPs and I were asked if we wanted to submit a whitepaper to coincide with the new release of SQL Server; today those papers were (bar one) released: Considerations for High Volume ETL Using SQL Server Integration Services by Pat Read More... Posted 29 August 2008 22:49 by jamie.thomson | 15 Comments Filed under: SQL Server Integration Services, SSIS, configurations

• SSDS and MDM naturally converge

  If you've been reading my blog over the past year or so you'll have noticed that two things I've started to become really interested in are Master Data Management ( MDM ) and SQL Server Data Services ( SSDS ). The interest in SSDS, a cloud-based service Read More... Posted 29 August 2008 20:25 by jamie.thomson | 0 Comments Filed under: MDM, Master Data Management, SSDS, SQL Server Data Services, cloud computing, Entity-Attribute-Value, EAV, SDS, SQL Data Services, azure, SQL Azure

• SSIS: Case sensitive SQL Server configurations

  I just received an email from Michael Groh who had a warning about using SQL Server configurations in SSIS and he suggested I post about it on my blog which I'm more than happy to do. Here's what Michael had to say:   We finally tracked down a really Read More... Posted 22 August 2008 08:49 by jamie.thomson | 6 Comments Filed under: SQL Server Integration Services, SQL Server, SSIS, configurations

• SSIS: Small but important bit of news

  One of the biggest complaints about SSIS since it release in November 2005 has been its inability to load files with differing row formats. There's an infamously monster thread about it over on the SSIS forum. Hopefully some of the complains are alleviated Read More... Posted 19 August 2008 23:30 by jamie.thomson | 0 Comments Filed under: SQL Server Integration Services, SSIS

• SSIS: Validating your package to see if it will execute

  Whilst reading SQL Tip, Compiling Your SQL Without Running It to See If It Would Run (which, I believe, is written by Denis Gobo) I was reminded of an oft forgotten feature within SSIS. It is possible to validate that your package will execute without Read More... Posted 19 August 2008 19:09 by jamie.thomson | 2 Comments Filed under: SQL Server Integration Services, SSIS

• Attachments must die!

  Am I the only person that is bothered by email attachments? I ask the question because I'm of the opinion that the proliferation of word documents, PDFs, installer binaries and other such detritus that litters my and many other people's inbox is an unnecessary Read More... Posted 17 August 2008 21:02 by jamie.thomson | 11 Comments Filed under: Collaboration, Information sharing

• Twitter-alike on SSDS

  [I had to call this out because I think its a cool example of what can be done with SSDS.] Mike Amundsen is a guy that really grasped the SSDS nettle. First he built the SSDS provisioning client ( http://amundsen.com/examples/ssds/data-client/ ) and now Read More... Posted 01 August 2008 09:13 by jamie.thomson | 3 Comments Filed under: SQL Server 2005, SSDS, SQL Server Data Services, SDS, SQL Data Services, azure, SQL Azure