Using OVER() to Fix Bad Version Numbers

See how the OVER() clause was used in a live system to fix overlapping field version numbers.

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.

Stairway to U-SQL Level 8: Joining Tables in U-SQL

U-SQL provides a number of ways to join data sources together. This articles introduces the joins available and how you can use them.

Stairway to U-SQL Level 7: More Partition Schemes

Following on from our previous introduction to indexes and partition schemes, we review the distribution schemes used by horizontal partitioning.

Stairway to U-SQL Level 6: U-SQL Indexes and Partition Schemes

Find out how to speed up your queries by indexing and partitioning data, U-SQL style.

Stairway to U-SQL Level 5: Databases and Tables in Azure Data Lakes with U-SQL

A guide to using databases, schemas and tables in Azure Data Lakes, using (of course!) U-SQL.

Stairway to U-SQL Level 4: U-SQL and Data Lake Tooling with Visual Studio

A guide to using Visual Studio to create U-SQL projects and scripts.

Guide to MCITP: SQL Server 2008 BI Developer

A guide to the SQL Server 2008 Business Intelligence exams.

Rebuilding The Master Database

Guide To MCITP: SQL Server 2008 Administration

Find out what you need to learn for the SQL Server 2008 Administration certification exams.