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
Software development is hard, and it isn't always the programming language or the framework you use, it's the people who work on it. People are an essential part of a team; everything can be easily changed and fixed, but to achieve effective communication and a great culture, you need to make sure people work well … Continue reading Enabling software engineering teams for success.
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
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