I'm delighted to speak at SQL Saturday 888 in Sioux Falls this weekend. I'm delivering a session on web development with R. R isn't well known for enterprise Web Applications. However, recent advancements in the R ecosystem aim to change…
Earlier this month I delivered a presentation to the Omaha R user group. Originally I had planned to write out the major themes of the presentation into a series of blog posts. It later occurred to me that I could…
The CASE expression is one of the most important functions for cleaning and enriching data. CASE evaluates a column or group of columns against one or more conditions and then returns an expression. This is helpful for cutting data into…
Relational database management systems (RDBMS) provide a cornerstone for many apps and services. By technology standards, RDBMS are ancient. Strong theoretical underpinnings have kept RDBMS technologies relevant in a volatile industry. Even non-relational data stores have had to add RDBMS-like…
-------------------------------------------------------------------------------- Let’s pretend we’re back in 2016 for a moment. It's the morning of Tuesday February 9th. You are ready to take on the day right after you check Reuters news. A bearish headline catches your eye: “SE…