A step-by-step guide to creating a practice setup for the 70-462 exam using Azure virtual machines.  Read more...

Learn how you can move data from your Data Lake to Azure SQL Database with Azure Data Factory.  Read more...

Microsoft bought a data center.  Read more...

Did you know you can query SQL Server data with U-SQL? It's true! Find out how in this latest stairway step.  Read more...

Need to inspect your Data Lake objects and files? Want to automate the process? Find out how with PowerShell.  Read more...

In this article, we will show how to create an ASDW in Bash using the Cloud Shell.  Read more...

The majority of traditional database management systems are responsible for making sure that any changes to their data are consistently reflected in the results of subsequent queries. Azure Cosmos DB extends the range of consistency options by providing support for bounded-staleness, session, and consistent prefix models.  Read more...

In this new article, we will show how to audit the Data Warehouse Activities.  Read more...

This article will explain what is an elastic query and show an example.  Read more...

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

This article will show you how to set up SQL Monitor to monitor Azure-based clustered instances right alongside your on-premise clusters.  Read more...

SQL Server on-premises includes a module to create Data Mining models. We will show how to create them using ASDW.  Read more...

Tim Radney of SQLskills talks about the various Standard tiers available in Azure SQL Database – what they get you, and how much they cost.  Read more...

This time we will show how to access to Azure SQL Data Warehouse using Excel.  Read more...

Vitor Montalvao explains how to work with the basic configuration settings for a SQL Azure database from the Microsoft Azure portal itself.  Read more...

CTAS and CETAS are very important T-SQL features in ASDW. These features allow to create a table and fill with data based on a query.  Read more...

This week Steve Jones asks about moving to the cloud and how interesting that might be to the community?  Read more...

In the part 18, we created a Cube based on the Azure Data Warehouse. In this new chapter, we will work with the cube, create backups and show some tips to restore.  Read more...

A SQL Server, SQL Azure and Hekaton performance bench marking application that uses patterns.  Read more...

There is already a template on the Azure marketplace for setting up an AlwaysOn Availability Group. In just a few easy steps you can get a working AlwaysOn Availability Group setup, configured and running - this post describes the steps to quickly set it up.  Read more...