883 search results for "SQL"

A predictive maintenance solution template with SQL Server R Services

September 13, 2016
By
A predictive maintenance solution template with SQL Server R Services

by Jaya Mathew, Data Scientist at Microsoft By using R Services within SQL Server 2016, users can leverage the power of R at scale without having to move their data around. Such a solution is beneficial for organizations with very sensitive, big data which cannot be hosted on any public cloud but does most of their coding in R....

Read more »

Installing R packages in SQL Server using only T-SQL

August 2, 2016
By
Installing R packages in SQL Server using only T-SQL

Installing R packages in SSMS using T-SQL can take some time, especially when you need to switch between R Tools for Visual Studio or R Studio or your favorite R GUI tool (or R CMD). But so far, installing any additional library using sp_execute_external_script is just not working. --InstallPackage using sp_execute_external_script EXECUTE sp_execute_external_script       

Read more »

Enabling sp_execute_external_script to run R scripts in SQL Server 2016

July 26, 2016
By
Enabling sp_execute_external_script to run R scripts in SQL Server 2016

SP_EXECUTE_EXTERNAL_SCRIPT is a stored procedure that execute provided script as argument on external script to a provided language (in this case R language). To enable normal function of this external stored procedure, you must have administrator access to your SQL Server instance in order to run sp_configure command (and set following configuration): EXECUTE sp_configure; GO

Read more »

Data science show at SQL Server Radio

July 22, 2016
By
Data science show at SQL Server Radio

SQL Server Radio with Matan Yungman (info | twitter| company ) and Guy Glantser (info | twitter | company ) was hosting me for SQL Server radio 52th series. Main topic was discussion on  data science, statistics, who data scientist is and what SQL Server offers with R integration, SSRS, PowerBI, Excel and other tools.

Read more »

Working on Data-Warehouse (SQL) with R

July 13, 2016
By
Working on Data-Warehouse (SQL) with R

SQL being the most popular used query language for deep diving from small data to so called big data. However, there are many other languages like R which are growing in the user community for stats and graphical methodology models and plot data to match the data scientists mind. R as an Analytic Application R Related Post

Read more »

SQL Server, Power BI, and R

July 12, 2016
By
SQL Server, Power BI, and R

by Sheri Gilley, Microsoft Senior Software Engineer SQL Server 2016 has reached general availability recently and one of the top new capabilities it features is SQL Server R Services -- advanced analytics in-database with the R language. R has also been integrated into Power BI, allowing you to create fully integrated visualizations with the power of the R language....

Read more »

Running multiple correlations with R and T-SQL

June 26, 2016
By
Running multiple correlations with R and T-SQL

Getting to know the data is always an interesting part of data science. With R integration into SQL Server, the exploration part is still part of the game. Usual way to get some statistics out of the dataset is to run some frequencies, descriptive statistics and nevertheless correlations. Running correlations against a set of variables

Read more »

First thoughs on R integration in SQL Server 2016

June 23, 2016
By
First thoughs on R integration in SQL Server 2016

This blog post is a very personal confession, might be delicate but it must be understood as a  proposal or plan for improvement. Update #1: Typing error in title: correct title is First thoughts on R integration in SQL Server 2016 (update: June 24, 2016) Before the start, let me put some background and context.

Read more »

Importing CSV data using T-SQL and R

June 18, 2016
By
Importing CSV data using T-SQL and R

Several ways exists to import CSV (excel) data into your SQL Server Database. One is of course, using SSIS. The other one – similar to SSIS – is using import/export function in SSMS. With wizard, you will be able to import data. Futher on, BULK INSERT (BCP) statement is to all DBA and developers very

Read more »

How to install R packages on an off-line SQL Server 2016 instance

May 4, 2016
By

by Andrie de Vries One of the most exciting features of the forthcoming release of SQL Server 2016 (generally available on June 1, and in preview now) is the ability to run R scripts directly in database using SQL Server R Services. This means your R code will run directly on the server, as opposed to first extracting the...

Read more »

Sponsors

Mango solutions



plotly webpage

dominolab webpage



Zero Inflated Models and Generalized Linear Mixed Models with R

Quantide: statistical consulting and training

datasociety

http://www.eoda.de





ODSC

ODSC

CRC R books series





Six Sigma Online Training









Contact us if you wish to help support R-bloggers, and place your banner here.

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)