Hi John

You're welcome, and you're correct - part 5[/url] (which went out last week) deals with tables.

Regards,

Mike.

Hi John

Glad you are enjoying the series, and thanks for your question.

You are correct, all of your data is structured, regardless of where it comes from or the format it...

Hi Nagaraju,

I have taken a look at this.

Unfortunately I cannot recreate the error on my machine. I am running Windows 10 64-bit with Visual Studio 2015 Community Edition. Everything works...

Hi NK

Sorry to hear you've had issues. I won't have access to Visual Studio until August 2nd, so I'll take a look at your issue then. Sorry for the delay.

Regards,

Mike.

Thanks to you both for the kind words, glad you are enjoying the series!

I too have noticed the mis-spelling of "Stairway", I will ask Steve if he can fix it.

Regards,

Mike.

Hi John

I'm having fun writing it too, glad to hear you're enjoying the series! Thanks for the kind words.

Regards,

Mike.

Hi John,

Thanks for the kind words (and the vote of course)! Hope you continue to enjoy the series.

Regards,

Mike.

Hi there Eric

U-SQL looks like T-SQL on the surface, but it's a blend of both T-SQL and C#. The WHERE clauses are very different - you can't write WHERE x...

Hi there Gerald

Unfortunately, at the moment there isn't an on-prem version of Data Lakes.

Your best bet is to ask Michael Rys (he's in charge of all this stuff) whether there...

Hi Andy

A feature is coming called SkipFirstNRows, which will, er, let you skip a number of specified rows. That should sort out the header issue, which is a massive problem...

Hi MCDB

It's up to the developer to know what columns are in the file, and then apply them in the EXTRACT statement. As per this statement:

@results = EXTRACT postcode string,

total...

Hi Jeff

Glad you liked the article, thanks for the kind words.

It is a shame U-SQL isn't available locally, although who knows what Microsoft will do in the future. There may...

Hi Clint

Thanks for the kind words, glad you enjoyed the article.

I agree on both your points. I was trying to make the point that it should be easier to respond...

Thanks Alan, glad you liked it!

Mike.

Hi there PB_BI

Just trying to make the article fairly general for readers who don't know the stack inside out. I do agree with your point.

Hope I don't ruin your sleep...