Welcome to EMC Consulting Blogs

July 2009 - Posts

• .Net Service bus demo by EasyJet at UK Azure Net user group meeting

  Yesterday evening I attended the second meeting of the UK Azure Net user group in London Victoria. Normally this wouldn’t in itself be blog worthy but one of the presentations given really piqued my interest and I wanted to draw some attention to it. Read More... Posted 30 July 2009 15:38 by jamie.thomson | 0 Comments Filed under: azure, Service Bus, Easyjet

• Sync is the word

  I recently tweeted the following rather silly little ditty… Sync is the word Its in Groove, its in GMail Sync works any time, any place, in motion Sync is the way we'll be storing Ahem, yes. Well… silly but with a relevant point. Sync is becoming an integral Read More... Posted 22 July 2009 17:56 by jamie.thomson | 0 Comments Filed under: sync

• String Aggregation in T-SQL & PL-SQL : SQL Nugget

  In my current day job I’m doing a lot of work against an Oracle back-end and I’ve just come across a situation where I need to do some string aggregation. Effectively I needed to turn this: Parent Child Charles William Charles Harry Anne Peter Anne Zara Read More... Posted 16 July 2009 13:32 by jamie.thomson | 6 Comments Filed under: SQL Server, Oracle, T-SQL, Nugget, pl-sql

• The Longest Tweet

  I read an article today called The Longest Tweet In History which explained how it is now possible to send Tweets via Twitter that are longer than the supposed 140 character limit. As it happens I’ve written a noddy app called Tweetpoll onto Windows Azure Read More... Posted 10 July 2009 11:59 by jamie.thomson | 0 Comments Filed under: twitter, windows azure, azure, tweetpoll, LINQPad, LINQ

• Kapow – ETL for HTML

  A couple of weeks ago Chris Webb sent me an IM telling me about a new technology he’d just seen a demo of called Kapow. Chris has since blogged about it at Kapow Technologies and in that blog post he described Kapow as: “a cross between a screenscraper Read More... Posted 08 July 2009 22:29 by jamie.thomson | 1 Comments Filed under: Kapow, etl

• LINQPad and Azure

  Since I started dealing with Azure tables I’ve become frustrated that there is no ad-hoc query tool, nothing equivalent to SQL Server Management Studio. Then I heard about LINQPad and figured there must be a way to use it to query Azure tables using LINQ Read More... Posted 06 July 2009 16:51 by jamie.thomson | 2 Comments Filed under: windows azure, azure, LINQPad, LINQ

• SSIS Connect digest 2009-07-05

  Here is the latest collection of submissions to http://connect.microsoft.com/sqlserver/feedback that pertain to SQL Server Integration Services (SSIS) and which I think are worthy of your attention. Take a read of the items below and if you agree with Read More... Posted 05 July 2009 09:31 by jamie.thomson | 0 Comments Filed under: SQL Server Integration Services, SQL Server, SSIS, connect, feedback, digest

• DRY SQL

  I recently inherited some SQL that someone else had written and had the job of “tidying it up” before it gets pushed out to production. Here’s a slightly simplified (yes, simplified) version of that SQL: 1: --options 2: select asset_class 3: , case when Read More... Posted 02 July 2009 22:05 by jamie.thomson | 4 Comments Filed under: SQL Server, SQL, T-SQL, DRY