Welcome to EMC Consulting Blogs

December 2008 - Posts

• Why do we need more ICANN-assigned top-level-domains?

  I read today on BBC News website that The Internet Corporation for Assigned Names and Numbers (ICANN) is considering introducing many many more top-level-domains (TLDs) for the internet addressing system to go alongside the existing ones such as .com, Read More... Posted 23 December 2008 13:48 by jamie.thomson | 4 Comments Filed under: Inane Waffle, TLD, top-level-domains

• Generating XML Schema Documents using SSIS

  Recently I was using Visual Studio 2005’s “Create Schema” feature to generate an XML Schema Document (XSD) from an XML file However I began to run into trouble with larger documents for which Visual Studio was throwing me back the following error:   Read More... Posted 15 December 2008 13:36 by jamie.thomson | 3 Comments Filed under: SQL Server Integration Services, SSIS, pipeline, xml, xsd

• What’s the difference between SQL Data Services (SDS) and Azure tables?

  I’ve seen many people on the web enquiring as to the difference between Azure table storage and SQL Data Services (SDS). Its a fair question, both appear in the ubiquitous Azure Services Platform slide: [N.B. Azure table store is part of “Windows Azure” Read More... Posted 12 December 2008 09:51 by jamie.thomson | 4 Comments Filed under: SDS, SQL Data Services, Azure Services Platform, windows azure, azure, SQL Azure

• Talking Pipelines : SSIS and Powershell

  Of late I have been fiddling with Powershell quite a bit as I toil with SDS Shell . The simplicity with which one can build seemingly complex logic using Powershell really appeals to me and, inevitably, I have started to think about Powershell as a lightweight Read More... Posted 09 December 2008 22:02 by jamie.thomson | 5 Comments Filed under: SQL Server Integration Services, SSIS, powershell, pipeline

• Making the case for expressions instead of parameterised SQL (and vice versa) : SSIS Nugget

  [Although I colloquially refer to myself on this blog as “SSIS Junkie” it won’t have escaped the notice of regular readers that I haven’t been talking about SSIS much lately, in fact nothing of real substance in regard to SSIS has appeared here since Read More... Posted 08 December 2008 13:35 by jamie.thomson | 1 Comments Filed under: SQL Server Integration Services, SQL Server, SSIS, T-SQL, Expressions, Execute SQL Task, Nugget, sp_executesql