| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:30:00 | Łukasz Bielak | BI Platform Architecture, Development Administration | Processing Large Tabular models with Analysis Services Partition Manager |
| 09:30:00 | Marek Maśko | Application Database Development | Wprowadzenie do SQL Server Data Tools |
| 09:30:00 | Emil Wasilewski | Cloud Application Development Deployment | Life on the Edge |
| 09:30:00 | Tomasz Cieplak | Advanced Analysis Machine Learning | Metody wykrywania anomalii z zastosowaniem sieci LSTM |
| 10:30:00 | Pawel Potasinski | Analytics and Visualization | AI and (Power) BI - Better Together |
| 10:30:00 | Adrian Chodkowski | Application Database Development | Hidden aspects of SQL Server |
| 10:30:00 | Adam Marczak | Cloud Application Development Deployment | Creating data transformation in minutes with no code using Azure Data Factory with Data Flows |
| 10:30:00 | Patryk Miziuła | Advanced Analysis Machine Learning | Uczenie maszynowe – jak zacząć |
| 11:30:00 | Marcin Szeliga | Advanced Analysis Machine Learning | AutoML at scale |
| 11:30:00 | Tomasz Waloszek | BI Platform Architecture, Development Administration | Best Practices in SSIS |
| 11:30:00 | Sławomir Drzymała | Application Database Development | Docker for data amateur |
| 11:30:00 | Hubert Kobierzewski | Analytics and Visualization | Mój własny wykres w Power BI |
| 13:15:00 | Rafał Suchorski | Enterprise Database Administration Deployment | Statystyki danych - czy to jest istotne? |
| 13:15:00 | Bartosz Ratajczyk | Application Database Development | How does the recursive CTE work? |
| 13:15:00 | Michał Ćwiok | Analytics and Visualization | Zaawansowane obchodzenie ograniczneń w Power BI. Komentarze do danych w real-time w bankingu. |
| 13:15:00 | Jakub Wawrzyniak | BI Platform Architecture, Development Administration | PowerBI Embedded: powerful analytics in your application |
| 14:15:00 | Jose Manuel Jurado Diaz | Cloud Application Development Deployment | How to get the most from Azure SQL Database |
| 14:15:00 | Kevin Chant | Enterprise Database Administration Deployment | Database Adventure |
| 14:15:00 | Tomasz Gołaszewski | Advanced Analysis Machine Learning | DAX Filter Context |
| 14:15:00 | Damian Widera | BI Platform Architecture, Development Administration | Query optimization on steroids with SQL Server 2017/2019 |
| 15:15:00 | Natalia Świtalska | Application Database Development | Non-relational faces of SQL |
| 15:15:00 | Grzegorz Stolecki | Analytics and Visualization | How to quickly cook a brand new visual for Power BI |
| 15:15:00 | Andrzej Pyskir | Advanced Analysis Machine Learning | Czy można nauczyć komputer znajdować budynki na zdjęciach satelitarnych? |
| 15:15:00 | Lukasz Kaluzny | Enterprise Database Administration Deployment | Availability Groups on Kubernetes in SQL Server 2019 |
Event Date: 28-09-2019 - Session time: 09:30:00 - Track: BI Platform Architecture, Development Administration
Session in Polish.
Event Date: 28-09-2019 - Session time: 09:30:00 - Track: Application Database Development
Na tej sesji dowiesz się jakie funkcjonalności dostarcza SSDT, jak stworzyć nowy projekt bazodanowy zawierający model bazy danych, jak za jego pomocą wgrać zmiany na serwer bazodanowy oraz jak porównać istniejącą bazę z wzorcowym modelem.
Event Date: 28-09-2019 - Session time: 09:30:00 - Track: Cloud Application Development Deployment
Event Date: 28-09-2019 - Session time: 09:30:00 - Track: Advanced Analysis Machine Learning
Event Date: 28-09-2019 - Session time: 10:30:00 - Track: Analytics and Visualization
Event Date: 28-09-2019 - Session time: 10:30:00 - Track: Application Database Development
Event Date: 28-09-2019 - Session time: 10:30:00 - Track: Cloud Application Development Deployment
This is also natural migration path for those working with SSIS.
Event Date: 28-09-2019 - Session time: 10:30:00 - Track: Advanced Analysis Machine Learning
Event Date: 28-09-2019 - Session time: 11:30:00 - Track: Advanced Analysis Machine Learning
Existing automated machine learning (AutoML) techniques have been remarkably successful in identifying good parameters for a given model, sometimes even outperforming humans. However, these options either take too long to train or they work for only a handful of parameters. That’s why Azure Machine Learning uses probabilistic latent variable model to work with DNNs without needing to fully train them. Azure Machine Learning Services (AML) provides a cloud-based environment you can use to develop, train, test, deploy, manage, and track machine learning models. AutoML in the cloud will soon become mainstream.
Event Date: 28-09-2019 - Session time: 11:30:00 - Track: BI Platform Architecture, Development Administration
One of the most important features of SSIS is flexibility, which is also one of the most common failures. In this session you will learn what are the good practices of creating SSIS packages. How to handle errors, what to do to make our SSIS work quickly and efficiently.
Event Date: 28-09-2019 - Session time: 11:30:00 - Track: Application Database Development
I will show you my journey, my thoughts and my findings regarding the usage of SQL Server and Python together with Docker. And there will be a lot, a lot of demos.
Event Date: 28-09-2019 - Session time: 11:30:00 - Track: Analytics and Visualization
Event Date: 28-09-2019 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment
Sesja pomyślana tak, by ilość slajdów ograniczyć do minimum i jak najwięcej czasu poświęcić na dema. Oczywiście będzie odrobina teorii, ale przede wszystkich będziemy statystyki tworzyć, kasować, aktualizować na różne sposoby. Spróbujemy też czytać je tak jak robi to Optymalizator Zapytań. Zobaczymy też różnice, jakie zaszły w interpretacji oraz mechanizmach aktualizujacych statystyki wraz z wprowadzeniem SQL Server 2014 i 2017. A na koniec przeniesiemy statystyki bazy produkcyjnej do bazy testowej.
Event Date: 28-09-2019 - Session time: 13:15:00 - Track: Application Database Development
If you want to know how does recursive CTE work internally, want to know more about non-blocking, blocking and semi-blocking query plan operators, want to familiarise yourself with the spools, asserts, compute scalars - come to this session. I will analyse the whole query plan flow, describe the internals of the used operators and show you other situations where they are useful (or not).
Event Date: 28-09-2019 - Session time: 13:15:00 - Track: Analytics and Visualization
Event Date: 28-09-2019 - Session time: 13:15:00 - Track: BI Platform Architecture, Development Administration
Based on selected case studies, I will show you step by step on how to add data visualizations and interactive reports to your application.
Event Date: 28-09-2019 - Session time: 14:15:00 - Track: Cloud Application Development Deployment
We will learn how to monitor the performance of our workload, how to improve it and how to secure it using the tools and features at our disposal on the Azure portal without having to install 3rd party tools. We will also see some ways to lower the costs or increase performance without having to also increase costs.
Event Date: 28-09-2019 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment
Each selection will have a different outcome, and along the way you will probably learn some new things.
Event Date: 28-09-2019 - Session time: 14:15:00 - Track: Advanced Analysis Machine Learning
Basing on queries and visualizations, playing with PowerBI and DAX studio, we will see rules and examples, trying to understand how engine works and how sees what is coded in our calculations.
Event Date: 28-09-2019 - Session time: 14:15:00 - Track: BI Platform Architecture, Development Administration
SQL Server 2019 has a lot more important features like =batch mode on rowstore, memory grant feedback, interleaved execution, adaptative joins, deferred compilation and approximate query processing. So now we have entered the Intelligent Query Processing world!.
I would like to present both the AQP and IQP to show what you can expect in the nearest future and how these features help your queries running faster
Event Date: 28-09-2019 - Session time: 15:15:00 - Track: Application Database Development
Event Date: 28-09-2019 - Session time: 15:15:00 - Track: Analytics and Visualization
Event Date: 28-09-2019 - Session time: 15:15:00 - Track: Advanced Analysis Machine Learning
Event Date: 28-09-2019 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment