Studio711.com – Ben Martens

As I rebuilt the server a while ago, I started thinking back to all the computers that I’ve ever own. Here’s my attempt to list them out along with estimated prices. This should be good for a laugh in 20 years. Aside from the first computer, none of these prices include monitors. This list only includes computers that I purchased new, not used ones I bought or was given.

• 1998 – Gateway Pentium 2 350 with a 10GB hard drive and a tape backup.
  • I bought this when I was heading off to college. I don’t remember the exact price but it was somewhere between $2000 and $2500 which was pretty much all the money I had left. It lasted me all the way through college though.
• 2002 – Dell P4 2.4GHz with 512MB RAM and an 80GB hard drive. $900
• 2006 – Dell Core 2 Duo E6600 2.4GHz with 2GB RAM and a 250GB hard drive. $1200
  • This one is still in use 8 years later! It’s running Windows Media Center 24/7. It can record 4 HD video streams and serve them simultaneously to the three XBox360s around the house. One wall of the case is a cardboard beer box, but this thing still runs like a champ.
• 2010 – Core i7 860 2.8GHz quad core with 8 GB RAM. $1000
  • This was the first computer that I built on my own. It became my file server and is the machine that had the CPU and motherboard replaced earlier this month.
• 2011 – Lenovo Thinkpad Edge $700
  • I can’t find any info about this, but it was the first laptop we bought for Tyla after we got married.
• 2012 – Core i7 3770 3.4GHz quad core with 16GB RAM. $1400
  • While I retrofitted the 2006 and 2010 computers with SSDs, this was the first one that started life with an SSD in it.
• 2013 – HP Pavilion Touchsmart 15-b154nr AMD A8-4555M quad core 1.6GHZ and 6 GB of RAM. $550
  • Though I had used many laptops from work, this was the first one I ever paid for. We got it for Tyla when her previous laptop died a surprisingly early death.

This last desktop computer from 2012 is still plenty fast and I would be very hard pressed to find any excuse to update it. Maybe once we start seeing 8 core CPUs then I’ll make the jump.

Our current laptop (the HP), on the other hand, has been a pretty big disappointment. It’s my fault for being cheap. I bought the most inexpensive laptop with a touchscreen that I could find and yikes, it’s not great. The biggest flaw is the 5400 rpm hard drive that you can’t replace without tearing apart the entire machine. If I could just put an SSD into it, it would probably be fine, but I’m not very confident that I’d ever get the machine physically back in one piece after installing it. We’re trying to eek out two years with it but hopefully it will be replaced soon and I will not be going cheap.

It’s fun to look back at the performance/price ratio even in just 16 years. Moore’s Law is alive and well!

[UPDATE] Changed Murphy’s to Moore’s. Thanks Jim. Although accidentally typing Murphy’s makes it a true statement as well.

I wrote previously about my two failed hard drives. The story, unfortunately, didn’t end there. A few days later, I started getting some goofy boot up behaviors that pointed to a bad BIOS. It would get stuck at “Loading operating system.” This was a transient thing that I had seen before but now it was consistent. I tried to update the BIOS and that said it succeeded but after that it never got past the logo screen for the motherboard. Oops. I tried pulling the CMOS battery to reset the BIOS but nothing I tried got me past that logo. I decided it was time to replace the motherboard even though it was only four years old.

The CPU was an LGA1156 socket and unfortunately they don’t make motherboards for that anymore. I had to buy a new CPU too. I really didn’t need any additional power in that server box, but I did upgrade a little. Here’s what I got:

• MSI Z87-G41 PC Mate LGA1150 Motherboard $90 after rebate
• Intel Core i5-4590 $179

The swap went pretty quickly and easily with no problems. It booted right up and I didn’t have to reinstall Windows or anything. I did have to reactivate it but a quick phone to a robot call took care of that.

I kind of suspect that the second hard drive failure was more of a motherboard failure than a drive failure. I’ll run some thorough SpinRite tests on it before putting it to use again.

P.S. Happy Birthday Dad!

I came home the other night and found out that I had a dead hard drive on my main file server. D’oh! That machine carries every one of our photos since we got a digital camera and a ton of the print photos from early in our childhood. It’s irreplaceable!

But, of course, I have multiple levels of backup so I knew my data was safe. It’s just a matter of getting it back to a healthy condition.

I decided to just let the drive sit there and wait for a replacement to arrive from Amazon. (4TB for $142!) Each file is stored on two physical drives so once I put the new drive in, it would automatically copy the files back onto the drive and I’d be all set.

Well, while I was waiting, the machine reported that a second drive had failed. It was the other one that I had purchased as the same time as the first drive so it’s not completely unreasonable that they failed together, but it still seemed unlikely. Looking through the SMART data on the drive, it looks like it got pretty hot in the case at one point so maybe that led to early demise (3 months after the 2 year warranty expired.) Now I had a mess on my hands and would be forced to pull out some backups.

I didn’t want to wait around so I drove to Best Buy and paid $40 extra for the same drive. Thankfully I was able to get the second failed drive to boot up again so the server was able to heal itself. When the new drive arrived from Amazon, I replaced that second drive because I just don’t trust it anymore. The machine now has four 4TB drives in it and all our files are safe.

I don’t know how you could read this site and not have heard me say it before, but BACK UP YOUR DATA! Hard drives only carry a one or two year warranty for a reason. Here’s the test for whether you are doing enough backups: if I walk into your house, take your computer and smash it with a sledgehammer, did you just lose photos, videos, documents, etc? If so, you’re not doing your backups correctly. Here’s the very quick and very economical solution: http://crashplan.com  Less than $200 will get you four years of worry free backups. Set it up once and forget about it until you need it.

If your computer is acting weird, slow or you suspect a virus, Windows 8 has two great new features that will help you get back to normal again.

1. “Refresh” will keep your documents and pictures, but you’ll have to reinstall most of the programs on your computer.
2. “Reset” will completely remove everything from your computer and put it back the way it was when you got it.

Both of these are just a few clicks away and they will guide you through the process. More information is available here: http://windows.microsoft.com/en-us/windows-8/restore-refresh-reset-pc

If you’re an uber geek, you can create custom reset images so that when you reset your PC, it can reset with a bunch of your regular apps pre-installed.

So you need to share a big file or a bunch of files that add up to a lot. This problem has been around since time began and it’s often still easier to hand someone a physical piece of media like an SD card or a CD. But there are (free) ways to do it online and they aren’t terribly difficult. I can think of a dozen different ways to do it off the top of my head, but I’m going to pick one and yes, it’s a Microsoft solution. What did you expect?

1. You probably already have a Microsoft account (hotmail.com, live.com, outlook.com, etc), but if you don’t go sign up for one.
2. Visit OneDrive.com. You have a bunch of free space to store and share files.
3. Create a folder for your files that you want to share.
4. Upload the files into this folder.
5. Go back to that folder, select it and then click Share.
6. Choose “Get a link” from the left side. “View Only” should be selected by default on the right and that’s probably good.
7. Click Create link.
8. A link is generated and you can email that to the people you want to share it with. Anyone with that link will be able to get to the files you shared.

Cue the “The More You Know” music.

You may remember a previous post about a product called SpinRite. It’s a hard drive maintenance and recovery tool, and it’s handy to have it in my bag of tricks. It has always been slightly annoying to use though because it requires me to dedicate a machine to it while it’s running and it can easily take a day (or even a week) to run.

Last week I had cause to run it again and after futzing around for a long time trying to get it to run on a spare laptop (it wouldn’t see the USB drive that was connected to the laptop), I started to wonder if I could get it to run in a virtual machine on my main desktop. SpinRite uses very low level commands to access the drive and I didn’t think that would work inside a VM, but why not try anyway?

Sure enough, it did work! Here are the steps I did:

• Attach the USB hard drive dock to my desktop and insert the drive.
• Power up the drive and wait for Disk Manager to recognize it.
• Set the disk to Offline mode.
• Create a new VM in Hyper-V (I’m running Windows 8.)
• Use SpinRite.exe to create an ISO and set the VM to boot that ISO.

From that point, SpinRite could see the drive, and I didn’t care how long it took to run because it wasn’t blocking me from doing other work on the machine. Perfect! Theoretically I could even spin up multiple instances of the VM and point it to multiple drives to parallelize a big recovery job.

I’ve written a couple times before about my Power BI project at work. The head of our group gave a presentation at the Worldwide Partner Conference that provides a nice overview of our future roadmap. To view it, go the WPC keynote page, click on “The Cloud for Modern Business” and then skip ahead to the 21 minute mark when James Phillips comes on stage.

Last November, I posted that I was switching my email from GMail to Outlook.com. It didn’t affect anyone because it just meant that my @studio711.com email forwarded to a different site, but it was a pretty major change for me.

I did it in large part because I want to dogfood the solutions that our company provides in hopes of fairly representing them and offering feedback to the teams that wrote them. I thought it would be a bit of a downgrade, but wow, I’m really impressed. Outlook.com is a fantastic mail service. First of all, their junk mail detection is just as good as GMail. Where they really shine is their interface. Outlook.com loads faster and is subjectively easier to use, especially if you’re on a touch-enabled device. The web client looks and acts very similarly to the Windows 8 app so the continuity is a plus. I manage all my email in the desktop version of Outlook, but their web client and Windows 8 apps are so good, I’m thinking dropping the client version of Outlook.

This wasn’t the side-step (or even downgrade) that I expected. It’s pure win. If you’re frustrated with your email service or just looking for a change, give it a shot.

Yesterday I wrote about the process of losing weight, but I only alluded to data sets. Let’s dig in! My data sources were the Fitbit API (for both number of steps and weight) and some weather history which I’ll explain later. This all came into through Power Query.

First of all, here is a chart showing my weight over time and then which days of the week. I usually gained weight on Sundays (our days to get together with family), Tuesdays (taco day in the café at work) and Fridays (the day we sometimes go out to eat.)

Next up are some charts showing the number of steps I took each day. The chart on the left shows how often I took a certain number of steps. The chart on the right shows the total number of steps each month. Note that we’re only halfway through June so that bar is shorter.

I fully expected to see a correlation between the number of steps I took on a given day and the amount of weight that I lost. Nope. Here’s a scatter plot showing no correlation. I think that walking is good for weight loss if you’re very overweight and you don’t move much. But there’s a point where walking is just too efficient to do much additional good.

I then started looking for other possible data correlation. Maybe the number of steps that I took was related to the temperature? Nope.

We’re in a wet part of the country so maybe the amount of rain we get in a day dictates how many steps I take? Not really. My really big days have happened when it doesn’t rain, but just because it’s dry doesn’t mean I’ll walk a lot.

In the end, I took all the various data points and ran them through Excels correlation algorithm. Nothing came out showing any real correlation. The biggest one was one of the charts you see above: the bigger the high temperature, the more steps I take, and even that was only a 0.48 correlation. That’s skewed quite a bit too because I’ve been doing a LOT more yard work lately and it has been warmer.

Even though I didn’t find a scientific way to lose weight, I did learn lots of things that AREN’T related and that’s interesting too!