1088 search results for "sql"

SQL Server 2017 to add Python support

April 20, 2017
By
SQL Server 2017 to add Python support

One of the major announcements from yesterday's Data Amp event was that SQL Server 2017 will add Python as a supported language. Just as with the continued R support, SQL Server 2017 will allow you to process data in the database using any Python function or package without needing to export the data from the database, and use SQL...

Read more »

Creating Interactive Charts with R, Shiny, MySQL and AnyChart JS via Template

April 18, 2017
By
Creating Interactive Charts with R, Shiny, MySQL and AnyChart JS via Template

Data visualization and charting are actively evolving as a more and more important field of web development. In fact, people perceive information much better when it is represented graphically rather than numerically as raw data. As a result, various business intelligence apps, reports, and so on widely implement graphs and charts to visualize and clarify … Continue...

Read more »

Publish R functions as stored procedures with the sqlrutils package

April 4, 2017
By

If you've created an R function (say, a routine to clean up missing values in a data set, or a function to make forecasts using a machine learning model), and you want to make it easy for DBAs to use it, it's now possible to publish R functions as a SQL Server 2016 stored procedure. The sqlrutils package provides...

Read more »

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 »

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)