I wanted a calendar table in SQL Server (Azure SQL Database), so here is a memo on how to create one. I googled, and it seems to be created by creating a table with "WITH" and then making a recursive call from "UNION ALL" in the table defi…

Git is difficult.... I thought I could do it by making a coping cheat sheet, but no luck.... Whenever there is a problem, we don't know what to do. There are multiple ways to write the same thing across commands, but this can be confusing …

Postscript (08/06/2019) Since only String type data can be passed from PowerApps to Flow, I had to manually convert map data to String, but you added a function to convert JSON data to String! qiita.com Now you can easily pass data! Data s…

Microsoft Flow has data types such as basic types, arrays, and maps (objects), but because the operations are wrapped in a GUI, it is very difficult to understand how to get from the data to the desired element values. Often, after much tr…

There is a Kubernetes package manager called Helm. I don't use it that often, but every time I search for how to use it, I make a note of it for myself. What is Helm? When adding functionality to Kubernetes, deploy it to the cluster with a…

We use Puppeteer as a crawler. Sometimes you are crawling and want to retrieve data from a table created by a Table tag on your site. With Python, this can be done elegantly by extracting only the tags below the Table tag from the html and…

It was convenient to use "cert-manager" + DNS authentication to automatically update Let's Encrypt on Kubernetes (GKE) without processing on the service side. I wrote Introductory note before, but the procedure had changed, so I rewrote it…