| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:10:00 | Asgeir Gunnarsson | BI Platform Architecture, Development Administration | Who, What, When. Monitoring usage of your MS BI stack |
| 09:10:00 | Alexander Klein | Cloud Application Development Deployment | Bringing AI to the edge - Azure Cognitive Services in docker containers |
| 09:10:00 | Lord Richard Douglas | Enterprise Database Administration Deployment | Managing Memory for Optimal Performance |
| 10:30:00 | Philipp Lenz | BI Platform Architecture, Development Administration | Microsoft Power BI Deployment Types |
| 10:30:00 | Bartosz Ratajczyk | Enterprise Database Administration Deployment | First steps with SQL Server on Docker |
| 10:30:00 | Daniel Hutmacher | Enterprise Database Administration Deployment | Getting your ducks in a row - Understanding ordered data flows |
| 11:45:00 | Magnus Ahlkvist | Application Database Development | It depends - don't mistake your Google search for my database knowledge |
| 11:45:00 | Jose Manuel Jurado Diaz | Cloud Application Development Deployment | Azure SQL Database - Lessons learned from the trenches |
| 11:45:00 | Mark Broadbent | Enterprise Database Administration Deployment | SQL Server Availability Groups for dummies |
| 11:45:00 | Pau Sempere | BI Platform Architecture, Development Administration | Churn Norris: Retain your customers with Machine Learning |
| 13:45:00 | Kalen Delaney | Enterprise Database Administration Deployment | What the Hekaton?! |
| 13:45:00 | Erland Sommarskog | Application Database Development | Don't Bite Off More Than You Can Chew - Take It in Chunks |
| 15:00:00 | Anton Boyko | Cloud Application Development Deployment | The future of serverless computing |
| 15:00:00 | Ted Malone | BI Platform Architecture, Development Administration | Construct Visual Data Flows by using Azure Data Factory |
| 15:00:00 | Damian Widera | Application Database Development | AQP vs IQP - query optimization on steroids |
| 16:10:00 | Aleksandar Talev | Enterprise Database Administration Deployment | How to choose the right data model: SQL Server or Azure Cosmos DB. Which, When and Where ? |
| 16:10:00 | Hugo Kornelis | Application Database Development | From adaptive to intelligent: query processing in SQL 2019 |
| 16:10:00 | Kamil Nowinski | BI Platform Architecture, Development Administration | Move part of your body to Azure SQL Data Warehouse |
Event Date: 14-09-2019 - Session time: 09:10:00 - Track: BI Platform Architecture, Development Administration
We will talk about how to collect the data, how to build something meaningful from the data and how you can report on top of the data. We will do this for SSAS cubes (tabular and multidimensional), for Power BI reports and for Reporting Services Reports and we will explore ways you can further develop this for your own organization.
At the end of the session all participants will leave with all the code as well as the know how to get started with the collection of usage statistics for their Microsoft BI Solutions.
Event Date: 14-09-2019 - Session time: 09:10:00 - Track: Cloud Application Development Deployment
How can you use these API's if you don't want to send your data to an Azure Data Center? Not every data set should leave your company. That's why Microsoft now offers the whole thing as a docker image, which you can run on your own hardware. As a company, you regain control over your data.
Event Date: 14-09-2019 - Session time: 09:10:00 - Track: Enterprise Database Administration Deployment
In this session, you will learn how SQL Server uses memory and various caches, how to gauge memory pressure, and how to address the significant problems it can cause. You will leave with a much clearer understanding of how to monitor and manage memory consumption within SQL Server using native Dynamic Management Objects.
Event Date: 14-09-2019 - Session time: 10:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 14-09-2019 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment
Join me in the session where I will introduce you to the Docker containers world. You will see their phenomena and will take a look at how you can start using them in your work. During the hour we will start from the beginnings, through use cases, to configuring custom SQL Server environment within minutes and starting it in seconds. We will focus on SQL Server, but also take a look at the other applications.
Event Date: 14-09-2019 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment
But let's take a step back and understand the one fundamental principle of querying data - ordering. This session is all about interactively and visually explaining the flow of data in terms of ordering, and how that affects the performance of your queries and server.
Once you get these basics right, tuning will feel so much easier and execution plans may even start to appear quite intuitive.
Event Date: 14-09-2019 - Session time: 11:45:00 - Track: Application Database Development
My powerpoints usually look terrible, so I will focus on T-SQL and execution plans.
Event Date: 14-09-2019 - Session time: 11:45:00 - Track: Cloud Application Development Deployment
Event Date: 14-09-2019 - Session time: 11:45:00 - Track: Enterprise Database Administration Deployment
In this session, we will explain how to plan for, deploy, and manage Availability Groups from the ground up in easy to understand examples and demos.
We will cover both Basic Availability Groups (BAGs) and full deployments, and also cover their use in Windows and Linux environments as well as look at the new SQL Server 2019 availability group support on containers in a Kubernetes cluster.
If you want to finally get to grips with SQL Server Always On Availability Groups, then this is the session for you!
Event Date: 14-09-2019 - Session time: 11:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 14-09-2019 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 14-09-2019 - Session time: 13:45:00 - Track: Application Database Development
You can solve this by operating on the data in chunks. Implementing chunking is not that difficult, but there are still pitfalls you can run into. In this session, I will discuss in what situations you may want to use chunking. I will give some best practices for how to implement chunking for good performance and I will highlight some things you need keep in mind, for instance, recovering from interruptions.
I will also look at how you can use chunking for error handling: You want process many rows and you want the good rows to succeed even if some rows yield errors - something you cannot do in a single set-based statement.
Event Date: 14-09-2019 - Session time: 15:00:00 - Track: Cloud Application Development Deployment
In my session I will talk about the current state and the future of serverless computing. I will show several demos that show how to start using serverless computing, what are the application scenarios for it, how it can scale, what it will cost, etc.
This session will be useful for developers and architects who are seeking a way to create an app utilizing all your previous skills, but make it scalable, reliable, fast and cost efficient.
Event Date: 14-09-2019 - Session time: 15:00:00 - Track: BI Platform Architecture, Development Administration
In this session, attendees will be introduced to Azure Data Factory Mapping Dataflows, which allows users to develop comprehensive data pipelines using a graphical interface. These pipelines are executed in Azure Databricks, which provides a very efficient Spark-based execution context. Attendees will learn how to effectively build visual pipelines using common transformations, and will learn how to monitor and debug ETL and ELT pipelines by using Azure Data Factory.
Event Date: 14-09-2019 - Session time: 15:00:00 - Track: Application Database Development
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: 14-09-2019 - Session time: 16:10:00 - Track: Enterprise Database Administration Deployment
Event Date: 14-09-2019 - Session time: 16:10:00 - Track: Application Database Development
In this high-paced session, we will look at all these features and cover some use cases where they might help - or hurt! - you.
Event Date: 14-09-2019 - Session time: 16:10:00 - Track: BI Platform Architecture, Development Administration
Even if not today, certainly in the future (yes, believe me) you will face a case: how to move my data from on-premise Data Warehouse to Azure. This session will reveal the ideas of how to do that, how to recognise if you are ready, what the best practices are and other important things we should be aware of. I will describe potential issues and give you hints on how to avoid them. Finally, I will present one tool that can help you in preparation and also we will see what speed we can achieve during a migration.