SQLBits encompasses everything from in-depth technical immersions to the enhancement of valuable soft skills. The full agenda will be announced in the spring; in the meantime check out the timetable and content we cover below.
2024 Training Days
Presenting 2024’s selection of training days, encompassing a deep dive into a range of subjects with some of the best data trainers in the world.
- 08:00 Registration opens and breakfast served.
- All training days run simultaneously across the venue from 09:00 – 17:00 with co-ordinated breaks.
- All training days include regular refreshment breaks and a lunch stop to rest, recharge, and chat to fellow delegates.
- No evening events planned, but if you’re staying over the night beforehand, why not join us in the Aviator on Monday night to meet the training day speakers for an informal drinks reception.
Data Science with SQL Server Tools
Description
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.
Learning Objectives
Previous Experience
Tech Covered
performance, SSRS, BI, Analytics, Power BI, R