Clounce.com
One of the very reasons to work with JSON files is their ability to represent data as objects and arrays, in simple or complex combinations. When working with JSON files that represent data which was joined from different sources, there is a tendency of ending up with objects containing arrays of other objects. However, the … Continue reading Array concatenation from JSON file using Azure Data Factory
Some years ago, we saw how one can highlight a row in an Excel table based on a cell value. Today, we are going to look into how to highlight a column instead of a row. It is quite similar, so I will only focus on the change required and explain the functions used. To … Continue reading Conditional highlighting of a column in Excel
It has been a while that I wanted to leverage the power of ESP-8266 NodeMCU to monitor my aquarium. My first experiment is to read the water temperature every x interval and upload it to ThingSpeak. For this experiment, I need: ESP-8266 NodeMCU; DS18B20 waterproof sensors, which I bought from Amazon; 4.7kΩ resistor. The setup … Continue reading Simple Aquarium Temperature Sensor
Today, we are going to carry out a simple experiment using logic ICs to apply De Morgan First and Second Laws. They state that: – the negation of a disjunction is the conjunction of the negations – the negation of a conjunction is the disjunction of the negations Wikipedia Let’s keep the theory in the … Continue reading Applying De Morgan’s First and Second Laws using digital TTL ICs
An easy way to create new Policies in Azure is to use the Portal and duplicate an existing policy. However, when working with Infrastructure as Code, using the manual process is not ideal as the new policy won’t be part of the code. An option would be to export the existing policy and update the … Continue reading Creating a Policy with PowerShell