Did you ever have one of those “what am I doing with my life” moments? Those “is this really what I want to do for a living?” type of self-introspection conversation moments? About 4 months ago, I was having one of those moments. Let me be clear though: I love what I do for a living. I love where I work. I love who I work with. Seriously, I hit the career lottery and I’m thankful every day for it. That doesn’t mean that I don’t get bored, or want a new challenge every once in a while. Which is why I get hair-brained ideas like building a button to control SQL Server. So I do things that keep me engaged, learning, and interested. I look for unique problems with unique solutions. I’ll go learn something. I’ll travel. I get way too into a hobby.
The point is, I’ll find something to occupy my time. But I’m fickle; I can’t sit still for too long (and fidget spinners don’t really do it for me). So when I get into a mood where I’m not totally enthralled with or excited about the work I’m doing, I’ll tell my boss that I’m bored. He hates it when I say that; he thinks it’s his problem (it’s not). One good thing about working where I do is that if you have an idea, you’re encouraged to run with it. And I had doozie on an idea. I know I’ve been teasing it for a while now, and a few select people have been in the know, but today, I’m excited to finally announce it to the world: we’re putting SQL Server in space*.
Over the last few months, I’ve had a new itch: I wanted to get into the world of high altitude ballooning. The concept is pretty simple: get a balloon and some helium, tie it to a payload, and let it go. The balloon travels a certain height and distance, then bursts, and your payload falls back to earth. That in itself is pretty interesting to me, and it’s not prohibitively expensive: students have done it for a couple hundred dollars. For a few dollars more, you can put a camera on it and take pictures as it travels.
The thing is, I wanted to do more than that. The maker in me wanted to do something special, something no one (to my knowledge) has done before. I not only wanted to launch a balloon and a camera, I wanted to put SQL Server up there, too. So that’s why we’re announcing the High Altitude SQL Server Project (HASSP).
More seriously, here’s the idea:
- Create a custom IoT device,
- Attach some sensors to it,
- Write some code to poll the sensors,
- Tie it to a balloon,
- Send it up, collect data, and store the results in SQL Server.
All in the upper atmosphere. Pretty cool? I think so, too.
Just the beginning
We live in exciting times, folks. Thanks to recent changes to SQL Server, Microsoft embracing open-source, more diverse sensor and IoT technology, and cheap, easy to get materials, this type of project is possible. We might be successful but there’s also a chance we might not be successful, either. Gravity is not the easiest thing in the world to conquer, after all. That doesn’t really matter though; this has been an incredible journey and I’m fortunate and proud to share every step with whomever wants to read it. Most of all though, I’m proud of the people I get to work with not just on this project, but every day as well. As we move forward you’ll get to meet a lot of them, and they all have an important part to play in the project. I couldn’t (and wouldn’t want) to do this alone. I work with the best people, truly, and they have just as much to do with this as I did.
There’s a lot more to doing a project like this than the steps above. Over the past few months myself and my teammates that are interested in helping out have been kicking around ideas and testing hardware and writing software. We’re finally at a place where we’re ready to share our project with the world, and now you can follow along too as we move closer to our (projected) launch date:
06/20/2017 07/11/2017 (our initial launch date slipped due to reasons). I plan on having a project diary that runs from now till after our launch, detailing various steps of the project and how we solved problems (or inadvertently created new ones).
Over the new few weeks, I’ll be posting regular updates to twitter and writing some blog posts as well discussing of the tricky technical challenges we’ve had to solve (spoiler alert: near space is not a place where many things, especially databases, enjoy being). I encourage you to keep abreast of what we’re doing. Our ultimate goal is to live stream our launch, too, but I don’t have those details finalized yet. If you have the means to help us with that, let me know!
When we get done, I’m going make all my information available to everyone: the schematics of our device, our source code, balloon construction, and even our checklists. Everything so you can do it yourself, too, and improve on it (and hopefully burn yourself with soldering irons less than I did).
I hope you stay and follow me (us) as we move ahead with this ambitious project. Watch my twitter feed (or this site) for updates. It’s been a long time in the making and we’re excited to do it. And you can help by spreading the word. I’ll be using the hashtag #hassp and #sqlserver to post updates.
Let’s go to space*!
*Yes, I know, the upper atmosphere isn’t technically space. But the cost of going just a bit farther up is crazy expensive. But maybe phase two…