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
563 reads
Need to inspect your Data Lake objects and files? Want to automate the process? Find out how with PowerShell.
2018-03-07
563 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,064 reads
In this article, see how to created shared functions using C# assemblies in U-SQL.
2017-06-14
881 reads
Learn how U-SQL leverages C# to support flexible scalar functions in your scripts.
2017-05-31
1,107 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,609 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,638 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,126 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,089 reads
See how the OVER() clause was used in a live system to fix overlapping field version numbers.
2016-10-17
2,272 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,670 reads
By SQLBalls
William, right, 11 years ago the morning of our college tour Hello Dear Reader! When...
What is Docker? Docker is a famous platform for building, shipping, and running container...
This is part of a series of new job blog posts. You can find...
Hello Team, kindly advise how to change dtsx connection? below is source details: Data...
Hi All, I have following samples. create table tbl_svr (Server varchar(200) primary key) insert...
I am tasked with writing a package to import a series of files. One...