Event Date: 15-01-2021 - Session time: 09:00:00 - Track: Power BI
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: 15-01-2021 - Session time: 09:00:00 - Track: Cloud Technology
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.
Event Date: 15-01-2021 - Session time: 09:00:00 - Track: Power BI
I explain these concepts using small datasets that allowing us to perform computation without leveraging the cloud, but please be prepared for some surprises. The presentation uses a single pbix file that will be available for download after the session.
Event Date: 15-01-2021 - Session time: 09:00:00 - Track: Application Database Development
We will provide a good overview of all major facets of Azure DevOps including:
By the end of this session, you will be able to set up your first build and release pipelines and implement CICD in your workplace!
Event Date: 15-01-2021 - Session time: 09:00:00 - Track: Cloud Technology
As an on-prem DBA, chances are that you never had to think twice about which network the database was in, what kind of endpoint was used for the traffic or how the firewall was configured. In Azure, things can get rather complex pretty quickly - especially when working with the platform-as-a-service (PaaS) version of Azure SQL Server. This session will walk you through the basics of networking, explore the concept of virtual networks and firewalls, and explain the use of endpoints - all from the perspective of how they relate to Azure SQL Server. We will be looking at both how the technical components work, and also why one would choose a specific design in favor of another.
Event Date: 15-01-2021 - Session time: 09:00:00 - Track: Lightning Talk
topics across all tracks
John Miner - Don’t lose your integrity Erik Monchen - Use ADF dynamically to orchestrate your data load Reza Rad - The composite model with Analysis Services Gianluca Sartori - Using XESmartTarget to Respond to Extended Events Magnus Ahlkvist - dbatools Live Hackalong Tomaž Kaštrun - Creating data files in Azure Blob storage for on-prem SQL Server
Event Date: 15-01-2021 - Session time: 10:15:00 - Track: Artificial Intelligence Machine Learning
Event Date: 15-01-2021 - Session time: 10:15:00 - Track: Power BI
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: 15-01-2021 - Session time: 10:15:00 - Track: Power BI
In this session you will learn: • What Power BI Premium capacity exactly is, and what is happening 'under the hood'! • How it compares to the regular/shared capacity • How it compares to Azure Analysis Services • How you can govern and manage the capacity • How you can monitor the capacity
Event Date: 15-01-2021 - Session time: 10:15:00 - Track: Application Database Development
Event Date: 15-01-2021 - Session time: 10:15:00 - Track: Cloud Technology
Event Date: 15-01-2021 - Session time: 10:15:00 - Track: Administration
In this session attendees will learn how to record workloads from production instances and replay them either on-prem or on to Azure instances (VMs and managed instances) and compare workload profiles (ie. wait times, time of day), identify bottlenecks and explore SQL tuning techniques. We can show you how to justify modifying VM resources and compare the impact on performance to get the right balance of performance and cost, and also tuning queries to reduce IO or CPU. We will also demonstrate how to replay production workloads in a test/development environment. Ensuring a high accuracy of regression testing in CI/CD.
Event Date: 15-01-2021 - Session time: 11:30:00 - Track: Administration
Join Mohammad Darab this session to explore the cutting-edge technology that SQL Server 2019 has to offer: Big Data Clusters.
Topics include: -Big Data Cluster architecture and its components such as: Containers, Kubernetes and the newly enhanced Polybase -Unique advantage of SQL Server Big Data Clusters -Data Virtualization, Scale-out Data Marts, and Data Hub concepts
Event Date: 15-01-2021 - Session time: 11:30:00 - Track: Power BI
Event Date: 15-01-2021 - Session time: 11:30: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: 15-01-2021 - Session time: 11:30:00 - Track: Cloud Technology
Event Date: 15-01-2021 - Session time: 11:30:00 - Track: Cloud Technology
Event Date: 15-01-2021 - Session time: 11:30:00 - Track: Power BI
In this session I will show you how I build my model documentation external tool and how you can start doing this yourself!
Event Date: 15-01-2021 - Session time: 13:30:00 - Track: Cloud Technology
In dieser Session zeigen wir, welche unterschiedlichen Konzepte es für die Strukturierung eines Data Lakes gibt und wie Sie die verschiedenen theoretischen Ansätze in die Praxis überführen.
Welche Namenskonventionen haben sich etabliert oder sollten vermieden werden. Der Azure Data Lake bietet darüber hianus auch eine gewisse Unterstützung auf der Infrastrukturseite in Form von Richtlinien, die beim Aufbau eines sauberen Data Lakes helfen können.
Taucht mit uns ab in die Tiefen des Azure Data Lakes.
Event Date: 15-01-2021 - Session time: 13:30:00 - Track: Power BI
Event Date: 15-01-2021 - Session time: 13:30:00 - Track: Application Database Development
Then in 2017, Microsoft added wait stats per query plan and Automatic Plan Correction capabilities. Allowing DBAs more tools to troubleshoot fires with and a way to automatically resolve issues.
In this session, we will walk through the features of the Query Store, so you can understand how to use them in SQL Server 2016, 2017, and 2019.
Event Date: 15-01-2021 - Session time: 13:30:00 - Track: Administration
As we walk through this session we will discuss and demo the technologies and tools that are useful for a cloud migration - and we'll review some that are not useful and talk about why they should be avoided. We will also mix in discussions of successful migrations and how the team worked together to move those organizational and political mountains out of the way in order to execute a successful cloud migration to make clients, customers
Event Date: 15-01-2021 - Session time: 13:30:00 - Track: Cloud Technology
Event Date: 15-01-2021 - Session time: 13:30:00 - Track: Power BI
How many Dashboards are there in a workspace? Which Datasource is this Dataset configured to use? Who is allowed to see this Report? Can I take ownership of this Dataset? How do I resfresh my Dataset? Is my Dataset refreshing on a schedule? ... Those are just some of the questions we will find the answers to.
Examples will be provided in Powershell, which may require minute skills up front. Not to worry, a quick intro will be provided as well.
Attending this session will make you familiar with the Power BI REST API and provide you with guidance on how to manage the most common tasks in Power BI.
Event Date: 15-01-2021 - Session time: 14:45:00 - Track: Cloud Technology
Event Date: 15-01-2021 - Session time: 14:45:00 - Track: Administration
Deepthi will show you how the SQL engine thinks – enabling you to think like it!
Event Date: 15-01-2021 - Session time: 14:45:00 - Track: Application Database Development
By subdividing a data set into meaningful groups of islands, we can perform analytics against it that would otherwise be slow, error-prone, or seemingly impossible!
Data clustering can be applied to complex data sets in order to answer questions about winning streaks, financial performance, monitoring/alerting, goal achievement, and more!
Data quality becomes critical when crunching data in this fashion. We address duplicate data, bad data, NULL, and any other unexpected weirdness that a user might throw at us.
This is a fast-paced session that delves into methods that can be applied to any data. A complete set of historical baseball records will be used as our imperfect sample data in order to everything from a player's hitting streak to the longest winning streak by a team on Wednesdays at night.
Event Date: 15-01-2021 - Session time: 14:45:00 - Track: Power BI
We can create functions, re-use funcitons, create loops, everything to turn our data transformations easier. During this session you will see many advanced techniques using M and Power Query
Event Date: 15-01-2021 - Session time: 14:45:00 - Track: Cloud Technology
Event Date: 15-01-2021 - Session time: 14:45:00 - Track: Power BI
Event Date: 15-01-2021 - Session time: 16:00:00 - Track: Power BI
Building Successful Financial Models based of a Chart of Accounts and General Ledger can be difficult for a number of reasons:
Bob will show the “secret sauce” to financial modelling for General Ledger (GL) structures such as Profit and Loss and Balance Sheet.
Event Date: 15-01-2021 - Session time: 16:00:00 - Track: Administration
While there are multiple levels of security (securing data at rest, data in traffic, etc.), this session will focus on securing data that is on the move; ie., securing traffic between a client and server. We'll discuss and look at two solutions: Certificates and IPsec, exploring them in detail, outlining the pros and cons of each, how to set up and configure them, and when to use what.
Event Date: 15-01-2021 - Session time: 16:00:00 - Track: Administration
Event Date: 15-01-2021 - Session time: 16:00:00 - Track: Artificial Intelligence Machine Learning
Event Date: 15-01-2021 - Session time: 16:00:00 - Track: Administration
The lack of rigor in being able to reproduce analysis in business context or to reproduce data troubleshooting can lead to confusion and time wasted on work that had been previously done. With Notebooks, Data Professionals can share their techniques and data sources used for the data analysis or troubleshooting for code review and reproducible insights/troubleshooting.
Azure Data Studio Notebooks support SQL and KQL natively with intellisense; with easy to use charting capabilities. With Notebooks and Jupyter Book (collection of Notebooks) in Azure Data Studio, it’s also easy now for your team to build an onboarding guide (user manual) / documentation on data sources, useful sample scripts and tutorials.
Event Date: 15-01-2021 - Session time: 16:00:00 - Track: Cloud Technology
We need DIY ETL when the easy data sources don't exist, and the usual methods won't work. In this session, we'll take 3 scenarios, solve them and make them reliable, and repeatable, with tools like Power Automate, logic apps, Azure functions and more.