Tag Archives: Work

[SOLVED] Lenovo BSOD on Windows 7, Windows has recovered from an unexpected shutdown

One my clients uses a number of Lenovo mini PC systems. The systems perform very well for their intended purposes, however, some of the systems were sporadically shutting down (blue screen of death). Thankfully, disabling Bluetooth devices/adapters in Device Manager seems to have permanently resolve the issue. The client did not need the bluetooth capability in the first place, so now all is well 🙂 For reference, here is the error message and assorted diagnostic info: Problem signature: Problem Event Name:

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

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]

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

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

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

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

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

Page 1 of 3123