Author Archives: J.D. H.

How to set the time zone & time on Synology NAS DSM

Recently I needed to setup a scheduled shutdown task for my Synology DS 1813+ NAS. After I created the task, I wanted to check the time to make sure it would be triggered at the correct time. Turns out that my timezone had never been set correctly, so here is how I fixed it: Login to NAS via web brower -> Control Panel -> Regional Options -> Time Zome Just FYI here is the awesome NAS in question (though DSM

Format SQL code

I have been writing copious quantities of SQL lately. Some of the queries are getting really long. When I am working with Navicat it has a nice ‘SQL beautify’ feature that takes messy SQL and makes it nice and tidy. 🙂 While that features is great when using Navicat for SQL editing, sometimes I need to workdirectly with SQL Server 2008 there is no comparable feature built into Microsoft’s SQL pane. 🙁 Thankfully, with a quick copy/paste there is an online tool

Intel Centrino 6235 or 7260 Bluetooth not detected by Windows [SOLVED]

I came across an interesting tip today: […] Samsung RC530 and a 7260.HMWWB. Bluetooth can’t be activated on some notebooks, so you need to activate it manually with a hardware “hack”. Just get some Scotch Tape / Sellotape (in german “Tesafilm”) and stick it on pin #51 (picture). Put the card back in the PCIe slot and have fun . […] this workaround works also for the 6235 and other Intel Wifi/Bluetooth cards.. via Intel Communities. Well worth checking out

Pavestone retaining wall choices for timber frame home

Pavestone has a nice selection of retaining wall rock. These were the specific options we chose for our retaining walls around our house: Pavestone | Pavers, Retaining Walls, Patio Stones & Edginghttp://www.pavestone.com/Beautify your outdoor living spaces with Pavestone’s elegant collection of pavers, retaining walls, patio stones and edging. Our stone and concrete brick paving products transform landscapes…

Select top 2 rows from records, grouped/partitioned by Unique ID

The Problem: A client needed a query that selected the two most recent tour dates for each user ID. This is an easy task for a single user ID because specifying the user ID and an ORDER BY tour_date DESC with a LIMIT 2 clause would get the dates needed. However, when there are a lot of users it gets harder. For a single date, the MAX function works great but in our instance it will not work because we

AT&T LTE data speeds in Low Wassie MO

This result is quite good considering the rural location as well as the trees/hills. Nice job AT&T! 🙂 This test was on a Lumia 635 no contract phone which is often available for less than $80 USD. AT&T Nokia Lumia 635 – No Contract GoPhone: Cell Phones & Accessorieshttp://www.amazon.com/gp/product/B00LBFFSNM?ie=UTF8&tag=pixensity-20&linkCode=as2&camp=1789&creative=390957&creativeASIN=B00LBFFSNMThe Lumia 635 isn’t your average smart phone. Powered by Windows Phone 8.1, a Quad core processor and supporting a microSD card of up to 128 GB of memory, it’s fast and