Category: Coding
-
How to Prevent Identity Column Exhaustion in SQL Server
As a software developer, you’ll likely work with one or multiple database systems that integrate with your applications. One of these database systems is Microsoft’s SQL Server. In this post, I’d like to list some tasks you might consider to reduce headaches and make your work more enjoyable. Microsoft SQL Server is a fantastic relational…
-
Technology Has Lowered the Bar for Starting a Business
Starting a business was once a monumental task, particularly for endeavors requiring significant investment, such as spacecraft, pharmaceuticals, or automotive manufacturing. However, the landscape for launching software or service companies has vastly improved in terms of accessibility. There was a time when establishing a software business necessitated significant investments in server space, hardware, and costly…
-
Tinkering with AI: My First Steps
Lately, I’ve been exploring the realms of Artificial Intelligence (AI) and Machine Learning (ML). My interest was sparked by a project at my day job, where we identified the potential for a simple ML model to enhance our data mapping process. We often encounter straightforward cases where source values directly map to expected system values,…
-
A day of decoding SQL scripts
Today served as the perfect embodiment of the a common saying and a trusty algorithm. For months, we’ve been toiling away on a project of considerable complexity. Not only is the technical side intricate, but the sheer number of steps involved to ingest, transform, and persist data amplifies the complexity. While examining my upcoming task,…
-
The Code Typing Test Game
I’ve started coding small apps again to help me understand and apply cool code functions and APIs I discover online. Below is an example of a JavaScript game I created to learn more about the Octokit API and the typing animation inspired by ChatGPT. The code is straightforward, and I provide details about its functionality…
-
How to (efficiently) delete millions of records in a SQL table
[Updated on 2024-06-30 based on feedback from comments] A while ago, I blogged about how to efficiently update millions of records in a SQL table, today I’d like to show you a simple trick to do the same when deleting millions of records in a SQL table. The idea is the same, you don’t want…
-
A simple explanation of the four basic concepts of Object-Oriented Programming (OOP)
As a software engineer, the concept of object-oriented programming is something you need to learn, understand, and be able to explain simply to anyone who asks. Therefore, most interviews for programming jobs will include questions about object-oriented programming. In this post, I’d like to share a list and a simple description of the four concepts…
-
A simple explanation about Software Architecture and Software Design
I have been working as a software developer for many years now. In my experience, many people (including myself) confuse these two processes and talk about them interchangeably as if they are the same thing, but they are not. I hope this post helps clarify the distinction between these two important processes. For years I…
-
Where are the Authentication views in AspNet Core App?
I am struggling with Visual Studio for Mac. I have been a Visual Studio user since it came in multiple CDs in a box. Visual Studio has been improved a lot, I like it more now than I did before. But there is a problem, the VS version for the Mac is a completely different…
-
Don’t forget about character casing when comparing strings!
There are many issues I’ve experienced during the many, many years I’ve worked as a software developer. But one of the most recurring issues is, without a doubt, the mismatching of words due to character casing. There are solutions to the character casing mismatch problem. For example, you can make your strings all lower case…