| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:15:00 | Denny Cherry | Application Database Development | Table Indexing for the .NET Developer |
| 08:15:00 | Vedran Kesegic | Enterprise Database Administration Deployment | Logging Actual execution plans in SQL 2017 and 2019 |
| 08:15:00 | Mihail Mateev | Cloud Application Development Deployment | Creating Custom BI Solutions with Power BI Embedded |
| 09:30:00 | Catalin Gheorghiu | Cloud Application Development Deployment | “SQL-like” or query languages in Azure IoT |
| 09:30:00 | Sebastiano Galazzo | Analytics and Visualization | Creating a photorealistic avatar using generative adversarial net |
| 09:30:00 | Magnus Ahlkvist | Application Database Development | Statistics, an unreliable friend. |
| 10:45:00 | Gianluca Sartori | Enterprise Database Administration Deployment | Monitoring SQL Server without breaking the bank |
| 10:45:00 | Nicky van Vroenhoven | Analytics and Visualization | Query Folding in Power BI |
| 10:45:00 | Aleksandar Talev | Enterprise Database Administration Deployment | Implementing security in Azure Data Platform Solutions |
| 12:00:00 | Nikola Ilic | BI Platform Architecture, Development Administration | Magnificent 7 - Simple tricks to boost your Power BI development |
| 12:00:00 | John Martin | Enterprise Database Administration Deployment | Performance Tuning with SQLDiag, the best free tool you never knew you had. |
| 13:45:00 | Tomaž Kaštrun | BI Information Delivery | Useful DAX and Power BI examples for everyday usage |
| 13:45:00 | Miloš Radivojević | Professional Development | Transact-SQL Performance Tips |
| 13:45:00 | Dejan Sarka | Analytics and Visualization | Data Science in Power BI Desktop |
| 15:00:00 | Gergely Csom | BI Platform Architecture, Development Administration | Building a modern data warehouse and BI solution in Microsoft cloud |
| 15:00:00 | Torsten Strauss | Enterprise Database Administration Deployment | Wait Statistics |
| 15:00:00 | Rudi Bruchez | Cloud Application Development Deployment | Diagnosing performance problems on Azure SQL |
Event Date: 19-09-2020 - Session time: 08:15:00 - Track: Application Database Development
Event Date: 19-09-2020 - Session time: 08:15:00 - Track: Enterprise Database Administration Deployment
Now it also includes wait statistics, logical reads, and actual row numbers for that execution. But there is a catch - it is traditionally very expensive to track plans for all executions, even if we filter for only slow ones. We will see how new versions of SQL Server evolved to get us actual plans without sacrificing performance. Let me introduce you to "Lightweight profiling" you can have enabled all the time on your server, with close to zero impact.
Event Date: 19-09-2020 - Session time: 08:15:00 - Track: Cloud Application Development Deployment
Microsoft Power BI Embedded helps Independent Software Vendors to use Power BI data experiences within their applications. Customers, who use applications with Power BI Embedded don’t need to have a Power BI account or to know anything about this Azure service. This talk is a practical session on Microsoft Power BI Embedded concept with many examples how to create custom BI solutions using this technology.
Event Date: 19-09-2020 - Session time: 09:30:00 - Track: Cloud Application Development Deployment
In this presentation we will explore Azure IoT places where queries are used and see how to use them. And in the process to find out more about this “SQL-like” languages and how being a DB developer cam make you a IoT hero. We will concentrate on the scenarios with the greatest impact, where a little SQL can solve you a lot of hassle. So, we will leave no SQL query unturned in Azure IoT Hub, Stream Analytics, Power Bi to name a few.
Event Date: 19-09-2020 - Session time: 09:30:00 - Track: Analytics and Visualization
Focusing on autoencoders, will be journey from the biginning (Of the speaker experience), mistakes and tips learned along the path showcasing several convolution flows. https://www.youtube.com/watch?v=pJ7VmOOMy4kfeature=youtu.be
Event Date: 19-09-2020 - Session time: 09:30:00 - Track: Application Database Development
Join me on some head-ache, a dive into statistics histograms, fun with flags and a praise to the evolution of SQL Server optimizer. Much of this session is about the "ascending key problem", and how Microsoft have made shanges to the SQL Server optimizer to improve, but not completely eliminate the problem.
Event Date: 19-09-2020 - Session time: 10:45:00 - Track: Enterprise Database Administration Deployment
In this session we will combine multiple open source tools (InfluxDB, Telegraf , Grafana, DbaTools and many more) to collect important performance metrics, analyze the data they collect, set up alerts for the critical events, troubleshoot issues and plan for the future. Join me and you will see how monitoring is not a business for billionaires.
Event Date: 19-09-2020 - Session time: 10:45:00 - Track: Analytics and Visualization
Query folding is important because it offloads data transformations to the source, instead of performing them in Power BI. Attend this session to learn how to ensure that you get all the performance improvements possible within your reports! As a bonus, you will also learn in which cases query folding is not your best friend.
Event Date: 19-09-2020 - Session time: 10:45:00 - Track: Enterprise Database Administration Deployment
In this presentation, attendees will see how Azure provides a multi-layered security model to protect customer data. I will show how security can range from setting up secure networks and access keys, to defining permission and to monitoring with Advanced Threat Detection across a range of data stores.
Event Date: 19-09-2020 - Session time: 12:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 19-09-2020 - Session time: 12:00:00 - Track: Enterprise Database Administration Deployment
SQLDiag installs with SQL Server and is capable of coordinating the capture of trace data, perfmon data, and log files for you. Sounds great, "how do I use it?" I hear you ask.
In this session we will look at how to setup and run a data capture against SQL Server. We will then look at how to process the captured data into a format that we can use to troubleshoot performance problems. I will also showcase a number of additional tools such as Diag Manager, PAL, and Relog to help make sense of the data captured.
By the end of this session you will be in a position to start using SQLDiag to perform data catpure and have the toolset to process it to solve performance problems with your SQL Server systems.
Event Date: 19-09-2020 - Session time: 13:45:00 - Track: BI Information Delivery
Event Date: 19-09-2020 - Session time: 13:45:00 - Track: Professional Development
Pokrićemo tipične greške koje programeri tom prilikom prave zbog nedovoljnog poznavanja funkcionisanja database engina.
Razume se, podelićemo savete u vezi sa pisanjem upita koji će svakako pomoći da se izbegnu tipične i najčešće greške u svakodnevnom radu sa SQL Serverom, a i elaboriraćemo šta bi to svaki programer trebalo da zna o SQL Serveru.
Session level: 200 - 300
Event Date: 19-09-2020 - Session time: 13:45:00 - Track: Analytics and Visualization
Event Date: 19-09-2020 - Session time: 15:00:00 - Track: BI Platform Architecture, Development Administration
Which ETL tool should I use? Data factory v2 with SSIS and BIML, or Azure Databricks powered Dataflows? Or Power BI Dataflow? Which is the right decision to run OLAP workloads? Azure AS? Or simply Power BI? When do I need Azure SQL DWH? In the last couple years I helped many customers to modernize their DWH landscape partially or fully in the cloud and during my presentation I will share my findings and recipes for the most common situation I met. You will have fun:)
Event Date: 19-09-2020 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment
In this session you will learn this understanding to identify common performance issues and find solutions to solve them.
Event Date: 19-09-2020 - Session time: 15:00:00 - Track: Cloud Application Development Deployment