Pete's Soapbox

I've been stuck picking through serialized DevExpress layouts by hand lately. One aspect of it that had me confused for a while was this...

Sometimes a SQL query ends up needing an expression to be represented more than once. For example, some queries I've worked on have requ...

Here's a general-purpose Power Query 'rolling' function that can be used to make a rolling averages / moving average, or any oth...

A friend drew my attention to this page comparing the Bay Area COVID-19 cases to New York . But it can be hard to judge visually how steep a...

"When will I ever need to use logarithms, or raising something to the the power of 1/n in real life". During Covid-19, it turns ou...

I seem to find myself generating a lot of SQL from other higher-level query structures. And it's bugged me for a while that if I have so...

So my ten year old daughter wanted to build a keypad enabled electric lock for her bedroom "to keep her little brothers out".  TLD...