Dejan Sarka, MCT and SQL Server MVP, is an independent trainer and consultant that focuses on development of database & 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 coauthor of eighteen books about databases and SQL Server. Dejan Sarka also developed many courses and seminars for Microsoft, SolidQ and Pluralsight.

Dejan Sarka has submitted 2 sessions for SQLBits 2020, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

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.
Use Power BI Desktop as a data science tool. Learn how to push the free tool to its maximum.

Sessions

Previous Sessions

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.
Excel is “The” analytical tool in Microsoft suite for advanced analysts. This session introduces Excel 2013 and 2010 business intelligence capabilities.
Writing efficient queries with temporal predicates is finally not a problem anymore.
This session introduces SQL Server 2012 and 2014 text mining capabilities.
R extends statistical and mathematical capabilities of SQL Server 2016.
Before doing any analysis, you have to prepare the data properly.
Use temporal support in SQL Server and add what is missing out of the box.
Dejan_Sarka231255.jpg