Posts
All the articles I've posted.
-
Enabling Internet Access for Resources in a Public Subnet
When deploying resources in a public subnet within an AWS Virtual Private Cloud (VPC), you need to configure several components to allow them to communicate with the internet. Below are the essential
-
Network Address Translation (NAT): Overcoming IPv4 Shortages
Introduction Network Address Translation (NAT) is a technology designed to mitigate the shortage of IPv4 addresses by allowing multiple devices on a private network to share a limited number of public
-
Understanding Subnets, Gateways, and Route Tables in AWS
When designing applications in AWS, it's crucial to understand how networking components interact within a Virtual Private Cloud (VPC). This post will cover subnets, gateways, and route tables,
-
Generating a Calendar Table in Power Query (M Language)
When working with Power BI or other Power Query-supported tools, having a well-structured calendar table is essential for time-based analysis. In this blog post, we will walk through an M Language
-
How to Display an Error in Excel When More Than 5 "FALSE" Values Appear in a Row
Introduction When working with data in Excel, there may be instances where you need to monitor certain conditions and flag errors based on specific criteria. In this guide, we'll walk through a simple
-
Splitting Strings in Excel: A Simple Guide
When working with Excel, you may encounter situations where you need to split a string into separate parts. For example, consider the following string: orderId: 12345abc-de67-89fg-hijk-123456lmnop If
-
Handling Schema Changes in a Data Warehouse
When building and maintaining a Data Warehouse (DWH) , handling schema changes without breaking existing processes is a crucial challenge for data engineers. As new requirements emerge, we often need
-
Understanding How Hive Converts SQL Queries into Hadoop Jobs
When you execute a SQL query in Apache Hive, the query is not directly run on a traditional database. Instead, Hive translates it into a Hadoop job, which is then executed across a distributed system.