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
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,095 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
920 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,168 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,679 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,849 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,194 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
6,926 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,386 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,863 reads
Blogs
Scooby Dooing Episode 10: The Case of the Copy-and-Paste Consultant
Every Scooby-Doo episode has one thing in common — there’s always a fake ghost....
Regression Testing: DAX User Defined Functions
User Defined Functions is a new feature in PowerBI currently in public preview. There...
The fundamental requirements of a reporting system
By ChrisJenkins
There are some fundamental boxes that your reporting system must tick. ✅ The figures...
Forums
Varchar(max) to lines
I have an issue with a varchar(max) field with up to 7000 characters needing...
SQL MI Next-gen general purpose tier
Has anyone used Azure SQL MI on the next-gen general purpose tier, Microsoft documentation...
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Question of the Day
The Last Good DBCC Run
I want to check when DBCC CHECKDB was last run on my Baseball database. What code should I use?
See possible answers