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
668 reads
Mike McQuillan
Stairway to U-SQL Level 17: Executing U-SQL Jobs with PowerShell
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,185 reads
Stairway to U-SQL Level 15: U-SQL Global Scalar Functions With C#
In this article, see how to created shared functions using C# assemblies in U-SQL.
2017-06-14
998 reads
Stairway to U-SQL Level 14: Local U-SQL Scalar Functions with C#
Learn how U-SQL leverages C# to support flexible scalar functions in your scripts.
2017-05-31
1,243 reads
Stairway to U-SQL Level 13: SQL.MAP
We met SQL.ARRAY in the last step. Now say hello to SQL.MAP, which can store pairs of values.
2017-03-01
1,737 reads
Stairway to U-SQL Level 12: SQL.ARRAY and CROSS APPLY EXPLODE
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,950 reads
Stairway to U-SQL Level 11: Stored Procedures
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,275 reads
Using OVER() to Remove Duplicate Rows
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
7,035 reads
Using OVER() to Fix Bad Version Numbers
See how the OVER() clause was used in a live system to fix overlapping field version numbers.
2016-10-17
2,457 reads
Stairway to U-SQL Level 10: Table-Valued Functions and UDTs
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,949 reads
Blogs
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Alamat BCA KCP Kota Baru Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Prof Doktor Mohammad Yamin, Kota Baru, Kec. Pontianak Sel., Kota Pontianak, Kalimantan...
Alamat BCA KCP Sampit Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. A. Yani No. 38 B Sampit RT 25/RW XI Sampit Kelurahan Mentawa...
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers