Posts

Explore content from different tag terms

error loading post image

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. Clustered Index A clustered index points to a block of physical data and does not require a separate table for the indexed column values as it directly identifies a record in a table....
error loading post image

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....
error loading post image

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. What is a SQL join? A JOIN clause is used to combine records or rows between one or more tables through a related column that references another record....
error loading post image

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....
error loading post image

Experience With Hugo

Building a personal site is never an easy task, although there are tools and frameworks available for web developers to aid in the building process. In this blog, I will share with you my Hugo development experience and the bits of knowledge I’ve gained when building my personal blogging site....
1 2

Tags: