July 2019 Archive
Dynamically Created Anchor HREFs
![Multiple Arows Crossing Paths](/sites/default/files/2019-07/arrows.png)
- July 29, 2019
- 3 minutes
- tech, website, automation, inspiration
Back in the day, namely before Javascript and jQuery were really a thing, the idea of dynamically creating an anchor's HREF attribute required some serious magic and behind-the-scenes wizardry. Or something like Flash. Those were not the days...
A Bit of Background
Several years ago, during a client's web app rebuild/refresh, I decided to clean up some of the gnarly baggage behind their reporting mechanism.
Read MoreTo The Moon!
![Astronaut Buzz Aldrin during the Apollo 11 extravehicular activity (EVA) on the moon](/sites/default/files/2019-07/moonbusiness.jpg)
We spent the weekend away from home taking in a production of Guys and Dolls at the Guthrie Theater in Minneapolis, along with a visit to the Science Museum of Minnesota in St. Paul.
Read MoreWhat's That Join Again?
![Visualization of SQL Joins](/sites/default/files/2019-07/Visual_SQL_JOINS_orig.jpg)
In the interest of hopefully saving Future Me some time, I'm writing this little bit so as not to have to stumble to remember a simple premise:
How do I LEFT JOIN the same table more than once in a query?
For as many times as I've had to join a table more than once (effectively as a certain type of generic lookup table), you'd think I'd have this memorized. But I always get caught forgetting to proper alias both joins.
Read MoreThat's A Wrap, and Happy Summer
As I wrote about two weeks ago (while in mid-run), we just had our early summer theatre production. It was, in my opinion, a very successful run...though bittersweet to see it end after two weekends (and six shows). We had a great and consistent audience, which speaks well to the attempt at doing a show over two weekends in June. Our next board meeting will reveal the "final" financial result of our activities.
Read MoreAuto-Determine Primary IP Address
- June 30, 2019
- 3 minutes
- automation, tech, powershell
One of the things I've baked into our production task sequence for "multi-user devices" is a secondary way to automatically determine a device's use case while in the WinPE stage. The primary, preferred way to determine use case is by the use of SCCM collection variables, but those require a known object (in the proper collection) to function as designed. Thus, for all rebuilds of known devices, the use case is figured out by collection variable.
Read More