Blog posts

2025

How to import data into PostgreSQL?

Working with PostgreSQL databases often requires moving data in and out of tables, and PGAdmin makes this process seamless with its intuitive interface. If you have data in CSV or text files and want to bring it into your PostgreSQL table, here’s a clear, actionable guide to help you do it effortlessly.

What is Azure AI Foundry?

Understanding Azure AI Foundry in detail.

I saw this video on Azure AI Foundry on YouTube by John Savill.

How to create and manage Azure resources?

Discussing about different ways to create and manage Azure resources. There are many ways to interact with Azure resources and the right tool to choose depends on the requirements of a particular task.

DP-100 Preparation Notes

My notes to prepare for DP-100 exam. This includes some important concepts which may help.

15 Days of DAX Series

This is the 15 days of DAX series that I have created on LinkedIn. Learn 50+ common DAX functions in Power BI with simple examples.

AI-900 Preparation Notes

I have created this notes while I was preparing for AI-900 exam. It includes some important concepts essential for this exam.

2024

Azure Data Flow Derived Columns

In this task, we are going to use derived columns transformation in Azure Data Factory to split a column into 2 columns.

Azure Data Flow Conditional Split

In this task, we are going to use conditional split in Azure Data Factory to split the data in a Persons table present in Azure SQL Database to split the data based on the age column.

Azure Data Flow Conditional Flatten

In this task, we are going to flatten the json file stored in a Container in our storage account.

In the json file, the data is an array of arrays, so we are going to flatten it to individual records.

Enable Security for Azure Data Lake

Understanding how to enable security for Azure Data Lake.

The security model in Azure Data Lake Storage supports both RBAC and ACLs. Azure role assignments are evaluated first. They take priority over any ACL assignments.

Pricing Calculator in Azure

In this exercise, you use the Pricing calculator to estimate the cost of running a basic web application on Azure.

TCO Calculator in Azure

In this exercise, you use the Total Cost of Ownership (TCO) Calculator to compare the cost of running a sample workload in your datacenter versus on Azure.