Introduction to SSIS and making it metadata independent
Introducing SSIS In the Microsoft Sql Server Integration services (SSIS), we have a variety of tasks to perform ETL. However, with changing data landscape and newer...
Azure Synapse Analytics: Azure SQL Data Warehouse revamped
Prologue On 5th November 2019, I read an early morning announcement of Azure Synapse Analytics. It was formerly known as Azure SQL Data warehouse. This announcement took...
Inside Bill’s Brain: revisiting the documentary
What’s Inside Bill’s Brain? One such winner is Bill Gates. ‘Inside Bill’s Brain: Decoding Bill Gates’ is a Netflix docuseries which brings...
Lambda Architecture with Azure Databricks
Introducing Lambda Architecture It is imperative to know what is a Lambda Architecture, before jumping into Azure Databricks. The greek symbol lambda(λ) signifies...
Comparing SSIS Lookup and SQL Joins
Motivating SSIS lookups Denormalization is the most important step to create a Data warehouse. Fundamentally, we do so to populate surrogate key of a dimension in a fact...
Is Artificial Intelligence a threat to Software Engineers?
The fear of the singularity Every threat is an opportunity The Forbes magazine article Software Ate The World, Now AI Is Eating Software reminded me of the movie...
Log Analytics with Python Pandas Explode
Prologue to Analytics with Python I strongly recommend reading this article before you go ahead with this article: Log Analytics using STRING_SPLIT function. This...
What is a Data Hub: Concepts and Guidelines
The V’s of Big Data: Before Data Hub Life was simple when we restricted ourselves to spreadsheets and relational data stores. Data was structured, databases were...
Azure Logic App deployment process with Powershell
Prologue A software product goes through three broad phases viz. development, testing and deployment. The last phase can be approached in multiple ways. One of the ways...
Making ADF Web activity synchronous with Logic App
Prologue It is a common scenario in ETL jobs to send Email Notifications. With Azure Data Factory, such an example can be found in this article. Accordingly, we use web...