Rajanand's Blog

Rajanand Ilangovan

Rajanand Ilangovan

7 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 read

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

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

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

Jun 23, 20231 min read

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 fix git "fatal: Authentication failed" issue after password change?

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

May 31, 20234 min read

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...

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

Finding Top Customers Who Ordered Every Week

Apr 21, 20234 min read

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

Finding Top Customers Who Ordered Every Week

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

Apr 16, 20238 min read

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 read

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