archives

2024  5

July  5

Azure Fundamentals of Generative AI

July 31, 2024 · 1 min · 123 words · Eric

Azure Fundamentals (AZ-900) - Part I

July 26, 2024 · 6 min · 1192 words · Eric

Azure Fundamentals (AZ-900) - Part II

July 24, 2024 · 13 min · 2623 words · Eric

Azure Fundamentals (AZ-900) - Part III

July 24, 2024 · 8 min · 1513 words · Eric

Exam Guide - Azure Fundamentals (AZ-900)

July 24, 2024 · 1 min · 91 words · Eric

2023  18

October  1

Strava Authorization Error - Missing activity read_permission

October 14, 2023 · 1 min · 7 words · Eric

August  2

How to Build Scalable, Maintainable, and Performant Software  [draft]

August 31, 2023 · 0 min · 0 words · Eric

Machine Learning with Databricks  [draft]

August 20, 2023 · 0 min · 0 words · Eric

June  3

Project Initiation - Starting a Successful Project  [draft]

June 11, 2023 · 7 min · 1425 words · Eric

Project Management Best Practices  [draft]

June 10, 2023 · 1 min · 9 words · Eric

Project Management Glossary  [draft]

June 10, 2023 · 0 min · 0 words · Eric

May  1

Foundation of Project Management  [draft]

May 28, 2023 · 13 min · 2663 words · Eric

April  2

Databricks Data Engineering Professional Preparation  [draft]

April 26, 2023 · 5 min · 1024 words · Eric

Exam Guide - Databricks Certified Data Engineer Professional

April 25, 2023 · 6 min · 1267 words · Eric

March  5

ChatGPT Tips and Tricks

March 27, 2023 · 1 min · 117 words · Eric

Databricks Best Practices  [draft]

March 16, 2023 · 9 min · 1803 words · Eric

Delta Lake Whitepaper  [draft]

March 12, 2023 · 1 min · 94 words · Eric

Useful Databricks References  [draft]

March 8, 2023 · 1 min · 65 words · Eric

Data Engineering with Databricks v2  [draft]

March 7, 2023 · 30 min · 6268 words · Eric

February  4

Exam Guide - Databricks Certified Data Engineer Associate

February 20, 2023 · 7 min · 1294 words · Eric

Databricks Lakehouse Fundamentals

February 8, 2023 · 7 min · 1327 words · Eric

Databricks Learning Path

February 8, 2023 · 1 min · 101 words · Eric

Databricks Glossary

February 1, 2023 · 5 min · 966 words · Eric

2022  16

December  6

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

dbt Fundamentals  [draft]

December 2, 2022 · 3 min · 488 words · Eric

November  3

General Social Rules

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

Organise Team Day Off-site

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

Create Random Pairs in Excel & Google Sheets

November 16, 2022 · 2 min · 329 words · Eric

October  2

Facilitate Productive Workshop

October 19, 2022 · 2 min · 315 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  10

November  1

Cost Optimisation for AWS Resources  [draft]

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

September  2

Keep Mental Health

September 27, 2021 · 4 min · 810 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  2

Notion Resources  [draft]

April 9, 2021 · 1 min · 6 words · Eric

Configure Java Environment on macOS Big Sur

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

January  3

Effective Retrospective  [draft]

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

Data Engineering Project Template  [draft]

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

DataOps  [draft]

January 7, 2021 · 2 min · 293 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 · 1914 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  17

December  1

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

October  1

First 90 Days

October 26, 2019 · 6 min · 1201 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  4

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

Engineer Manager Overview  [draft]

April 1, 2019 · 4 min · 720 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  18

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  2

Keep Windows PC Awake

September 30, 2018 · 2 min · 284 words · Eric

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 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

April  1

Resume resources

April 4, 2018 · 1 min · 55 words · Eric

2017  17

November  1

System Design Practice - MyTube  [draft]

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

October  2

Running Concept

October 31, 2017 · 1 min · 30 words · Eric

System Design Note - Core Concept  [draft]

October 31, 2017 · 1 min · 134 words · Eric

June  2

Homebrew on macOS

June 4, 2017 · 1 min · 32 words · Eric

2017 AWS Summit Auckland

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

May  2

Dao and Fa

May 8, 2017 · 1 min · 119 words · Eric

AWS Concept

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

April  1

Business of The 21st Century

April 8, 2017 · 3 min · 600 words · Eric

March  9

Offer Comparison  [draft]

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

System Design VII - Database Design and Scaling

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

System Design - Caching

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

System Design - Load Balancer

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

System Design - Vertical and Horizontal Scaling

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

System Design - Numbers You Should Know

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

System Design - Performance Metrics

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

System Design - Distributed System

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

System Design Note - CAP Theorem  [draft]

March 3, 2017 · 1 min · 14 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 · 5 min · 1045 words · Eric

2015  8

December  2

Managing Your Python Environment with Pipenv  [draft]

December 3, 2015 · 4 min · 677 words · Eric

Type Hint with Python  [draft]

December 3, 2015 · 1 min · 81 words · Eric

September  1

Interview Preparation for Hiring Manager Round

September 20, 2015 · 2 min · 274 words · Eric

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  7

June  1

Conversation Topic

June 9, 2014 · 1 min · 74 words · Eric

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

January  1

SQL Table Index

January 11, 2014 · 3 min · 437 words · Eric

2013  8

December  1

Hadoop Command  [draft]

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

August  2

Machine Learning Glossary  [draft]

August 20, 2013 · 2 min · 254 words · Eric

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

About this Site

December 31, 2012 · 2 min · 244 words · Eric