Welcome to EMC Consulting Blogs

October 2008 - Posts

• Business Intelligence for my blog from Adcenter Analytics

  In early August I signed-up with Adcenter Analytics , a free service that can provide information about visitors to my blog. Its also a direct compete with Google Analytics. I’d completely forgotten about it until yesterday when I was reminded about the Read More... Posted 30 October 2008 09:16 by jamie.thomson | 9 Comments Filed under: Conchango, Business Intelligence, blog, Adcenter Analytics, analytics

• Announcing SDS Shell – Managing SDS from Powershell

  I mentioned in yesterday’s blog entry SSDS Developments that I’ve been working on a little something around SQL Data Services (SDS) and this is blog entry is intended to tell you all about it. “It” is SDS Shell or “sds-sh” for short. In short, sds-sh Read More... Posted 28 October 2008 15:05 by jamie.thomson | 1 Comments Filed under: powershell, SDS, SQL Data Services, Azure Services Platform, sds-sh, azure, SQL Azure

• SSDS developments

  There have been some snippets of information trickling out of the Microsoft PDC this evening about SQL Server Data Services (SSDS). Namely: That’s not its name anymore. Its now called SQL Data Services (SDS) SDS is the data layer in Windows Azure You Read More... Posted 27 October 2008 20:50 by jamie.thomson | 5 Comments Filed under: SQL Server, REST, cloud computing, RESTful, SDS, SQL Data Services, Azure Services Platform, azure, SQL Azure

• ADO.Net Data Services (aka Astoria) book available soon

  Congratulations are in order for my Conchango EMC Consulting Services colleagues Simon Evans and John Shaw who are soon to be first-time published authors when their book “Pro ADO.NET Data Services : Working with RESTful data” hits the virtual bookshelves Read More... Posted 27 October 2008 12:11 by jamie.thomson | 0 Comments Filed under: Astoria, REST, ADO.Net Data Services, RESTful

• SSIS Nugget: Nesting variables to calculate values

  I was looking over a package today that a colleague had built and it contained the following code in a Script Task that was being used to return today’s day name: Public Sub Main() ' Dim sWeekday As String sWeekday = Now().DayOfWeek.ToString Dts.Variables( Read More... Posted 24 October 2008 10:44 by jamie.thomson | 8 Comments Filed under: SQL Server Integration Services, SQL Server, SSIS, Expressions, Variables, Nugget

• SSIS: Consuming SOAP web services in SSIS2008 demo updated

  Quick note. Today I updated the demo package that I built for my blog entry Consuming web services in SSIS 2008 , published in June 2007 (one of my busiest ever months ). The previous package was built on CTP3 of SSIS2008 and hence didn’t work on the Read More... Posted 22 October 2008 20:02 by jamie.thomson | 0 Comments Filed under: SQL Server Integration Services, SQL Server, SSIS, Web Services, sqL server 2008

• SSDS: Getting a list of authorities in C#

  I mentioned yesterday in my blog entry Are database pros relevant on the RESTful web? that I’d be doing more blogging related to cloud computing and here is the first one. it regards SQL Server Data Services (SSDS). I’ve been using SSDS for a few months Read More... Posted 17 October 2008 17:23 by jamie.thomson | 3 Comments Filed under: SQL Server, REST, SSDS, SQL Server Data Services, cloud computing, RESTful, SDS, SQL Data Services

• UK SQL Server user group meeting – 16th October 2008

  Yesterday evening I attended the latest UK SQL user group conflab at Microsoft’s offices in Cardinal Place, London . Here was the agenda: 6:00 - 6:30 Meet & Greet 6:30 – 6:45 Intro, whats in the news, Q&A – James Rowland-Jones, Christian Bolton Read More... Posted 17 October 2008 10:44 by jamie.thomson | 2 Comments Filed under: SQL Server, Service Broker

• SSIS and embedded SQL

  I have been having an email back-and-forth with Jon Jaques which began with us discussing various limitations regarding BLOB support within the OLE DB Command and ended with Jon’s blog entry SSIS and the Perils of Embedded SQL where he discusses the drawbacks Read More... Posted 17 October 2008 10:13 by jamie.thomson | 8 Comments Filed under: SQL Server Integration Services, SQL Server, SSIS, Dataflow Task, Execute SQL Task

• Are database pros relevant on the RESTful web?

  Recently I went on record as saying: everything that travels on the internet is data in one shape or another so I believe that the skills and experience that we as data professionals apply today in hosted on-premise database applications will serve us Read More... Posted 16 October 2008 15:08 by jamie.thomson | 8 Comments Filed under: REST, RESTful