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,776 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,812 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,570 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,979 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
92 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,216 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,254 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,050 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,340 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,736 reads
Blogs
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
AI: Blog a Day – Day 7: Vector and Vector Databases
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
Forums
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Restoring On Top I
Comments posted to this topic are about the item Restoring On Top I
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers