Latest From The Blog

ADF (Azure Data Factory) Daily Routine Expressions / ADF Expressions Cheatsheet

All keywords, function names etc. are case-sensitive Single quote to be used for string All expressions to begin with @ No direct use of operators; all manipulations through functions only Datetime format is SQL Server’s DATETIMEOFFSET format Accessing Parameter – Accessing Variable e.g. – Lookup Activity First Row – Lookup Activity Multi Row Output but

Continue reading

Did You Know…This About ADF For Each Activity

This post is a part of the series “Did You Know” whereby the purpose is to share some quick key point of a particular concept that helps us to be informed on top of our head or something that we want to be revisited quickly. So, no detailed discussions on the topic but a straight

Continue reading

Azure Cost Optimization With Reserved Capacities

One of the primary benefit of hosting our resources over cloud is the control that we get over the incurred cost. We can always manage that it doesn’t overshoot certain limits by defining some budgets and placing more governance around who can provision and scale up or scale out the resources. Once our workload is

Continue reading

Did You Know…These Data Types are Deprecated in SQL Server

This post is a part of the series “Did You Know” whereby the purpose is to share some quick key point of a particular concept that helps us to be informed on top of our head or something that we want to be revisited quickly. So, no detailed discussions on the topic but a straight finding about

Continue reading

Tip of the Day – ADF Mapping vs. Wrangling Data Flows

An easy way to understand the use case or concept around Azure Data Factory Mapping Data Flows and Wrangling Data Flows (now through Power Query) is to keep this on top of your head – Mapping Data Flows is Logic First design paradigm and Wrangling Data Flow is a Data First methodology

Continue reading

Did You Know…This About Azure Managed Identities

This post is a part of the series “Did You Know” whereby the purpose is to share some quick key point of a particular concept that helps us to be informed on top of our head or something that we want to be revisited quickly. So, no detailed discussions on the topic but a straight

Continue reading