over all architecture of MS SQL big data and data scientist solution.

marrowyung
marrowyung used Ask the Experts™
on
hi,

for big data and data science solution of MS SQL, how many piece of puzzle we need? I know MS SQL has R service/server included in the MS SQL installation, I don't think only one server can do the job, what is the full picture?

each need separate cost ?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
You can't make a question like this without providing more information. What's the scale you're talking about? What's the server specifications?
It's to be used only by R language or others as well (e.g. Python)?
marrowyungSenior Technical architecture (Data)

Author

Commented:
"It's to be used only by R language or others as well (e.g. Python)? "

both ! just like MS SQL 2017, support both.

I want a big picture on how to do it, it seems move to Azure. at this moment, I want to hear voice.
marrowyungSenior Technical architecture (Data)

Author

Commented:
any idea ?
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

IT Engineer
Distinguished Expert 2017
Commented:
I'm not really sure what you're looking for but if you're looking to use SQL Server then MSSQL 2017 is the solution that you want.
As far as I know, SQL Azure doesn't support yet Python or R Services.
marrowyungSenior Technical architecture (Data)

Author

Commented:
"SQL Azure doesn't support yet Python or R Services."

then the local installation will do . but what I am wondering is, it seems Big data ONLY support in Azure , but AI support in local installation, is it making any sense ?

so MS want you to pay for both local installation and cloud ?

so local installation can't support big data ?
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
To be honest I don't know much what the Cloud is offering today because I've been working only for big banks where the quantity of information and the power of processing those information aren't yet available in any Cloud solution.
marrowyungSenior Technical architecture (Data)

Author

Commented:
ok.  tks.,

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial