| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | David Postlethwaite | Cloud (Application Development Deployment) | Shard Attack - Horizontal Scaling in Azure SQL Database |
| 09:00:00 | Markus Ehrenmueller-Jensen | Administration (Platform, Architecture) | Lightning Talk |
| 09:00:00 | Bartosz Ratajczyk | Development | Start testing your SSIS packages with ssisUnit |
| 09:00:00 | Thomas Martens | BI (Architecture, Advanced Analytics, Visualization, Information Delivery) | Power BI Data Modeling |
| 10:15:00 | William Durkin | Administration (Platform, Architecture) | Query Store without SQL 2016 = Open Query Store |
| 10:15:00 | Mario Schnalzenberger | BI (Architecture, Advanced Analytics, Visualization, Information Delivery) | Woodworks on Azure ML Workbench |
| 10:15:00 | Mikael Wedham | Development | A Masters view on Query plans and indexing |
| 10:15:00 | Johan Ludvig Brattås | Cloud (Application Development Deployment) | Don't Cross the Streams! A Closer Look at Azure Stream Analytics |
| 11:30:00 | Andrew Pruski | Cloud (Application Development Deployment) | Azure SQL Containers |
| 11:30:00 | Frank Geisler | Development | Azure Data Studio - The new kid in town |
| 11:30:00 | Oliver Engels | BI (Architecture, Advanced Analytics, Visualization, Information Delivery) | Data Quality matters! Go for a quality roundtrip in the MS data platform |
| 11:30:00 | Michael Roedeske | Administration (Platform, Architecture) | Anomalien Monitoring und SQL Abfragen-Analyse |
| 13:15:00 | Gabi Münster | Cloud (Application Development Deployment) | FROM DATA LAKE TO DAX QUERY |
| 13:15:00 | Martin Pöckl | Development | Let's build an end-to-end IoT solution - from Edge to Cloud |
| 13:15:00 | Suha Güngören | Administration (Platform, Architecture) | Big Data und Data Science |
| 13:15:00 | Ben Weissman | BI (Architecture, Advanced Analytics, Visualization, Information Delivery) | SQL Server 2019 Big Data Clusters – a game changer? |
| 14:30:00 | Dejan Sarka | BI (Architecture, Advanced Analytics, Visualization, Information Delivery) | SQL Server 2017: Data Science with Python or R? |
| 14:30:00 | Mark Broadbent | Development | Persistence is Futile - Implementing Delayed Durability in SQL Server |
| 14:30:00 | Björn Peters | Cloud (Application Development Deployment) | How to Get Started with Azure Managed Instance |
| 14:30:00 | Markus Schröder | Administration (Platform, Architecture) | Der moderne DBA in einer heterogenen Datenbankwelt: Performance- und Verfügbarkeitsüberwachung |
| 15:45:00 | Damian Widera | Cloud (Application Development Deployment) | U-SQL in great depth |
| 15:45:00 | Alexander Arvidsson | Administration (Platform, Architecture) | Headless chicken - calming the sysadmin that turned DBA |
| 15:45:00 | Asgeir Gunnarsson | BI (Architecture, Advanced Analytics, Visualization, Information Delivery) | Enterprise Power BI – Development Lifecycle |
| 15:45:00 | Marcos Freccia | Administration (Platform, Architecture) | My 10 favorite PowerShell commands |
Event Date: 18-01-2019 - Session time: 09:00:00 - Track: Cloud (Application Development Deployment)
However there comes a point, especially in the cloud, where it is no longer possible to add more resources to a single database. Here we need a different solution. Instead of scaling up we must scale out, sometimes called horizontal scaling or sharding.
In this talk we will look at how to scale out in Microsoft Azure SQL database using the Azure Elastic Database tools We will look at the requirements and options for horizontal scaling in Azure and then we will have a go at sharding an Azure SQL database and then querying and updating the different shards We will be using t-sql, PowerShell and c# so come prepared for some serious coding
Event Date: 18-01-2019 - Session time: 09:00:00 - Track: Administration (Platform, Architecture)
Matija Lah - “You dread talking to lawyers? Try designing their apps.” Gianluca Sartori - "Benchmarking with WorkloadTools" Oliver Engels - "10min Flash on Common Data Model" Roman Lansky - "How much memory you need for your SSAS Tabular solution?"
Event Date: 18-01-2019 - Session time: 09:00:00 - Track: Development
On this session, I will show you how to start with automated testing of the packages and the whole projects using ssisUnit – the free SSIS testing library. I will start with some basics and move forward to the real-life examples of the unit and integration testing of the SSIS packages/ projects/solutions. You will see the benefits of automated testing and that testing is hard only at the beginning.
Event Date: 18-01-2019 - Session time: 09:00:00 - Track: BI (Architecture, Advanced Analytics, Visualization, Information Delivery)
New data modeling features like many-to-many relationships and aggregations have been released during the last months. This session demonstrates how these features can be used to solve complex problems and how these techniques can be used on top of large amounts of data.
Event Date: 18-01-2019 - Session time: 10:15:00 - Track: Administration (Platform, Architecture)
This session will give a short introduction to the Query Store feature in SQL 2016 and then dive into the Open Query Store (OQS) solution. William (co-creator of the OQS project) will explain the design of OQS and demonstrate the features. You will leave this session with an understanding of the features of Query Store and Open Query Store, and a desire to implement OQS in your systems when you return to the office.
Event Date: 18-01-2019 - Session time: 10:15:00 - Track: BI (Architecture, Advanced Analytics, Visualization, Information Delivery)
We will go through two experiments to classify raw data and image data using PYTHON and the Azure ML stack.
Event Date: 18-01-2019 - Session time: 10:15:00 - Track: Development
You will se how queries are run, how indexes are used and get an insight into what query plans tell you. Further on you'll be introduced to In-Memory and Column Store indexing to get a fair chance of selecting appropriate indexing for your query load.
Event Date: 18-01-2019 - Session time: 10:15:00 - Track: Cloud (Application Development Deployment)
Event Date: 18-01-2019 - Session time: 11:30:00 - Track: Cloud (Application Development Deployment)
I'll cover the following different options for running Docker containers in Azure: Azure Container Registry Azure Container Instances Azure Container Services (AKS)
This session is aimed at SQL Server DBAs and Developers who have some experience with Docker (Docker for Windows) and want to know the different options that are available in Azure.
Each topic will be backed up with demos which will show how simple it is to get up and running with these technologies.
Event Date: 18-01-2019 - Session time: 11:30:00 - Track: Development
Event Date: 18-01-2019 - Session time: 11:30:00 - Track: BI (Architecture, Advanced Analytics, Visualization, Information Delivery)
We dive into the requirements of modern curation and show in examples, what the Microsoft Data Platform has to offer: Can SQL Server Master Data Service (MDS), Data Quality Services (DQS) and Integration Service (SSIS) especially with the integration in ADF help? Which options offers the Azure Data Catalog and how does the Microsoft Common Data Service come into play? We also look at the potential of the new integrated languages in the Data Platform like R or U-SQL. At the end of this session you will have an overview and understanding of the possibilities, that Microsoft Data Platform offers you to address your data curation requirements.
Event Date: 18-01-2019 - Session time: 11:30:00 - Track: Administration (Platform, Architecture)
Event Date: 18-01-2019 - Session time: 13:15:00 - Track: Cloud (Application Development Deployment)
Azure offers a variety of services that work hand in hand and can be fully automated using PowerShell or.NET.
In this session we will show an example of how data from various sources such as FTP, databases or streaming data can be loaded via ADF and processed in Azure Data Lake.
But getting the information out of Azure Data Lake still requires a special skill set and doesn‘t allow for usage by the broader audience or standard visualization tools. This is a typical requirement of Azure Analysis Services.
But how to implement the model? Can this even be automated in a way? We will present you one approach to accomplish this.
Event Date: 18-01-2019 - Session time: 13:15:00 - Track: Development
This demo-heavy session is for the cast and crew of developers that make any IoT solution work for its intended audience. It's a guide not just to the “Things”, but to their secure connection to the “Internet” that powers every IoT solution and the analytics that allows you to gain insight from your data.
Event Date: 18-01-2019 - Session time: 13:15:00 - Track: Administration (Platform, Architecture)
Bedeutung von Big Data und Data Science Was kann man sich unter Data Science und Big Data vorstellen? Prozesse Big Data und Data Science Warum betrifft Big Data und Data Science auch Sie? Der Microsoft Data Science und Big Data Track Big Data und Data Science Ausbildungsweg Angebot: Hybride Ausbildung bei ETC – MPP DS und MPP BD Q A
Event Date: 18-01-2019 - Session time: 13:15:00 - Track: BI (Architecture, Advanced Analytics, Visualization, Information Delivery)
Event Date: 18-01-2019 - Session time: 14:30:00 - Track: BI (Architecture, Advanced Analytics, Visualization, Information Delivery)
Event Date: 18-01-2019 - Session time: 14:30:00 - Track: Development
In this session, we will investigate how SQL Server implements transactional durability in order to understand how Delayed Durability bends the rules to remove transactional bottlenecks and achieve improved throughput. We will take a look at how this can be used to compliment In-Memory OLTP performance, and how it might impact or compromise other things.
Attend this session and you will be assimilated!
Event Date: 18-01-2019 - Session time: 14:30:00 - Track: Cloud (Application Development Deployment)
Showing and explaining how you to steer around all the cliffs and make sure everything works smoothly.
It is about the features and why it might save you costs and make the life of your admin much easier by using Azure Managed Instances. Showing how to deploy, connect and migrate your application data. After this session, you'll understand this great database a bit better and know how to deploy it via portal and Powershell and why it a step ahead.
Event Date: 18-01-2019 - Session time: 14:30:00 - Track: Administration (Platform, Architecture)
Event Date: 18-01-2019 - Session time: 15:45:00 - Track: Cloud (Application Development Deployment)
Event Date: 18-01-2019 - Session time: 15:45:00 - Track: Administration (Platform, Architecture)
Event Date: 18-01-2019 - Session time: 15:45:00 - Track: BI (Architecture, Advanced Analytics, Visualization, Information Delivery)
These include things like source control, multiple environments, deployment processes, and governance.
As Power BI content is developed using Power BI Desktop and not Visual Studio as most Microsoft BI solutions are, these things can get tricky. In this session we will look at what Power BI has to offer when it comes to development lifecycle. We will look at the different options available to the developer when it comes to source control, multiple environments, deployment and distribution of Power BI content. Lastly, we will look at governance and see how it is possible to secure the content and audit the usage of Power BI.
For all these topics we will look at the capabilities Power BI offers and how we, in the company where I work, decided to implement it.
Event Date: 18-01-2019 - Session time: 15:45:00 - Track: Administration (Platform, Architecture)
I promise that at least one new thing you will learn it