SQL Server 2017, the next major release of the SQL Server database, has been available as a community preview for around 8 months, but now the first full-featured release candidate is available for public preview. For those looking to do data science with data in SQL Server, there are a number of new features compared to SQL Server 2017 which might be of interest:
- SQL Server 2017 will be supported on Linux, specifically on Red Hat, SUSE, and Ubuntu (as well as within a Docker container). You can read some of the backstory on how SQL Server came to Linux here.
- The new SQL Server Machine Learning Services will provide in-database analytics in both the R and — new to SQL Server 2017 — Python languages.
- There are several improvements to the in-database R integration (previously known as "R Services" in SQL Server 2016). These includes a new package management system, real-time in-database scoring of predictive models, and an updated R engine.
SQL Server 2017 Release Candidate 1 is available for download now. For more details on these and other new features in this release, check out the link below.
SQL Server Blog: First release candidate of SQL Server 2017 now available
I've been playing around with R in SQL 2017 RC1 and I've got a couple of questions:
1) SQL 2017 RC1 ships with Microsoft R Server 9.2. I can't find any release notes for changes in 9.2. Any additional information about what makes it different from 9.1? And any insight into when MRS will update to R 3.4?
2) I'm interested in learning more about the new R package management features in SQL 2017, specifically "CREATE EXTERNAL LIBRARY" (https://docs.microsoft.com/en-us/sql/t-sql/statements/create-external-library-transact-sql) but I've run into a few issues with it.
3) The real-time scoring in-database scoring is interesting and I'm looking forward to testing that more soon!
Thanks!
Posted by: Bob Albright | July 25, 2017 at 17:23
Great Thanks for sharing this news
Posted by: پنل اس ام اس | July 26, 2017 at 04:33