Nr: 880
SQLSaturday #880 - Munich 2019
SessionID: 95213
From Power BI to AI – Enrich your BI with Artificial Intelligence
Event Date: 19-10-2019 - Session time: 09:15:00 - Track: Analytics
Speaker: Markus Ehrenmueller-Jensen
Title: From Power BI to AI – Enrich your BI with Artificial Intelligence
Abstract:
AI is everywhere – and now even included in Power BI. Sometimes AI might be very apparent when you enrich your data with predictions by explicitly calling an Azure Machine Learning web service in Power Query. Sometimes it might by hidden in a nice little context menu when Power BI is automagically explaining the reason of a difference or a change over time in your data to you.
No matter if you are a business user, analyst or data scientist – Power BI has AI capabilities tailored to you. In this session we will cover how you can integrate and leverage the use of language R, how to integrate an Azure Machine Learning Service when loading data, what kind of insights Power BI is capable of delivering automatically, how you can create a complex new column without typing a single formula/function, how you can explore your data by asking questions in plain English, ... and more!
Sounds like a lot of content? I omitted most of the slides in favour to spend the time in live demos instead.
SessionID: 95528
Der Klotz zeigt Dir den Weg - ins Internet of Legos
Event Date: 19-10-2019 - Session time: 09:15:00 - Track: Other
Speaker: Benjamin Kettner
Title: Der Klotz zeigt Dir den Weg - ins Internet of Legos
Abstract:
Nachdem Robbi der Lego-Roboter auf dem SQL Saturday im Rheinland seinen Freund Damon wiedergefunden hat, hat er sich überlegt, wie er ein solches Desaster in Zukunft vermeiden kann. Natürlich hat der schlaue Roboter dafür eine Lösung gefunden, wie er mit Hilfe der Cloud immer auf dem richtigen Weg bleibt. Diese Lösung möchten wir euch zeigen.
Unser Vortrag enthält Lego, LabView, Azure und künstliche Intelligenz. Wie das Zusammenspiel dieser Komponenten funktioniert, zeigen wir in unserer IoT Demo in der Session.
SessionID: 96377
SQL in Azure: What to use When and How to Migrate
Event Date: 19-10-2019 - Session time: 09:15:00 - Track: Administration
Speaker: Anna Hoffman
Title: SQL in Azure: What to use When and How to Migrate
Abstract:
After this session, you should be able to:
- Understand the benefits of SQL Server in Azure
- Articulate the key differentiators between SQL Server on-prem, in Azure VM, in Azure SQL DB (Single database, Elastic Pools, and Managed instance), and hybrid
- Explain the different service tiers within Azure SQL DB, and evaluate what is best for your workloads and business requirements (Serverless, Hyperscale, General Purpose, Business Critical, etc)
- Understand the tools, processes, and partners available to migrate to Azure
SessionID: 96453
ETL with Azure Databricks, The Complete Introduction
Event Date: 19-10-2019 - Session time: 09:15:00 - Track: Business Intelligence
Speaker: André Kamman
Title: ETL with Azure Databricks, The Complete Introduction
Abstract:
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!
SessionID: 93399
How to choose the right data model: SQL Server or Azure Cosmos DB. Which, When and Where ?
Event Date: 19-10-2019 - Session time: 10:45:00 - Track: Administration
Speaker: Aleksandar Talev
Title: How to choose the right data model: SQL Server or Azure Cosmos DB. Which, When and Where ?
Abstract:
SessionID: 94451
Von 0 auf 100 mit der Kusto Query Language (KQL)
Event Date: 19-10-2019 - Session time: 10:45:00 - Track: Analytics
Speaker: Sascha Dittmann
Title: Von 0 auf 100 mit der Kusto Query Language (KQL)
Abstract:
Die Kusto Query Language wird in verschiedenen Azure Diensten verwendet, wie beispielsweise Azure Log Explorer oder der Zeitreihendatenbank Azure Data Explorer (aka Kusto DB).
In dieser Session gibt Sascha Dittmann eine Einführung in die Abfragesprache. Dabei startet er mit den Grundlagen, spricht aber auch Fortgeschrittene Themen wie Machine Learning, Zeitreihenanalysen und das Zusammenspiel mit anderen Azure Diensten an.
SessionID: 94610
Power BI Dataflows? Why you need to implement it!
Event Date: 19-10-2019 - Session time: 10:45:00 - Track: Business Intelligence
Speaker: Benni De Jagere
Title: Power BI Dataflows? Why you need to implement it!
Abstract:
Not so long ago, Power BI Dataflows have been added to the Power BI landscape. It is showing great promise, as they have the potential of becoming key in every (large) implementation of a Power BI or Hybrid BI Architecture.
During this session, the core concepts of Power BI Dataflows will be explained, and we'll discuss how Power BI Dataflows could alleviate some of the specific problems you might be experiencing in your current architecture.
How this feature ties into some other cool concepts, like Azure Data Lake Storage Gen2 or the Common Data Model, obviously can't be missing from this speech.
Expect to walk out of this session with a decent grasp on the underlying architecture, and some key takeaways to take home with you.
SessionID: 96359
Presentation Skills for the Technical Professional
Event Date: 19-10-2019 - Session time: 10:45:00 - Track: Other
Speaker: Buck Woody
Title: Presentation Skills for the Technical Professional
Abstract:
SessionID: 91119
SQL Server Big Data Clusters
Event Date: 19-10-2019 - Session time: 12:00:00 - Track: Other
Speaker: Ben Weissman
Title: SQL Server Big Data Clusters
Abstract:
Was bedeutet das konkret? Wir schauen uns an, wie man die neuen Features installiert und nutzt, welchen Mehrwert sie bieten und wo man vielleicht dennoch mit anderen Funktionen besser aufgehoben ist.
SessionID: 92902
Fast like a Roadrunner - Get the M(eep) M(eep) into your M(eep)-Queries?
Event Date: 19-10-2019 - Session time: 12:00:00 - Track: Business Intelligence
Speaker: Frank Geisler
Title: Fast like a Roadrunner - Get the M(eep) M(eep) into your M(eep)-Queries?
Abstract:
SessionID: 93380
How to Get Started with Azure Managed Instance
Event Date: 19-10-2019 - Session time: 12:00:00 - Track: Administration
Speaker: Björn Peters
Title: How to Get Started with Azure Managed Instance
Abstract:
This session will be about how to start with Azure Managed Instances and what you'll need to know before.
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.
SessionID: 94184
Four questions machine learning can answer
Event Date: 19-10-2019 - Session time: 12:00:00 - Track: Analytics
Speaker: Nico Jacobs
Title: Four questions machine learning can answer
Abstract:
The aim of this talk is to help you identify business opportunities in which machine learning can help.
You will see four broad types of business problems for which machine learning can be the right tool for the job.
The next step will be to find answers to these questions. Azure provides many different ways to apply machine learning. In this session you will see demos of 4 different Azure services which can help you answer the questions: Cognitive services, ML Studio, SQL Server ML Services and Databricks.
SessionID: 98781
Das super nerdige Solisyon Quiz
Event Date: 19-10-2019 - Session time: 13:30:00 - Track: Sponsor/Lunch Session
Speaker: Ben Weissman
Title: Das super nerdige Solisyon Quiz
Abstract:
Das super nerdige Solisyon Quiz
SessionID: 98965
Event Date: 19-10-2019 - Session time: 13:30:00 - Track: Sponsor/Lunch Session
Speaker: Oleg Ulyanov
Abstract:
• vCPU allocation and deep dive in vNUMA
• Memory allocation and configurations options
• Storage configuration best practices including PMem/NFS/Snapshots
• Network configuration myths and best practices
It all that you want to know about virtual platform configuration but hesitated to ask! Directly from the source with the ton of hands-on from VMware Professional Services.
BIO: Oleg Ulyanov is a Sr. Solutions Architect focused on Microsoft SQL Server workloads in the Cloud Platform Business Unit. He is a Subject Matter Expert in virtualization, monitoring and performance tuning of business critical applications workloads on VMware vSphere with tons of hands-on directly from customer sites.
SessionID: 99168
SQL Server high availability in cloud and hybrid environments
Event Date: 19-10-2019 - Session time: 13:30:00 - Track: Sponsor/Lunch Session
Speaker: Thomas Jorczik
Title: SQL Server high availability in cloud and hybrid environments
Abstract:
This session, presented by SIOS Technology, will highlight important information business and IT staff need to know to provide both high availability (HA) and disaster recovery (DR) protections for critical applications – and specifically SQL Server – running in public and hybrid cloud environments, as well as on-premise!
SessionID: 99223
Event Date: 19-10-2019 - Session time: 13:30:00 - Track: Sponsor/Lunch Session
Speaker: Erik Monchen
Abstract:
Was ist Kampagnenmanagement und wie kann ich es einsetzen?
Wo kann die Data-Plattform unterstützen? (Real-Life-Beispiele)
- AI mit Phyton in der Datenbank
- Einfacher Zugriff auf externe Daten mit Polybase
- Cloud-Szenarien mit Azure-Data-Factory und Databricks
SessionID: 92900
Event Date: 19-10-2019 - Session time: 14:20:00 - Track: Business Intelligence
Speaker: Stefan Kirner
Abstract:
Die Data Factory steht seit längerem in der Microsoft Azure Cloud für das effiziente Kopieren von Massendaten zwischen vielen Arten von Datenspeichern zur Verfügung. Ergänzt wird dieses Angebot um die Modellierung von Abhängigkeiten zwischen mehreren Verarbeitungsschritten und seit der Version 2 auch durch einen Control Flow für die Abbildung von Schleifen und Bedingungen und dem Ausführen von Integration Services Paketen. Seit kurzem können jetzt auch visuell unterstützt Data Flows für das gezielte Anreichern, Korrigieren und Umwandeln innerhalb der Data Factory genutzt werden!
Der Vortrag zeigt nach einem allgemeinen Überblick zur ADF, die Data Flows und andere top aktuelle Features des Platform-as-a-Service Dienstes mit wichtigen Tipps aus der Praxis.
SessionID: 94883
Inside SQL Server Containers
Event Date: 19-10-2019 - Session time: 14:20:00 - Track: Administration
Speaker: Bob Ward
Title: Inside SQL Server Containers
Abstract:
Containers are the new virtual machines. Containers present a new way to deploy, manage, and run SQL Server never possible before. This session will present an internal view of how Docker containers work and how SQL Server runs in them. Will cover the architecture of containers, how we have built SQL Server to run in containers, and how they work in environments such as Kubernetes. While this is an internal focused session you will walk away with knowledge of practical scenarios where SQL Server in Containers may be the right deployment model for you.
SessionID: 95010
Using Charticulator - How to create No-Code Power BI custom visuals
Event Date: 19-10-2019 - Session time: 14:20:00 - Track: Analytics
Speaker: Thomas Martens
Title: Using Charticulator - How to create No-Code Power BI custom visuals
Abstract:
Charticulator (https://charticulator.com/) a Microsoft research project, enables you to create amazing custom visuals for Power BI without writing any line of code. Charticulator allows you to focus on the data without the need to split your attention between the design and a programming language. This demo packed session focus on the design process and the creation of selected charts. All data used during this session will be available via a GitHub repo with a detailed explanation of how to recreate the examples.
SessionID: 96719
Hybrid Power BI - What is possible? What do you need?
Event Date: 19-10-2019 - Session time: 14:20:00 - Track: Business Intelligence
Speaker: Wolfgang Strasser
Title: Hybrid Power BI - What is possible? What do you need?
Abstract:
Power BI as a cloud-based SaaS solution is not limited to cloud data sources. In many projects, hybrid architectures are the key to successful projects using already existing infrastructure.
Besides the on-premises data gateway, there are additional options how a hybrid approach can bring benefits and lead to better solutions.
SessionID: 92051
Event Date: 19-10-2019 - Session time: 15:40:00 - Track: Administration
Speaker: Rob Sewell
Abstract:
Afraid of PowerShell?
Worried its too complicated?
Don't want to go through the learning curve?
Let me show you with plenty of demos how easy and straight forward it can be and I will save you time starting Monday
Want to restore an entire servers databases to the latest available point in time of the backups in just one line?
Be useful to know the Last DBCC Check for your entire estate in only one line of code?
Need to test your restores but its complicated?
and many many more
All this in a fast paced, fun session
SessionID: 92912
Data Visualization: How to truly tell a great story!
Event Date: 19-10-2019 - Session time: 15:40:00 - Track: Business Intelligence
Speaker: Jonathan Stewart
Title: Data Visualization: How to truly tell a great story!
Abstract:
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…
SessionID: 92941
From Datawarehouse, across BI, to modern data analysis and artificial intelligence, Azure Databricks
Event Date: 19-10-2019 - Session time: 15:40:00 - Track: Analytics
Speaker: Andre Essing
Title: From Datawarehouse, across BI, to modern data analysis and artificial intelligence, Azure Databricks
Abstract:
Have you heard about Azure Databricks? The new kid in the Azure Big Data family? I would do wrong to call Azure Databricks as a managed Apache Spark service, as it is so much more.
In addition to transforming data, Databricks can also be used to analyze and stream data, run your ETL tasks, train Machine Learning models and explore your data. All of that can be done with the powerful compute engine, combined with an integrated development environment.
As a first-class citizen in Azure, Databricks is a Platform as a Service offering that makes Big Data accessible for everybody.
However, as always, the first steps are the hardest to take. Because of that, in this session, we have a look at how to provision Azure Databricks. You learn how to configure clusters, schedule jobs, stay secure and much more.
SessionID: 93722
Agile Data Warehousing
Event Date: 19-10-2019 - Session time: 15:40:00 - Track: Other
Speaker: Christoph Seck
Title: Agile Data Warehousing
Abstract:
Changing requirements, obscure sources, surprising successes - are DWH projects ideal candidates for agile approaches? It's not that easy. No matter if on-prem or “modern” with big data and on Azure: Fixed price requirements, challenging stakeholder setups, missing test cases and often the sheer size of the action, point in a different direction. So, what should be "agile" in DWH projects? And what are the actual benefits?
After a brief reminder of what makes BI / DWH projects "different", we first look at a practice-proven agile approach (test and backlog-driven, etc.). Extra bonbon: Agile projects fixed price.
Afterwards the reality check: What exactly qualifies this process as "Agile”? Are there hidden waterfalls? And which advantages or risks are we dealing with?
We close with discussing how to adapt this to your specific projects and the old debate SCRUM versus Kanban.
SessionID: 99226
Power BI Embedded with RLS Access to the on-prem Data Source
Event Date: 19-10-2019 - Session time: 15:40:00 - Track: Business Intelligence
Speaker: Georg Gamsjäger
Title: Power BI Embedded with RLS Access to the on-prem Data Source
Abstract:
In this session, I invite you to join me on a hike from the on-premise data source to the full Power BI Embedded sample solution. After a steep and long climb, we reach the summit from where we can enjoy the prospect of a complete Power BI Embedded sample solution with the non-domain users getting a Power BI report provided with them with row-level security on an on-premise data source and all without programming skills.
We start with an overview of the requirements for our Power BI Embedded sample solution, then we go to the question: "What is Power BI Embedded?". Next, we focus on how all components of our sample solution interact and configure in detail, and then we publish a first Power BI Report. Next, we want to prove that row-level security works and implement a solution for continuous monitoring.
This is a 1-hour session that is a compact version of the Precon that was scheduled for 18.10.2019.
SessionID: 92840
Event Date: 19-10-2019 - Session time: 17:00:00 - Track: Business Intelligence
Speaker: Felix Möller
Abstract:
These changes come with the challenge of an increasing number of components that have to be manged. However, they provide the benefit of the flexibility and scalability of PaaS services.
This presentation will demonstrate how to build a full modern data platform with CI/CD. Resources will be deployed as ARM templates, a Data Lake is configured and created, a database is deployed, in addition, Azure Analysis Services is configured and finally Power BI reports are deployed to Power BI workspaces. The platforms' glue are Azure Data Factory including the brand new ADF Mapping Flows and Azure Functions.
This enables to spin up a fully configured environment within minutes.
The presentation will demonstrate how to integrate all above technologies based on Azure DevOps.
SessionID: 94420
Statistical Analysis with T-SQL
Event Date: 19-10-2019 - Session time: 17:00:00 - Track: Analytics
Speaker: Dejan Sarka
Title: Statistical Analysis with T-SQL
Abstract:
SessionID: 96162
SQL Server Kubernetes
Event Date: 19-10-2019 - Session time: 17:00:00 - Track: Administration
Speaker: Andrew Pruski
Title: SQL Server Kubernetes
Abstract:
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.
An introduction to Helm
Chaos engineering for SQL Server in Kubernetes using Space Invaders!
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.
SessionID: 96461
Event Date: 19-10-2019 - Session time: 17:00:00 - Track: Business Intelligence
Speaker: Oliver Engels
Abstract: