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
567 reads
Need to inspect your Data Lake objects and files? Want to automate the process? Find out how with PowerShell.
2018-03-07
567 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,070 reads
In this article, see how to created shared functions using C# assemblies in U-SQL.
2017-06-14
888 reads
Learn how U-SQL leverages C# to support flexible scalar functions in your scripts.
2017-05-31
1,121 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,625 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,696 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,139 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,319 reads
See how the OVER() clause was used in a live system to fix overlapping field version numbers.
2016-10-17
2,296 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,708 reads
By SQLPals
Get Configuration Change History From the SQL Server Error Logs There...
By SQLPals
How To Gain Access To SQL Server When No DBA ...
Hi, I need to design a data warehouse solution to manage medical records about...
Comments posted to this topic are about the item Gentlest of Reminders, Don't Stop...
Gurus, there is a table which is very slow to query , it has...