1066 search results for "SQL"

Practical Data Science with R errata update: Java SQLScrewdriver replaced by R procedures and article

March 11, 2017
By
Practical Data Science with R errata update: Java SQLScrewdriver replaced by R procedures and article

We have updated the errata for Practical Data Science with R to reflect that it is no longer worth the effort to use the Java version of SQLScrewdriver as described. We are very sorry for any confusion, trouble, or wasted effort bringing in Java software (something we are very familiar with, but forget not everybody … Continue...

Read more »

Using PostgreSQL and shiny with a dynamic leaflet map: monitoring trash cans

March 1, 2017
By
Using PostgreSQL and shiny with a dynamic leaflet map: monitoring trash cans

When there is increased social activity, trash cans can get full quicker. On the contrary, during very cold weather, trash cans can take one or a couple of more days to get full. Therefore, knowing when trash cans are full is important to pick them up right away rather than waiting for a specific day PostgreSQL and shiny...

Read more »

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 »

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)