Dark

Auto

Light

Dark

Auto

Light

Blog

The Row Number function

As a SQL Server engineer, I often find myself reaching for the ROW_NUMBER() function when I need to assign unique row numbers to rows within a result set. This versatile function is a staple in data manipulation and analysis, and it can be applied to a wide range of use cases. In this article, I’ll explore some practical scenarios where

Read More »

Career Update

To anyone interested on my profile I just wanted to provide a brief career update, I have been working full time since July 2022 therefore I am not available for freelancing tasks, if you would like to make a job offer reach out by using the contact form of the main website. Happy holidays,Carlos.

Read More »

How to Protect Sensitive Data Against Quantum Computers

I was reading this article yesterday about how hackers keep harvesting data so that they can decrypt it in 10 years when quantum computers may be available to do just that. Me being a Msc student of software engineering I decided to give a shot at a potential solution, so here is my idea on how to tackle the problem.

Read More »

How Colombia Should Collect Data for Decision Making

I was reading The Economist earlier today (the October 23rd edition) and its main topic of the week, third wave economics, got me thinking how countries like Colombia should be making their decisions. Colombia has a National Department of Statistics (DANE in spanish) that publishes data on things like surveys and unemployment every quarter or so depending on the topic.

Read More »

Moving to Finland

We recently moved to Lappeenranta, Finland, near the border with Saint Petersburg since I’m doing the second year of my masters degree at LUT. I’m chasing a double degree option to attain a title of Msc in software engineering and digital transformation. The process of getting physically to Lappeenranta was a bit challenging, given the covid impact on travel and

Read More »