Rajanand's Blog

Archive (76)

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

Jun 29, 2023 ·  Rajanand Ilangovan

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

Jun 23, 2023 ·  Rajanand Ilangovan

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

May 31, 2023 ·  Rajanand Ilangovan

Finding Top Customers Who Ordered Every Week

Apr 21, 2023 ·  Rajanand Ilangovan

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

Apr 16, 2023 ·  Rajanand Ilangovan

Understanding Calculated Columns and Measures in DAX

Apr 9, 2023 ·  Rajanand Ilangovan

Mastering DAX Basics

Apr 8, 2023 ·  Rajanand Ilangovan

Data Modeling in DAX

Apr 6, 2023 ·  Rajanand Ilangovan

Beginner's Guide to ETL: Extract, Transform and Load

Apr 4, 2023 ·  Rajanand Ilangovan

OLAP vs OLTP

Apr 2, 2023 ·  Rajanand Ilangovan

What is Data Warehousing?

Apr 1, 2023 ·  Rajanand Ilangovan

Data Analyst

Mar 22, 2023 ·  Rajanand Ilangovan

SSIS Error: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.

Mar 21, 2023 ·  Rajanand Ilangovan

Data Engineer

Mar 19, 2023 ·  Rajanand Ilangovan

PowerShell: Objects, Properties and Methods

Feb 14, 2023 ·  Rajanand Ilangovan

PowerShell Cmdlets and Alias

Feb 4, 2023 ·  Rajanand Ilangovan

PowerShell Variables

Feb 3, 2023 ·  Rajanand Ilangovan

PowerShell Overview and Basics

Feb 1, 2023 ·  Rajanand Ilangovan

SSIS Error: Unable to load the package as XML because of package does not have a valid XML format.

Jan 31, 2023 ·  Rajanand Ilangovan

SSIS Error: Failed to open package file "T:\SSIS\Package.dtsx" due to error 0x80070003 "The system cannot find the path specified.".

Jan 31, 2023 ·  Rajanand Ilangovan

SSIS Error: Cannot create a task from XML for task, "task" type Microsoft.ExecuteProcess due to error 0x80070057 "The parameter is incorrect

Jan 30, 2023 ·  Rajanand Ilangovan

Dashboard Inspirations

Jan 20, 2023 ·  Rajanand Ilangovan

SQL Server Performance tuning and troubleshooting checklist

Dec 20, 2022 ·  Rajanand Ilangovan

How to search for a table or column in all the databases in a server

Nov 17, 2022 ·  Rajanand Ilangovan

How to fix the error of dynamically generated T-SQL query when the syntax is correct?

Oct 12, 2022 ·  Rajanand Ilangovan