locked
SQL Server Machine Learning Services vs azure machine learning? RRS feed

  • Question

  • Hi,

    What's the difference between 'SQL Server Machine Learning Services' and 'azure machine learning'?

    I used to be a sql developer, I am a statistician now, I am wondering which product should I use and what's the difference...

    Saturday, April 13, 2019 9:38 PM

Answers

  • Hi maca128,

     

    SQL Server Machine Learning Services: SQL Server 2017 Machine Learning Services is an add-on to a database engine instance, used for executing R and Python code on SQL Server. The feature includes Microsoft R and Python packages for high-performance predictive analytics and machine learning. Code runs in an extensibility framework, isolated from core engine processes, but fully available to relational data as stored procedures, as T-SQL script containing R or Python statements, or as R or Python code containing T-SQL. For more details, please refer to Machine Learning Services (R, Python) in SQL Server 2017

     

    Azure machine learning: Azure Machine Learning service provides a cloud-based environment you can use to prep data, train, test, deploy, manage, and track machine learning models. Azure Machine Learning service fully supports open-source technologies. So you can use tens of thousands of open-source Python packages with machine learning components. Examples are PyTorch, TensorFlow, and scikit-learn. Support for rich tools makes it easy to interactively explore and prepare data and then develop and test models. Examples are Jupyter notebooks or the Azure Machine Learning for Visual Studio Code extension. Azure Machine Learning service also includes features that automate model generation and tuning to help you create models with ease, efficiency, and accuracy. For more details, please refer to What is Azure Machine Learning service?

     

    Hope this could help you .

    Best regards,

    Dedmon Dai


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Monday, April 15, 2019 5:29 AM
  • Hello,



    Now you not only have SQL Server Machine Learning Services and Azure Machine Learning Services as options for ML, you also have Azure SQL Database Machine Learning as option as you can read here.


    SQL Server Machine Learning Services is an In-database Machine Learning (ML) solution. No data movement. Model training on full datasets where your data lives, in a secure, compliant, scalable way. Operationalization of the models as T-SQL stored procedures. Existing and new applications can access the ML models by just calling a stored procedure. SQL Server Machine Learning Services is an on-prem ML solution for enterprises that supports both R and Python


    Meanwhile, SQL Machine Learning Services in Azure SQL Database has the same in-database ML benefits as SQL Server Machine Learning Services, but in your Azure database. This option is in preview and for now supports R but support for Python may be coming in the future.


    About Azure Machine Learning Service, it is an Azure only solution (not on-premises). It includes experimentation, model management and multiple deployment options. This option of ML only supports Python. You can use data coming from many sources in Azure. For more information, read here.


    Hope this helps.


    Regards,

    Alberto Morillo
    SQLCoffee.com




    Tuesday, April 16, 2019 3:28 AM

All replies

  • I think it depends what service you are using . If you on Azure use Azure Machine Learning service

    https://docs.microsoft.com/en-us/azure/machine-learning/studio/


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Sunday, April 14, 2019 4:28 AM
    Answerer
  • These two are totally two different things.

    SQL server machine learning services is all about the capabilities of SQL server with Machine Learning. 

    Azure machine learning is all about the services provider by azure such as Machine learning studio and Machine learning service which includes databricks, cognitive services, Azure notebooks etc.


    Please remember to mark the replies as answers if they help and unmark them if they provide no help, this will help others who are looking for solutions to the same or similar problem. profile for Sajeetharan at Stack Overflow, Q&A for professional and enthusiast programmers


    Sunday, April 14, 2019 4:37 AM
  • Hi maca128,

     

    SQL Server Machine Learning Services: SQL Server 2017 Machine Learning Services is an add-on to a database engine instance, used for executing R and Python code on SQL Server. The feature includes Microsoft R and Python packages for high-performance predictive analytics and machine learning. Code runs in an extensibility framework, isolated from core engine processes, but fully available to relational data as stored procedures, as T-SQL script containing R or Python statements, or as R or Python code containing T-SQL. For more details, please refer to Machine Learning Services (R, Python) in SQL Server 2017

     

    Azure machine learning: Azure Machine Learning service provides a cloud-based environment you can use to prep data, train, test, deploy, manage, and track machine learning models. Azure Machine Learning service fully supports open-source technologies. So you can use tens of thousands of open-source Python packages with machine learning components. Examples are PyTorch, TensorFlow, and scikit-learn. Support for rich tools makes it easy to interactively explore and prepare data and then develop and test models. Examples are Jupyter notebooks or the Azure Machine Learning for Visual Studio Code extension. Azure Machine Learning service also includes features that automate model generation and tuning to help you create models with ease, efficiency, and accuracy. For more details, please refer to What is Azure Machine Learning service?

     

    Hope this could help you .

    Best regards,

    Dedmon Dai


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Monday, April 15, 2019 5:29 AM
  • Hello,



    Now you not only have SQL Server Machine Learning Services and Azure Machine Learning Services as options for ML, you also have Azure SQL Database Machine Learning as option as you can read here.


    SQL Server Machine Learning Services is an In-database Machine Learning (ML) solution. No data movement. Model training on full datasets where your data lives, in a secure, compliant, scalable way. Operationalization of the models as T-SQL stored procedures. Existing and new applications can access the ML models by just calling a stored procedure. SQL Server Machine Learning Services is an on-prem ML solution for enterprises that supports both R and Python


    Meanwhile, SQL Machine Learning Services in Azure SQL Database has the same in-database ML benefits as SQL Server Machine Learning Services, but in your Azure database. This option is in preview and for now supports R but support for Python may be coming in the future.


    About Azure Machine Learning Service, it is an Azure only solution (not on-premises). It includes experimentation, model management and multiple deployment options. This option of ML only supports Python. You can use data coming from many sources in Azure. For more information, read here.


    Hope this helps.


    Regards,

    Alberto Morillo
    SQLCoffee.com




    Tuesday, April 16, 2019 3:28 AM