Throughout this series, we’ve consistently dealt with delimited text files; comma and tab, for instance. We’ve used the U-SQL built-in extractors to process these files. But what if we need to deal with different types of file, like JSON, XML or fixed width? That’s where custom extractors come in. U-SQL provides us with the ability […]
2020-07-01
1,065 reads
Delve behind the scenes and learn about the catalog used to manage Azure Data Lakes.
2020-04-08
2,205 reads
Delve behind the scenes and learn about the catalog used to manage Azure Data Lakes.
2020-04-08
13 reads
Learn how U-SQL views can hide complexity and use C# expressions, providing powerful ways to format and return your data.
2020-03-04 (first published: 2016-10-05)
3,882 reads
An introductory guide to querying files in Azure Data Lakes using Microsoft's U-SQL language.
2020-02-26 (first published: 2016-06-15)
13,122 reads
In part 3 of the U-SQL Stairway, we look at how multiple files can be processed with a single U-SQL statement.
2019-10-30 (first published: 2016-07-06)
6,423 reads
Learn how you can move data from your Data Lake to Azure SQL Database with Azure Data Factory.
2019-07-31 (first published: 2018-03-28)
2,148 reads
Following on from our introduction to U-SQL, we take a look at how a typical U-SQL statement is constructed.
2018-11-21 (first published: 2016-06-22)
6,164 reads
Did you know you can query SQL Server data with U-SQL? It's true! Find out how in this latest stairway step.
2018-03-14
1,363 reads
Need to inspect your Data Lake objects and files? Want to automate the process? Find out how with PowerShell.
2018-03-07
488 reads
I almost died. I’m sure a lot of you already know this but just...
By Steve Jones
This month the T-SQL Tuesday invitation comes from Tamara Clark. I strong-armed Tamara last...
By Arun Sirpal
Recently I found out that I passed the BETA exam for Azure Database Administrator...
Hi I have a job that I need to be notified/emailed if it runs...
Hi I have an application that is timing out i run the query...
Ask SSC