880 search results for "SQL"

A use of gsub, reshape2 and sqldf with healthcare data

December 18, 2015
By
A use of gsub, reshape2 and sqldf with healthcare data

Building off other industry-specific posts, I want to use healthcare data to demonstrate the use of R packages. The data can be downloaded here. To read the .CSV file in R you might read the post how to import data in R. Packages in R are stored in libraries and often are pre-installed, but reaching

Read more »

Tutorial: Data Science with SQL Server R Services

December 17, 2015
By
Tutorial: Data Science with SQL Server R Services

You may have heard that R and the big-data RevoScaleR package have been integrated with with SQL Server 2016 as SQL Server R Services. If you've been wanting to try out R with SQL Server but haven't been sure where to start, a new MSDN tutorial will take you through all the steps of creating a predictive model: from...

Read more »

Bringing the powers of SQL into R

December 11, 2015
By
Bringing the powers of SQL into R

One of the big flaw of R is that data loaded into it are stored in the memory (on the RAM) and not on the disk. As you are working in an analysis with large (big) data the processing time of simple and more complex functions can become very long or even crash your computer.

Read more »

Exploring Recursive CTEs with sqldf

December 1, 2015
By
Exploring Recursive CTEs with sqldf

by Bob Horton Sr. Data Scientist at Microsoft Common table expressions (CTEs, or “WITH clauses”) are a syntactic feature in SQL that makes it easier to write and use subqueries. They act as views or temporary tables that are only available during the lifetime of a single query. A more sophisticated feature is the “recursive CTE”, which is a...

Read more »

DataOps at SQL in the City

November 24, 2015
By
DataOps at SQL in the City

By Steph Locke Back in October, I had the pleasure of going along to the annual Redgate conference SQL in the City. This was a great day full of informative talks on how people are becoming more agile with their … Continue reading →

Read more »

Demo: R in SQL Server 2016

October 30, 2015
By

At the PASS Summit in Seattle this week, Microsoft's Jason Wilcox and Gopi Kumar demonstrated a SQL Server 2016 application that embeds R to predict what time you need to leave to catch a flight, given traffic, check-in time, and the likelihood of a flight leaving early or being delayed. The underlying preditive model was created with the RevoScaleR...

Read more »

Revolution R now available with SQL Server Community Preview

October 28, 2015
By
Revolution R now available with SQL Server Community Preview

The new SQL Server 2016 is now available as part of the Community Technical Preview program, and as presaged it embeds connectivity with the R language and the big-data statistical algorithms of Revolution R Enterprise. SQL Server 2016 includes two ways of calling R. The first is by embedding R code direcly in a SQL Stored Procedure, which can...

Read more »

Mango at SQL Relay!

October 22, 2015
By
Mango at SQL Relay!

By Steph Locke SQL Relay is an annual conference around SQL Server and related tech. It hits six to ten cities in the space of a fortnight, touring the country offering free and awesome training on SQL Server, Business Intelligence … Continue reading →

Read more »

A preview of using Revolution R Enterprise inside SQL Server

October 14, 2015
By

by Andrie de Vries The second week of SQLRelay (#SQLRelay) kicked off in London earlier this week. SQLRelay is a series of conferences, spanning 10 cities in the United Kingdom over two weeks. The London agenda included 4 different streams, with tracks for the DBA, BI and Analytics users, as well as a workshop track with two separate tutorials....

Read more »

Treasure Trove of R Scripts for Auto Classification, Chart Generation, Solr, Mongo, MySQL and Ton More

October 7, 2015
By

In this repository hosted at github, the datadolph.in team is sharing all of the R codebase that it developed to analyze large quantities of data.datadolph.in team has benefited tremendously from fellow R bloggers and other open source communities and ...

Read more »

Sponsors

Mango solutions



RStudio homepage



Zero Inflated Models and Generalized Linear Mixed Models with R

Quantide: statistical consulting and training



http://www.eoda.de









ODSC

CRC R books series













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)