Tag Archives: Work

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

St. Louis Retail: the good, the bad and the ugly

I spent the past few days with Samantha and Hazel in St. Louis. We were visiting my longtime buddy and business partner John. We had a great trip and accomplished a lot of fun stuff (dining out, talking, playing) as well as some serious work (computer & server installation, house planning, etc.) One thing that really struck me though was how poorly St. Louis retail locations were performing. Service at Best Buy, Target, Old Navy and several other places was

Page 1 of 3123