| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:15:00 | Ida Bergum | BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem) | Power BI Automation with Microsoft Flow |
| 09:15:00 | Alexander Arvidsson | Analytics and Visualization (Cloud/Hybrid/On-prem) | Azure Machine Learning for the absolute beginner |
| 09:15:00 | Antonio Abalos Castillo | Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem) | Azure SQL and Automation, how to keep your database up-to-speed in the cloud |
| 09:15:00 | Daniel Hutmacher | Application Database Development (Cloud/Hybrid/On-prem) | Not just polish – How good code also runs faster |
| 09:15:00 | Bartosz Ratajczyk | Application Database Development (Cloud/Hybrid/On-prem) | First steps with SQL Server on Docker |
| 09:15:00 | Adam Marshall | Analytics and Visualization (Cloud/Hybrid/On-prem) | Tools and techniques for managing big data with Power BI. |
| 10:30:00 | Frank Geisler | Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem) | Use Docker to Deploy SQL Server Applications |
| 10:30:00 | Marc Lelijveld | BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem) | End-to-end monitoring for a successful Power BI implementation |
| 10:30:00 | Alexander Klein | BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem) | BI in Azure one year live |
| 10:30:00 | Mikael Wedham | Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem) | A Masters view on Locking and blocking |
| 10:30:00 | Thomas Hütter | Application Database Development (Cloud/Hybrid/On-prem) | "Can I join you?", one table asked the other |
| 10:30:00 | Gabi Münster | Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem) | Continuous Intelligence... What's this all about? |
| 11:45:00 | Jonathan Stewart | Analytics and Visualization (Cloud/Hybrid/On-prem) | Now you see it, but did you really? Correcting visual fallacies... |
| 11:45:00 | Erland Sommarskog | Application Database Development (Cloud/Hybrid/On-prem) | Don't Bite Off More Than You Chew - Take It in Chunks |
| 11:45:00 | Jens Vestergaard | BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem) | ABC's of the Power BI REST API |
| 11:45:00 | Jeroen Bosems | BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem) | Applying Agile in Business Intelligence |
| 11:45:00 | Andrew Pruski | Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem) | SQL Server Kubernetes |
| 11:45:00 | André Kamman | BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem) | ETL with Azure Databricks, The Complete Introduction |
| 13:00:00 | SQLSaturday Oslo Sponsor | Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem) | Managing SQL Server Farms VS SQL Server instances by dbWatch |
| 13:00:00 | SQLSaturday Oslo Sponsor | Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem) | SQL Server Auditing and Compliance with Quest |
| 13:00:00 | SQLSaturday Oslo Sponsor | Application Database Development (Cloud/Hybrid/On-prem) | Add rockets to your database with Hyperscale by Microsoft |
| 13:20:00 | SQLSaturday Oslo Sponsor | BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem) | Include Power BI metadata in Xpert BI by BI-Builders |
| 14:00:00 | Jonathan Stewart | Analytics and Visualization (Cloud/Hybrid/On-prem) | Data Visualization: How to truly tell a great story! |
| 14:00:00 | Markus Ehrenmueller-Jensen | Application Database Development (Cloud/Hybrid/On-prem) | A Game of Hierarchies: Introduction to Graph Processing with SQL Server 2019 |
| 14:00:00 | Wolfgang Strasser | BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem) | The Microsoft Power Platform - What is it? |
| 14:00:00 | Marek Jablonski | Other | SQL Server database perfomance on Azure, Google and AWS cloud platform |
| 14:00:00 | Helge Rege Gårdsvoll | BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem) | Beyond orchestration with Azure Data Factory |
| 14:00:00 | Grant Fritchey | Application Database Development (Cloud/Hybrid/On-prem) | SQL Injection: What Is It, Prevent It, Monitor For It! |
| 15:15:00 | Ben Watt | BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem) | An IoT/BI/AI session - from Raspberry Pi to Power BI and lots in between |
| 15:15:00 | Isabelle Van Campenhoudt | BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem) | Power BI server and Office Online server, modernize your on-premises BI approach. |
| 15:15:00 | John Martin | Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem) | Making Managed Instance Perform, a dive into storage. |
| 15:15:00 | Hugo Kornelis | Application Database Development (Cloud/Hybrid/On-prem) | Execution plans ... where do I start? |
| 15:15:00 | Rob Sewell | Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem) | SQL Notebooks in Azure Data Studio for the DBA |
| 15:15:00 | Cathrine Wilhelmsen | BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem) | Building Dynamic Data Pipelines in Azure Data Factory |
| 16:30:00 | Sander Stad | Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem) | Mask That Data! |
| 16:30:00 | Kellyn Pot'Vin-Gorman | BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem) | Taming of the Shrew - Optimizing Power BI |
| 16:30:00 | Margarita Naumova | Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem) | Practical Adaptive Query Processing in SQL Server 2019 |
| 16:30:00 | Allen White | Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem) | Ransomware Happens - Are You Ready for Disaster to Strike? |
| 16:30:00 | Håkon Lenschow | BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem) | Azure Machine Learning Services and Kubernetes – Taking models into production |
Event Date: 31-08-2019 - Session time: 09:15:00 - Track: BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem)
Event Date: 31-08-2019 - Session time: 09:15:00 - Track: Analytics and Visualization (Cloud/Hybrid/On-prem)
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.
Event Date: 31-08-2019 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem)
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.
Event Date: 31-08-2019 - Session time: 09:15:00 - Track: Application Database Development (Cloud/Hybrid/On-prem)
But most of all, they’ll make the code prettier and easier to understand for the next person.
We’ll look at common ways that null values, implicit datatype conversions and foreign key constraints can radically affect the performance of your queries. Inspired by an actual client case, where I tuned a 20 hour query down to a few minutes, with only a minor code change.
This presentation is all-code, some execution plans, and no-powerpoint.
Event Date: 31-08-2019 - Session time: 09:15:00 - Track: Application Database Development (Cloud/Hybrid/On-prem)
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.
Event Date: 31-08-2019 - Session time: 09:15:00 - Track: Analytics and Visualization (Cloud/Hybrid/On-prem)
Event Date: 31-08-2019 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem)
Event Date: 31-08-2019 - Session time: 10:30:00 - Track: BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem)
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.
Event Date: 31-08-2019 - Session time: 10:30:00 - Track: BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem)
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.
Event Date: 31-08-2019 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem)
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.
Event Date: 31-08-2019 - Session time: 10:30:00 - Track: Application Database Development (Cloud/Hybrid/On-prem)
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.
Event Date: 31-08-2019 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem)
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.
Event Date: 31-08-2019 - Session time: 11:45:00 - Track: Analytics and Visualization (Cloud/Hybrid/On-prem)
Event Date: 31-08-2019 - Session time: 11:45:00 - Track: Application Database Development (Cloud/Hybrid/On-prem)
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.
Event Date: 31-08-2019 - Session time: 11:45:00 - Track: BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem)
• 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: 31-08-2019 - Session time: 11:45:00 - Track: BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem)
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.
Event Date: 31-08-2019 - Session time: 11:45:00 - Track: Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem)
This session will provide an overview of running SQL Server in Kubernetes, which is the leading orchestrator.
Topics covered will be: - An overview of Kubernetes. Definition of pods and services. Deploying SQL Server containers to Kubernetes. Persisting data for SQL Server in Kubernetes.
This session is aimed at SQL Server DBAs and Developers who want to learn the what, the why, and the how to run SQL Server in Kubernetes.
Event Date: 31-08-2019 - Session time: 11:45:00 - Track: BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem)
Event Date: 31-08-2019 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem)
Event Date: 31-08-2019 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem)
Event Date: 31-08-2019 - Session time: 13:00:00 - Track: Application Database Development (Cloud/Hybrid/On-prem)
Speaker: Jon Jahren, Senior Cloud Solution Architect (Data Platform), Microsoft Norway
Event Date: 31-08-2019 - Session time: 13:20:00 - Track: BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem)
This session will give insights into the lates features of the Xpert BI Solution Catalog, which includes controlling the enterprise Power BI environment. This functionality is to be released this fall and the session will be a sneak-peak of what to expect.
*gives end-to-end data lineage
*document reports, tables and columns
*generate metadata reports of the Power BI.com enterprise environment
Event Date: 31-08-2019 - Session time: 14:00:00 - Track: Analytics and Visualization (Cloud/Hybrid/On-prem)
Event Date: 31-08-2019 - Session time: 14:00:00 - Track: Application Database Development (Cloud/Hybrid/On-prem)
Event Date: 31-08-2019 - Session time: 14:00:00 - Track: BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem)
This new term was introduced by Satya Nadella and James Philips as the serving foundation for building powerful (cloud-baked) applications. PowerApps as the data manipulation part, Microsoft Flow as the connecting workflow engine and Power BI for analysis and reporting. In addition, the Common Data Service (CDS) and the Common Data Model (CDM) provide a solid framework for data storage and modelling. Join me in this session if you want to get an overview about the involved technologies, how they work together, see them live working together in many demos and how they will definitely change the way of building powerful solutions in the future!
Event Date: 31-08-2019 - Session time: 14:00:00 - Track: Other
To confirm if this is really the case, a series of performance tests were conducted on Microsoft SQL Server in three different locations and on three different cloud platforms: Azure, AWS and Google. We also compeer the results, from three Azure Service tiers (Basic 5 DTU, Standard S3 100 DTU and Premium P2 250 DTU) with previous tests from December 2016 and March 2018.
We will present the test methods and the results and findings. Based on our measurements we have seen:
Event Date: 31-08-2019 - Session time: 14:00:00 - Track: BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem)
Event Date: 31-08-2019 - Session time: 14:00:00 - Track: Application Database Development (Cloud/Hybrid/On-prem)
Event Date: 31-08-2019 - Session time: 15:15:00 - Track: BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem)
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!
Event Date: 31-08-2019 - Session time: 15:15:00 - Track: BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem)
How to refresh your BI solution by providing the beauty of Power BI reports on premises and the ability from the same place to consume your legacy reports or to share efficiently your data model through a unique place. Demo based session with a strong architecture introduction and a "from the field" real project feedback.This session will explore all the possibilities offered by Power Bi Report server: What are the difference with the classical SQL Server Report Server ? What is the difference with Power BI Service ? What kind of data sources are used ? How to manage the refresh ? What infrastructure is needed to make it working ? How to manage the authentication from the data source to the report ?
Event Date: 31-08-2019 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem)
Event Date: 31-08-2019 - Session time: 15:15:00 - Track: Application Database Development (Cloud/Hybrid/On-prem)
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.
Event Date: 31-08-2019 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem)
While you might have read about notebooks being used for Data Science, this session is for DBAs. You will see how you can use SQL Notebooks to simplify your work.
You will learn about SQL Notebooks from installing them in Azure Data Studio to creating a Notebook for Glenn Berry's Diagnostic queries as well as numerous use cases for you to use in your daily workload
Event Date: 31-08-2019 - Session time: 15:15:00 - Track: BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem)
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.
Event Date: 31-08-2019 - Session time: 16:30:00 - Track: Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem)
You need data for development, reporting or a devops related scenario.
Data breaches happen more often than ever.
Data that's not on production systems should be masked. Especially when you're dealing with regulations like GDPR and HIPAA, you should know how to prevent attackers from acquiring your production data.
In this session will talk about we need to know about data masking. Which types of masking there and especially how we can implement it.
If you want to take the next step in data security come to this session.
Event Date: 31-08-2019 - Session time: 16:30:00 - Track: BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem)
This session will take the Power User through how to identify time consuming processing in Power BI and how to address it through step-by-step and proven methods used to optimize in multi-tier environments. This method removes frustration and finger-pointing and gets to the heart of the problem with a goal of correcting performance challenges. The results are satisfied end users who get the information they need, when they need it.
Take Aways: Learn how to identify what is taking the time in a Power BI data set and report. Understand the logging and tracing mechanisms and capabilities in the environment. Understand when a problem is really a problem.
Event Date: 31-08-2019 - Session time: 16:30:00 - Track: Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem)
Event Date: 31-08-2019 - Session time: 16:30:00 - Track: Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem)
Event Date: 31-08-2019 - Session time: 16:30:00 - Track: BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem)
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.