Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type



Sessions Found: 29
This is a live demo session that demonstrates the Microsoft Power Platform of products working together to create an interactive data application.

It's good to have some form of interactivity in your presentation. Whether it's by (live) polling your audience, telling a story, asking questions during your presentation or any other way to make your presentation more interactive, doesn't really matter.
The way I started doing this was by firing some questions at the audience after I introduced myself. Although that worked pretty well, I was asking closed questions with a show of hands. 
But as I work with the Power Platform suite of products I thought it was a good idea to use some of that Power! In this session I will show you:
- Create a form with Microsoft Forms,
- Create a Power Automate flow to get the answers,
- Push them into a Power BI streaming dataset,
- And finally create a Power BI report and dashboard on that dataset to get a live view of the answers of the audience.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Power BI

Level: Intermedia

Session Code:

Date: September 26

Time: 9:30 AM - 10:30 AM

Room: Power BI

Azure Databricks has been around for a while now, and Apache Spark since 2012. You've watched a couple of demos, got a brief overview of what Databricks does and you've got a rough idea of where it fits in… but where do you go from there?

This session is that next stop. We'll start by taking a deeper look inside the spark engine, understanding what makes it tick and how it talks to data. We'll then break down some of the key features that come together to build the kind of data processing task that's changing how we think about ETL.

We'll be looking at:
 - RDDs & How data is stored
 - Schema Inference
 - Storing Metadata
 - Parameters in Notebooks
 - Integration with Data Factory

Each of these features comes together to build a single, generic notebook that can validate the rows within a dataset that meet a specific structure, and it's all driven by metadata!

We'll be doing everything in python, so a light familiarity will help but is not mandatory
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Azure BI

Level: Advanced

Session Code:

Date: September 26

Time: 3:45 PM - 4:45 PM

Room: Azure BI

SQL Server is a high frequently used piece of software which need to serve single requests and/or hundreds of thousands of requests in a minute. Within these different kinds of workloads Microsoft SQL Server has to handle the concurrency of tasks in a fashion manner. This demo driven session shows different scenarios where Microsoft SQL Server has to wait and manage hundreds of tasks. See, analyze and solve different wait stats due to their performance impact:
- CXPACKET: when a query goes parallel
- ASYNC_IO_COMPLETION: speed up IO operations (Growth / Backup / Restore)
- ASYNC_NETWORK_IO: What happens if your application refuses data?
- THREADPOOL starvation: crush of requests for Microsoft SQL Server
- PAGELATCH_xx: How does Microsoft SQL Server protects data?
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Data Platform

Level: Intermedia

Session Code:

Date: September 26

Time: 10:45 AM - 11:45 AM

Room: Data Platform

Welcome to Azure DevOps Duet, a tale about how a development team and an operations team have to bond together and start using Azure DevOps for SQL Server related deployments.

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

- the challenges of implementing DevOps
- setting up a database solution project
- getting started with source control
- testing your database releases using tSQLt
- setting up your Azure Devops pipelines

After this session you will have the tools and knowledge to get started with DevOps and get your development process to the next level.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
Cloud Development

Level: Intermedia

Session Code:

Date: September 26

Time: 10:45 AM - 12:15 PM

Room: Cloud Dev

Can we store our Connectionstrings or BlobStorageKeys or other Secretvalues somewhere else then in Azure Data Factory(ADF)? Yes you can! You can store these valuable secrets in Azure Key Vault(AKV).
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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Data Platform

Level: Intermedia

Session Code:

Date: September 26

Time: 2:30 PM - 3:30 PM

Room: Data Platform

While designing the solution or migrating to the cloud its important to consider the offerings of (Azure SQL vs SQL Server). In this talk, I will discuss the design and planning considerations for data services. This session will give understanding (IaaS) OR (PaaS) What to use When?
Speaker:

Session Type:
Session (45 minutes)

Track:
Azure DB

Level: Intermedia

Session Code:

Date: September 26

Time: 1:15 PM - 2:00 PM

Room: Azure DB

Within the Power Platform, there's a data store called Common Data Service (CDS). But why would you use it? You've several hundred connectors allowing you to connect to almost every type of data storage. Well, CDS is an easy way to define and centralize business logic over multiple, interconnected applications handling various types of data.

In this session, we have a good look at CDS and find his strengths and weaknesses. We'll see how to build, ingest and extract data from CDS using demos. When you're using the Power Platform and/or curious about CDS but haven't used it yet, join me at this session.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Azure BI

Level: Advanced

Session Code:

Date: September 26

Time: 9:30 AM - 10:30 AM

Room: Azure BI

In many cases and BI projects, the manual process of development and especially deployment of artefacts led to sleepless nights, emergency hotfixes, grey hair and many hours of stress.
Especially in BI development, the usage of database projects, unit testing, version control, continuous integration and deployment is an underrepresented area.
Join me in this demo-heavy session where I will guide you through the not-so-frightful jungle of continuous integration using SQL Server database projects, SSIS, T-SQLt and Azure DevOps etc.
After this 60 minutes you'll have the guidelines and some ideas how easy it is to change your manual BI development and deployment into a powerful and automated no-brainer that - just works!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Azure BI

Level: Intermedia

Session Code:

Date: September 26

Time: 1:15 PM - 2:15 PM

Room: Azure BI

Planning on creating a new data platform? Come join one of Norway's most experienced solutions architect to learn the Do's and Don'ts on cloud data platforms as well as design patterns and which services to choose where.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Azure BI

Level: Beginner

Session Code:

Date: September 26

Time: 10:45 AM - 11:45 AM

Room: Azure BI

Containers are becoming ever popular but other than spinning one up to have a play around with the latest SQL Server 2019 CTP's new features, what else can they be used for?

In this demo heavy session we will show how Containers along with Azure DevOps can work for your CI/CD pipeline.

You will leave this session with the knowledge and ability to start creating your own bespoke SQL Server on Linux development / testing environments with automated image builds and releasing to Azure Kubernetes Service (AKS) along with some of the issues / pitfalls of doing so. 

Pre-Requisite:
To get the most out of this session a basic understanding of what Docker/Containers are, is recommended.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Data Platform

Level: Beginner

Session Code:

Date: September 26

Time: 9:30 AM - 10:30 AM

Room: Data Platform

What are the fundamental characteristics of Data Storytelling? How to use PowerBI not only as a data analysis tool but also as narrative data? During the session we will find out how the human brain reacts to what it sees and what are the most important best practices inherent in data visualization. We will also discover the main features of the most used visuals and when to use them or not to use them.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Power BI

Level: Intermedia

Session Code:

Date: September 26

Time: 10:45 AM - 11:45 AM

Room: Power BI

An essential part of migrating your application workload to the cloud is how to transfer your data securely to its new home. If you in addition want to change the underlying database system, for instance Oracle to SQL Server, it can quickly escalate to an overwhelming task. What if your application have a very high uptime requirement and your database is so large that you don’t not have a downtime window long enough to do a traditional backup/restore operation? In order to overcome these pain points we have now available, both in Azure and AWS, services and tools that alleviate these pains and brings your valuable data safely across with near-zero downtime.

In this talk we will:
- Guide you through how to set up a migration process with checks and balances
- Compare the schema analysis and conversion tools provided by AWS and Microsoft
- Compare the migration services provided by AWS and Azure
- Demonstrate near-zero-downtime migration for a live database on AWS and Azure
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Development

Level: Intermedia

Session Code:

Date: September 26

Time: 9:30 AM - 10:30 AM

Room: Cloud Dev

Power BI offers an add-in to work with 3rd party external tools like Tabular Editor, DAX Studio and ALM toolkit. The fact that you can use a tool of your own preference is already really cool! But did you know that you can build these tools yourself pretty easy? 

In this session I will show you how I build my model documentation external tool and how you can start doing this yourself!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Power BI

Level: Advanced

Session Code:

Date: September 26

Time: 3:45 PM - 4:45 PM

Room: Power BI

You are already familiar with T-SQL and are eager to learn R but do not know where to start? Start from what you already know: T-SQL. Both languages have many things in common on some levels, but are very different on others. You will learn how to begin your first steps in the new language and how to perform the most common tasks, typical for R: statistics, machine learning & data visualization.
This session will kick you off to the new language by using analogies from T-SQL. You will learn how to write your first R-scripts, make usage of packages and will leave this session with a basic understanding of typical use-cases of R and how to integrate that into your existing environment with SQL Server.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Data Platform

Level: Beginner

Session Code:

Date: September 26

Time: 1:15 PM - 2:15 PM

Room: Data Platform

AzureSQL Database has gone from being a simple PaaS relational database to a more complex service with different service options. Selecting the right service option and tier for your need can be difficult.

In this session I will explain the differences between SQL Database, Managed Instance, and Serverless as well as the Hyperscale options. Together we will look at the use casses where these will fit best and when you should not use them in order to deliver the best results for your data driven applications.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Azure DB

Level: Beginner

Session Code:

Date: September 26

Time: 12:00 PM - 1:00 PM

Room: Azure DB

To master any technology, you need to understand the foundation of how it works on the backend first. We will explore Azure Cosmos DB's infrastructure, I will explain you how Azure Cosmos DB works in the backend in this session. We will cover the basics and some of the most misunderstood features like Partitioning, Multi-Model APIs and Consistency Levels of Azure Cosmos DB. 
Learning new technologies make you a better leader and collaborator. Join me to learn more about this new Cloud Database technology.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Azure DB

Level: Beginner

Session Code:

Date: September 26

Time: 9:30 AM - 10:30 AM

Room: Azure DB

In this session we will show how to get the most advantages out from Azure SQL Database.
We will learn how to monitor the performance of our workload, how to improve it and how to secure it using the tools and features at our disposal on the Azure portal without having to install 3rd party tools.
We will also see some ways to lower the costs or increase performance without having to also increase costs.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Azure DB

Level: Intermedia

Session Code:

Date: September 26

Time: 10:45 AM - 11:45 AM

Room: Azure DB

Building reliable and repeatable infrastructure deployments thatcan be transitioned through Development, Test, and into production is becoming increasingly essential. There are many options including PowerShell, ARM, Cloud Formation and many more that you can use depending on your cloud of choice. But what if you want vendor lock in? Enter Terraform. An open source Infrastructure as code platform that works with Azure, AWS, and others as well as on-premises environments.

Together we will work through the what, why, and how of infrastructure automation with Terraform for building solutions. We will build a data platform solution and look at how we can transition through environments with VSTS and integrate this into development and operations processes that will let you concentrate on delivering more value to your users.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Development

Level: Beginner

Session Code:

Date: September 26

Time: 1:15 PM - 2:15 PM

Room: Cloud Dev

f you're a .NET developer, you may be forgiven for thinking that in order to build awesome machine learning applications, you'll have to brush up on your Python skills in order to use ML libraries.

With the release of ML.NET, this is no longer the case!

In this session, I'll cover what ML.NET is and how you can use it to add machine learning capabilities to your .NET applications. I'll cover the capabilities that the API offers in terms of preparing our data and evaluating our models. I'll also talk about the capabilities that the ML.NET Model builder and how that can simplify how we choose what type of model we want to build. I'll also talk about how we can deploy our models into production.

By the end of the session, you'll know how you can leverage your existing C# skills to use ML.NET to build machine learning applications!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Development

Level: Beginner

Session Code:

Date: September 26

Time: 2:30 PM - 3:30 PM

Room: Cloud Dev

Power BI Report Builder is the tool to build paginated reports in Power BI and even though its a Power BI Premium feature - it could be a handy tool in your BI toolset that you should know about.

I will demo how you can build reports based on a Power BI dataset and how to parameterize the report.

I will also show how you can use paginated reports without having a Power BI premium capacity by using Power BI Embedded SKU's to create datadriven subscriptions.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Power BI

Level: Intermedia

Session Code:

Date: September 26

Time: 1:15 PM - 2:15 PM

Room: Power BI

Sessions Found: 29
Back to Top cage-aids
cage-aids
cage-aids
cage-aids