Configuration management is a cornerstone of application development, allowing flexibility and scalability across environments. While .NET Framework and .NET Core (now .NET) share 

Associate Software Engineer

Exploring Configuration Changes in .NET Framework and .NET Core

When transitioning from SQL Server to PostgreSQL, one common challenge is handling cross-database queries efficiently. SQL Server provides Synonyms as a way to create aliases for t

Foreign Data Wrappers in PostgreSQL: A Powerful Alternative to SQL Server Synonyms

In traditional SQL-based systems like MySQL or SQL Server, stored procedures can return multiple table views in a single call. However, PostgreSQL does not support returning multip

Returning Multiple Table Views in SQL Stored Procedures Using Refcursors in PostgreSQL

Exploring the Universe with SQL: A Galactic GuideWelcome to an exciting SQL refresher! Imagine we are building a universe database to store details about different solar systems an

SQL Refresher : Part - I

In Part I, we built the foundation of our databases and tables. Now, let's dive deeper into querying that data — starting with the mighty SELECT statement.1. The SELECT KeywordIn S

SQL Refresher : Part - II

Welcome back to the SQL Refresher series! In this post, we’re diving into the following SQL concepts—how to DELETE and UPDATE records, understand DELETE rules, explore smart table 

Mutukundu Mahendra Reddy

Associate Software Engineer