You can leverage ADF’s parameters feature with Mapping Data Flows to create pipelines that dynamically create new target tables. You can set those table names through Lookups or other activities. I’ve written a very simply post below on the tools … Continue reading Dynamic SQL Table Names with Azure Data Factory Data Flows
I’m going to use this blog post as a dynamic list of performance optimizations to consider when using Azure Data Factory’s Mapping Data Flow. I am going to focus this only to files. I will post subsequent articles that list ways to optimize other source, sinks, and data transformation types. As I receive more good practices, feedback, and other performance tunings, I will update this article accordingly. Here is Azure SQL DB Optimizations for ADF Data Flows Here is Azure SQL DW Optimizations for ADF Data Flows Optimizations to consider when using ADF Mapping Data Flows with files NOTE: When … Continue reading ADF Mapping Data Flows: Optimize for File Source and Sink
I’m going to use this blog post as a dynamic list of performance optimizations to consider when using Azure Data Factory’s Mapping Data Flow. I am going to focus this only to Azure SQL DW. I will post subsequent articles … Continue reading ADF Mapping Data Flows: Optimize for Azure SQL Data Warehouse
I’m going to use this blog post as a dynamic list of performance optimizations to consider when using Azure Data Factory’s Mapping Data Flow. I am going to focus this only to Azure SQL DB. I will post subsequent articles … Continue reading ADF Mapping Data Flows: Optimize for Azure SQL Database
There are a lot of “best practice” and “performance guide” links available on the Internet to provide guidance on migrating SQL Server instances and databases from on-prem to Azure on VMs (aka Azure IaaS). In this post, I wanted to share a few findings from the field that I’ve encountered along the way recently working with customers on projects that migrate from on-prem SQL Server to Azure VMs. This is not a guide to migrating to Azure SQL Database and I do not cover all of the issues, migration steps or performance measures in an exhaustive manner. I will share … Continue reading SQL Server on Azure VMs – Updated Tips April 2017
MSSQLDUDE Blog 