976 search results for "sql"

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 »

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 »

Tutorial: Build a live rental prediction service with SQL Server R Services

November 23, 2016
By
Tutorial: Build a live rental prediction service with SQL Server R Services

A great way to learn is by doing, so if you've been thinking about how to enable R-based computations within SQL Server, a new tutorial will take you through all the steps of building an intelligent application. In a few simple steps, you'll set up all the necessary software and code to build a live service that predicts demand...

Read more »

SQLServer on Docker

November 19, 2016
By
SQLServer on Docker

I have been looking forward to test driving Microsoft SQLServer R Services.   However, I don't run the Windows Operating System on any of my machines.  I do use Docker regularly and so was interested to hear about a new version of SQLServer that runs on Linux that is now available as...

Read more »

MySql in a container

November 19, 2016
By

I have previously written on using containerized PostgreSQL with R. This show the steps for using containerized MySQL with R. As a consulting data scientist I often have to debug and rehearse work away from the clients actual infrastructure. Because of this it is useful to be able to spin up disposable PostgreSQL or MySQL … Continue...

Read more »

Microsoft allows trying its new SQL Server for Linux

November 16, 2016
By

This is a great time to have tools to do data analysis.  Microsoft is now allowing evaluations of its new SQL Server.  This new SQL Server can now be deployed to a Linux OS environment.  This is big news especially for those that have followed this blog through the years.The new SQL Server version is also carries new...

Read more »

Detecting outliers and fraud with R and SQL Server on my bank account data – Part 1

October 31, 2016
By
Detecting outliers and fraud with R and SQL Server on my bank account data – Part 1

Detecting outliers and fraudulent behaviour (transactions, purchases, events, actions, triggers, etc.) takes a large amount of experiences and statistical/mathetmatical background. One of the samples Microsoft provided with release of new SQL Server 2016 was using simple logic of Benford’s law. This law works great with naturally occurring numbers and can be applied across any kind … Continue...

Read more »

Free e-book: Data Science with SQL Server 2016

October 28, 2016
By
Free e-book: Data Science with SQL Server 2016

There's a new e-book available to download free from Microsoft Academy: Data Science with Microsoft SQL Server 2016. This 90-page e-book is aimed at data scientists who already have some experience in R, but want to learn how to use R wirth SQL Server. The book was written by some of my most experienced colleagues from Microsoft's data science...

Read more »

R, SQL, LaTeX and Chat!

October 27, 2016
By
R, SQL, LaTeX and Chat!

Building a product is an exhilarating experience; building a product for the smartest people on the planet is a whole ‘nother beast.Over the last few months, everyone at Datazar has been on an accelerated learning experience. Most of it due to the f...

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)