I am a Software Engineer with 14 years of experience in industry. I am here to share my learnings and experiments with technology. I am a Software Engineer with 14 years of experience in industry. I ...

Iron Software builds trusted .NET libraries for document automation. CSV remains the most common tabular data exchange format in enterprise software. From database exports and financial feeds to IoT ...

A cron job that worked perfectly for six months suddenly runs two hours early. A payment dashboard shows yesterday's revenue in today's column. Session tokens expire at unpredictable times. These bugs ...

The error “Column is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause” appears when a query uses ...

This is an app for Nextcloud that offers user management and authentication with arbitrary SQL queries. You can authenticate, create, delete users, change their ...

Excel is a powerhouse at transforming and manipulating data, thanks to a wide variety of Excel formulas and in-app tools. Add Power Query to this already powerful mix, and you get an even more ...

Splitting a string by a delimiter in SQL Server involves breaking a single text string into smaller parts based on a chosen character. This is often done using functions like STRING_SPLIT, which ...

The automation of repetitive tasks has become part of today’s workplace, whether CPAs are engaged in industry, governmental, not-forprofit, or public accounting. This automation can consist of ...

The simplicity and ease of use that allows Power BI users to quickly gather data and generate interesting and powerful reports to make intelligent business decisions also allows users to easily ...

First off, let’s create an ASP.NET Core 7 project in Visual Studio 2022. Follow these steps: We’ll use this ASP.NET Core 7 Web API project to work with advanced features of Dapper in the sections ...