R in SQL Server
-
Comments posted to this topic are about the item R in SQL Server
-
Good question, looks like time to learn R!!
...
-
Refusing to answer because I want 2016 now!
-
This was removed by the editor as SPAM
-
Easy, and R is very interesting...!!
-
Good spot! Thank you for the question.
Iulian
-
I've never used it, so having to research and learn something is a great way to start the week (or any day) for me. Thanks.
-
One more feature that makes me want to upgrade to 2016! Thanks for the question Steve.
-
I guess I'll have to learn R now.
Tom
-
Easy one, thanks.
Shameless plug:
SQL Server 2016 R Services: Executing R code in SQL Server[/url]
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
But this R code does execute using the database objects ?
Or it uses R data structures ?
I am not sure I get the point of this enhancement since I can call any program with xp_cmdshell.
Ta
Iulian
-
The R that I want to learn about is Retirement.
-
Iulian -207023 (4/26/2016)
But this R code does execute using the database objects ?Or it uses R data structures ?
I am not sure I get the point of this enhancement since I can call any program with xp_cmdshell.
Ta
Iulian
Yes, but with this stored procedure the R code is executed inside the SQL database engine.
So better performance, parallelism and scale.
The idea is that you execute a query and send the result set into the R code.
The R code does its magic and gives you either a result set, a model or a plot.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
Koen Verbeeck (4/26/2016)
Iulian -207023 (4/26/2016)
But this R code does execute using the database objects ?Or it uses R data structures ?
I am not sure I get the point of this enhancement since I can call any program with xp_cmdshell.
Ta
Iulian
Yes, but with this stored procedure the R code is executed inside the SQL database engine.
So better performance, parallelism and scale.
The idea is that you execute a query and send the result set into the R code.
The R code does its magic and gives you either a result set, a model or a plot.
Thanks Coen,
I saw that R is now integrated in Visual Studio too: https://www.visualstudio.com/en-us/features/rtvs-vs.aspx
Also Visual Studio can be used as dev tool for SQL Server.
So both, SQL Server and R, share a common tool which bring them together.
Looks like it converge in this direction of adopting R.
I wander if I can control R data structures, i.e. Vector, Matrix, Array, List and Data frame, from T-SQL. Any ideea ?
T.a.
Iulian
-
Iulian -207023 (4/27/2016)
I wander if I can control R data structures, i.e. Vector, Matrix, Array, List and Data frame, from T-SQL. Any idea ?
I don't think so. You can run R scripts on top of SQL data (in SQL Server), not the other way around.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply