Dejan Sarka
Dejan Sarka, MCT and SQL Server MVP, is an independent trainer and consultant that focuses on development of database and business intelligence applications. Besides projects, he spends about half of the time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or co-author of nineteen books about databases and SQL Server. Dejan Sarka has also developed many courses and seminars for Radacad, Microsoft, SolidQ, and Pluralsight.
Dejan Sarka's Training Days
Python for SQL Server SpecialistsSQLBits 2018
Learn how to do the data science with Python in SQL Server 2017.
Advanced Data Modeling TopicsSQLBits 2014
Go well beyond generally spread knowledge about the relational database design.
Dejan Sarka's Sessions
Statistical Analysis in T-SQLSQLBits 2021
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.
Statistical Analysis in T-SQLSQLBits 2020
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, PythonSQLBits 2018
Before doing any analysis, you have to prepare the data properly.
Temporal Data in SQL ServerSQLBits 2018
Use temporal support in SQL Server and add what is missing out of the box.
Using R in SQL Server 2016 Database Engine and SSRSSQLBits 2016
R extends statistical and mathematical capabilities of SQL Server 2016.
Analysing Text with SQL Server 2014SQLBits 2015
This session introduces SQL Server 2012 and 2014 text mining capabilities.
Optimizing Temporal QueriesSQLBits 2014
Writing efficient queries with temporal predicates is finally not a problem anymore.
Excel 2013 AnalyticsSQLBits 2013
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 WarehousingSQLBits 2012
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.
Statistical Analysis in T-SQLSQLBits 2020
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, PythonSQLBits 2018
Before doing any analysis, you have to prepare the data properly.
Temporal Data in SQL ServerSQLBits 2018
Use temporal support in SQL Server and add what is missing out of the box.
Analysing Text with SQL Server 2014SQLBits 2015
This session introduces SQL Server 2012 and 2014 text mining capabilities.
Optimizing Temporal QueriesSQLBits 2014
Writing efficient queries with temporal predicates is finally not a problem anymore.
Excel 2013 AnalyticsSQLBits 2013
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 WarehousingSQLBits 2012
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.