I usually use Spotify to listen to podcasts, but because I use Spotify with my children, I want to find another Podcast App for my personal use. And I find Pocket Casts has an interesting feature, it can skip the first or last *** seconds. It means some podcasts have an introduction at the beginning, if you want to …

Read More

If you want to get the 1st record of range records, you can use this SQL command. 1SELECT * FROM 2(SELECT DISTINCT rank() over(PARTITION BY a.username ORDER BY a.update_dt desc) rn, a.* 3 FROM table_name a 4 WHERE a.update_dt > p_cur_timestamp 5 AND a.update_dt <= p_cur_timestamp + C_PERIOD 6 ) 7WHERE rn = 1

Read More

Remind This is for .NET 4.8 or below only!! Precondition You already have a GitLab (GitLab Saas or GitLab self-managed). This document is for .NET 4.X, if you want to build .NET core or .NET 5/6/7/..., you can use docker to run GitLab Runner. Procedure Step 1 - Prepare .NET build environment First, you need to prepare …

Read More

Requirement I want to have daily mail including currency exchange rate information. Mail subject: include the exchange rate in the mail subject. Mail content: Has some links to banks' exchange rate pages. Include some exchange rate history charts. Solution Use ifttt.com Create a new Applet on IFTTT Add a new "If This" …

Read More

Requirement I want to have daily mail including currency exchange rate information. Solution use https://wise.com (no need to register an account) Connect to https://wise.com/tools/exchange-rate-alerts/ Input the currency exchange rate you want to know and your email address. Mail result You will receive the mail …

Read More

Purpose Checkmarx is a good tool to do code analysis, but there are 2 pain points during the flow. Checkmarx can integrate SCM like GitHub/GitLab/..., but it cannot be triggered by by a code commit, it can only schedule the job to run the scan. (If I don't commit code, I don't want to waste resources scanning the …

Read More

Purpose In previous article, we know how to integrate GitLab and Checkmarx. In this article, we want to integrate SonarQube too. When we commit code to GitLab, we want GitLab to trigger these actions automatically: GitLab sends the code to Checkmarx to scan. GitLab triggers SonarQube to scan. SonarQube integrates …

Read More

Check table size (remember to check last_analyzed_date) 1SELECT * FROM all_tables WHERE table_name LIKE 'AB%' Re-analyze table 1ANALYZE table TABLE_NAME estimate statisitics Check index-related information (it doesn't contain block information) 1SELECT * FROM all_indexes WHERE table_name LIKE 'AB%' Re-analyze index: …

Read More