Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type


Sessions Found: 39
So you have your database beautifully set up according to Codd. What do you need when you have to retrieve data from related tables? Most probably a JOIN operator, but which one?

Fom LEFT to RIGHT, when is it INNER and when OUTER? Is a CROSS JOIN something NATURAL? And why may ANTI yield more results than SEMI...? How and when do their buddies MERGE, HASH and NESTED LOOP get to participate? 

We'll have demos for all of this on well-known databases. And if all that doesn't make your head dizzy enough, I might even throw in some CROSS and OUTER APPLY.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development (Cloud/Hybrid/On-prem)

Level: Beginner

Session Code:

Date: August 31

Time: 10:30 AM - 11:30 AM

Room: Valhalla

Hierarchies are the bread and butter of most business applications and you find them almost everywhere:
* Product Categories
* Sales Territories
* Bill of Material
* Calendar and Time
Even when there is a big need from a business perspective, the solutions in relational databases are mostly sort of awkward. The most flexible hierarchies are usually modeled as self-referenced tables. If you want to successfully query such self-referenced hierarchies, you will need either loops or recursive Common Table Expressions. SQL Server 2017 brought us Graph Database and the MATCH clause and SQL Server 2019 comes with further improvements.
Join this session for a journey through best practices to transform your hierarchies into useful information. We will have fun playing around with a sample database based on G. R. R. Martin’s famous “Game of Thrones”.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development (Cloud/Hybrid/On-prem)

Level: Beginner

Session Code:

Date: August 31

Time: 2:00 PM - 3:00 PM

Room: Valhalla

How do the wait stats show you that you have a locking issue?
This session will show you how to detect and view blocking and lock waits, and understand the cause of it.
An extensive walkthrough of the different isolation levels and their respective benefits and drawbacks.
And finally a real-world quick list of suggestions on what you can do to solve some of the common issues I come across in my daily work.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment (Cloud/Hybrid/On

Level: Intermedia

Session Code:

Date: August 31

Time: 10:30 AM - 11:30 AM

Room: Jotunheim

In this session we will be looking into managing our Power BI content using only the Power BI REST API. While the Power BI REST API is extensive, we will be limiting this session on the following sections of interest: Dashboards, Datasets, Reports & Groups.
	• 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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration (Cloud/Hy

Level: Intermedia

Session Code:

Date: August 31

Time: 11:45 AM - 12:45 PM

Room: Bifrost

What’s the hype about Hyperscale? In this lunch session we will explain the tech behind Azure SQL DB Hyperscale, and compare it with other scalable Azure database services such as Azure SQL Data Warehouse, PostgreSQL Hyperscale (Citus), and Snowflake. This talk will be fast, fun, and highly technical.

Speaker: Jon Jahren, Senior Cloud Solution Architect (Data Platform), Microsoft Norway
Speaker:

Accompanying Materials:

No material found.

Session Type:
Sponsor Session (20 minutes)

Track:
Application & Database Development (Cloud/Hybrid/On-prem)

Level: Intermedia

Session Code:

Date: August 31

Time: 1:00 PM - 1:20 PM

Room: Asgard

In this session Ben will walk you through a home-made IoT project with the data ultimately landing in Power BI for visualisation. A Raspberry Pi is the IoT device, with sensors and camera attached to give an end-to-end streaming solution. 

You will see Python used to run the program and process the images. Microsoft Azure plays its part where Microsoft Cognitive Services enriches the images with facial attributes and recognition, Azure SQL stores the metadata, Azure Blob storage holds the images, Power BI visualises the activity and Microsoft Flow sends mobile notifications. You'll see enough to walk out and get your own project started straight away!

This is a demo heavy session and audience interaction is key!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration (Cloud/Hy

Level: Intermedia

Session Code:

Date: August 31

Time: 3:15 PM - 4:15 PM

Room: Valhalla

In this presentation, we will be discussing the merits of Agile processes in Business Intelligence (BI) development. 
First of all the focus will be on explaining the differences between Agile methodology and Waterfall processes in BI and why Agile is here to stay. 
Agile requires a specific mindset in BI projects due to being full stack and we give pointers on what rules can make your communication with the business more fluent. 
This will include the value of maintaining live documentation for both business and developer.
We then look at technical limitations for implementing Agile that are specific to BI and how to overcome these. 
Following this, we can describe how we're pragmatically going to apply these principles, and elaborate on splitting up the scopes in a project (staging, Data Warehouse, and reporting layers). 
By the end of this session, you will have a better understanding of Agile development in BI, and some tools of how to apply this to your day to day operations.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration (Cloud/Hy

Level: Beginner

Session Code:

Date: August 31

Time: 11:45 AM - 12:45 PM

Room: Yggdrasil

Machine learning is one of the hottest trends on the market. According to the popular belief, machine learning will help you do everything from water your plants to help run your multi-million dollar company. Some of the hype is true, much of it is false.  But what IS machine learning - really? How can it be used? What questions can it answer? Har hard is it to get started?
Join Alexander for a session that will give you a thorough overview of what machine learning tools are available in Azure, how to actually find any use for machine learning, what preconceptions are wrong and how to get started on your first machine learning project.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization (Cloud/Hybrid/On-prem)

Level: Beginner

Session Code:

Date: August 31

Time: 9:15 AM - 10:15 AM

Room: Valhalla

On December 2018 Microsoft announced the general availability of Azure Machine Learning Services. This component contains many advanced capabilities designed to simplify and accelerate the process of building, training, and deploying machine learning models. In combination with Azure Kubernetes Services it has never been easier to facilitate everything from development to operation for machine learning models within Azure.

In this session we will go in depth in both components with demos from a machine learning project from Bane NOR. We will also discuss different Machine learning framework in Azure, and how Azure stands as a Machine Learning platform compared to its biggest competitors.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration (Cloud/Hy

Level: Intermedia

Session Code:

Date: August 31

Time: 4:30 PM - 5:30 PM

Room: Asgard

While the typical DBA role is being assigned to mission-critical databases, we developers, still need to plan for some basic database maintenance. 
During this session, we will review the typical maintenance activities that need to be taken in Azure SQL and how to make sure they execute on a regular basis, without a higher cost and with low supervision effort. Several demos will also be reviewed to show the usage and potential of these techniques.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment (Cloud/Hybrid/On

Level: Intermedia

Session Code:

Date: August 31

Time: 9:15 AM - 10:15 AM

Room: Yggdrasil

Back in the old days Azure Data Factory could only trigger data transformation from Azure Batch Service or Data Lake Analytics. With ADFv2 you now have options with SSIS, Mapping Data Flows or Databricks notebooks. This session shows you the strengths and weaknesses of the various approaches and some demos to showcase how to make your choice of data transformation tool in Azure Data Factory.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration (Cloud/Hy

Level: Beginner

Session Code:

Date: August 31

Time: 2:00 PM - 3:00 PM

Room: Asgard

After more than one year live with BI in Azure Alexander Klein would like to give an honest feedback. 

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, ...) ?
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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration (Cloud/Hy

Level: Beginner

Session Code:

Date: August 31

Time: 10:30 AM - 11:30 AM

Room: Asgard

You already know how to build, orchestrate, and monitor data pipelines in Azure Data Factory. But how do you go from basic, hardcoded data pipelines to making your solution dynamic and reusable?

In this session, we will dive straight into some of the more advanced features of Azure Data Factory. How do you parameterize your linked services, datasets, and pipelines? What is the difference between parameters and variables, and when should you use them? And how does the expression language and built-in functions really work?

We will answer these questions by going through an existing solution step-by-step and gradually making it dynamic and reusable. Along the way, we will cover best practices and lessons learned.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration (Cloud/Hy

Level: Intermedia

Session Code:

Date: August 31

Time: 3:15 PM - 4:15 PM

Room: Asgard

Continuous Intelligence combines the terms of Continuous Integration and Business Intelligence and aims for defining and implementing processes to keep your implementation and deployment processes for your BI applications flexible and as seamless as possible.
Even in the near past support for CI processes of BI projects was almost not there. But the last few years brought some changes to the perception of this topic and shifted the mindset.
Let's look at advantages and challenges for CI in BI and at possibilities to implement such a process for Analysis Services.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment (Cloud/Hybrid/On

Level: Beginner

Session Code:

Date: August 31

Time: 10:30 AM - 11:30 AM

Room: Yggdrasil

We have more information available to us today than ever before. So much so that we run the risk of not being able to tell concise stories. There's a lot more to creating that story than just getting the correct information. Come learn not just the do's and don'ts, but the whys…
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization (Cloud/Hybrid/On-prem)

Level: Beginner

Session Code:

Date: August 31

Time: 2:00 PM - 3:00 PM

Room: Jotunheim

Any SQL programmer with some experience knows that loops are bad and that you should work with all data at once in set-based statements. However, you may have experienced situations where this strategy did not work out well and you ran into problems like out-growing the transaction log or blocking other users.

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development (Cloud/Hybrid/On-prem)

Level: Advanced

Session Code:

Date: August 31

Time: 11:45 AM - 12:45 PM

Room: Jotunheim

Implementing Power BI in your organisation is more then allowing people to download Power BI desktop and publish reports to the Power BI Service. People have to be aware of what Power BI is able to achieve for them! But how do you know who is creating what? Using what? Or maybe even more important, sharing (confidential) information with others? 

With a Power BI end-to-end monitor you will be able to monitor all Power BI content allover your tenant. These actionable insights will help you to see who needs some extra help, but also in governing your data solutions within your organisation. 

In this session I will show you which insights you will get with an end-to-end monitor and how you can monitor your own Power BI environment.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration (Cloud/Hy

Level: Advanced

Session Code:

Date: August 31

Time: 10:30 AM - 11:30 AM

Room: Bifrost

Azure Databricks seems to be the new sheriff in town. It promises easy but capable ETL (amongst other things). But how does it work? For an SSIS (and possibly BIML) person this all looks new and strange. Python notebooks? Scala? Spark? What is all this, and where do I start? Well, you start by coming to this presentation. We’ll take a look at how to approach making an Azure Databricks based ETL solution from start to finish. Along the way it will become clear how Azure Databricks works and we will use our SSIS based ETL knowledge to see if it can handle the common use-cases from our daily jobs. And of course we will also have some fun and see how fast it can go!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration (Cloud/Hy

Level: Intermedia

Session Code:

Date: August 31

Time: 11:45 AM - 12:45 PM

Room: Asgard

SQL (the language) is not a third generation language, where the developer tells the computer every step it needs to take. It is a declarative language that specifies the required results. SQL Server itself will figure out what steps it takes to get to those results. Most of the time, that works very well.

But sometimes it doesn't. Sometimes a query takes too much time. You need to find out why, so you can fix it. That's where the execution plan comes in. In the execution plan, SQL Server exposes exactly which steps it took for your query, so you can see why it's slow.

However, execution plans can be daunting to the uninitiated. Especially for complex queries. Where do you even start?

In this session you will learn how to obtain execution plans. and how to start reading and understanding them.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development (Cloud/Hybrid/On-prem)

Level: Beginner

Session Code:

Date: August 31

Time: 3:15 PM - 4:15 PM

Room: Jotunheim

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 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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development (Cloud/Hybrid/On-prem)

Level: Beginner

Session Code:

Date: August 31

Time: 9:15 AM - 10:15 AM

Room: Midgard

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