I've used many different databases in my career. I began with Ashton Tate's dBase III and then moved to FoxPro and Access. I remember when Sybase 6.5 became SQL Server 7.0. I've used Oracle, Postgres, Cassandra and other open source db software.

Today, I'm spending most of my time with SQL Server, MySQL and Snowflake.

Microsoft SQL Server

I like to say SQL Server 2008 R2 was my favorite version of SQL Server. The software just "worked" and I really liked the integration with SSAS, SSIS and SSRS. Microsoft has continued to work on SQL Server embedding R and Python in the latest releases (2016, 2017, 2019).

The example illustrates how R script can be embedded in SQL stored procedures. It's available on Github and can be deployed to either on-prem or Azure instance. I'm using a VM to keep costs down.

The example can be found at:

I'm using a local instance - Power BI Report Server - to deliver the "reporting" available with the sample.


I've had a chance in the last couple of years to use Snowflake on a couple of projects. Here is an image from a Snowflake instance where I was an Account Admin and added the data from the CPG Dataset example.


I've also used MySQL, Postgres and Cassandra in the past.