Share via

SQL Saturday 613: Building 1 million predictions per second with R-services and SQL Server 2016

  • Article

image

SQL Saturday is round the corner again! SQL Saturday is a great event to meet the community, gather feedback and meet some great friends that we made during our last few SQL Saturdays. This time the Tiger team will be presenting a session on how to use R-Services with SQL Server to build an analytical workflow for banking solutions. We will talk about how our customer Jack Henry & Associates, an S&P 400 company that supports more than 11,300 financial institutions with core processing services, is leveraging the power of SQL Server and R to make drive intelligent insights into their data warehousing software. Post the session, I will share a complete solution which you can deploy on our Data Science Virtual Machine on Azure and tinker around with the demo solution at your free time.

Our Corporate Vice President, Joseph Sirosh, had demonstrated this solution along with Jack Henry & Associates at Ignite. In this session, I will talk about the nuts and bolts on how to build a scalable predictive engine with SQL Server and using the enhancements shipped in SQL Server 2016. After this session, you will be able to build your very own scalable predictive engine on SQL Server 2016!

Title: Building 1 million predictions per second using SQL-R [Session Link]

When: 15th April, 2017 | 2:45PM – 3:45PM PST

Where: Building 92, 15010 NE 36th St, Redmond (Room: Utopia)

Abstract: Using the power of OLTP and data transformation in SQL 2016 and advanced analytics in Microsoft R Server, various industries really push the boundary of processing higher number of transaction per second (tps) for different use cases. In this talk, we will walk through the use case of predicting loan charge off (loan default) rate, architecture configuration that enable this use case, and rich visual dashboard that allow customer to do what-if analysis. Attend this session to find out how SQL + R allows you to build an "intelligent datawarehouse".

My colleague, Pedro Lopes, will be presenting a session on “Enhancements that will make your SQL database roar”.

Looking forward to meet the community this Saturday!

The slide deck used for my presentation can be found on SlideShare. The PowerBI dashboard and the demo scripts can be downloaded from the tigertoolbox repo on GitHub.