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 … Continue reading How to (efficiently) update millions of records in a SQL table

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 anexcellent tool for writing software, and when you install the right extensions, it can be very powerful. However, if these extensions and VS Code … Continue reading Must-have VS Code Settings for Web Development

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 … Continue reading How to host a static website on Amazon’s AWS with SSL using S3, Certificate Manager, CloudFront, and Route53

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, … Continue reading How to consume books while hiking, driving, or washing dishes. Hint: Audiobooks.