|Start Time (24h)||Speaker||Track||Title|
|09:00:00||Nikola Ilic||YELLOW||From XL to S - Reduce your Power BI model size by 90%!|
|09:00:00||Oliver Engels||RED||Common Data Model - Our new buddy for Data Governance|
|09:00:00||Dean Savović||BLUE||SQL Server Intelligent Query Processing|
|10:15:00||Gilberto Zampatti||BLUE||Performance Monitoring in SQL Server 2019|
|10:15:00||Erland Sommarskog||RED||When Things go Wrong - Error Handling in SQL Server|
|10:15:00||Wolfgang Strasser||YELLOW||Connect your data artifacts with Azure Synapse Analytics|
|11:30:00||Boriana Petrova||YELLOW||Working with parameters in Power Query|
|11:30:00||Gianluca Sartori||BLUE||Baking Extended Events recipes without breaking a sweat|
|11:30:00||Mark Broadbent||RED||2 Fast 2 Furious - designing for speed, concurrency, and correctness|
|13:00:00||Pedro Reis||YELLOW||"DAX" the way to do it|
|13:00:00||Erwin De Kreuk||BLUE||Azure Key Vault, Azure Dev Ops and Data Factory how do these Azur|
|13:00:00||Gabi Münster||RED||Azure Synapse Analytics - Early Lessons learned|
|14:15:00||Javier Villegas||RED||The Evolution of SQL Server as a Service - Azure SQL Database Managed Instance|
|14:15:00||Benni De Jagere||YELLOW||Designing impactful visualisations for your data|
|14:15:00||Björn Peters||BLUE||Change your skills - from an onpremise DBA to a cloud DBA|
|15:30:00||Uwe Ricken||RED||Why Partitioning can boost your data management|
|15:30:00||Thomas Hütter||BLUE||Poor man's SQL Server job monitoring with R|
|15:30:00||Just Blindbaek||YELLOW||The Hitchhiker's Guide to navigating Power BI|
|16:45:00||Hugo Kornelis||BLUE||Debugging without debugger: investigating SQL Server’s internal structures|
|16:45:00||Paul Turley||RED||Data Modeling Solutions for Challenging BI Data Modeling Problems|
|16:45:00||Cédric Charlier||YELLOW||Automating the testing of your BI solutions with NBi|
Event Date: 12-12-2020 - Session time: 09:00:00 - Track: YELLOW
In this session, we will dig deep to discover what is “under the hood” of Power BI, how your data is being stored, compressed, queried, and finally, brought back to your report. After the session, you will get a better understanding of the hard work happening in the background and appreciate the importance of creating an optimal data model in order to get maximum performance from the Power BI engine.
Finally, you will see a real use-case demo showing how the Power BI data model was reduced by 90%!
Event Date: 12-12-2020 - Session time: 09:00:00 - Track: RED
Event Date: 12-12-2020 - Session time: 09:00:00 - Track: BLUE
Event Date: 12-12-2020 - Session time: 10:15:00 - Track: BLUE
efficiency of our monitoring and tuning. This session will show some new object (DMO) introduced in the new platform and a couple of new options that can change our approach to the monitoring, maintenance and tuning activity.
Event Date: 12-12-2020 - Session time: 10:15:00 - Track: RED
The session presents a recipe for writing CATCH block where focus is on keeping things simple and you will learn why it is not a good idea to make your error handling "fancy", although it may seem to be a good idea in theory. The session also covers a few things to think of on client level.
Event Date: 12-12-2020 - Session time: 10:15:00 - Track: YELLOW
Join this session, if you want to hear about the building blocks of Azure Synapse Analytics, how Data Engineers and Data Scientists and even BI developer can work together in a single service and see how easy it is to start with Synapse Analytics!
Event Date: 12-12-2020 - Session time: 11:30:00 - Track: YELLOW
Event Date: 12-12-2020 - Session time: 11:30:00 - Track: BLUE
Fear not: in this demo intensive session I will show you how to tackle the most challenging tasks without writing a single line of code. I will use the open-source tool XESmartTarget to audit logins, find unused objects, capture and notify deadlocks and much more. Stop doing things the hard way! Join me and learn how XESmartTarget can do all the heavy lifting for you.
Event Date: 12-12-2020 - Session time: 11:30:00 - Track: RED
In this session, we will reveal how SQL Server concurrency and correctness often goes wrong, how we can avoid this, and how we can use our knowledge to design and develop for optimal server throughput for our applications and processes using tips and tricks gained from real-world scenarios.
We will cover SQL Server’s traditional locking model, In-Memory OLTP, Columnstore, Delayed Durability, and many other technologies and techniques you can use to make your transactions more robust.
Event Date: 12-12-2020 - Session time: 13:00:00 - Track: YELLOW
No more hundreds of columns and weird aggregations in the database. With the Power of DAX, you can now achieve much more sophisticated and powerful calculations, while keeping it simple at its core. I'll show you real-world applications of DAX and lots of tips and tricks that you will be able to use quickly and with little effort!
Event Date: 12-12-2020 - Session time: 13:00:00 - Track: BLUE
But how can we achieve this in ADF? And finally how do we deploy our DataFactories in Azure Dev Ops to Test, Acceptance and Production environments with these Secrets ? Can this be setup dynamically? During this session I will give answers on all of these questions. You will learn how to setup your Azure Key Vault, connect these secrets in ADF and finally deploy these secrets dynamically in Azure Dev Ops. As you can see a lot to talk about during this session.
Event Date: 12-12-2020 - Session time: 13:00:00 - Track: RED
Event Date: 12-12-2020 - Session time: 14:15:00 - Track: RED
Event Date: 12-12-2020 - Session time: 14:15:00 - Track: YELLOW
During this session, we'll go through some steps on how to maximise the potential of data visualisations. Starting at choosing the right types of visualisations, and which colour palettes are good matches for your message, we'll also make sure that our designs are as inclusive as we can possibly make them. Wrapping up with a few common use cases, you’ll definitely pick up a few new things to take home with you.
Walking out of this session, you can expect to have a decent understanding on a few common design principles for your data visualisations and reports.
Event Date: 12-12-2020 - Session time: 14:15:00 - Track: BLUE
Event Date: 12-12-2020 - Session time: 15:30:00 - Track: RED
The main area of application for partitioning is the optimization of load paths for complex DWH solutions and maintenance of large databases (statistics, indexes, backup, restore).After a brief introduction to partitioning, this session will focus on the key benefits of the above topics
Event Date: 12-12-2020 - Session time: 15:30:00 - Track: BLUE
This session is for DBAs and R newbies alike: In one hour we'll develop a dashboard-like overview of your agent jobs' and their durations with the R language.
We'll work our way from finding the right system tables to use, generating one graph per job with the help of R, to adding that little trend line to every one of them. After creating it in RStudio, we'll eventually adapt our script to run in SSMS/ADS just as fine. Once finished, no additional tools are needed, no additional €€ spent.
Event Date: 12-12-2020 - Session time: 15:30:00 - Track: YELLOW
This session will cover all the options we have to change and setup navigation on three different levels. (1) Inside Reports, (2) between Reports in an App and finally (3) the Power BI Web Portal to help users finding the Apps and Reports. You will be amazed how much actually can be done, to give your users a better experience.
We will cover topics like, Power BI Service navigation, Linking from an Intranet, Setting up Dashboards, The new App navigation, Drillthrough, Buttons, Bookmarks and much more.
Event Date: 12-12-2020 - Session time: 16:45:00 - Track: BLUE
But you might still WANT to know. I did. And I figured it out. Without ever touching the debugger (I’m a simple soul, that stuff is much too complex for me!), I figured out how I could look at the exact storage structures SQL Server creates and uses to store data in Table Spool and Index Spool operators. If you are willing to commit to a fast-paced and deep internals session that is guaranteed to teach you exactly zero actually useful information, then this is the session for you.
Event Date: 12-12-2020 - Session time: 16:45:00 - Track: RED
Event Date: 12-12-2020 - Session time: 16:45:00 - Track: YELLOW