925 search results for "sql"

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 »

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 »

Installing SQL Server ODBC drivers on Ubuntu (in Travis-CI)

April 20, 2016
By

Did you know you can now get SQL Server ODBC drivers for Ubuntu? Yes, no, maybe? It’s ok even if you haven’t since it’s pretty new! Anyway, this presents me with an ideal opportunity to standardise my SQL Server ODBC connections across the operating systems I use R on i.e. Windows and Ubuntu. My first The post

Read more »

An Analysis of Traffic Violation Data with SQL Server and R

April 6, 2016
By
An Analysis of Traffic Violation Data with SQL Server and R

By Srini Kumar, Director of Data Science at Microsoft Who does not hate being stopped and given a traffic ticket? Invariably, we think that something is not fair that we got it and everyone else did not. I am no different, and living in the SF Bay Area, I have often wondered if I could get the data about...

Read more »

SQL Server 2016 with R Install

April 2, 2016
By
SQL Server 2016 with R Install

I installed the “SQL Server 2016 Release Candidate” today to start playing around with Microsoft is calling “SQL Server R Services (In-Database)”. I think this is really going to change the way we do things at the office and it’s … Continue reading →

Read more »

SQL Server 2016 launch showcases R

March 14, 2016
By
SQL Server 2016 launch showcases R

Microsoft officially launched SQL Server 2016 at the Data Driven event in New York City last week, and R featured prominently. One of the highlights from Joseph Sirosh's keynote was a demonstration of the World Wide Telescope, an online tool that allows budding astronomers (and professionals!) to explore the visible universe using imagery from the Digitized Sky Survey. The...

Read more »

Performing SQL selects on R data frames

March 13, 2016
By
Performing SQL selects on R data frames

For anyone who has SQL background and who wants to learn R, I guess the sqldf package is very useful because it enables us to use SQL commands in R. One who has basic SQL skills can manipulate data frames in R using their SQL skills. You can read more about sqldf package from cran. Related Post

Read more »

Querying Big Data SQL tables with Oracle R Enterprise

February 15, 2016
By
Querying Big Data SQL tables with Oracle R Enterprise

I was wondering recently if I could use Oracle R Enterprise (ORE) to query Big Data SQL tables (i.e. Oracle Database external tables based on HDFS or Hive data), since I have never seen such a combination mentioned in the relevant Oracle documentation and white papers. I am happy to announce that the answer is an unconditional yes. In...

Read more »

Getting Started with Microsoft SQL Server on Azure

February 11, 2016
By
Getting Started with Microsoft SQL Server on Azure

by Joseph Rickert If you are an R user and work for an enterprise where Microsoft SQL server is important, it is extremely helpful to have easy access to SQL Server databases. Over the past year, we have run several posts on this topic including a comprehensive four part series from Microsoft's Gregory Vandenbrouck on using various flavors of...

Read more »

Sponsors

Mango solutions



RStudio homepage



Zero Inflated Models and Generalized Linear Mixed Models with R

Dommino data lab

Quantide: statistical consulting and training



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)