The Internet of Things

Question

The Internet of Things

Steve Jones - SSC Editor

SSC Guru

Points: 734418
More actions
April 2, 2014 at 8:27 pm

#306047

Comments posted to this topic are about the item The Internet of Things

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

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

Jeff Moden SSC Guru Points: 1003853 More actions · Answer 1

I guess that pretty much puts the cap on the rumor that the cloud was going to kill the position of "DBA" in all it's wonderous mryiad of forms. 🙂

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Gary Varga SSC Guru Points: 82166 More actions · Answer 2

More data. More DBAs.

More apps. More testers. More developers. More DBAs.

More complex systems. More architects. More testers. More developers. More DBAs.

Mmmm. I can imagine that many more jobs will be performed in developing economies (BRICS and MINT nations and such like - perhaps less so to Russia at the moment) but it looks like there is still room for jobs in US and Western Europe (traditionally areas where offshoring hits).

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!

murphy_jd Newbie Points: 5 More actions · Answer 3

This is a very good point. I for one am voting for the

non relational side.

Somewhat related is the webcast Ralph Kimball presented on 4/2.

"Building a Hadoop Data Warehouse: Hadoop 101 for EDW Professionals"

The recording runs a little over an hour, this is the link:

http://cloudera.com/content/cloudera/en/resources/library/recordedwebinar/building-a-hadoop-data-warehouse-video.html%5B/url%5D

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

Jeff Moden (4/2/2014)
I guess that pretty much puts the cap on the rumor that the cloud was going to kill the position of "DBA" in all it's wonderous mryiad of forms. 🙂

Yeah pretty much.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

chrisn-585491 SSCoach Points: 16006 More actions · Answer 5

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...

Steve Jones - SSC Editor SSC Guru Points: 734418 More actions · Answer 6

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.

chrisn-585491 SSCoach Points: 16006 More actions · Answer 7

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.

You forgot license costs, which is easy for many of the folks here. If you already have enterprise level agreements or a large budget you may be cavalier with adding yet another SQL Server instance or server. But if you have OSS expertise and are cost sensitive, you may not need to spend the additional $$$$$ for a RBMS or NoSQL system.

(I live in both worlds and have a wonderful time explaining to clients why the license costs of SQL Server are 3 to 4 times the cost of their state of the art hardware.)

Steve Jones - SSC Editor SSC Guru Points: 734418 More actions · Answer 8

I didn't forget licensing costs, but they may or may not apply to you. Plenty of companies don't stress over adding another SQL Server, and plenty more don't stress about adding another database to an existing SQL Server. There's no additional licensing in the latter case.

I didn't say that OSS isn't a good choice, but just that SQL Server isn't a bad one. Your situation or view doesn't necessarily apply to the majority of people. Some it doesn't.