SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Azure, data lake Rss

   Items 1 to 13 of 13   
 

Stairway to U-SQL Level 18: Populating a Data Lake with PowerShell

Learn how PowerShell can be used to manage files and folders in your Data Lake.  Read more...
By Mike McQuillan 2017/10/04 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 415 reads

Stairway to U-SQL Level 17: Executing U-SQL Jobs with PowerShell

Automate your Data Lake with PowerShell! Learn how PowerShell can be used to execute U-SQL scripts, as well as a few other little tricks.  Read more...
By Mike McQuillan 2017/09/20 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 476 reads

Stairway to U-SQL Level 16: The Azure Data Lake Catalog

Delve behind the scenes and learn about the catalog used to manage Azure Data Lakes.  Read more...
By Mike McQuillan 2017/08/30 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 532 reads

Stairway to U-SQL Level 12: SQL.ARRAY and CROSS APPLY EXPLODE

U-SQL introduces two new data types - SQL.ARRAY and SQL.MAP. Here, we look at what we can do with SQL.ARRAY and the CROSS APPLY EXPLODE expression.  Read more...
By Mike McQuillan 2017/01/11 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 1,517 reads

Stairway to U-SQL Level 11: Stored Procedures

To finish off our look at the core database objects, we inspect how the venerable stored procedure works in U-SQL.  Read more...
By Mike McQuillan 2016/11/16 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 1,467 reads

Stairway to U-SQL Level 10: Table-Valued Functions and UDTs

Table-Valued Functions and User-Defined Types can help you write parameterised U-SQL views in an elegant manner. They also aid code reuse.  Read more...
By Mike McQuillan 2016/10/12 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 1,829 reads

Stairway to U-SQL Level 9: Views and C# Expressions

Learn how U-SQL views can hide complexity and use C# expressions, providing powerful ways to format and return your data.  Read more...
By Mike McQuillan 2016/10/05 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 1,142 reads

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

A guide to using databases, schemas and tables in Azure Data Lakes, using (of course!) U-SQL.  Read more...
By Mike McQuillan 2016/07/27 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 698 reads

Stairway to U-SQL Level 4: U-SQL and Data Lake Tooling with Visual Studio

A guide to using Visual Studio to create U-SQL projects and scripts.  Read more...
By Mike McQuillan 2016/07/20 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 1,431 reads

Stairway to U-SQL Level 3: Processing Multiple Files With U-SQL

In part 3 of the U-SQL Stairway, we look at how multiple files can be processed with a single U-SQL statement.  Read more...
By Mike McQuillan 2016/07/06 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 2,029 reads

Stairway to U-SQL Level 2: Breakdown of a U-SQL Statement

Following on from our introduction to U-SQL, we take a look at how a typical U-SQL statement is constructed.  Read more...
By Mike McQuillan 2016/06/22 | Source: SQLServerCentral.com | Category: usql
Rating: |  Discuss |   Briefcase | 3,916 reads

Stairway to U-SQL Level 1: Introduction to U-SQL and Azure Data Lakes

An introductory guide to querying files in Azure Data Lakes using Microsoft's U-SQL language.  Read more...
By Mike McQuillan 2016/06/15 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 6,047 reads

Azure Data Lakes

The Data-lake is basically a large repository of data for 'big data' analytic workloads, held in its original format. The Azure Data Lake adds Data Lake Analytics, and Azure HDInsight. Although the tools are there for Big Data Analysis, it will require new skills to use, and a heightened attention to Data Governance if it is to appeal to the average enterprise. Rob Sheldon takes a look.  Read more...
By Additional Articles 2015/12/21 | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 3,078 reads
   Items 1 to 13 of 13   
 
Tags
u-sql (12)    
big data (10)    
stairway series (6)    
cloud (2)    
c# (1)    
catalog (1)    
expressions (1)    
powershell (1)    
schemas (1)    
sql.array (1)    
stored procedure (1)    
table-valued function (1)    
tvf (1)    
udt (1)    
user defined type (1)    
usql (1)    
views (1)    
visual studio (1)