chrisn-585491 (4/4/2014)
Question: If I'm going to use cheap open hardware like the Raspberry Pi, Arduino and OSS to capture data, why would I use StreamInsight and SQL Server to store it and manage it when there are OSS alternatives for both RDBMS and NoSQL?Yes there still would be a need for good developers and DBAs...
Because you already have SQL Server?
Perhaps I want to capture images over time in the office for security, or fun. Maybe I want to gather rate of flows of people in/out using RFID badges and I choose some programmable device like an Arduino. If I have SQL Server internally running, why not store data there?
It's not that you have to, but you have a choice and SQL Server is as valid as any other choice. It isn't about picking one OSS component and then being limited to only other OSS items.