SQLTeam.com | Weblogs | Forums

Python Security

Is there a way to check if "Machine Learning Language" has been installed on a SQL Server?

Also, in terms of security, is it safe to enable External Script language?

Are you planning on learning Machine Learning?

Run this and see what it throws

use sqlteam
go

--Hello World:
EXEC sp_execute_external_script @language =N'Python',
@script=N'
print("Hello World")

Yes, because in your other reply to the thread, you recommended Python right?

This is how you check if Machine Learning has been installed:
EXEC sp_configure 'external scripts enabled'

Also, after further research, Microsoft recommends to install Machine Learning on its own server, not with the database server to avoid performance conflicts.

Thanks

You dont need to install machine learning. Just install latest python and run the scripts I shared