Home Forums Future Versions SQL 12 Learning R: Easy Syntax, Horribly Difficult Concepts RE: Learning R: Easy Syntax, Horribly Difficult Concepts

  • xsevensinzx (12/14/2015)


    Not to side track, but question:

    Why prove the usefulness of R to the DBA as opposed to a general purpose language like Python that can accomplish the same thing? I only ask because R is a bit more complex and has limited uses for the DBA versus Python than can actually be used by the DBA as a secondary scripting language both inside and outside of Windows that spans across platforms, API's and even database engines?

    I feel this awesome blog article you're writing would be targeted to someone like me who works as a data professional in the data science field, but most of us are using Python on the backend where all the data scientist are using R for the deep dives down the road. Both are awesome and useful, but until most of us start picking up 2016, we're still using Python across RDBMS, NoSQL, etc. 😎

    Microsoft is investing pretty heavily in R. You can call R functions directly from SQL Server 2016. I'm just focusing where Microsoft does. It's not a knock against Python.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning