Rajanand's Blog

Rajanand Ilangovan

Rajanand Ilangovan

31 followers

I'm a Business Intelligence Developer with over a decade of experience in design and development of databases, data warehouse, ETL, business intelligence reports and data visualization/analytics.

What is the difference between parameters and variables in Azure Data Factory?

Jun 29, 20233 min read1.2K views

In Azure Data Factory (ADF), parameters and variables serve different purposes in controlling and configuring pipelines. Here's a breakdown of the key...

How to fix git "fatal: Authentication failed" issue after password change?

Jun 23, 20231 min read32 views

Problem: I have the local git repository which is set up to track the remote git repository. I have changed the password of the remote git service....

How to Add Tables to an Existing Publication and Syncing Without Reinitializing the Subscription in SQL Server Replication

May 31, 20234 min read244 views

Problem: When I add a new table to the existing publication, I had to reinitialize the subscription. This creates a snapshot for all the articles...

Finding Top Customers Who Ordered Every Week

Apr 21, 20234 min read377 views

SQL Challenges ยท The Problem You have been given a table Orders that contain the following columns: OrderId (int) CustomerId (int) OrderDate...

Mastering DAX Context: Understanding Row, Filter, and Evaluation Context

Apr 16, 20238 min read1.6K views

When working with DAX in Power BI, there are three critical contexts that you need to understand: Row context Filter context Evaluation...

Mastering DAX Context: Understanding Row, Filter, and Evaluation Context

Understanding Calculated Columns and Measures in DAX

Apr 9, 20233 min read223 views

When working with data in Power BI or other analytical tools, creating calculations on the fly can be essential to understanding and making sense of...

Understanding Calculated Columns and Measures in DAX