As software engineers who have experience with databases and application languages, we are often asked to troubleshoot difficult performance problems. Most of those problems present in the database, and in …
AI’s future looks impressive but is constrained. Models will get faster, cheaper, and more integrated into daily work, but none of that changes the reality of the situation. AI is …
ETL by API can be done well, but the reality is most of the time it is not. Why? APIs were designed to back applications and allow for communication between …
After two decades in software engineering, I’ve seen a fair number of ORMs come and go, and I’ve worked with everything from ADO.NET to Entity Framework. Lately, I’ve been spending …
C# Attributes are absolutely powerful.Attributes are metadata that you attach to code elements (think classes, methods, properties, etc).I like to think of attributes as tags that give additional information, but …
Interfaces define a contract that classes can implement. They allow for a flexible approach by specifying a set of methods or properties that the implementing classes must provide. While interfaces …
A memory leak transpires when a program fails to deallocate memory that it has previously allocated.This oversight results in a progressive increase in memory consumption, which can ultimately degrade system …
Performance tuning is usually focused on the database because many problems will manifest there, although some of the problems are not caused there. We will begin by analyzing the presentation …
SQLite is a lightweight, self-contained SQL database engine.The entire database is a single file on disk. 1) VACUUM. Reclaim unused space and defragment the database file. 2) INDEX. Create indexes …
When creating a basic C# console application, such as a web scraper, keep these essential tips in mind. Remember to consider access modifiers: They protect the internal state of the …
