
SQL: Clustered and Non Clustered Index
Indexes in SQL are a great way to identify and organize records. Indexing a column can also optimize queries as it reduces overhead and improves efficiency on frequently referenced columns. There are different types of SQL indexes, though this blog focuses on the contrast between clustered and non-clustered indexes.

Promise: all and allSettled
Promises… How long can one hold on to such promises? Nonetheless, this short blog refers to promises in JavaScript. There are two static methods from the Promise object that are used to handle multiple promise instances that resolves to an array of values. These methods are useful for validating and aggregating promise results.

SQL Joins
In this blog post, I will do a short walk-through on the use of the SQL join clause and its types to retrieve related data between two tables on a simple blogging database. Come and join the venture beyond SQL.

CSS Box Sizing Property
Styling with CSS is fun until you scratch your head when unexpected styling behavior starts to surface. Most of the time, web developers encounter overflowing content after applying style properties to an element. This is a “shoot yourself in the foot” moment where an element starts to overflow when setting such style properties. Though, there is a CSS property that can be utilized to control or mitigate overflowing elements.