Tag Archives: Work

Best (low cost) digital signage solution w/remote centralized management

Hardware Configurations and Software Features/Levels (color coded)

Recently I was tasked with recommending a digital signage solution for a client. Specifically, they needed centralized maintenance and control of approximately 20-30 signs covering 10-12 locations. Another paramount goal was cost effectiveness via no recurring/subscriptions costs. Here is my digital signage recommendation: Specific unit recommendation: Mvix Xhibit Myrko   Mvix Xhibit Myrko   http://direct.mvixusa.com/product/xhibit-mykro-digital-signage $259 single time cost to purchase device No additional license cost, no subscription fees Remote management Single HDMI output My recommendation is for one of the

AT&T LTE speeds in Pierce CO [speedtest]

This hotspot is capable of ~50Mbps speeds

I have been in CO for work and to visit family. Part of our stay has been in Pierce which is in northern CO. Remote work has been very easy since the LTE speeds are quite rockin’ in Pierce CO Here are the results using an AT&T Unite Pro hotspot with unlimited internet: This sure beats the old days of slow wifi and even slower 3G/4G 😉 Have you used LTE in this area of CO? I would love to see

Order SQL query manually when numeric string representation is out of order

Order/Rank by your own criteria

In some instances, doing a straight ORDER BY ASC (OR DESC) does not work as one might want: 0-50 101-200 201-300 301-400 401-500 501-600 51-100 601+ That is not how humans do it 😉 A way to get around this, is to add a new column and put in an ordering value, for instance: 1. 0-50 2. 51-100 3. 101-200 4. 201-300 5. 301-400 6. 401-500 7. 501-600 8. 601+ Now that is much better Here is a real world

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

Shows the records with their new ROW_NUMBERs added and paritioned

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

Fidelity Communications internet and phone service down

The internet and phone service was down in Salem MO this morning for customers of Fidelity Communications. It was quite perplexing at first, because I was working on a wireless upgrade at the Crossroads Inn & Suites hotel in Salem. During the middle of the upgrade, internet connectivity was lost. Eventually we determined that it was not our system’s issue but rather Fidelity’s. After contacting them we learned that a router went down in Kansas City and that caused widespread

Download the latest version of ESXi for Dell

Today I needed to download the latest Dell customized ISO of VMWare ESXi. It took me a moment to find the latest version, so here is a link to help you find it faster: http://www.dell.com/support/drivers/us/en/19/driverdetails?driverid=RD5JN This is VMware ESXi 5.1 Update 1 and it was released on April 29th 2013. You can burn it to a CD or mount it via an IPMI/DRAC interface if you so desire. Also, you will need a USB thumbdrive to install ESXi to as you

Determine if TRIM is supported and enabled on an SSD!

Today I was installing a Samsung 840 Pro 512GB SSD in a new server. Everything went smoothly, but I wanted to make sure that TRIM was actually working. This turned out to be slightly trickier than one might imagine! 😉 First Samsung’s SSD Magician Tool was of no use. CrystalDiskInfo reported that my SSD supported TRIM (which I already knew) but really gave no indication that Windows 7 and the SSD were working in concert to accomplish TRIMming. Nothing really

Page 1 of 3123