Azure DWH part 22: Dynamic Management Views

The DMV are very effective and important to administer ASDWH. In this article we will show some important DMVs.

Azure DWH part 21: Using Excel in ASDWH

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

EXPLAINing plans

Creating ASDW tables

Getting Started with Azure SQL Data Warehouse - Part 6

Azure SQL Data Warehouse is Microsoft’s new enterprise-class, elastic petabyte-scale, data warehouse service that can scale according to organizational demands in just few minutes. In this installment, Arshad Ali covers the different ways to load data into SQL Data Warehouse.

Azure DWH part 11: Data Warehouse Migration Utility

There is a new utility to import data from SQL Server on premises or Azure SQL to Azure SQL Data Warehouse (ASDW)

Azure DWH part 10: WPF and Azure SQL Data Warehouse

In this article, we will show how to create a WPF application and show how to insert data to ASDW.

Getting Started with Azure SQL Data Warehouse - Part 5

In part 5 of this series covering Azure SQL Data Warehouse, Arshad Ali looks at performance optimization.

Getting Started with Azure SQL Data Warehouse - Part 4

Azure SQL Data Warehouse is a new enterprise-class, elastic petabyte-scale, data warehouse service. Join Arshad Ali as he discusses round-robin and distributed tables, and how to create them. He also discusses how partitioning works in SQL Data Warehouse and looks at the impact of choosing the right distribution key. As a bonus Arshad shows you how to leverage PolyBase to quickly and easily import or export data from SQL Data Warehouse.

Azure DWH Part 8: Accessing Azure SQL Data Warehouse with C#

In this new article, we will learn how to access to our Azure DWH tables using C#.