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,800 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,820 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,574 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,999 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
98 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,234 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,276 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,060 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,347 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,739 reads
Blogs
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Generate Embeddings in SQL with Aurora and Bedrock
Most embedding pipelines on AWS have the same shape: a job reads rows out...
Resolving SQL Server Transaction Log Issues Efficiently
By Arun Sirpal
Transaction log issues are one of the quietest ways a healthy database turns into...
Forums
Symmetric Key Encryption
Comments posted to this topic are about the item Symmetric Key Encryption
The “Successful Login” Dilemma: Why Your Login Auditing Strategy Might Be Hurting Your Server
Comments posted to this topic are about the item The “Successful Login” Dilemma: Why...
Building Your Own Software
Comments posted to this topic are about the item Building Your Own Software
Question of the Day
Symmetric Key Encryption
If I run this statement in SQL Server 2025, how is the password encrypted?
CREATE SYMMETRIC KEY MySymmetricKey WITH ALGORITHM = AES_256, KEY_SOURCE = 'My secret key source passphrase', IDENTITY_VALUE = 'My secret identity value' ENCRYPTION BY PASSWORD = 'S&perS#cretP@ssword7'; GOSee possible answers