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

Content with tags Azure, U-SQL Rss

   Items 1 to 18 of 18   
 

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 | 413 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 | 473 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 | 530 reads

Stairway to U-SQL Level 15: U-SQL Global Scalar Functions With C#

In this article, see how to created shared functions using C# assemblies in U-SQL.  Read more...
By Mike McQuillan 2017/06/14 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 466 reads

Stairway to U-SQL Level 14: Local U-SQL Scalar Functions with C#

Learn how U-SQL leverages C# to support flexible scalar functions in your scripts.  Read more...
By Mike McQuillan 2017/05/31 | Source: SQLServerCentral.com | Category: u-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 565 reads

Stairway to U-SQL Level 13: SQL.MAP

We met SQL.ARRAY in the last step. Now say hello to SQL.MAP, which can store pairs of values.  Read more...
By Mike McQuillan 2017/03/01 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 970 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 8: Joining Tables in U-SQL

U-SQL provides a number of ways to join data sources together. This articles introduces the joins available and how you can use them.  Read more...
By Mike McQuillan 2016/09/14 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 1,651 reads

Stairway to U-SQL Level 7: More Partition Schemes

Following on from our previous introduction to indexes and partition schemes, we review the distribution schemes used by horizontal partitioning.  Read more...
By Mike McQuillan 2016/08/24 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 887 reads

Stairway to U-SQL Level 6: U-SQL Indexes and Partition Schemes

Find out how to speed up your queries by indexing and partitioning data, U-SQL style.  Read more...
By Mike McQuillan 2016/08/10 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 1,328 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 | 695 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,428 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,026 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,914 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,042 reads
   Items 1 to 18 of 18   
 
Tags
data lake (12)    
big data (11)    
stairway series (8)    
azure data lake (3)    
c# (3)    
cloud (2)    
data lakes (2)    
partitioning (2)    
scalar functions (2)    
visual studio (2)    
catalog (1)    
expressions (1)    
indexes (1)    
joins (1)    
partition scheme (1)    
powershell (1)    
schemas (1)    
sql.array (1)    
sql.map (1)    
stored procedure (1)    
tables (1)    
table-valued function (1)    
tvf (1)    
udt (1)    
user defined type (1)    
usql (1)    
views (1)