How to filter non-existing records in SQL

Introduction Developing predefined reports in addition to all the ad-hoc queries have been a part of my daily activities. Often I find my stakeholders asking me to prepare reports in which they want to know something that has never happened. It might sound strange, but yeah, that's what their point of concern is all about. […]

What You Need to Know About Data Classifications in Azure SQL Data Warehouse

Data classifications in Azure SQL DW entered public preview in March 2019. They allow you to label columns in your data warehouse with their information type and sensitivity level.

Pausing / Resuming Azure SQL DW

Before writing about pausing (and resuming) Azure SQL Data Warehouse (DW) it makes sense to discuss the architecture of this product. At a high level it involves a control...
The...

Where should I clean my data?

James Serra talks about where you should you clean your data when building a modern data warehouse in Azure.

Azure DWH part 28: The ASDW enemies

This time, we will talk about the competition or alternatives to Azure SQL Data Warehouse.

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.