I downloaded SQL Server 2016 CTP2 over the weekend in hopes to try the new integration with R, but I can't figure out how to do it. I watched the Ignite video and saw a stored procedure being used to register the script, but I can't find that proc in intellisense. Was R included in CTP2? If so, what stored procedure can I use (assuming that's how the integration will be done) to register R code?

Thanks,

Scott

I downloaded SQL Server 2016 CTP2 over the weekend in hopes to try the new integration with R, but I can't figure out how to do it. I watched the Ignite video and saw a stored procedure being used to register the script, but I can't find that proc in intellisense. Was R included in CTP2? If so, what stored procedure can I use (assuming that's how the integration will be done) to register R code?

Thanks,

Scott

Hi Scott,

Based on my research, SQL Server 2016 CTP2 includes R integration.

As indicates by the demo in this blog, to demonstrate a prototype of running R within SQL Server, it requires to apply classification model (from the e1071 R package) to the famous Iris data, using the same R code used in this Azure ML Studio experiment.

Additionally, as the issue is more related to SQL Server BI, I would recommend you post the question in the following forums to get better support.
SQL Server Analysis Services  forum : https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlanalysisservices
SQL Server Reporting Services forum: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlreportingservices


Thanks,
Lydia Zhang

If you have any feedback on our support, please click here.

Lydia,

I found that same blog. Everything I've seen leads me to believe that you should be able to execute R code in T-SQL without having to use Analysis Services. Both the discussion at 1:01:00 and the demo code at 1:11:00 in the video in the blog you linked to (as well as other documentation I've seen) make me think that this is available without using BI. 

I don't need detailed documentation at this point, just a place to get started. The video demonstrated two stored procedures: sp_create_table_transform_settings and sp_create_script. Are these available in CTP2 under different names?

Thanks,

Scott

What Lindsey Allen showed in that video last month was, according to her "early prototype code". 

In a SQL Server release, features don't appear in a CTP until they are both completely done, and nearly ready to ship. 

Hopefully we'll see this in the next CTP.

David

Thanks David. That makes sense.

When the next version comes out, will there be any way to tell whether R will be included without installing SQL Server and hoping to see it?

Yes.  It should appear in Books Online for SQL Server 2016 when it ships in a CTP.  It _should_ be fully documented, but will at least be in the What's New in SQL Server 2016 section.

David

Me too tried to replicate what Lindsey showcased in the CTP2 video. No success. Is there any idea as when we can have CTP3 with R integration?

Thank you,

~Kannan Chandrasekaran