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

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

In this article, we will show how to install Azure CLI and then create an Azure SQL Server and a SQL Database.  Read more...

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

Everybody says that the backup process in Azure SQL is very easy. Is that true? In this new article, we will show how to do it.  Read more...

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

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

Toady we are going to make a copy and export your DB to Azure Storage. Lets get started.  Read more...

In part 3 of the U-SQL Stairway, we look at how multiple files can be processed with a single U-SQL statement.  Read more...

Following on from our introduction to U-SQL, we take a look at how a typical U-SQL statement is constructed.  Read more...

Azure SQL Data Warehouse uses SQL to query the data, but there are some differences to SQL Server's dialect of TSQL, and queries don't necessarily work in the same way. DBAs are also required to use SSDT to access Azure SQL Data Warehouse. It is worth taking the time to try the preview of the product, and take it for a 'spin around the block', following Robert Sheldon's walk-through.  Read more...

An introductory guide to querying files in Azure Data Lakes using Microsoft's U-SQL language.  Read more...

In this chapter, we will show how to create a Machine Learning experiment from our Azure SQL Warehouse.  Read more...

What are your options for connecting to an Azure VM? Sure, a Remote Desktop Protocol (RDP) connection will get you started but you'll soon need a full secure VPN connection. Azure can provide three different options for doing this: Point-to-Site (P2S), Site-to-Site (S2S), and ExpressRoute, but what are their relative advantages, and which one is right for the way you need to use Azure?  Read more...

In earlier chapters, we talked about the Microsoft Data Mining enemies. We will talk now about Microsoft Azure Machine Learning.  Read more...

Azure SQL Data Warehouse is an obvious first-step towards migrating on-premise organisational data to the cloud. So how do you get started with it? Robert Sheldon provides a simple guide that should provide you with sufficient of the the basics you need to get a SQL Data Warehouse database up and running.  Read more...

In this article, Marcin Policht describes the basic functionality and implementation steps for Azure SQL Database's Elastic Database jobs.  Read more...

Tim Radney talks about the initial differences he has encountered while mastering the art of performance tuning Azure SQL Database.  Read more...

Have you created a Data Factory in Azure and are wondering how to get it into TFS and source control? This article will show you how.  Read more...

Microsoft cloud platform allows you to provide resiliency for your on-premises SQL Server deployments. Marcin Policht describes this functionality, available as part of the Azure Site Recovery solution.  Read more...