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

Enabling software engineering teams for success.

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.

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

Must-have VS Code Extensions for Web Development

The VS Code editor is such a pleasure to work with; it is my code editor of choice when working with light C# projects or any other languages such as JavaScript or Ruby on Rails. Below are my must-have extensions for anyone doing web development. There are many more magnificent extensions, but I feel like … Continue reading Must-have VS Code Extensions 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