Posts From October, 2016

-August 2017+
SMTWTFS
303112345
6789101112
13141516171819
20212223242526
272829303112
3456789
  • RSS
  • Add To My MSN
  • Add To Windows Live
  • Add To My Yahoo
  • Add To Google

Statistics

  • Entries (93)
  • Comments (0)

An introduction to the Azure Data Lake and U-SQL 

By Russ Loski
Posted by altadmin Monday, October 17, 2016 9:36:00 AM Categories: Announcement Meeting
Data is exploding across enterprises. Much of it is semi-structured junk. Or is it junk? What are you going to do with it until you can explore it? Microsoft’s Azure Data Lake is a cloud storage and analytical service for parking a variety of data. When you are ready to discover what is in those files you can spin up the resources you need and run ANSI SQL queries using the U-SQL language. You can join those files to other files and even to SQL Server on Azure in a single query.
After we look at how easy it is to set up a Data Lake we will develop some simple queries against files that I have already loaded into the data lake. We will run a query against a set of files with over 15 GB of data. We will look at the different SQL elements that we are all familiar with (grouping, where clauses) and note the similarities and glaring differences between U-SQL and T-SQL.

Bio: Russ Loski is a local SQL Server developer in the DFW area. He has worked with SQL Server since version 6.5. His passion is finding ways to get information out of a variety of formats from SQL Server to comma delimited files. He is currently working as a contract ETL developer at Baylor Scott & White.

6:30 PM Meet & Greet | 7 PM Presentation
Site Map | Printable View | © 2008 - 2017 Fort Worth SQL Server Users Group | Powered by mojoPortal | HTML 5 | CSS | Original design by Andreas Viklund