Studio711.com – Ben Martens

Geek

Cloud Computing Job Description

datacenter(Note: I generally try to avoid specifically mentioning my company name because then I get picked up by search engines and news articles and incorrectly quoted as an official company resource. Let me be clear that none of this is an official company statement. I’m just explaining things from my current, personal viewpoint.)

I’ve worked in some interesting groups in Microsoft. The most recent was probably the easiest to explain. I’d just tell people to go to powerbi.com and they could either watch a couple videos or even sign up for a free account. Now I’ve made the switch to Azure Compute and I’m in more of a data scientist role so I thought I’d take some time to explain what that all means.

Azure and Cloud Computing
Azure is Microsoft’s cloud offering. It’s a direct competitor to Amazon Web Services (AWS). It’s hard to know who is bigger because these companies don’t publish lots of numbers, but it’s probably safe to assume that AWS has more customers than Azure. Watch for that to change in the future though. Azure is growing by leaps and bounds.

That’s great, but what is “the cloud”? In the past, businesses have operated their own data centers. It’s generally a building full of racks and racks of computers with blinky lights and cables all over the place. Each computer is specially built for a special purpose and maybe there’s an identical one sitting right next to it in case the first one fails. There is a huge overhead cost of the building (including cooling, electricity, maintenance, etc) as well as the need to amortize the cost of all the equipment over many years. Companies often end up running on old equipment because they’re still trying to pay it off. And oh yeah, even if you can get a datacenter running smoothly and paying for itself, if you need to be concerned about compliance, certifications and international law, be prepared to create a new data center in a variety of countries or even in specific countries. There are all kinds of laws that say, for example, you cannot move user data out of Europe if it was created there. How’s that going to work if your only datacenter is in the United States? There have been huge international changes in this area after all the Snowden revelations. And oh yeah, even if you do somehow manage to build out a global network of datacenters, some countries won’t let you do business there unless they run the datacenter themselves! You don’t even get a key to the building that you paid to construct. It quickly becomes a nightmare to manage on your own.

Cloud computing changes that whole model. Microsoft, Amazon, and others are building enormous data centers around the world. Instead of designing and buying all of your own equipment, you just rent time from the provider. In Microsoft’s case, that is the Azure service. There are many different products inside of the Azure world, but the basic premise is that you no longer need to think about the physical hardware. You just tell Microsoft what reliability and scalability you want. Do you want to store data in one part of the world but have it automatically mirrored on the other side of the world? Click a box. Do you want to change from using a single CPU machine to one with 16 CPUs? Click a box. Do you want to expand from 10 computers to 1000? Click a box. Or you can even completely ignore what kind of computer is being used and just publish your web application to Azure. Azure will then help you automatically scale based on load and automatically failover when underlying hardware has issues. It’s a big mind shift and it’s taking time for some companies to wrap their heads around it. At this point you basically have people in the old mindset who are still running their own data centers and are trying to pay off the cost over 10-20 years while their competitors are using the latest cloud technology and are just paying for what they use. Cloud computing costs a fraction of what a full, custom datacenter would cost and you’ll get eaten for lunch if your company doesn’t switch over because your competitors will be running so much faster and cheaper than you can.

Azure Compute
I’m in the “Azure Compute” team. It’s one of the fundamental building blocks of Azure. This team provides the virtual computers directly to customers and also to all of the other Azure products. If you need computing power in Azure, it comes through this team. As an example, there is a virtual machine in Azure hosting the MySQL database that powers this website.

Data Scientist
And finally, my title has changed from Software Engineer to Data Scientist. The “data science” term is a buzzword right now and I always ask people to define it when they use it because everyone means something different. But very generally, what it means on this team is that we take all of the telemetry data that we get from the system and we dig through it, analyze it, and run machine learning algorithms on top of it to find problems and make sure our customers are happily getting what they pay for. There’s also a lot of “data engineering” thrown in because in order to analyze petabytes of information, you have to do some serious work to get all that data moved into the right systems and curated into a format that makes sense. And once you get it all working, you have to keep it working.

This area of computer science has been around for a long time but it’s getting really hot right now. Technology has advanced to the point where storage and computing power are almost free (because of cloud computing) and everything around us is logging data. Depending on which report you read, the total amount of data on the planet doubles every year or two. And the rate at which it doubles is rapidly increasing. All of this data on it’s own is pointless so it’s the job of people like me to dig through it and extract actionable information and value from it. It’s an exciting area of the field and I’m really happy to be doing it for Microsoft Azure!

Office 16

powerqueryexcel2016The next version of Office is now public. “But Ben, I already have Office and I hate buying new copies of it.” Never fear! Do you have an Office 365 subscription? If so then you get this upgrade for FREE. And if you don’t have a subscription, this is a good reason to consider it. Unless you have a single computer in your house and you never upgrade Office, the subscription is a great deal. You get five installs with free upgrades, 1TB on One Drive, and some other perks for  100/year. There’s no more worrying about whether or not the upgrade is worth it for you. Pretty slick!

I normally don’t get too worked up about Office upgrades, but I’m really excited about Excel 2016. You may remember that I spent the vast majority of my time at Microsoft on Power Query and the projects that led up to it. Power Query now ships as a core feature of Excel 2016! Click the Data tab and look in the “Get & Transform” section. It’s awesome to have my code running on hundreds of millions (or billions?) of desktops. I know that it’s not a feature that most people will use, but it’s still cool to be included.

CrashPlan Update

crashplan-logoIn 2011 I signed up for CrashPlan and I’ve been a big advocate ever since. It’s a fantastic cloud backup service. You just install it on your machine, pay a small annual fee, tell it what folders to watch and you’re protected! There’s no limit on how much data you can upload. I have 3.9TB uploaded now!

As the size of my backups have increased, there have been two times when the app has stopped working. Both times were because the app was running out of memory to look at all the files and figure out what had changed. There’s an easy fix which is well-documented on the CrashPlan site. You just edit an INI file and restart the service.

If you’re not doing any kind off site backup yet, go to crashplan.com and sign up. It’s a tiny amount of money to be protected against all kinds of problems and data loss disasters.

Moving From Groove To Spotify

spotifylogoTyla and I have been enjoying our Groove (Xbox Music) subscriptions. They work well on our phones, computers, Xboxes, etc. I have three main complaints about the service:

  1. I use it to play music through our whole-house FM transmitter. It crashes/stops pretty frequently and I have to restart it about once per day.
  2. There is no sharing of playlists. This is a huge negative for me. Sometimes I want to make my own lists, but very often I just want a curated list that somebody else generated. Or maybe I want to use the playlist that Tyla made of Elijah’s favorite songs. There’s no way to import/export or share playlists in Groove.
  3. There’s no family plan. Everyone buy’s their own subscription at full price.

With these thoughts in mind, I think we’re going to join the rest of the planet and switch to Spotify when our current subscriptions are up later this year. The first family member pays full price and additional family members are half price. It’s easy to switch but the only real pain point is moving our playlists over to Spotify. Manually recreating them would take forever.

There’s no great way to do this, but if you’re a geek, you can probably follow my vague instructions:

  1. Fire up Chrome. Browse to music.windows.com and open your playlist.
  2. Scroll down to make sure the whole playlist loads (it only grabs 50 songs at a time.)
  3. Press F12 to open the developer tools
  4. In the Elements tab, right click on the root HTML node and choose Copy.
  5. Paste that into notepad and save the file.
  6. Now you need to parse out the artist and song info. There are tons of possibilities here, but I used Power Query in Excel. Basically I filtered for the types of rows that had Artist and Titles. I stripped out all the extra info and voila. I built out a table with two columns: Artist and Title.
  7. I copied that table and went to Ivy. That site lets you create a Spotify playlist. It looks up each one of those songs in the Spotify catalog. You’re probably not going to find all of your songs in the Spotify catalog since the catalogs are different, but most of them will probably work.
  8. Ivy gives you a button to click that copies the playlist to your clipboard. Then you create a new playlist in Spotify and paste your clipboard into that playlist. Voila!

Easy? Nope. Hacky? Yep. But it saved me a bunch of time. There is an SDK for Groove but it doesn’t look like you can easily get playlist contents for a specific user. I started trying to code it up, but this was faster and I’ll never need to do it again anyway.

Hyperlapse

A while back, Microsoft Research announced a technology called Hyperlapse. The idea is that it takes something like bumpy GoPro video, smooths it out and speeds it up. I didn’t play around with it much until the other day when I installed a preview of the professional desktop application. I dropped in a ski video from a 2013 trip to Crystal with AndyM. The result was pretty impressive! Sure it’s not going to make a great ski video, but it’s cool to see the “flow” down the mountain. It almost looks like the camera was flying above the ground.

Long Timelapse Tips

GoPro-HD-Hero-2During our Indiana trip, I made a six-day timelapse. That was by far the longest one I’ve ever attempted. How did it work? Here are some tips:

  • The GoPro is a great device for this. You can set it to snap a photo every 2, 5 or 10 seconds. Generally I do 2 seconds but since this one was so long I did 5 seconds since I knew I would speed it up a lot anyway.
  • Set the GoPro to the lowest resolution possible. On my camera that is 5 megapixels. Even that is a waste since you’re going to end up resizing down to 1080p anyway. The lower resolution will help you save room on the memory card and also saves battery life.
  • Don’t skimp on the memory card. 32 and 64GB cards are super cheap. Just get a big one and remove this potential problem from your setup.
  • Get a portable USB battery pack. I use this one, but there are lots of options. Get one that takes AA batteries. When you run out of battery, you just slap new batteries in there and you’re instantly ready to go instead of waiting for a recharge. I use and recommend Eneloop AA’s and the Lacrosse BC-700 charger. By using the battery pack to keep the internal GoPro battery charged up, I’m able to confidently let the camera run for 4 hours and it will probably go a lot longer. I changed out the batteries at lunch and at night. That way I didn’t have to worry about them dying on me.

When I was done I had over 30,000 photos. How do you process all of those into a movie? There are LOTS of options, but here’s how I do it (for free):

  • Install IrfanView. It has a lot of features, but I use it to batch resize and crop all of the photos down to 1920×1080. I also rename the photos to something like image#####.jpg so that there is a sequential number for every image.
  • Install ffmpeg. Decipher the command line parameters to build up the video that you want. Here’s the line that I use:”c:\program files\ffmpeg\bin\ffmpeg” -i image%05d.JPG -r 30 -s hd1080 -vcodec libx264 -y out.mp4
  • Techincally you could be done at this point, but I usually take that MP4 into Adobe Premiere Elements and crop it up, speed it up, slow it down, etc.

Software Toolkit

toolsIt’s been a few weeks since I last wiped my computer and started with a fresh install. When I do this, I only install software as I need it, so at this point, if I have something on my machine, it’s because I use it pretty regularly. I thought it might be interesting to share the list as a bit of a recommendation/tip post. I’ll leave out specific apps for my printer, scanner, etc.

  • 7-Zip
  • Adobe Photoshop Elements 10
  • Adobo Photoshop Lightroom 3.6
  • Adobe Premiere Elements 12
  • Foxit Reader
  • Google Chrome
  • HandBrake
  • LastPass
  • Microsoft Azure SDK v2.7
  • Microsoft Office Professional Plus 2013
  • Microsoft Power Query for Excel
  • Microsoft SQL Server Management Studio
  • Microsoft Visual Studio Ultimate 2013
  • MySQL Workbench
  • Notepad++
  • Python 2.7.6
  • SketchUp 2015
  • VLC media player

Windows 10 Photo Viewer

WindowsPhotoViewerI’m not a fan of the new photo viewer in Windows 10. Specifically I have troubles rapidly flipping through a bunch of files in a folder and I’ve seen some stuff online showing it’s poor rendering capabilities. The old Windows photo viewer was simple and perfect. Why change?

The good news is that you can get it back, but it requires a few registry edits. I’m not going to explain how that works. Ask a geek in your life to help you out if you don’t know. It’s not generally something you should ever do. That being said, here are your instructions: http://www.tenforums.com/software-apps/8550-unable-replace-photos-app-photo-viewer-default-10240-a-2.html?s=30e1f367ee6f758b05431dc82f25b765

Once that’s done, right click on a JPG and choose Open With. Select the old Windows Photo Viewer and check the box to always open with that app.

Edge Browser Extensions

microsoft-edge-browserI use Internet Explorer for most of my work and play but sometimes I also fire up Chrome. I love Chrome’s extension model for expanding the capabilities of the browser. I was very excited to hear that Edge (the new Windows 10 browser) is going to be supporting Chrome extensions! I haven’t flipped over to Edge yet because it doesn’t have any extensibility so I can’t run AdBlock or LastPass, but once they enable these extensions, I’ll be able to upgrade to Edge. It’s a great (and ambitious) idea. I hope they can pull it off cleanly.

http://news.softpedia.com/news/microsoft-wants-google-chrome-extensions-to-work-on-edge-with-zero-work-to-do-488282.shtml

Windows 10 Thoughts

windows-10Windows 10 is a big deal, and I have lots of thoughts about it. Instead of splitting them up into a bunch of posts, I’ll try to list them all here and you can pick and choose what might be interesting to you.

Should you upgrade?
If you’re an early adopter, you’ve probably already upgraded to Windows 10. Good! I’ve done it on most of my machines, but if you’re not in a hurry then it’s fine to wait. I’m waiting for a month or two to upgrade Tyla’s computers and I won’t upgrade the computers at church until January or February. However, you should definitely upgrade before about June next year. Microsoft is giving free upgrades for one year. Don’t miss out!

If you do upgrade now, the one change that I recommend is to not use the new Microsoft Edge browser as your default. At least that’s what I’m doing on my machine. I really like the new browser and it is super fast, but it also doesn’t support any plugins yet and that’s a deal breaker for me. I like to run AdBlock and LastPass and I can’t do that in Edge yet. Support for plugins is coming later this fall and it’s going to be awesome because Edge will support Chrome plugins! To change your default browser, open the start menu and search for “default web browser”.

What does it mean that “Windows 10 will be the last version of Windows”?
You hear this a lot in the media and even from Microsoft. What it probably means is that there won’t be a Windows 11. We’ll just see incremental changes to Windows 10. This is similar to how Apple has been handling updates to their operating system for the last few years. You’ll get feature updates on a more regular basis, but I’m sure there will still be plenty of marketing and fanfare around some of the releases.

Will I like it better than Windows 7 or Windows 8.1?
I’m the wrong one to ask about this. In fact, the question makes me a bit cranky because people love to talk about how much Windows 8 stinks. I find that most people dislike it because of a couple tiny UI things like the start screen and the charms bar. If that’s enough for you to hate it, fine. Everyone gets their opinion. Personally I almost never see those UI things and it doesn’t bother me at all. I love the additional OS features that are available in Windows 8 like Storage Spaces, Hyper-V, and more.

In general, I think people will be more receptive to Windows 10 than Windows 8 for the simple reason that it has a start menu. So many people get stuck on that one tiny fragment of the operating system, and there, now you have it. You also have ~5 years of awesome new features that have been developed while you were still on Windows 7. Welcome to the future!

Why is Microsoft offering it for free?
There are lots of articles about how Microsoft is dramatically changing their business model by offering Windows 10 for free. This statement oversimplifies the situation. First of all, they are only offering free upgrades to home users who already have a legal license for Windows 7 or Windows 8.1. The vast majority of Windows income comes from enterprise sales and sales of new PCs. Neither of these money makers is included in this free offer. Sure, it’s a big deal and I’m happy about this offer, but it’s not like half of the company’s money is disappearing.

People who state this also fail to comprehend where Microsoft makes their money. Lots of media people only think about the consumer facing stuff: Windows, Office, Xbox, Phone. They forget that there is a third pillar that as big as Windows and Office (and is growing much faster): Cloud and Enterprise. This team has a whole bunch of new billion dollar business and the growth rate of some of these products is incredible. For example, Azure had triple digit year over year growth in both revenue!

How did they make the picture for the Windows 10 logon page?
Nobody has asked me this question, but it has a cool answer. Check out this video to see behind the scenes: https://www.youtube.com/watch?v=hL8BBOwupcI It’s an actual photo, not something designed on the computer.