Because I don't have to know T-SQL inside out and upside down in order to use R for something that SQL won't even do.
There's no question that R brings some fantastic stuff to the table and that there's a lot of stuff that it can do that T-SQL can't do never mind being super easy to do in R and I'm not challenging that. What I am challenging is the use of R, Powershell, SQL CLR, VBS, etc, etc, etc to do things that are actually quite easy to do in T-SQL that people just don't seem to take the time to learn because they think that SQL Server is just a place to store data.
My favorite example is when 2005 came out and the use of SQL CLR was all the rage. To make a much longer story shorter, a "developer" brought me an SQL CLR to deploy to production and I refused. He stormed out of the room before I could complete the word "No" and explain and he took it to management and I was called out on the carpet because it was supposedly a showstopper holding up a project. What did the SQL CLR do that was so critical. It calculated a MODULO. You know... the one that uses the "%" operator in T-SQL. <headdesk><major facepalm>
That's what I'm talking about.
hahaha, ok. was he paid hourly, by chance?
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses