| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Alexander Klein | Data Science Machine Learning | Let the Cognitive Services to help you to find your favourite cocktail. |
| 09:00:00 | Cláudio Silva | Database Administration Deployment | Administrating SSRS/PBIRS was a boring task! Sorry...did you said WAS? |
| 09:00:00 | Dmitry Pilugin | Database Application Development | Parallel Query Processing in SQL Server |
| 10:15:00 | Alberto Ferrari | Business Intelligence | Inside the VertiPaq engine |
| 10:15:00 | Luis Beltran | Data Science Machine Learning | SQL Server Machine Learning Services with Python and R |
| 10:15:00 | Mikael Wedham | Database Application Development | A Masters view on Locking and blocking |
| 12:15:00 | André Melancia | Database Administration Deployment | SQL Curiosities: Zvědavost kočku zabila |
| 12:15:00 | Andrea Martorana Tusa | Database Application Development | T-SQL advanced: Grouping and Windowing |
| 12:15:00 | Jiří Neoral | Business Intelligence | Monitoring your BI solution with Power BI |
| 13:30:00 | Cédric Charlier | Business Intelligence | Automating the testing of your BI solutions with NBi |
| 13:30:00 | Hugo Kornelis | Database Application Development | Execution plans ... where do I start? |
| 13:30:00 | Damian Widera | Data Science Machine Learning | Data Science for everybody. Beware of what you are eating. |
| 14:45:00 | Marcos Freccia | Database Administration Deployment | Dbatools - The Swiss army knife for the DBA |
| 14:45:00 | Erland Sommarskog | Database Application Development | When Things go Wrong - Error Handling in SQL Server |
| 14:45:00 | Roman Lansky | Business Intelligence | Hitchhiker's Guide to the SSAS Tabular |
| 16:00:00 | Milan Berka | Data Science Machine Learning | Azure Databricks - managed Spark cluster as a service |
| 16:00:00 | Martin Bém | Business Intelligence | Data Modeling for Beginners |
| 16:00:00 | Karol Papaj | Database Application Development | Query profiling options in SQL Server |
| 17:15:00 | Matt Gordon | Data Science Machine Learning | Football Feelings Quantified – Ranking Clubs by Supporter Sentiment |
| 17:15:00 | Grzegorz Stolecki | Business Intelligence | Predictive Reporting Services Performance Monitoring |
| 17:15:00 | Guy Glantser | Database Application Development | The Complete Guide to Temporary Tables and Table Variables |
Event Date: 08-12-2018 - Session time: 09:00:00 - Track: Data Science Machine Learning
The Cogntive services offer here with face, emotion and recommendation three APIs that can help you. How do you best combine these services to get a suggestion for your cocktail?
Event Date: 08-12-2018 - Session time: 09:00:00 - Track: Database Administration Deployment
Some time ago, I accomplished this by hand, wasting hours of my life. Nowadays it takes me a couple of minutes and I'm done.
In this session I will share how you can leverage on ReportingServicesTools PowerShell module to deploy your reports, manage permissions and subscriptions and stop waste your time with some of those trivial tasks.
We will see examples for both Reporting Services and PowerBI Report Server.
Event Date: 08-12-2018 - Session time: 09:00:00 - Track: Database Application Development
In this session we will look at the balance from the Query Processor prospective. We will learn the reasons: how and why does a server choose a parallel or a serial plan. We will learn how to read and interpret parallel plans and look at some important aspects of a parallel plan analysis. After this session you will know what to look at, when the next time you have to deal with parallelism in SQL Server.
Event Date: 08-12-2018 - Session time: 10:15:00 - Track: Business Intelligence
Event Date: 08-12-2018 - Session time: 10:15:00 - Track: Data Science Machine Learning
But... did you know that you can use SQL Server to create powerful machine learning models with Python code and deploy them to your SQL instance? What about building predictive models in R using a SQL Server datasource so you can foresee the future? Well, with SQL Server Machine Learning Services this is possible (and more, much more!).
In this session, I will show you how to prepare your environment to do ML in SQL Server, as well as some cool demos.
Event Date: 08-12-2018 - Session time: 10:15:00 - Track: Database Application Development
This session will show you how to detect and view blocking and lock waits, and understand the cause of it. An extensive walkthrough of the different isolation levels and their respective benefits and drawbacks. And finally a real-world quick list of suggestions on what you can do to solve some of the common issues I come across in my daily work.
Event Date: 08-12-2018 - Session time: 12:15:00 - Track: Database Administration Deployment
Disclaimer: No feline was harmed in the making of this session. Please do not report it to the Pražský spolek ochránců zvířat...
Event Date: 08-12-2018 - Session time: 12:15:00 - Track: Database Application Development
With grouping and ranking functions you can calculate in your query grandtotal, running totals, find islands in intervals, select the last-not-null value, etc. Windows functions apply directly on a set of rows defined by the OVER clause ("a window"). Windows function do not perform aggregation on group level and do not hide row details. So they allow mixing detail and total elements in the same query. The session is mainly based on a copious array of demos, to make explicit every concept introduced taking into account the impact on performances for every solution.
Event Date: 08-12-2018 - Session time: 12:15:00 - Track: Business Intelligence
Event Date: 08-12-2018 - Session time: 13:30:00 - Track: Business Intelligence
Event Date: 08-12-2018 - Session time: 13:30:00 - Track: Database Application Development
But sometimes it doesn't. Sometimes a query takes too much time. You need to find out why, so you can fix it. That's where the execution plan comes in. In the execution plan, SQL Server exposes exactly which steps it took for your query, so you can see why it's slow.
However, execution plans can be daunting to the uninitiated. Especially for complex queries. Where do you even start?
In this session you will learn how to obtain execution plans. and how to start reading and understanding them.
Event Date: 08-12-2018 - Session time: 13:30:00 - Track: Data Science Machine Learning
Event Date: 08-12-2018 - Session time: 14:45:00 - Track: Database Administration Deployment
Event Date: 08-12-2018 - Session time: 14:45:00 - Track: Database Application Development
This presentation starts with a horror show of the many different actions SQL Server can take in case of an error. We will then learn how should deal with this - what we should do and what we should not and that with SET XACT_ABORT we get better consistency. We will learn how TRY-CATCH works in SQL Server, and we will get a recipe for how to write CATCH blocks. More generally, we will learn why it pays off to be simple-minded to survive in this maze. The session mainly looks at traditional T-SQL code, but the session ends with a quick look at natively compiled stored procedures, where everything is different.
Event Date: 08-12-2018 - Session time: 14:45:00 - Track: Business Intelligence
Event Date: 08-12-2018 - Session time: 16:00:00 - Track: Data Science Machine Learning
Event Date: 08-12-2018 - Session time: 16:00:00 - Track: Business Intelligence
Event Date: 08-12-2018 - Session time: 16:00:00 - Track: Database Application Development
The situation in production is a bit complicated. In some cases exploring the plan cache and analyzing Estimated plans can be good enough to fix problematic queries. In other cases we would need to analyze runtime statistics, available in Actual Execution Plans only. In this session we will cover query profiling infrastructure available in SQL Server since SQL Server 2008 (including SQL Server 2019) and query profiling options on global, session and query level.
Event Date: 08-12-2018 - Session time: 17:15:00 - Track: Data Science Machine Learning
Event Date: 08-12-2018 - Session time: 17:15:00 - Track: Business Intelligence
During my session you will learn how to monitor Reporting Services with the Execution Log. I will show the structure of the log and some useful queries to get precise insights into report generating process. Analysing the log gives you a quick way to find bottlenecks and sources of your problems. Especially when you use a tool like Power BI or Excel to create a functional dashboard. You also will learn how to use R powered models in Power BI to predict problems with your reports execution.
Event Date: 08-12-2018 - Session time: 17:15:00 - Track: Database Application Development
The main difference in terms of performance is statistics, which exist for a temporary table, but do not exist for a table variable. For that reason, there can be a huge difference in performance of a stored procedure that uses one data structure or the other. In this session, we will demonstrate the differences and analyze performance for various use cases. We will cover all kinds of ways to work with these data structures, such as OPTION (RECOMPILE) and trace flag 2453. By the end of this session you will know exactly when and how to use each one in order to achieve the desired functionality with the best performance. This is a must session for every SQL Server developer.