03/27/2018
by Marlon Ribunal
Comments Off on Getting Things Done With SSMS
As a SQL Server pro, I spend most of my productive time in the SQL Server Management Studio (SSMS). I am currently using the latest version as of this writing, which is v17.6. I set it up in different configurations … Continue reading
03/20/2018
by Marlon Ribunal
1 Comment
Installing R packages in SQL Server 2017 is a breeze with the stored procedure sp_execute_external_script. But so far, it is limited to installing one package at a time. If you have an R Package with dependencies, you have to install those … Continue reading
03/13/2018
by Marlon Ribunal
2 Comments
Prior to SQL Server 2016, running R on Microsoft platform required an installation of the R Language and its environment and an external IDE to write R codes. Then came the Microsoft R Server and its own flavor of R, … Continue reading