Category: How-To
-
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…
-
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…
-
Focus and avoid context switching
My day job as a software engineer requires a great deal of focus and organization. Writing code is one of the last steps you do in software development. Writing code only comes after gathering enough information and understanding what changes or features we need in an application. Focusing on one task, but more importantly, one…
-
How to (efficiently) update millions of records in a SQL table
You need to update one or more columns in a table with millions of records with data from another table, what’s a good way of going this with low risk and in an optimized way? One of my favorite ways of dealing with millions of records in a table is processing inserts, deletes, or updates…
-
Must-have VS Code Settings for Web Development
Last week I wrote about must-have VS Code extensions for web development. This time, I’m writing about the recommended settings to make sure these extensions and VS Code work correctly. VS Code is an excellent tool for writing software, and when you install the right extensions, it can be very powerful. However, if these extensions and…
-
Here’s one way to cure procrastination
Writing is something I enjoy doing, , but to be very candid, it is hard for me to sit down and start writing. It’s the same feeling I have about working out, for example, love the feeling while exercising and then after when I’m done, but it isn’t easy to start an exercise routine; starting…
-
How to host a static website on Amazon’s AWS with SSL using S3, Certificate Manager, CloudFront, and Route53
So you have a static website and need to host it somewhere, there are many places to host your site but since you also want your site to have a security certificate, and you want all of this at a reasonable price, your options are limited. Last year, I tried Azure Storage to host a…
-
How to consume books while hiking, driving, or washing dishes. Hint: Audiobooks.
The thing is, as much as I enjoy reading paper books and also books in my kindle, it’s nearly impossible and highly irresponsible to do it while walking, washing dishes, or driving, it really isn’t safe. Now, I’ve known about Audible for a while, but for some reason, just never tried it until recently. However,…
-
Failed to authenticate HTTPS connection. Conflicting certificates for localhost when using Visual Studio for Mac
Lately, I have been trying Visual Studio for Mac as this version of Visual Studio has evolved significantly. However, something I noticed is that since I don’t use it often, the local SSL certificates created by dotnet in the Mac get a bit screwy. There is a possibility that you might end up with a…
-
How to Monetize your Blog with Google AdSense
How to monetize your blog? When you’ve had a blog for a while with plenty of content and visitors, one of the options you have it to monetize it is displaying ads. You care about your site and your content, and you should care about the ads you choose to show in your website. Google…