1088 search results for "sql"

Detecting outliers and fraud with R and SQL Server on my bank account data – Part 1

October 31, 2016
By
Detecting outliers and fraud with R and SQL Server on my bank account data – Part 1

Detecting outliers and fraudulent behaviour (transactions, purchases, events, actions, triggers, etc.) takes a large amount of experiences and statistical/mathetmatical background. One of the samples Microsoft provided with release of new SQL Server 2016 was using simple logic of Benford’s law. This law works great with naturally occurring numbers and can be applied across any kind … Continue...

Read more »

Free e-book: Data Science with SQL Server 2016

October 28, 2016
By
Free e-book: Data Science with SQL Server 2016

There's a new e-book available to download free from Microsoft Academy: Data Science with Microsoft SQL Server 2016. This 90-page e-book is aimed at data scientists who already have some experience in R, but want to learn how to use R wirth SQL Server. The book was written by some of my most experienced colleagues from Microsoft's data science...

Read more »

R, SQL, LaTeX and Chat!

October 27, 2016
By
R, SQL, LaTeX and Chat!

Building a product is an exhilarating experience; building a product for the smartest people on the planet is a whole ‘nother beast.Over the last few months, everyone at Datazar has been on an accelerated learning experience. Most of it due to the f...

Read more »

Association Rules on WideWorldImporters and SQL Server R Services

October 14, 2016
By
Association Rules on WideWorldImporters and SQL Server R Services

Association rules are very handy for analyzing Retail data. And WWI database has really neat set of invoices that can be used to make a primer. Starting with following T-SQL query: USE WideWorldIMportersDW; GO ;WITH PRODUCT AS ( SELECT    ,  ,  ,LEFT(, 8) AS L8DESC  ,ROW_NUMBER() … Continue...

Read more »

Comparing performance on dplyr package, RevoScaleR package and T-SQL on simple data manipulation tasks

October 10, 2016
By
Comparing performance on dplyr package, RevoScaleR package and T-SQL on simple data manipulation tasks

Long I wanted to test a simple data manipulation tasks and compare the execution time, ease of writing the code and simplicity between T-SQL and R package for data manipulation. Couple of packages I will mention for data manipulations are plyr, dplyr and data.table and compare the execution time, simplicity and ease of writing with … Continue...

Read more »

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 »

Sponsors

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)