DW Table Distribution Options ⚡

Replicated (optional) vs Round Robin (default) vs Hash (optional) The statement about replicated vs round robing is simply a storage distribution setting. In the data warehouse world due to the massive parallel processing capabilities these distribution settings help us do performance tuning so queries run optimal at a lower cost. Azure SQL Data Warehouse has…

Recent Benchmark Studies 🧩

Perhaps you haven't seen it. Hopefully it helps someone as it has others. It is specific to APS (Analytics Platform System) and PDW (Parallel Data Warehouse), even if you're assessing other items. Want to evaluate your cloud analytics provider? Here are the three questions to ask. By Julia White, Corp VP, Microsoft Azure. Independent benchmark results Company-wide…

Copy from On-Prem to Azure SQL with Azure Data Factory 📺

PASS Insights In this short video, I demonstrate how to copy data or multiple tables from an on-prem SQL Server, through a self-hosted run-time integration to Azure SQL DB Hyperscale and/or Azure SQL Data Warehouse with Azure Data Factory. Plus, how to automate tasks like Resuming or Pausing your Azure SQL Data Warehouse before or…

Backup SQL Server Database(s) to Azure Blob Container

This is a step by step guide to help a friend that is looking for a quick and inexpensive way to upload/migrate his small on-prem SQL Server databases onto Azure cloud without having to use complex tools.   Note: This will work on SQL Server 2012 or above with internet connectivity.   SUMMARY: Create Azure…