22-25 April 2026 
Python for SQL Server Specialists
2018TL; DR
Learn how to do the data science with Python in SQL Server 2017.
Session Details
Python is a more organized language than R. In last years, many data analytics libraries for Python evolved, and thus Python is catching up with R even in the data science area.
Microsoft added support for Python code in SQL Server in version 2017. Now you can use either R or Python inside the Database Engine for advanced tasks like predictive analytics. Therefore, you can use the language that suits you better. Statisticians and mathematicians might prefer R, while developers tend to be more Python oriented.
Attendees of this seminar learn to program with Python from scratch. Basic Python code is introduced using the Python engine installed with SQL Server 2017 and Visual Studio 2017. The seminar shows some more advanced data manipulations, matrix calculations and statistical analysis together with graphing options. The mathematics behind is briefly explained as well. Then the seminar switches to more advanced data mining and machine learning analyses.
Microsoft added support for Python code in SQL Server in version 2017. Now you can use either R or Python inside the Database Engine for advanced tasks like predictive analytics. Therefore, you can use the language that suits you better. Statisticians and mathematicians might prefer R, while developers tend to be more Python oriented.
Attendees of this seminar learn to program with Python from scratch. Basic Python code is introduced using the Python engine installed with SQL Server 2017 and Visual Studio 2017. The seminar shows some more advanced data manipulations, matrix calculations and statistical analysis together with graphing options. The mathematics behind is briefly explained as well. Then the seminar switches to more advanced data mining and machine learning analyses.
Pre-requisites
Familiarity with the tools - SQL Server Management Studio, Visual Studio
Laptop Required:Optional
- Spec: No special requirements, anything that can host SQL Server 2017. Note: laptop is not obligatory; however, I plan to provide the code used in the seminar at the beginning of the day, so you can join me in exploring and executing it. If you don"t have a laptop then no problem, you can sit back and watch!
- Software: SQL Server 2017 Database Engine Services with Machine Learning Services (In-Database) and both languages, Python and R, SQL Server Management Studio, Visual Studio 2017 setup for Data Science and Analytical Applications
3 things you'll get out of this session
Speakers
Dejan Sarka's previous sessions
Statistical Analysis in T-SQL
Learn how to analyze your data with pure T-SQL to get the performance you cannot reach with R, Python, or other tools. Learn the math behind as well.
Data Overview and Manipulation - T-SQL, R, Python
Before doing any analysis, you have to prepare the data properly.
Temporal Data in SQL Server
Use temporal support in SQL Server and add what is missing out of the box.
Analysing Text with SQL Server 2014
This session introduces SQL Server 2012 and 2014 text mining capabilities.
Optimizing Temporal Queries
Writing efficient queries with temporal predicates is finally not a problem anymore.
Excel 2013 Analytics
Excel is “The” analytical tool in Microsoft suite for advanced analysts. This session introduces Excel 2013 and 2010 business intelligence capabilities.
A Deep Dive in SQL Server 2012 Data Warehousing
In this session, we are going to explain and test different DW features in SQL Server 2012, including star join optimization through bitmap filters, table partitioning, window functions, columnstore indices and more.