It was a Sunday, I was working on my tile as usual. Pulling a double shift on weekends has become a norm, but enough about that. This isn't my construction blog. The email came in about Azure Data Factory. My friend happened to watch my video and reached out for help. Watch it on YouTube… Continue reading My pipeline is slow, what do I do?
Azure Data Factory From On-Prem to Data Warehouse Agenda: Azure Data Factory Data store Connectors 80x On-Premises DevOps Automation Notifications Resources by: Hiram Fleitas Twitter: @hiramfleitas Blog: http://fleitasarts.com Video Recording https://youtu.be/TXxssUeqsOA Resources fleitasarts.com github.com/hfleitas/rig netflix.com/trollhunters Azure Data Factory: GitHub Integration Azure Data Factory: Documentation Azure Data Factory: Copy Activity Performance Azure Data Factory: Connector Azure SQL Data Warehouse Connector… Continue reading Microsoft Data & AI South FL (Nov 2019) Azure Data Factory
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… Continue reading DW Table Distribution Options ⚡
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… Continue reading Recent Benchmark Studies 🧩
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… Continue reading Copy from On-Prem to Azure SQL with Azure Data Factory 📺
This list of tools and resources are intended to help you manage a Big Data Cluster (SQL, PDW, HDFS, Spark, k8s) on SQL Server 2019. You can already start familiarizing yourself with them to better prepare your implementation. Install big data tools - SQL Server big data clusters | Microsoft Docs https://t.co/uAgY4d9gMT — Hiram Fleitas… Continue reading SQL Server Big Data Cluster 🧭