Did You Know?? R Services is in Standard Edition of SQL Server 2016

While my last post extolled the virtues of SQL Server Standard Edition, this week while doing some client testing  with Microsoft, I learned about another key standard edition feature. The new SQL Server R services is supported in standard edition of SQL Server 2016. While you won’t get access to some of the cool functions from Revolution Analytics and in-line parallelism (there is a @parallel=1 in sp_execute_external_script that automatically parallelizes your operations), you can still use all of the Open Source R functions, and build out your own parallelism (just multiple calls of your procedure). 

 

This is a huge benefit for those of you are who are doing statistical analysis of data and want to integrate with SQL Server. Stay tuned here for more detail for how DBAs can use R to analyze performance.

About jdanton1
A DBA, cyclist, cook (who likes to play chef occasionally)

One Response to Did You Know?? R Services is in Standard Edition of SQL Server 2016

  1. Pingback: Did You Know?? R Services is in Standard Edition of SQL Server 2016 — The SQL Herald | SimpleSQLDBA | Shadab Mohammad

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: