Python Security

SQL Server Administration
1

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?

2

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")
3

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

4

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