OpenWeather – Local Weather API for IoT

August 20, 2024

I was looking around for an easy to use weather API to get simple weather information. I found OpenWeather and the free version allowed me to do all that I wanted. Latitude/Longitude All the weather APIs require that you furnish the latitude and longitude for the location you are querying. You can look it up by ZIP code.… Read More »

Add Build Output Messages to Azure DevOps

September 11, 2024

Azure has a tool that is used in many DevOps YAML scripts. It has many capabilities – to the point of wondering why they crammed so many unrelated functions into one construct. All of this information is from a Microsoft Azure DevOps Services page: Logging commands. Check it out because I will not list these options: Show percentage… Read More »

ESP32 Documents

November 29, 2024

Expressif main site documentation Locally Hosted Documents Just to aid finding ESP32 documents more conveniently, I wanted to bring some items locally – if I use them in a project for instance. General ESP32-­WROOM-­32 (Not recommended for new designs)

SQL Cheatsheet

August 15, 2024

Multiple “Order By” Clause Separate the order by clauses with commas. Use “CASE” to Convert Non-String to String Value In this example, we want do display the SettlementType value (an integer) as a human readable value in a column named “Settlement”. Resulting SQL view. Update Row Value The basic command is: For instance:

Windows Special Folders

March 18, 2024

Windows uses an enumeration of special folder names to make it easier to find commonly used folders. Without this mechanism, we’d have to jump through a lot more hoops to determine this information since it is user dependent. I was trying to use a special folder as the root of a path for some common files shared by… Read More »

PowerShell Commands

August 21, 2024

File Search Related Operations Microsoft help on items in this section. Find Processes Get-Process (alias gps) allows you to get all running processes on your machine. It can also be used to create a filtered list. Find all processes with name that matches “mmc”. We are looking for an exact match so don’t need double quotes. All of… Read More »

Create Select Order on Server

February 12, 2024

The code below demonstrates how to create an order on a Select Server. The primary difference between clients and servers is that clients are created by a login process that provides a user and profile. Servers do not have profiles by default. Any order created by a Server will show up as created by “System”. I must make… Read More »