SQL 2016 Technical Deep Dive Video – Big Data and Analytics
Big Data and Analytics
This is the set of videos from the SQL Server Engineering Team on SQL Server 2016. This post is covering Big Data, Analytics and Modelling.
For the other groups of videos have a look at.
Videos on You tube.
R Services in SQL Server 2016
Dotan Elharrar (LinkedIn) & Umachandar Jayachandran (linkedIn)
See how SQL Server R Services, a new feature in SQL Server 2016, allows you to build smart, predictive applications and extract insights from your SQL Server data while using the highly popular open source R language. Learn how to execute and deploy advanced analytics at scale while keeping the data in the database.
PolyBase- Gaining insights from HDFS and relational data in SQL Server 2016
To gain insights from both your Hadoop data and your relational data stored in SQL Server, you often need to transform and move data from one environment to the other. On this Data Driven sesssion, you'll learn how PolyBase in SQL Server 2016 enables you to query HDFS using T-SQL directly from SQL Server.
Real-Time Operational analytics with SQL Server 2016
Sunil Agarwal (LinkedIn|Twitter)
On this Data Driven session, we'll go over how Real-Time Operational Analytics in SQL Server 2016 combines two industry leading SQL Server technologies–In-memory OLTP and In-memory Analytics–using Columnstore index. Learn how it enables the creation of columnstore indexes directly on transactional tables which eliminates the need for a separate data warehouse and data movement. See how your transactional workload can continue to run with minimal performance impact while colunmstore index speeds up analytics.
Scaling your advanced analytics in SQL Server 2016 with R Server
Richard Kittler (LinkedIn) and Bill Jacobs (LinkedIn|Twitter)
R Server is an essential component in SQL Server R Services, a new feature in SQL Server 2016 which allows you to build predictive applications at scale using the popular open-source R language. On this Data Driven session, we will learn about R Server in a nutshell: How it allows you to scale your advanced analytics, what functions and algorithms come in the box, the difference between in-database R Services and a standalone R Server, and more.
Predictive Maintenance with R in SQL Server 2016
Xinwei Xue (LinkedIn) and James Ren (LinkedIn)
SQL Server R Services is a new feature in SQL Server 2016 which allows you to build predictive applications at scale using the popular open-source R language. On this Data Driven session, you'll learn how R Services can be used to predict machine failures, producing a more cost-effective maintenance model. This is just one example for a variety of smart applications that can be built or enhanced using R Services.
R Services FAQ SQL Server 2016
Vijay Jayaseelan (LinkedIn), Jasraj Dange (linkedIn), Umachandar Jayachandran (linkedIn) and Dotan Elharrar (LinkedIn)
SQL Server R Services is a new feature in SQL Server 2016 which allows you to build predictive applications at scale using the popular open-source R language. On this Data Driven session, we cover common questions about this new and exciting capability: How it scales, the high level architecture, how it is secured and governed, its availability in all the Editions of SQL Server, and more.
R Tools for Visual Studio
John Lam (LinkedIn|Twitter)
Watch this Data Driven session to get a tour of key features in Microsoft's new IDE for R users and data scientists.
Fraud Analysis using a hybrid implementation of Azure SQL Data Warehouse and SQL 2016 Reporting
Matt Goswell (LinkedIn|Twitter) and Sanjay Soni (LinkedIn)
On this Data Driven session, find out how business models are becoming more reactive in order to adapt to changing market conditions and channel opportunities. With the increase in breadth comes an increase of potential fraud, making Microsoft data warehousing capabilities critical in managing large volumes of disparate and relational data. Learn how to combine it for fast, accurate and validated information beautifully visualized through Microsoft Power BI and SQL Server 2016 Reporting Services including Mobile BI. Be connected to your data anywhere in the world, all with the immersive power and experience of touch.
Building intelligent applications using SQL Server R services- an End to End Walkthrough
SQL Server R Services is a new feature in SQL Server 2016 which allows you to build predictive applications at scale using the popular open-source R language. On this Data Driven session, you will experience the end-to-end journey starting with exploring the data and ending with deploying the R scripts and models in production. Additionally, you'll see code examples and learn about the typical personas involved and their roles.