22-25 April 2026 
Data Science with SQL Server Tools
2017TL; DR
This session aims to demystify data science by showing how to create advanced analytical functions and display the results using SQL Server 2016, R and Power BI. These concepts are applied to develop practical solutions for db performance insight.
Session Details
Advanced data analytics does not live only in the realm of data scientists. The necessary tools now exist in SQL Server 2016 to perform advanced analytical analysis with R and Power BI. Attendees will see how to apply these techniques to analyze a database server, by showing how to perform in-depth analysis on practical things such as improving database monitoring, create predictive models for server performance load, and determining when disk space is required.
Session Goals
Learn how to code applications in R to provide data insight and data visualizations for use within SQL Server.
Develop and understanding of some of the algorithms used in data science and how to apply them.
Extend the functionality of SQL Server by integrating R code to provide insight into the performance of SQL Server.
Understand different ways to visualize the results, including storing within SQL Server, creating SSRS reports and visualizing in Power BI.
Session Agenda
Introduction to Data Science concepts.
Application of Data Science algorithms in R.
SQL Server R Internals and Integration.
Modifying SQL Server to optimally perform and monitor R Code.
In depth walkthrough of SQL Server running R
Introduction to Linear Regression.
Application of linear regression to determine storage space usage over time within SQL Server.
Predictive and Prescriptive Analysis techniques.
Application of predictive and prescriptive analysis through analysis of DMVs.
Common visualization techniques used in data science.
Demonstration of how visualizations are used in evaluating data algorithms.
Configuration and methods for displaying visualizations within SQL Server, R and Power BI.
Session Goals
Learn how to code applications in R to provide data insight and data visualizations for use within SQL Server.
Develop and understanding of some of the algorithms used in data science and how to apply them.
Extend the functionality of SQL Server by integrating R code to provide insight into the performance of SQL Server.
Understand different ways to visualize the results, including storing within SQL Server, creating SSRS reports and visualizing in Power BI.
Session Agenda
Introduction to Data Science concepts.
Application of Data Science algorithms in R.
SQL Server R Internals and Integration.
Modifying SQL Server to optimally perform and monitor R Code.
In depth walkthrough of SQL Server running R
Introduction to Linear Regression.
Application of linear regression to determine storage space usage over time within SQL Server.
Predictive and Prescriptive Analysis techniques.
Application of predictive and prescriptive analysis through analysis of DMVs.
Common visualization techniques used in data science.
Demonstration of how visualizations are used in evaluating data algorithms.
Configuration and methods for displaying visualizations within SQL Server, R and Power BI.
3 things you'll get out of this session
Speakers
Ginger Grant's previous sessions
How changes to Azure Synapse Analytics impact data architecture designs
Explore the changes that have been made to Azure Synapse Analytics and how this has changed it’s use over time. We will review how these feature additions have impacted the methods used for transforming, storing, and querying data so that you can evaluate whether it would be a good fit for your data environment.
How to pick the best Data transformation strategy
Combining data from multiple sources can be performed using a number of different tools including Azure Synapse Integration/Azure Data Factory, Spark and Power BI Data Flows. We will explore which tool or combination of tools to select to best match your data environment.
SQL Server Internals and Configuration for R
Learn how to configure SQL Server 2016 for running R. The individual components and executables installed with R on SQL Server will be explored to understand the internal interactions and processes involved.