April 23, 2016 at 2:28 pm
Comments posted to this topic are about the item R in SQL Server
April 24, 2016 at 2:15 am
Good question, looks like time to learn R!!
...
April 24, 2016 at 7:51 am
Refusing to answer because I want 2016 now! 😛
April 24, 2016 at 11:38 pm
This was removed by the editor as SPAM
April 24, 2016 at 11:54 pm
Easy, and R is very interesting...!!
April 25, 2016 at 12:41 am
Good spot! Thank you for the question.
Iulian
April 25, 2016 at 4:41 am
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.
April 25, 2016 at 7:21 am
One more feature that makes me want to upgrade to 2016! Thanks for the question Steve.
April 25, 2016 at 10:58 am
I guess I'll have to learn R now.
Tom
April 26, 2016 at 3:42 am
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
April 26, 2016 at 6:28 am
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
April 26, 2016 at 6:44 am
The R that I want to learn about is Retirement.
April 26, 2016 at 6:58 am
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
April 27, 2016 at 1:34 am
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
April 27, 2016 at 2:40 am
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