archives

2022  15

December  5

Note - Learn In Public

December 29, 2022 · 1 min · 4 words · Eric

Convert HEIC Images to JPEG with macOS

December 21, 2022 · 1 min · 30 words · Eric

Using ImageMagick to Add Watermark

December 18, 2022 · 2 min · 215 words · Eric

Resource Allocation Between Teams

December 5, 2022 · 1 min · 75 words · Eric

Orangise Hackathon in Your Organisation

December 2, 2022 · 7 min · 1440 words · Eric

November  3

General Social Rules

November 28, 2022 · 3 min · 605 words · Eric

Orangise Team Day Off-site

November 25, 2022 · 1 min · 104 words · Eric

Create Random Pairs in Excel & Google Sheets

November 16, 2022 · 1 min · 213 words · Eric

October  2

Facilitate Productive Workshop

October 19, 2022 · 2 min · 310 words · Eric

Meeting in Workplace

October 12, 2022 · 6 min · 1223 words · Eric

September  3

Thoughts from Career Fairs

September 6, 2022 · 3 min · 635 words · Eric

Technical Project Workload Estimation

September 4, 2022 · 1 min · 165 words · Eric

Pick the Low-Hanging Fruits First  [draft]

September 2, 2022 · 1 min · 9 words · Eric

July  1

Lambda vs Kappa Architecture

July 1, 2022 · 4 min · 722 words · Eric

June  1

Team Building Events

June 1, 2022 · 2 min · 318 words · Eric

2021  8

November  1

Cost Optimisation for AWS Resources  [draft]

November 27, 2021 · 1 min · 5 words · Eric

September  2

Keep Mental Health

September 27, 2021 · 3 min · 517 words · Eric

读书笔记 - 奈飞文化手册 (Patty McCord)

September 23, 2021 · 5 min · 931 words · Eric

June  1

Disagree Agreeably  [draft]

June 21, 2021 · 1 min · 15 words · Eric

May  1

How To Getting Buy-in for Your Ideas  [draft]

May 3, 2021 · 1 min · 32 words · Eric

April  1

Configure Java Environment on macOS Big Sur

April 7, 2021 · 1 min · 67 words · Eric

January  2

Effective Retrospective  [draft]

January 19, 2021 · 1 min · 6 words · Eric

Data Engineering Project Template  [draft]

January 7, 2021 · 2 min · 382 words · Eric

2020  19

November  3

Shared-nothing Architecture

November 13, 2020 · 1 min · 4 words · Eric

Building Modern Data Lake on AWS  [draft]

November 10, 2020 · 1 min · 4 words · Eric

Top System Design Questions

November 10, 2020 · 1 min · 118 words · Eric

October  1

Uninstall Anaconda on macOS

October 10, 2020 · 1 min · 178 words · Eric

August  4

Snowflake Pro  [draft]

August 24, 2020 · 1 min · 4 words · Eric

Google Certificated Machine Learning Engineer  [draft]

August 17, 2020 · 1 min · 7 words · Eric

AWS SysOps Exam Preparation

August 8, 2020 · 9 min · 1917 words · Eric

Talk Note - Influence without Authority

August 2, 2020 · 1 min · 119 words · Eric

June  1

Navigate Through Ambiguity

June 11, 2020 · 1 min · 183 words · Eric

May  7

Snowflake Concepts

May 13, 2020 · 3 min · 625 words · Eric

Snowflake Common Command Reference

May 12, 2020 · 1 min · 46 words · Eric

Snowflake Note IV - Data Ingestion  [draft]

May 10, 2020 · 1 min · word · Eric

7 Best Practices for Snowflake

May 5, 2020 · 5 min · 991 words · Eric

Snowflake Note III - Essential Tools

May 4, 2020 · 1 min · 41 words · Eric

Snowflake Note II - Data Ingestion

May 3, 2020 · 2 min · 244 words · Eric

Communication in Workplace

May 3, 2020 · 2 min · 265 words · Eric

April  1

Snowflake Note I - General Introduction

April 28, 2020 · 1 min · 176 words · Eric

March  1

Be Energetic

March 17, 2020 · 1 min · 210 words · Eric

January  1

AWS Cloud Practitioner Exam Preparation

January 17, 2020 · 1 min · 165 words · Eric

2019  15

December  1

How to Setup DataGrip Connection to AWS Athena with IAM Role Profile

December 11, 2019 · 2 min · 217 words · Eric

November  1

AWS Storage Comparison

November 3, 2019 · 1 min · 147 words · Eric

August  1

Apache Kafka Knowledge Quick Reference

August 17, 2019 · 10 min · 2099 words · Eric

May  1

Resolve VT-X not enabled on Windows 10

May 22, 2019 · 1 min · 117 words · Eric

April  3

GitHub Projects

April 16, 2019 · 1 min · 31 words · Eric

Open Source Project Contribution Guidance  [draft]

April 16, 2019 · 4 min · 685 words · Eric

Leadership  [draft]

April 1, 2019 · 1 min · 51 words · Eric

March  5

Mac Developer Environment Setup

March 26, 2019 · 2 min · 389 words · Eric

Pants  [draft]

March 22, 2019 · 1 min · 8 words · Eric

Table Lock Issues in PostgreSQL

March 6, 2019 · 6 min · 1097 words · Eric

Pandas Best Practice

March 1, 2019 · 2 min · 330 words · Eric

PostgreSQL Best Practice

March 1, 2019 · 2 min · 299 words · Eric

February  2

Common AWS S3 CLI command examples  [draft]

February 2, 2019 · 1 min · 14 words · Eric

RequestTimeTooSkewed Error with AWS CLI

February 2, 2019 · 3 min · 490 words · Eric

January  1

Docker Build with Proxy

January 30, 2019 · 2 min · 323 words · Eric

2018  16

November  1

Get AWS EMR Cluster Info with Powershell

November 21, 2018 · 2 min · 280 words · Eric

October  3

EMR JobFlow Arguments Error  [draft]

October 30, 2018 · 1 min · 105 words · Eric

Apache Spark Job Optimisation

October 28, 2018 · 1 min · 65 words · Eric

Basic Usage of Pandas  [draft]

October 6, 2018 · 1 min · 38 words · Eric

September  1

Tips and tricks of Jupyter Notebook  [draft]

September 29, 2018 · 1 min · 15 words · Eric

August  1

Getting All Tables Information in Redshift

August 29, 2018 · 1 min · 186 words · Eric

July  3

Redshift Pipelines  [draft]

July 25, 2018 · 1 min · 12 words · Eric

All about Apache Parquet  [draft]

July 16, 2018 · 1 min · 21 words · Eric

Best practices of AWS EMR  [draft]

July 3, 2018 · 1 min · 15 words · Eric

June  4

Create vs Apply in Kubernetes

June 16, 2018 · 1 min · 74 words · Eric

Airflow in Practice - Interactive with Airflow Internal Storage

June 11, 2018 · 2 min · 332 words · Eric

Execute Scripts When User Logon Linux Server

June 4, 2018 · 2 min · 233 words · Eric

Airflow Notes I - Basic Concept

June 1, 2018 · 2 min · 286 words · Eric

May  3

Redshift Data Ingestion from S3  [draft]

May 25, 2018 · 1 min · 27 words · Eric

Upload Files to S3 Bucket

May 23, 2018 · 1 min · 191 words · Eric

Understand AWS Redshift Query Execution Plan  [draft]

May 9, 2018 · 0 min · 0 words · Eric

2017  12

November  1

System Design Practice - MyTube  [draft]

November 10, 2017 · 1 min · 18 words · Eric

June  1

2017 AWS Summit Auckland

June 1, 2017 · 3 min · 614 words · Eric

May  1

AWS Concept

May 7, 2017 · 3 min · 503 words · Eric

March  9

Offer Comparison  [draft]

March 26, 2017 · 1 min · 13 words · Eric

System Design Note VII - Database Design and Scaling

March 9, 2017 · 3 min · 505 words · Eric

System Design Note VI - Caching

March 8, 2017 · 3 min · 632 words · Eric

System Design Note V - Load Balancer

March 7, 2017 · 2 min · 394 words · Eric

System Design Note IV - Vertical and Horizontal Scaling

March 6, 2017 · 3 min · 618 words · Eric

System Design Note III - Numbers You Should Know

March 5, 2017 · 5 min · 1022 words · Eric

System Design Note II - Performance Metrics

March 4, 2017 · 3 min · 550 words · Eric

System Design Note I - Distributed Systems  [draft]

March 3, 2017 · 1 min · 5 words · Eric

System Design Note I - Distributed Systems

March 3, 2017 · 2 min · 391 words · Eric

2016  7

December  1

Unable to SSH AWS EC2 Instance

December 13, 2016 · 1 min · 187 words · Eric

September  2

Docker Command  [draft]

September 17, 2016 · 1 min · 17 words · Eric

How to Do 1 On 1 Meeting  [draft]

September 2, 2016 · 1 min · 3 words · Eric

May  1

Parse JSON Object with Jenkins

May 5, 2016 · 1 min · 100 words · Eric

April  1

Read Note - Learning Spark

April 1, 2016 · 3 min · 565 words · Eric

March  1

Data Warehouse Design - Inmon vs Kimball  [draft]

March 10, 2016 · 1 min · 32 words · Eric

January  1

Data Warehouse Concepts

January 16, 2016 · 3 min · 567 words · Eric

2015  5

May  2

Hive Query Performance Tuning

May 11, 2015 · 1 min · 108 words · Eric

Something about GeoJSON

May 10, 2015 · 1 min · 71 words · Eric

March  1

Python Libraries

March 6, 2015 · 1 min · 41 words · Eric

January  2

Interview Preparation for HR Round

January 7, 2015 · 5 min · 1003 words · Eric

Interview Tips

January 7, 2015 · 6 min · 1149 words · Eric

2014  5

March  5

Learning Sqoop By Practice V - Sqoop Job

March 7, 2014 · 1 min · 77 words · Eric

Learning Sqoop By Practice IV - Sqoop Export

March 6, 2014 · 2 min · 375 words · Eric

Learning Sqoop By Practice III - Sqoop Import

March 5, 2014 · 6 min · 1182 words · Eric

Learning Sqoop By Practice II - Sqoop Eval, List Databases and Tables

March 4, 2014 · 2 min · 321 words · Eric

Learning Sqoop By Practice I - Introduction

March 3, 2014 · 2 min · 361 words · Eric

2013  7

December  1

Hadoop Command  [draft]

December 17, 2013 · 1 min · 26 words · Eric

August  1

SQL Query Performance Optimisation

August 11, 2013 · 4 min · 673 words · Eric

April  1

Common Git Command  [draft]

April 16, 2013 · 1 min · 8 words · Eric

March  2

Advanced SQL Concepts

March 14, 2013 · 2 min · 386 words · Eric

Interview Preparation for SQL Questions

March 14, 2013 · 1 min · 39 words · Eric

February  2

Basic SQL Concepts

February 14, 2013 · 1 min · 59 words · Eric

Open Source Datasets

February 2, 2013 · 1 min · 127 words · Eric

2012  1

December  1

Site Timeline

December 31, 2012 · 1 min · 168 words · Eric