Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type

Sessions Found: 21
So you've built yourself a snazzy report, and minutely layed out the tiles in a dashboard? Excellent! Obviously you want all the right people in your organization to gaze upon the wonder of your creation, so you share the report. What is going to happen when you make some changes, so the report is even more fantastic? What kind of interactions do you require from your end users to stay up-to-date? Are you really prepared to manually share to 20+ people? Sharing reports is cool, but we want it to be as little time consuming for everyone involved as we possibly can.

In this session, we'll take a stroll through some different sharing mechanisms for Power BI Reports and Dashboards and how you can make them accessible for your end users. Using these different mechanisms, we'll lay out a viable way of creating a decent application life cycle for your reports.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Power BI

Level: Beginner

Session Code:

Date: April 25

Time: 2:30 PM - 3:30 PM

Room: Two

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Azure BI

Level: Advanced

Session Code:

Date: April 25

Time: 3:45 PM - 4:45 PM

Room: One

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Platform

Level: Intermedia

Session Code:

Date: April 25

Time: 10:45 AM - 11:45 AM

Room: One

Mapping Data Flows is the fantastic new feature of Azure Data Factory, which combines a visual designer with the full power of Databricks to deliver a robust and hugely scalable data flow pipeline, like a constantly evolving integration services cloud service. In this hands-on session we'll design and build a data transformation in the data flow designer using the new Data Factory flow user interface, and talk about the underlying architectural components.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Azure BI

Level: Intermedia

Session Code:

Date: April 25

Time: 1:15 PM - 2:15 PM

Room: Three

Heard of dry January? Well, this the DBA equivalent. 
What is it? Why would I want to use this over Management Studio? Can I use it instead of Management Studio?  Martin will answer these questions – and more – and share with you what happened when as a DBA/Database professional he tried to exclusively use this instead of SSMS.  A month’s work of expertise to be shared in 60 minutes, detailing all the caveats and clever tricks needed to avoid pulling his hair out on a daily basis.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Platform

Level: Intermedia

Session Code:

Date: April 25

Time: 3:45 PM - 4:45 PM

Room: Four

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Azure BI

Level: Advanced

Session Code:

Date: April 25

Time: 9:30 AM - 10:30 AM

Room: Four

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Azure BI

Level: Beginner

Session Code:

Date: April 25

Time: 2:30 PM - 3:30 PM

Room: One

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Platform

Level: Beginner

Session Code:

Date: April 25

Time: 9:30 AM - 10:30 AM

Room: One

Infrastrucutre as Code is rapidly becoming a core tenant for teams managing cloud infrastructure. However, if you are managing on-premises or hybrid infrastrucutre with SQL Server this has been difficult in the past.

PowerShell Desired State Configuration helps bridge this gap and give us the ability to easily deploy and manage SQL Server state programatically. In this session I will explain what PowerShell DSC is and how you can use it to manage data platform infrastructure.

Looking at the different modules and resources that exist as well as how to build configurations. We will explore the options around using push and pull architecture to deliver value faster and reliably.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Platform

Level: Intermedia

Session Code:

Date: April 25

Time: 1:15 PM - 2:15 PM

Room: Four

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Development

Level: Intermedia

Session Code:

Date: April 25

Time: 9:30 AM - 10:30 AM

Room: Two

Containers are gathering more and more attention. Wherever you take a look at - you have them. SQL Server 2019 introduces Big Data Clusters that utilise Kubernetes to orchestrate SQL Server, Spark and HDFS containers. Starting with SQL Server Express 2014 each next version of SQL Server is available as a Docker container. If your contact with containers technology was somehow limited - it's time to change that.
 
Join me in the session where I will introduce you to the containers world. You will see how easy it is to install docker, how to run the first commands to get a grip with containers. I will make some mistakes on purpose and fix the problems you may run into. After this presentation, you will be able to install docker and run the containers on your home computer.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Azure DB

Level: Beginner

Session Code:

Date: April 25

Time: 2:30 PM - 3:30 PM

Room: Three

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Azure DB

Level: Intermedia

Session Code:

Date: April 25

Time: 1:15 PM - 2:15 PM

Room: One

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: April 25

Time: 10:45 AM - 11:45 AM

Room: Four

Azure DevOps is rapidly becoming one of the most in-demand skills for IT professionals and in this session, we will explain how you can implement and start using Azure DevOps from the ground up based upon real-world experiences.

We will provide a good overview of all major facets of Azure DevOps including:
* Azure Boards
* Azure (Build and Release) Pipelines
* Azure Repos
* Azure Test Plans
* Azure Artifacts
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!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Development

Level: Beginner

Session Code:

Date: April 25

Time: 2:30 PM - 3:30 PM

Room: Four

Having a real-time analytical solution to deal with the increase of data volumes and the ever-growing demand to have quicker access to the data is a real need.
In this session, we will learn which processes are required to build a real-time analytical model and how to achieve our goal by using the Speed and Serving layer of the Lambda Architecture. 
At the end of the session, you will have learned how to ingest, prepare and serve the data with Event Hubs, Stream Analytics, Azure Databricks, Azure Synapse Analytics and Power BI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Azure BI

Level: Intermedia

Session Code:

Date: April 25

Time: 10:45 AM - 11:45 AM

Room: Three

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Power BI

Level: Intermedia

Session Code:

Date: April 25

Time: 3:45 PM - 4:45 PM

Room: Two

An Azure Data Studio recent release introduced SQL Notebooks as a capability. While you might have read about notebooks being used for Data Science, this session is primarily for DBAs. 

We will cover installing Azure Data Studio.
What a SQL Notebooks is.
Using PowerShell in Notebooks in Azure Data Studio
Numerous use cases for you to use SQL Notebooks in your daily workload such as creating a Notebook for Glenn Berry's Diagnostic queries.

and some gifs ;-)
Prerequisites: Not having pogonophobia
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Azure DB

Level: Beginner

Session Code:

Date: April 25

Time: 3:45 PM - 4:45 PM

Room: Three

Back in the old days’ data storage in SQL server where simple - a table could be created with a clustered index and if you didn’t create an index the table was a heap. 

Today things are no longer that simple in SQL server. There are multiple ways a table can stored in SQL server:
•	Traditional row store 
•	Column store index 
•	Durable in memory tables
•	External tables (using Polybase)
Add on top of this different types of compression and partitioning and you have a more options to choose from that you will ever need :-)

In this session you will get an introduction to the 3 main data storages in SQL server: row store, column store and durable in-memory tables.
•	How do they work?
•	What are the pros and cons?
•	Potential pitfalls to avoid
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Platform

Level: Advanced

Session Code:

Date: April 25

Time: 9:30 AM - 10:30 AM

Room: Three

It’s the year 2020 about ten years ago many people were writing about the demise of the DBA and how they won’t be around in ten years time. As we move into a new decade, and those ten years have passed the DBA role is still alive and kicking. Albeit, it has evolved in the last ten years and it has changed considerably since I started my career in the early 2000s.
In this session we will look at what skills you would expect a DBA to have in 2010 and compare it to what they will need in 2020. No doubt we will be covering:
•	New versions of SQL Server
•	Automation and PowerShell
•	Continuous integration
•	Cloud technology
•	Maybe some non-technical skills too
If you want to get my take on what skills a DBA needs to have in the Roaring 20s then this session is for you.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Azure DB

Level: Beginner

Session Code:

Date: April 25

Time: 9:30 AM - 10:30 AM

Room: Five

As Power BI is a self-service tool, it can be hard for administrators to monitor it. Power BI is fast improving in this context but there still isn’t a consistent way of monitoring it. There are compliance, governance, performance, and implementation questions to consider. Who is creating content, how is it being distributed, what data is being used, how long does the refresh take and how is it changing, who has a trial license, and what report is the most used? These are just some of the questions you as an administrator of Power BI might want to get answers to. 

In this session, we will look at how you can find those answers by monitoring Power BI. We will look at the Power BI Audit log for usage, license, and other audit information. We will look at what the Power BI API can show us about data sets, refresh history, Enterprise Gateway information, premium capacity, and artifact inventory. The audience leave the session ready to start their own monitoring of all or some of the topic
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Power BI

Level: Beginner

Session Code:

Date: April 25

Time: 1:15 PM - 2:15 PM

Room: Two

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