SQL Server 2016: R Integration Redux

SQL Server 2016 has now reached Release Candidate 3 (RC3). One of the new features that continues to foster interest in the analytics and data mining community is the integration of SQL Server with the open-source statistics toolset R. If you fall into this category, I’m inclined to suggest you remain patient and wait for […]
Read More ›

SQL Server 2016: Query Store Configuration

Introduction Some of the new features of SQL Server 2016, most notably the Advanced Analytics and Polybase, are unprecedented in earlier versions. In contrast, the Query Store added to SQL Server 2016 doesn’t so much add new features as make the time-honored tasks of query execution monitoring faster, easier, and more convenient. Once turned on […]
Read More ›

SQL Server 2016 – Analytic Revolution with R: Part 3

Implementing a Data Science Workstation SQL Server Architecture for R and Data Science We have previously seen how to integrate R with SQL Server. While executing R scripts in stored procedures is tremendously valuable, the methods lacks the interactivity required by most analysts. To appreciate how SQL Server’s R services can provide this interactivity, we […]
Read More ›

SQL Server 2016 – Analytic Revolution with R: Part 2

Integrating R Scripts with Transact-SQL In Part 1, we discussed the installation of Revolution R, and confirmed that the SQL Server integration worked with a simple test. EXECUTE sp_execute_external_script @language = N’R’, @script = N’R_data_frame <- InputDataSet’, @input_data_1 = N’SELECT ”Hello, World!”’, @output_data_1_name = N’R_data_frame’ WITH RESULT SETS((MyColumn char (13))) Now let’s take a closer […]
Read More ›

SQL Server 2016: Real-Time Operational Analytics

SQL Server 2016 introduces updatable nonclustered columnstore indexes. The complexity of that phrase should not mask the simplicity and importance of its application. Updatable nonclustered columnstore indexes make possible what Microsoft calls “Real-Time Operational Analytics.” It would be hard to overstate the importance of making real-time transactional data available immediately for data mining and advanced […]
Read More ›

Type to search blog.learningtree.com

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.