1040 search results for "SQL"

Accessing MSSQL Server with R (RSQLServer with dplyr)

February 18, 2017
By
Accessing MSSQL Server with R (RSQLServer with dplyr)

Recently I have been starting to use dplyr for handling my data in R. It makes everything a lot smoother! My previous workflow – running an SQL query, storing the results as CSV, loading it in RStudio – is now history. With dplyr you can directly query data from many different databases in a very … Continue...

Read more »

Six Articles on using R with SQL Server

February 16, 2017
By

Tomaž Kaštrun is developer and data analyst working for the IT group at SPAR (the ubiquitous European chain of convenience stores) in Austria. He blogs regularly about using Microsoft R and SQL Server for data analyis, and recently published a roundup of his articles about R and SQL Server. Follow the link below for the an overview of the...

Read more »

Galaxy classification with deep learning and SQL Server R Services

February 14, 2017
By
Galaxy classification with deep learning and SQL Server R Services

One of the major "wow!" moments in the keynote where SQL Server 2016 was first introduced was a demo that automated the process classifying images of galaxies in a huge database of astronomical images. The SQL Server Blog has since published a step-by-step tutorial on implementing the galaxy classifier in SQL Server (and the code is also available on...

Read more »

R and SQL Server articles

February 8, 2017
By
R and SQL Server articles

In past couple of months, I have prepared several articles on R and SQL Server that have been published on SQL Server Central. The idea was, to have couple of articles covering the introduction to R, to basics on R Server, to some practical cases on R with SQL Server. 1) Using Microsoft R in … Continue...

Read more »

Retail customer analytics with SQL Server R Services

February 7, 2017
By
Retail customer analytics with SQL Server R Services

In the hyper-competitive retail industry, intelligence about your customers is key. You need to be able to find the right customers, understand what types of customers you have, and know how to keep the best ones. Three solutions based around R and SQL Server R Services will help you do exactly that. To find the right customers, you need...

Read more »

Clustering executed SQL Server queries using R as tool for

January 8, 2017
By
Clustering executed SQL Server queries using R as tool for

When query execution performance analysis is to be done, there are many ways to find which queries might cause any unwanted load or cause stall on the server. By encouraging DBA community to start practicing the advantage or R Language and world of data science, I have created a demo to show, how statistics on … Continue...

Read more »

Did you say SQL Server? Yes I did….

December 23, 2016
By
Did you say SQL Server? Yes I did….

Introduction My last blog post in 2016 on SQL Server 2016….. Some years ago, I have heard predictions from ‘experts‘ that within a few years Hadoop / Spark systems would take over traditional RDBMS’s like SQL Server. I don’t think … Continue reading →

Read more »

Run SQL Straight On S3 via Athena in R

December 7, 2016
By
Run SQL Straight On S3 via Athena in R

Run SQL on S3 Data via Athena in RSanta comes early for us data scientist in the form of a brilliant new Amazon service called Athena. Athena now allows you to use standard SQL to query directly from data that lives in Amazon's Simple Storage Service (S3). One of the benefits of...

Read more »

R-SQL Exercises

December 7, 2016
By
R-SQL Exercises

How to write Structured Query Language (SQL) code in R. Well there are many packages on CRAN that relate to databases. In the exercises below we cover some of the important data manipulation operations using SQL in R. We will use a ‘sqldf’ package, an R package for running SQL statements on data frames. Answers

Read more »

Understanding SQL and R Training Video

December 2, 2016
By
Understanding SQL and R Training Video

Just had a video series released by O'Reilly Media on infiniteskills.com:https://www.infiniteskills.com/training/understanding-sql-and-r.htmlThis course shows you how to combine two of the most popular technologies used in data analytics: SQL and R.  Complete this course and you'll learn the basics of a skill set highly valued by employers around the globe.Gain experience combining SQL and...

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)