Hello there! I am Eric Wong, I enjoy learning new technologies, and are interested in cybersecurity, web development, system optimization, DevOps, and process automation. I also do freelance website and system development, learn more about me, check out my portfolio, and get in touch if you would like to talk!



Recent posts

MOCSCTF 2024 WRITE-UP - ONE TIME PAD CHALLENGE

One Time Pad is a crypto challenge in MOCSCTF 2024. It is a standard Python crypto challenge, which as the name suggests, involves exploiting encryption padding weakness.

BUILDING A DATA DICTIONARY FOR SQL SERVER, MYSQL, AND POSTGRES

As a data analyst in a large enterprise, we have to touch tens of application databases, and each database would have tens and hundreds of tables. Building a data dictionary is a crucial step to help discover what data is available. In this post, we will build the SQL for compiling schema information from SQL Server, MySQL and PostgreSQL databases, and further automate the building of data dictionary in a SQL Server-with-linked-servers environment.

RESTORING CORRUPTED QNAP VOLUME

Some time ago, I set up a QNAP NAS in my home for our family to store our photos and documents. To protect ourselves from data loss, I configured a RAID 1 raid group on the NAS, and additional cloud backup is also done, classic 1-2-3 rule. Last month, I discovered that one of the HDD has reached a dangerously high bad block count, so I shopped for a new HDD to replace the broken one.