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.
2021-03-03 (first published: 2016-06-22)
8,757 reads
Mike McQuillan
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.
2021-01-06 (first published: 2017-10-04)
1,806 reads
Stairway to U-SQL Level 22: Creating a Custom Extractor
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,564 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.
2020-04-08
2,968 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.
2020-04-08
87 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.
2020-03-04 (first published: 2016-10-05)
4,206 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.
2020-02-26 (first published: 2016-06-15)
15,244 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.
2019-10-30 (first published: 2016-07-06)
7,041 reads
Stairway to U-SQL Level 21: Exporting Data with Azure Data Factory
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,336 reads
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.
2018-03-14
1,730 reads
Blogs
Scooby Dooing Episode 10: The Case of the Copy-and-Paste Consultant
Every Scooby-Doo episode has one thing in common — there’s always a fake ghost....
Regression Testing: DAX User Defined Functions
User Defined Functions is a new feature in PowerBI currently in public preview. There...
The fundamental requirements of a reporting system
By ChrisJenkins
There are some fundamental boxes that your reporting system must tick. ✅ The figures...
Forums
Varchar(max) to lines
I have an issue with a varchar(max) field with up to 7000 characters needing...
SQL MI Next-gen general purpose tier
Has anyone used Azure SQL MI on the next-gen general purpose tier, Microsoft documentation...
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Question of the Day
The Last Good DBCC Run
I want to check when DBCC CHECKDB was last run on my Baseball database. What code should I use?
See possible answers