Stairway to U-SQL Level 19: Azure Data Lake Metadata with PowerShell
Need to inspect your Data Lake objects and files? Want to automate the process? Find out how with PowerShell.
2018-03-07
594 reads
Need to inspect your Data Lake objects and files? Want to automate the process? Find out how with PowerShell.
2018-03-07
594 reads
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.
2017-09-20
1,094 reads
In this article, see how to created shared functions using C# assemblies in U-SQL.
2017-06-14
919 reads
Learn how U-SQL leverages C# to support flexible scalar functions in your scripts.
2017-05-31
1,164 reads
We met SQL.ARRAY in the last step. Now say hello to SQL.MAP, which can store pairs of values.
2017-03-01
1,676 reads
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.
2017-01-11
2,846 reads
To finish off our look at the core database objects, we inspect how the venerable stored procedure works in U-SQL.
2016-11-16
2,193 reads
Tables used purely for reporting sometimes lack a unique identifier. Find out how to remove duplicates from such a table when data loads go bad.
2016-11-08
6,907 reads
See how the OVER() clause was used in a live system to fix overlapping field version numbers.
2016-10-17
2,385 reads
Table-Valued Functions and User-Defined Types can help you write parameterised U-SQL views in an elegant manner. They also aid code reuse.
2016-10-12
2,860 reads
By gbargsley
Hello, reader! Today, I’m going to walk you through a scenario that many DBAs...
By Chris Yates
The Castle and the Keys Imagine your Azure SQL environment as a sprawling digital...
By Steve Jones
I think we might have forgotten this a bit, but on one of the...
Comments posted to this topic are about the item The Duplicate Cursor
Comments posted to this topic are about the item Concerns over AI Chat Privacy
Comments posted to this topic are about the item Introduction of Azure SQL Hyperscale:...
Can I run this code:
DECLARE ANewTable CURSOR FOR SELECT * FROM ANewTableSee possible answers