{"id":20797,"date":"2017-09-26T09:30:51","date_gmt":"2017-09-26T16:30:51","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/?p=20797"},"modified":"2024-01-22T22:51:02","modified_gmt":"2024-01-23T06:51:02","slug":"in-database-machine-learning-in-sql-server-2017","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/09\/26\/in-database-machine-learning-in-sql-server-2017\/","title":{"rendered":"In-database Machine Learning in SQL Server 2017"},"content":{"rendered":"<p><em>This post is authored by Sumit Kumar, Senior Program Manager, Microsoft and Nellie Gustafsson, Program Manager, Microsoft<\/em><\/p>\n<p>We are excited to announce the general availability of SQL Server 2017 and Machine Learning Services. You can start using Python-based in-database Machine Learning Services for production usage now. With support for both R and Python, we have rebranded \u2018R Services\u2019 to \u2018Machine Learning Services\u2019. SQL Server now supports the three most <a target=\"_blank\" href=\"http:\/\/www.kdnuggets.com\/2017\/05\/poll-analytics-data-science-machine-learning-software-leaders.html\" rel=\"noopener\">popular<\/a> data science languages and enables you to use the latest AI and ML packages from the open source world in-database, across ALL editions on Windows \u2013 making SQL Server 2017 the commercial database with built-in AI.<\/p>\n<p>As we have covered in previous <a target=\"_blank\" href=\"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2017\/04\/19\/python-in-sql-server-2017-enhanced-in-database-machine-learning\/\" rel=\"noopener\">posts<\/a>, there are many advantages of using this technology, such as the elimination of data movement, ease of deployment, improved security and better scale and performance. These abilities make SQL Server a powerful enterprise platform for machine learning. Examples of what some customers have built using Machine Learning Services:<\/p>\n<ul>\n<li>\n<a target=\"_blank\" href=\"https:\/\/customers.microsoft.com\/en-US\/story\/pros\" rel=\"noopener\">Pricing optimization<\/a> models<\/li>\n<li>Predictive analytics solutions to gain <a target=\"_blank\" href=\"https:\/\/customers.microsoft.com\/en-us\/story\/transforming-real-estate-data-services-with-hybrid-cloud-technologies\" rel=\"noopener\">real-estate property insights<\/a>\n<\/li>\n<li>Better and more accurate models for <a target=\"_blank\" href=\"https:\/\/customers.microsoft.com\/en-us\/story\/acxiom-corporation\" rel=\"noopener\">more precisely targeted marketing<\/a>\n<\/li>\n<li>\n<a target=\"_blank\" href=\"https:\/\/customers.microsoft.com\/en-US\/story\/heartlandbank\" rel=\"noopener\">Financial models<\/a> for banking<\/li>\n<\/ul>\n<h2>In-database Python integration<\/h2>\n<p>With the full support of in-database Python in SQL Server <a target=\"_blank\" href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/advanced-analytics\/what-s-new-in-sql-server-machine-learning-services\" rel=\"noopener\">Machine Learning Services<\/a> in SQL Server 2017, the vast population of Python developers and ML practitioners can now leverage the power of SQL Server alongside their Python code. And the SQL Server developers now have access to the extensive Python ML and AI libraries from the open source ecosystem along with the latest innovations from Microsoft (<em>revoscalepy<\/em> and <em>microsoftml<\/em> libraries) for developing intelligent applications with in-database analytics.<\/p>\n<h3><em>Python operationalization with T-SQL<\/em><\/h3>\n<p>Full Python integration with the sp_execute_external_script <a target=\"_blank\" href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/system-stored-procedures\/sp-execute-external-script-transact-sql\" rel=\"noopener\">infrastructure<\/a> in SQL Server enables the enterprise-grade operationalization of Python models and scripts as simple stored procedures.<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/application-developer-1024x535.png\"><img loading=\"lazy\" decoding=\"async\" width=\"879\" height=\"459\" class=\"aligncenter size-large wp-image-20785\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/application-developer-1024x535.png\" srcset=\"\"><\/a><\/p>\n<p>Streaming data from SQL to Python processes and MPI ring parallelization support provides much-improved performance to the Python scripts.<\/p>\n<h3>\n<em>Python remote <\/em>compute<em> in SQL Server<\/em><br \/>\n<\/h3>\n<p>With the SQL Server remote compute context, data scientists and developers can push the compute of Python code to the server from their development environments, to explore data and develop models without the need to move data.<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/data-scientists-1024x531.png\"><img loading=\"lazy\" decoding=\"async\" width=\"879\" height=\"456\" class=\"aligncenter size-large wp-image-20786\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/data-scientists-1024x531.png\" srcset=\"\"><\/a><\/p>\n<p>In-database Python integration is not limited to just machine learning and AI solutions &#8211; it is equally useful for general purpose data analysis work by combining Python and SQL in powerful ways; leveraging strengths of respective languages.<\/p>\n<h2>Orders of magnitude faster scoring<\/h2>\n<p>After <a target=\"_blank\" href=\"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2016\/10\/11\/1000000-predictions-per-second\/\" rel=\"noopener\">demonstrating<\/a> industry leading 1 million+ rows\/sec batch scoring performance, we are now introducing <a target=\"_blank\" href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/advanced-analytics\/sql-native-scoring\" rel=\"noopener\">Native Scoring<\/a> for even faster prediction! Some concurrent prediction scenarios require close to real-time response times. Models trained using the RevoScaleR and revoscalepy packages are supported by this new PREDICT verb (a system table value function) which makes it easy to embed this performant scoring functionality in regular T-SQL SELECT statements without invoking the R or Python runtime. Native scoring is also available on SQL Server on Linux.<\/p>\n<p><a target=\"_blank\" href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/advanced-analytics\/real-time-scoring\" rel=\"noopener\">Real-time scoring<\/a> is also available to SQL Server 2016 customers on upgrading in-database R to the latest release of Microsoft Machine Learning Server.<\/p>\n<h2>Improving R package management in SQL Server<\/h2>\n<p>One of the key values of R is its vibrant community with thousands of open source packages. We have further improved the <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/advanced-analytics\/r\/r-package-management-for-sql-server-r-services\">R package management<\/a> in SQL Server. We have a rich set of R functions to do package management in SQL Server that gives users the ability to install, uninstall and manage packages in various roles and scopes. In addition, it is now possible to install R packages on SQL Server using TSQL commands (CREATE EXTERNAL LIBRARY). This approach ensures availability of the previously installed packages when a server fails over.<\/p>\n<h2>Machine Learning Server<\/h2>\n<p>Along with the general availability of SQL Server 2017, we have also <a target=\"_blank\" href=\"https:\/\/aka.ms\/mlserver92\" rel=\"noopener\">announced the general availability<\/a>\u00a0of the new Microsoft Machine Learning Server! This is the underlying software that is integrated into SQL Server as Machine Learning Services. Machine Learning Server is the transformation of <a target=\"_blank\" href=\"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2017\/04\/19\/introducing-microsoft-r-server-9-1-release\/\" rel=\"noopener\">Microsoft R Server<\/a> into an even more flexible platform that offers a choice of R and Python languages and brings the best of algorithmic innovations from the open source world and Microsoft. Its multi-platform support enables customers to build portable models wherever their data is and operationalize the models on platforms like SQL Server, making the intelligence easily consumable by business applications.<\/p>\n<p>Key new algorithmic innovations of Machine Learning Server benefitting the SQL Server scenarios are:<\/p>\n<h3><em>Revoscalepy<\/em><\/h3>\n<p>This <a href=\"https:\/\/docs.microsoft.com\/en-us\/r-server\/python-reference\/revoscalepy\/revoscalepy-package\">package<\/a> has the Pythonic version of Microsoft\u2019s proprietary <em>Parallel External Memory Algorithms<\/em> (APIs for linear and logistic regressions, decision tree, boosted tree and random forest) and a rich set of APIs for <em>ETL<\/em>, remote <em>compute contexts<\/em> and <em>data sources<\/em>. These are the same scalable and parallelized algorithms (with \u2018rx\u2019 prefix) that have been the differentiating value proposition of Microsoft R Server and allow scaling analytics to arbitrarily large datasets, way beyond the available memory.<\/p>\n<h3><em>microsoftml<\/em><\/h3>\n<p>This <a target=\"_blank\" href=\"https:\/\/docs.microsoft.com\/en-us\/r-server\/python-reference\/microsoftml\/microsoftml-package\" rel=\"noopener\">package<\/a> is a set of state of the art, battle-tested ML algorithms and transforms with Python bindings including deep neural net, one class SVM, fast tree, forest, linear and logistic regressions etc. In addition, this package contains pre-trained models for extracting features from images using ResNet models, and doing sentiment analysis from English language text, which dramatically simplifies the creation and deployment of complex AI scenarios on image and text data.<\/p>\n<p>We have also simplified the pricing model to make it easier to acquire and use Machine learning Server on Hadoop. Each SQL Server EE core under Software Assurance gives you rights to use Machine Learning Server on 5 nodes of Hadoop.<\/p>\n<h2>Call to action<\/h2>\n<p>SQL Server Machine Learning Services is available in all editions of SQL Server 2017 on Windows and we encourage you to <a target=\"_blank\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/sql-server-2017\" rel=\"noopener\">download<\/a> and explore the above-mentioned enhancements in the free express or developer editions. Our R and Python <a href=\"http:\/\/aka.ms%5Cmlsqldev\">getting started tutorials<\/a> will walk you through building your first machine learning solutions with SQL Server. You can find additional <a target=\"_blank\" href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/advanced-analytics\/tutorials\/machine-learning-services-tutorials\" rel=\"noopener\">tutorials<\/a> on Microsoft docs.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This post is authored by Sumit Kumar, Senior Program Manager, Microsoft and Nellie Gustafsson, Program Manager, Microsoft We are excited to announce the general availability of SQL Server 2017 and Machine Learning Services. You can start using Python-based in-database Machine Learning Services for production usage now. With support for both R and Python, we have<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ms_queue_force_push":false,"ms_queue_id":"","ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[2394,5227,2406],"content-type":[2421],"topic":[2457],"coauthors":[2487],"class_list":["post-20797","post","type-post","status-publish","format-standard","hentry","product-machine-learning-server","product-sql","product-sql-server-2017","content-type-announcements","topic-data-analytics"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>In-database Machine Learning in SQL Server 2017 - Microsoft SQL Server Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/09\/26\/in-database-machine-learning-in-sql-server-2017\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"In-database Machine Learning in SQL Server 2017 - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"This post is authored by Sumit Kumar, Senior Program Manager, Microsoft and Nellie Gustafsson, Program Manager, Microsoft We are excited to announce the general availability of SQL Server 2017 and Machine Learning Services. You can start using Python-based in-database Machine Learning Services for production usage now. With support for both R and Python, we have\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/09\/26\/in-database-machine-learning-in-sql-server-2017\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2017-09-26T16:30:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:51:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/application-developer-1024x535.png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/09\/26\/in-database-machine-learning-in-sql-server-2017\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/09\/26\/in-database-machine-learning-in-sql-server-2017\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"In-database Machine Learning in SQL Server 2017\",\"datePublished\":\"2017-09-26T16:30:51+00:00\",\"dateModified\":\"2024-01-23T06:51:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/09\/26\/in-database-machine-learning-in-sql-server-2017\/\"},\"wordCount\":982,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/09\/26\/in-database-machine-learning-in-sql-server-2017\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/application-developer-1024x535.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/09\/26\/in-database-machine-learning-in-sql-server-2017\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/09\/26\/in-database-machine-learning-in-sql-server-2017\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/09\/26\/in-database-machine-learning-in-sql-server-2017\/\",\"name\":\"In-database Machine Learning in SQL Server 2017 - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/09\/26\/in-database-machine-learning-in-sql-server-2017\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/09\/26\/in-database-machine-learning-in-sql-server-2017\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/application-developer-1024x535.png\",\"datePublished\":\"2017-09-26T16:30:51+00:00\",\"dateModified\":\"2024-01-23T06:51:02+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/09\/26\/in-database-machine-learning-in-sql-server-2017\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/09\/26\/in-database-machine-learning-in-sql-server-2017\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/09\/26\/in-database-machine-learning-in-sql-server-2017\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/application-developer-1024x535.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/application-developer-1024x535.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/09\/26\/in-database-machine-learning-in-sql-server-2017\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"In-database Machine Learning in SQL Server 2017\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"In-database Machine Learning in SQL Server 2017 - Microsoft SQL Server Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/09\/26\/in-database-machine-learning-in-sql-server-2017\/","og_locale":"en_US","og_type":"article","og_title":"In-database Machine Learning in SQL Server 2017 - Microsoft SQL Server Blog","og_description":"This post is authored by Sumit Kumar, Senior Program Manager, Microsoft and Nellie Gustafsson, Program Manager, Microsoft We are excited to announce the general availability of SQL Server 2017 and Machine Learning Services. You can start using Python-based in-database Machine Learning Services for production usage now. With support for both R and Python, we have","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/09\/26\/in-database-machine-learning-in-sql-server-2017\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2017-09-26T16:30:51+00:00","article_modified_time":"2024-01-23T06:51:02+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/application-developer-1024x535.png","type":"","width":"","height":""}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"4 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/09\/26\/in-database-machine-learning-in-sql-server-2017\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/09\/26\/in-database-machine-learning-in-sql-server-2017\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"In-database Machine Learning in SQL Server 2017","datePublished":"2017-09-26T16:30:51+00:00","dateModified":"2024-01-23T06:51:02+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/09\/26\/in-database-machine-learning-in-sql-server-2017\/"},"wordCount":982,"commentCount":3,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/09\/26\/in-database-machine-learning-in-sql-server-2017\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/application-developer-1024x535.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/09\/26\/in-database-machine-learning-in-sql-server-2017\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/09\/26\/in-database-machine-learning-in-sql-server-2017\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/09\/26\/in-database-machine-learning-in-sql-server-2017\/","name":"In-database Machine Learning in SQL Server 2017 - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/09\/26\/in-database-machine-learning-in-sql-server-2017\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/09\/26\/in-database-machine-learning-in-sql-server-2017\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/application-developer-1024x535.png","datePublished":"2017-09-26T16:30:51+00:00","dateModified":"2024-01-23T06:51:02+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/09\/26\/in-database-machine-learning-in-sql-server-2017\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/09\/26\/in-database-machine-learning-in-sql-server-2017\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/09\/26\/in-database-machine-learning-in-sql-server-2017\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/application-developer-1024x535.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/application-developer-1024x535.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/09\/26\/in-database-machine-learning-in-sql-server-2017\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"In-database Machine Learning in SQL Server 2017"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/20797","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=20797"}],"version-history":[{"count":1,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/20797\/revisions"}],"predecessor-version":[{"id":50236,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/20797\/revisions\/50236"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=20797"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=20797"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=20797"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=20797"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=20797"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=20797"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}