SQL Server in Space - HASSP

  • Comments posted to this topic are about the item SQL Server in Space - HASSP

  • This was an interesting article, and it highlights some of the challenges engineers face when getting technology to work in extraordinary environmental conditions, like naked exposure to extreme sub-freezing temperature. It's not the first time that SQL Server has been running in space. This document released by the International Space Station Program back in March 2000 appears to contain an inventory and description of software installed on "payload laptops" used by station crew members for monitoring and operational tasks. It mentions SQL Server in addition to Windows NT Server, ISS, Internet Explorer, Outlook 98; basically the typical Microsoft server / client stack of that time period.
    http://www.spaceref.com/iss/computer/iss.ops.lan.icd.pdf

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • I've been trying to catalog my 200,000 photos over 3 decades. I need a database, but still haven't settled on one.

    412-977-3526 call/text

  • robert.sterbal 56890 - Tuesday, September 5, 2017 8:31 AM

    I've been trying to catalog my 200,000 photos over 3 decades. I need a database, but still haven't settled on one.

    Wow, that's a lot of photos. If you spend an average of 10 seconds reminiscing each one, it end up being 555 hours total. Then again, it will be a goldmine later in life.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • Eric M Russell - Tuesday, September 5, 2017 8:57 AM

    robert.sterbal 56890 - Tuesday, September 5, 2017 8:31 AM

    I've been trying to catalog my 200,000 photos over 3 decades. I need a database, but still haven't settled on one.

    Wow, that's a lot of photos. If you spend an average of 10 seconds reminiscing each one, it end up being 555 hours total. Then again, it will be a goldmine later in life.

    It would be nice to know how many are duplicates.

    200,000 frames is less than 2 hours of a 30 frame per second movie.

    Eventually I want to be able to make photomosaics by subject on demand.

    412-977-3526 call/text

  • robert.sterbal 56890 - Tuesday, September 5, 2017 9:54 AM

    Eric M Russell - Tuesday, September 5, 2017 8:57 AM

    robert.sterbal 56890 - Tuesday, September 5, 2017 8:31 AM

    I've been trying to catalog my 200,000 photos over 3 decades. I need a database, but still haven't settled on one.

    Wow, that's a lot of photos. If you spend an average of 10 seconds reminiscing each one, it end up being 555 hours total. Then again, it will be a goldmine later in life.

    It would be nice to know how many are duplicates.

    200,000 frames is less than 2 hours of a 30 frame per second movie.

    Eventually I want to be able to make photomosaics by subject on demand.

    200k is lot. I was working on organizing 15k+ photos in folders and it took a while. Make sure to use the DuplicateFileFinder first to delete the duplicates.

  • Avi1 - Tuesday, September 5, 2017 3:46 PM

    robert.sterbal 56890 - Tuesday, September 5, 2017 9:54 AM

    Eric M Russell - Tuesday, September 5, 2017 8:57 AM

    robert.sterbal 56890 - Tuesday, September 5, 2017 8:31 AM

    I've been trying to catalog my 200,000 photos over 3 decades. I need a database, but still haven't settled on one.

    Wow, that's a lot of photos. If you spend an average of 10 seconds reminiscing each one, it end up being 555 hours total. Then again, it will be a goldmine later in life.

    It would be nice to know how many are duplicates.

    200,000 frames is less than 2 hours of a 30 frame per second movie.

    Eventually I want to be able to make photomosaics by subject on demand.

    200k is lot. I was working on organizing 15k+ photos in folders and it took a while. Make sure to use the DuplicateFileFinder first to delete the duplicates.

    You'll never get around to viewing all these photos until you're retired from work, but what a trip down memory lane it will be.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • I'm looking toward a couple of open source projects to tag the images:

    https://github.com/cmusatyalab/openface

    https://github.com/TadasBaltrusaitis/OpenFace

    and I'm hoping there will be a few others.

    The photos are stored by decade/year/month/day and the format for the names is:

    YYYY-MM-DD_HH-mm-ss_old-or-edited-name.jpg

    a typical path is .\photos\by-date\2010s\2017\2017-04\2017-04-12-Wednesday\2017-04-12_12-23-23_img0030.jpg

    412-977-3526 call/text

  • Avi1 - Tuesday, September 5, 2017 3:46 PM

    robert.sterbal 56890 - Tuesday, September 5, 2017 9:54 AM

    Eric M Russell - Tuesday, September 5, 2017 8:57 AM

    robert.sterbal 56890 - Tuesday, September 5, 2017 8:31 AM

    I've been trying to catalog my 200,000 photos over 3 decades. I need a database, but still haven't settled on one.

    Wow, that's a lot of photos. If you spend an average of 10 seconds reminiscing each one, it end up being 555 hours total. Then again, it will be a goldmine later in life.

    It would be nice to know how many are duplicates.

    200,000 frames is less than 2 hours of a 30 frame per second movie.

    Eventually I want to be able to make photomosaics by subject on demand.

    200k is lot. I was working on organizing 15k+ photos in folders and it took a while. Make sure to use the DuplicateFileFinder first to delete the duplicates.

    And I thought I had a lot at 60K... 

    I had to migrate my photos from two laptops to a new desktop.  I was never happy with the way the photos were organized on either laptop (by event).  Being a developer, I wrote a quick console application that would read the EXIF data on the files and move to folders by date.  Let that run over night and I had 90-95% of the files moved and organized when I got up the next morning.  The remaining files didn't have the EXIF data I needed.

    The task for the past year has been to add metadata tags to my photos - people, location, event, etc.  That's still an ongoing project :blush:



    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply