Page 9 of 21 for Software architecture, Brewers baseball, pop culture, etc. | Brad Westness

Running Entity Framework Queries from Embedded Resource SQL Files with EFQueryScript

Software .NET Libraries Data

Persistence, Neglected

A .sql file named GetTop10ArtistsByPlaylistCount.sql open in Visual Studio, containing a T-SQL query that joins the Artists, Albums, Tracks and Playlist_Track tables to count playlist appearances.

Better Home/Away Smart Thermostat Detection via Wifi and IFTTT

Software Home Lab DIY

In 2018 I put in a smart thermostat, a Honeywell T5+, specifically. The thermostat works with an app called Honeywell Home that supports geofencing to detect when one or more users are home or away based on their device’s location services data.

A hallway wall with a UniFi wireless access point, its status ring lit blue, mounted above a Honeywell smart thermostat displaying 66 degrees.

Building a LACK Rack Plex NAS From a Refurbished Rackmount Server, Part 2

Software Home Lab DIY

In part 1 of this blog series, I talked about the reasoning behind my decision to build a Plex server out of a refurbished Dell PowerEdge R710 server. In this second part, I will cover the process of getting the OS and GPU installed.

The same LACK table rack relocated to a basement against an orange-painted concrete wall, with a router and cable modem on top and the Dell server and APC UPS mounted below.