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.
2016-09-14
3,566 reads
Mike McQuillan
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.
2016-08-24
1,710 reads
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.
2016-08-10
3,280 reads
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.
2016-07-27
3,187 reads
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.
2016-07-20
3,055 reads
Guide to MCITP: SQL Server 2008 BI Developer
A guide to the SQL Server 2008 Business Intelligence exams.
2012-05-11
12,390 reads
2011-10-04
2,480 reads
Guide To MCITP: SQL Server 2008 Administration
Find out what you need to learn for the SQL Server 2008 Administration certification exams.
2011-08-05
9,002 reads
Guide to MCITP: SQL Server 2008 Developer
An overview of what's involved in the two exams you need to pass to become a Microsoft IT Professional in SQL Server 2008.
2009-08-21
10,647 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