Technical Articles on .NET, Acumatica & Enterprise Software Development

Blog Aug 07, 2026

Understanding Semi Joins and Anti Joins in SQL

INNER JOIN is often used to find matching rows, but it can create duplicate results if the matching table has multiple records. Semi-joins and anti-jo...

read.article() Read →

Blog Aug 07, 2026

Hierarchical Data and Recursive CTEs

Standard SQL struggles with hierarchical data like org charts, multi-level product categories, or comment threads. Recursive Common Table Expressions ...

read.article() Read →

Blog Aug 07, 2026

Mastering SQL Window Functions

Window functions are a game-changer for analytical queries. They let you perform calculations across a set of rows related to the current row, without...

read.article() Read →

Blog Aug 07, 2026

Acumatica Customization: The Ultimate Do's and Don'ts Guide

Common mistakes developers make and how to avoid them Acumatica's customization framework is one of its greatest strengths—but also one of its bi...

read.article() Read →

Blog Jul 31, 2026

Using PXRestrictor with Complex Joins in Acumatica

Advanced techniques for implementing restrictions with subqueries and Foreign Keys The PXRestrictor attribute is a powerful tool for implementing...

read.article() Read →

Blog Jul 31, 2026

Program.cs vs. Startup.cs in ASP.NET Core: Best Practices 2026

Program.cs vs. Startup.cs One of the first decisions you make when starting a new ASP.NET Core project is the structure of your application start...

read.article() Read →

Blog Jul 20, 2026

Welcome to ACUAMITCA – Building Software That Solves Real Business Problems

This website is my personal space to share the software I build, the problems I solve, and the lessons I learn while working with modern business appl...

read.article() Read →

Blog Jul 20, 2026

Mastering Async/Await in C#

Async/Await in Production: The Mental Model That Matters The async and await keywords make asynchronous C# code look almost synchronous. That is th...

read.article() Read →

Blog Jul 20, 2026

High-performance data access using Dapper with the Repository pattern

Dapper is a lightweight, high-performance micro-ORM that sits right on top of ADO.NET. It gives you the best of both worlds: the speed of raw ADO.NET ...

read.article() Read →

Technical Articles.