Query Excel or CSV files with T-SQL without importing them in a table first

A series of my experiences and mistakes in working with databases up until now.

NET8/EF8 Breaking Change. Old servers/databases might not understand queries from EF8.

A small function utilizing CTE to replace undesired characters from a string

Using .NET Core 8.x to create a WebAPI framework which saves each user's data in a personal copy of Sqlite database.

A look at a simple SQL builder for Dapper

How Entity Framework Core 6 or 7 projects can take advantage of EF Core 8's OpenJson without having to migrate to EF Core 8 - using a custom NuGet Package for SQL Server

In this article, I provide a detailed overview of using IDistributed Cache to improve the performance of your EF Core queries, against On-Premise caching systems like Redis, NCache, SqlCache, MySqlCache, MongoDBCache and API Output caching.

An informal study of the Sqlite database and how many concurrent inserts it can handle. Will help you decide if you want to use Sqlite in your projects.

Examines the performance of SQLite in multi-threading applications