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 RDMS and NoSQL?

Yes there still would be a need for good developers and DBAs...