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

Content with tags Azure, Big Data Rss

   Items 1 to 13 of 13   
 

Stairway to U-SQL Level 20: Querying External Data with U-SQL

Did you know you can query SQL Server data with U-SQL? It's true! Find out how in this latest stairway step.  Read more...
By Mike McQuillan 2018/03/14 | Source: SQLServerCentral.com | Category: azure
Rating: (not yet rated) |  Discuss |   Briefcase | 601 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 2018/01/19 (first published: 2016/06/15) | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 7,152 reads

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: |  Discuss |   Briefcase | 483 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 | 560 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 | 638 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,573 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,539 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,504 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 | 925 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,587 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,219 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 | 4,119 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 2018/01/19 (first published: 2016/06/15) | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 7,152 reads
   Items 1 to 13 of 13   
 
Tags
u-sql (12)    
data lake (11)    
stairway series (6)    
catalog (1)    
cloud (1)    
credentials (1)    
data source (1)    
external data (1)    
indexing (1)    
partition scheme (1)    
partitioning (1)    
powershell (1)    
schemas (1)    
sql.array (1)    
stored procedure (1)    
usql (1)    
visual studio (1)