1019 search results for "SQL"

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 »

Running multiple correlations with R and T-SQL

June 26, 2016
By
Running multiple correlations with R and T-SQL

Getting to know the data is always an interesting part of data science. With R integration into SQL Server, the exploration part is still part of the game. Usual way to get some statistics out of the dataset is to run some frequencies, descriptive statistics and nevertheless correlations. Running correlations against a set of variables

Read more »

First thoughs on R integration in SQL Server 2016

June 23, 2016
By
First thoughs on R integration in SQL Server 2016

This blog post is a very personal confession, might be delicate but it must be understood as a  proposal or plan for improvement. Update #1: Typing error in title: correct title is First thoughts on R integration in SQL Server 2016 (update: June 24, 2016) Before the start, let me put some background and context.

Read more »

Importing CSV data using T-SQL and R

June 18, 2016
By
Importing CSV data using T-SQL and R

Several ways exists to import CSV (excel) data into your SQL Server Database. One is of course, using SSIS. The other one – similar to SSIS – is using import/export function in SSMS. With wizard, you will be able to import data. Futher on, BULK INSERT (BCP) statement is to all DBA and developers very

Read more »

Access your data in Amazon Redshift and PostgreSQL with Python and R

May 27, 2016
By
Access your data in Amazon Redshift and PostgreSQL with Python and R

So you want to start analyzing the data you have on Amazon Redshift or PostgreSQL with R or Python using NuMpy and Pandas. See how you can access your data.

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 »

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)