Avatar of marrowyung
marrowyung
 asked on

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

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 ?
Microsoft SQL ServerAzureBig DataSQL

Avatar of undefined
Last Comment
marrowyung

8/22/2022 - Mon
Vitor Montalvão

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)?
marrowyung

ASKER
"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.
marrowyung

ASKER
any idea ?
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
ASKER CERTIFIED SOLUTION
Vitor Montalvão

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
marrowyung

ASKER
"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ão

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

ASKER
ok.  tks.,
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.