SQL Server Performance & Troubleshooting – Where Milliseconds Matter 🚀

Hi Guys, I wish you an happy Easter! Today we will do another little step into the Machine Learning . Some weeks ago infact we talk about how to install Machine Learning services in SQL Server . I suggest to read the post you can find here: From SQLServer to ML, a first little step into machine learning This is because today we will see how to read data from SQL database with the R language . Read data in R language If you remember, in the previuos post we have enabled the execution of external scripts. Infact we will use external scripts in order to read data from SQL Server. The procedure sp_execute_external_script have some parameters that are: The language in this case you must specify "R" Command sent to R Runtime The input_data_1query data result Schema of the table returned For the example below we will read data from our ORDTES table: USE MASTER EXECUTE sp_execute_external_script @language = N'R' , @script ...

Hi Guys, Welcome back! Today a totally new argoument! It is now clear that the next big wave will be the AI (artificial intelligence) and the ML (Machine Learning) . I know you already have an installation of SQL Server installation. So let's see how to install machine learning services and the R language! Follow me! How to install machine learning services  Start the installation program and choose the first item. In italian “ Nuova installazione autonoma di SQL Server o aggiunta di funzionalità a un’installazione esistente ” Now choose the first checkbox “ Esegui una nuova installazione di SQL Server 2017 ” Choose the functions: Machine Learning Services (In-Database) R (aka R language) Install the Launchpad service: Now the installation come to the end: Restart the SQL Server instance! Now you need to enable the execution of the external scripts . You can do this through this command: sp_configure 'exter...