SQL Server R Services

External Article

SQL Server R Services: Working with Multiple Data Sets

  • Article

Although it is easy to use SQL Server R Services to create R scripts that incorporate SQL Server data by passing in a T-SQL query as an argument when calling the sp_execute_external_script stored procedure, you are limited to that one query, unless you pass additional data directly between R and SQL Server via CSV files. It is simple to do, and opens up many additional opportunities for data analysis. Robert Sheldon explains how.

2017-12-07

3,542 reads

External Article

SQL Server R Services: Working with ggplot2 Statistical Graphics

  • Article

It is when you use R in SQL Server with one of the huge range of packages that comes with it that you can begin to appreciate the power of the system. With a package such as ggplot there are many 'knobs one can twiddle' in order to get spectacular and informative visualisations. Rob Sheldon continues his beginners series for R in SQL Server by showing how to refine the output to get it as you need it.

2017-10-25

3,267 reads

External Article

SQL Server R Services: Digging into the R Language

  • Article

It is not just the analytic power of R that you get from using SQL Server R Services, but also the great range of packages that can be run in R that provide a daunting range of graphing and plotting facilities. Robert Sheldon shows how you can take data held in SQL Server and, via SQL Server R Services, use an R package called ggPlot that offers a powerful graphics language for creating elegant and complex plots.

2017-09-15

6,981 reads

Blogs

Day of Data Baton Rouge Slides and Code

By

Thanks to everyone for attending my talk today at Day of data Baton Rouge...

Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server

By

Here’s the scenario: one of my SQL Server instances migrated to the DR array....

The Book of Redgate: Products

By

We are product focused at Redgate Software. Here is another of our values that...

Read the latest Blogs

Forums

The SQL Server 2016 Plan

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The SQL Server 2016 Plan

whats that ssis analyzer product that documents lineage

By stan

hi, a few years ago was at a very large company that bought a...

Implicit Conversions Cripple SQL Server

By sabyda

Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server

Visit the forum

Question of the Day

BIT_COUNT() III

In SQL Server 2025, I run this code: 

select bit_count(-1)
What is returned?

See possible answers