| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:10:00 | Oskari Heikkinen | BI Platform Architecture, Development Administration | Best Practices for building a Data Lake with Azure Databricks |
| 09:10:00 | Juan E. Moreno Romo | Database Administration Deployment | Monitoring SQL Server: from on-premises to Azure |
| 09:10:00 | Asgeir Gunnarsson | Other | Checking in with Power Apps, Flow and Power BI |
| 10:30:00 | Magnus Ahlkvist | Database Administration Deployment | My romantic relation with Powershell generally and DBATools especially |
| 10:30:00 | Benni De Jagere | BI Platform Architecture, Development Administration | Power BI Dataflows? Why you need to implement it! |
| 10:30:00 | Damir Matesic | Application Database Development | MS SQL New functions, syntaxes, tips tricks |
| 11:45:00 | Jens Vestergaard | Advanced Analysis Techniques | Power BI Live Data sets, Monitoring your key metrics |
| 11:45:00 | Erland Sommarskog | Application Database Development | Dynamic Search Conditions |
| 11:45:00 | Torsten Strauss | Database Administration Deployment | Detect Plan Regression with Query Store |
| 13:45:00 | Ted Malone | BI Platform Architecture, Development Administration | Creating Scalable Data Pipelines with Azure Data Factory and Data Flows |
| 13:45:00 | Kevin Chant | Application Database Development | Azure DevOps duet (60 minutes version) |
| 13:45:00 | Dennes Torres | Advanced Analysis Techniques | Why Synapse Analytics is beyond Azure SQL Datawarehouse |
| 15:00:00 | Brent Ozar | Database Administration Deployment | What's New in SQL Server 2019: 100% Demos |
| 15:00:00 | Philipp Lenz | Application Database Development | Introduction into Power BI Embedded |
| 15:00:00 | Alexander Klein | BI Platform Architecture, Development Administration | BI in Azure two years live |
Event Date: 05-09-2020 - Session time: 09:10:00 - Track: BI Platform Architecture, Development Administration
Event Date: 05-09-2020 - Session time: 09:10:00 - Track: Database Administration Deployment
In this session we will show you the tools and techniques you could use to monitor your SQL Server environment, nevertheless where it is located on-premises or in Azure. We will go through DMVs, Wait Stats, Performance Counters, Extended Events, Query Data Store, Management Studio, Azure Portal, SQL Azure Diagnostics, SQL Auditing and more... We want to share with you what we have learnt from support cases and how we, Microsoft CSS, use these tools to help customers monitor and improve the performance of their SQL Server environments.
Event Date: 05-09-2020 - Session time: 09:10:00 - Track: Other
Power Apps is a great tool that allows you to create a desktop or mobile app with minimal coding. The app we are creating in this session uses the Bing location services to get the users location when a button is pressed. The Power Automate flow we create in this session will take the location and user information and write it to an Excel file. We will also look at the Power BI connector in Power Automate that will allow us to refresh a Power BI data set. In the Power BI report we will create, we will connect to an Excel file with the location information in it and display it in a report including the location on a map.
The audience will take away useful information about Power Apps, Flow and Power BI including
Event Date: 05-09-2020 - Session time: 10:30:00 - Track: Database Administration Deployment
In this session, I will demo some of the reasons I really love Powershell and DBATools. I will cover a brief overview of DBATools and then jump into some scenarios where DBATools really helped me, including:
Event Date: 05-09-2020 - Session time: 10:30:00 - Track: BI Platform Architecture, Development Administration
During this session, the core concepts of Power BI Dataflows will be explained, and we'll discuss how Power BI Dataflows could alleviate some of the specific problems you might be experiencing in your current architecture.
How this feature ties into some other cool concepts, like Azure Data Lake Storage Gen2 or the Common Data Model, obviously can't be missing from this speech.
Expect to walk out of this session with a decent grasp on the underlying architecture, and some key takeaways to take home with you.
Event Date: 05-09-2020 - Session time: 10:30:00 - Track: Application Database Development
Accompanied with multiple examples, this session will show you many interesting topics.
Event Date: 05-09-2020 - Session time: 11:45:00 - Track: Advanced Analysis Techniques
Differences between pushing, streaming and PubNub streaming will be explained and we will dive deep into each of the three methods. Join this session so learn how to get live data into your PowerBI service. The session will be covering basic entry to best practices.
Event Date: 05-09-2020 - Session time: 11:45:00 - Track: Application Database Development
Event Date: 05-09-2020 - Session time: 11:45:00 - Track: Database Administration Deployment
In this session, you will learn how Query Store works internally and to interpret the available reports to detect plan regression caused by parameter sniffing and by the new cardinality estimator.
Event Date: 05-09-2020 - Session time: 13:45:00 - Track: BI Platform Architecture, Development Administration
This session will be a mix of discussion and demo, and attendees will come away with a solid understanding of how these data pipelines are architected and built.
Event Date: 05-09-2020 - Session time: 13:45:00 - Track: Application Database Development
This session will cover the process of developing a CI/CD process starting at getting the team on board and ending with making an actual release.
We will discuss
After this session you will have the tools and knowledge to get started with DevOps and get your development process to the next level.
Event Date: 05-09-2020 - Session time: 13:45:00 - Track: Advanced Analysis Techniques
Event Date: 05-09-2020 - Session time: 15:00:00 - Track: Database Administration Deployment
I'm Brent Ozar, and I'll give you the whirlwind tour. I'll focus on just the features that make the biggest bang for the buck, things you can implement right away and see a noticeable difference. I'll show you what kinds of code will benefit the most so you can go back to the office and have an honest discussion with management about what to expect.
No slides here - not even an about-me slide. Let's dive into some queries!
Event Date: 05-09-2020 - Session time: 15:00:00 - Track: Application Database Development
Event Date: 05-09-2020 - Session time: 15:00:00 - Track: BI Platform Architecture, Development Administration
Which architecture is the right one? Which tools/services should I use ( Azure Data Factory V1 or V2, Azure Stream Analytics, Logic Apps, Azure Functions, Azure SQL DB, Azure SQL DW, Azure Analysis Service, Azure Data Lake, Power BI, Azure Databricks ...) ? What was good and what wasn't so good? What do you have to pay attention to? What can you possibly do better in the next project?
Alexander Klein will answer all these questions and more in this presentation.