Stairway to U-SQL Level 5: Databases and Tables in Azure Data Lakes with U-SQL

Question

Stairway to U-SQL Level 5: Databases and Tables in Azure Data Lakes with U-SQL

Mike McQuillan

SSCertifiable

Points: 5997
More actions
July 27, 2016 at 12:04 am

#400473

Comments posted to this topic are about the item Stairway to U-SQL Level 5: Databases and Tables in Azure Data Lakes with U-SQL

Viewing 15 posts - 1 through 15 (of 21 total)

You must be logged in to reply to this topic. Login to reply

Kevin3NF SSCarpal Tunnel Points: 4765 More actions · Answer 1

The files link appears to be broken...are these the same files we uploaded to the DLS in stairway 1 or 2?

------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NF DallasDBAs.com/Blog Why is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]

Mike McQuillan SSCertifiable Points: 5997 More actions · Answer 2

Hi Kevin
Many apologies, looks like there is a problem with my hosting. I'll try to have this sorted out in the next 24 hours. I'll post an update once it's sorted.

Thanks for letting me know.

Regards,
Mike.

Kevin3NF SSCarpal Tunnel Points: 4765 More actions · Answer 3

Thanks Mike...any chance they can be stuck in a dropbox somewhere, or something similar? I and a teammate have some dedicated training time today and tomorrow (US Central) 😀

I'd also be happy to host them on my site as well as a mirror in case yours has issues from time to time.

------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NF DallasDBAs.com/Blog Why is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]

Mike McQuillan SSCertifiable Points: 5997 More actions · Answer 4

Thanks for the offer Kevin, might take you up on that.

I think the hosting problem might be my fault 🙁

Anyway, I've just thought on - you can grab the files straight from the GitHub repo. Hope this does the trick:

https://github.com/mikemcquillan/usql_ssc/tree/master/SSC_UkPostcodes/ssc_uk_postcodes

Regards,
Mike.

Kevin3NF SSCarpal Tunnel Points: 4765 More actions · Answer 5

Thanks! have never used GitHub before...when I drill into the files and click download, they open in a new browser tab. Am I missing something simple to straight download them?

------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NF DallasDBAs.com/Blog Why is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]

Mike McQuillan SSCertifiable Points: 5997 More actions · Answer 6

No worries Kevin, you're welcome.

I can download them in Chrome by right-clicking on them and choosing "Save link as". Hopefully this will do the trick for you, regardless of the browser you're using.

Regards,
Mike.

Kevin3NF SSCarpal Tunnel Points: 4765 More actions · Answer 7

Yep...got them. I tried that, didn't work, new tab, worked just fine. Random PC weirdness 🙂

------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NF DallasDBAs.com/Blog Why is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]

Mike McQuillan SSCertifiable Points: 5997 More actions · Answer 8

Brilliant, I'll post on here once I've restored the old links.

Good luck!

Cheers,
Mike.

Mike McQuillan SSCertifiable Points: 5997 More actions · Answer 9

Just a quick note to let you know I've restored the files. The download links are working again.

Regards,
Mike.

naunihal Valued Member Points: 69 More actions · Answer 10

How does Database in ADLA compares to ADW.
ADW is limited to 240TB, does ADLA DB has any limitations ?

Mike McQuillan SSCertifiable Points: 5997 More actions · Answer 11

Hi there

To the best of my knowledge, because Azure Data Lake is file-based (even the databases), there are no size limitations.

Microsoft's marketing page repeats the "no limit" mantra several times.

Regards,
Mike.

naunihal Valued Member Points: 69 More actions · Answer 12

SO does it allow connections to ADLA Database from SMS or C# SDKs.
Since you mentioned it is file based does it allow updates to the records in ADLA Databases, does it provide transnational functionality etc ?

Mike McQuillan SSCertifiable Points: 5997 More actions · Answer 13

Hello

There are no "connections" as such. You appear to be thinking of ADL as a traditional database. You can insert/request data from URIs or using U-SQL. SDKs are available for C#, Python and R.

You cannot update the records in a table, there are no transactions. The principal aim is to run reports from the data or convert data into different formats. You either insert data or delete it.

.NET SDK information is available via Microsoft.

Regards,
Mike.

Sean Woehrle Mr or Mrs. 500 Points: 539 More actions · Answer 14

I had quite a bit of trouble with the files on github today. Doing save as gave me some html page content in the files (tried both IE and Chrome). I was able to get the files by choosing the raw option then saving the files down. Hope this helps others.

[font="Tahoma"]Cheers,

Sean :-D[/font]