Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 29
Let me show you how easy it is to use PowerShell to accomplish many everyday tasks straight from the command line with the community developed module dbatools.

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

Session Type:
Regular Session (60 minutes)

Track:
Administration

Level: Beginner

Session Code:

Date: October 19

Time: 3:40 PM - 4:40 PM

Room: Chicago

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

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Intermedia

Session Code:

Date: October 19

Time: 3:40 PM - 4:40 PM

Room: New York

On the one hand, traditional Enterprise Data Warehouses are transforming into modern Data Platforms. On the other hand, onPremise systems are moving to PaaS services in the cloud.

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

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: October 19

Time: 5:00 PM - 6:00 PM

Room: Redmond

Das super nerdige Solisyon Quiz
Speaker:

Accompanying Materials:

No material found.

Session Type:
Sponsor Session (45 minutes)

Track:
Sponsor/Lunch Session

Level: Beginner

Session Code:

Date: October 19

Time: 1:30 PM - 2:15 PM

Room: New York

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

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: October 19

Time: 2:20 PM - 3:20 PM

Room: New York

Do you need a Data Quality Solution? Do you work with Data Quality Services (DQS) or Master Data Services (MDS)? Are you interested what the Microsoft Data Platform has to offer in addition? We will show, based on various demos, how you can leverage Machine Learning Services, Common Data Model, Azure Data Factory, SQL Server 2019, and more to solve data quality problems.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: October 19

Time: 5:00 PM - 6:00 PM

Room: New York

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:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: October 19

Time: 3:40 PM - 4:40 PM

Room: Redmond

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

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: October 19

Time: 9:15 AM - 10:15 AM

Room: New York

In dieser DYMATRIX Sponsor-Session werden diese Themen besprochen:
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
Speaker:

Accompanying Materials:

No material found.

Session Type:
Sponsor Session (45 minutes)

Track:
Sponsor/Lunch Session

Level: Intermedia

Session Code:

Date: October 19

Time: 1:30 PM - 2:15 PM

Room: Washington

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:
Business Intelligence

Level: Intermedia

Session Code:

Date: October 19

Time: 9:15 AM - 10:15 AM

Room: Redmond

Mit Power BI kann man recht schnell komplexe M-Scripte zusammenklicken die das gewünschte Ergebnis liefern. Aber sind diese Scripte auch performant? Welche Einflussmöglichkeiten habe ich als BI Entwickler wenn ich mal wieder eine Folge Punisher auf Netflix gucken kann während Daten mit meiner M-Query geladen werden? Dieser spannenden Frage gehen der deutsche Data Platform MVP Frank Geisler und Dr. Benjamin Kettner in ihrem Vortrag nach. Neben grundsätzlichen Informationen zum Aufbau von M-Scripten in Power BI erfahren Sie, was Sie machen können um langsame M-Queries zu beschleunigen. Sie bekommen direkte Handlungsanweisungen an die Hand gegeben die Sie direkt in eigenen Umgebungen einsetzen können.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: October 19

Time: 12:00 PM - 1:00 PM

Room: Redmond

AI and machine learning are powerful tools! But as with all powerful tools you have to use them to solve the right problem: Even the most powerful hammer cannot do what a simple screwdriver can.

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

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Analytics

Level: Beginner

Session Code:

Date: October 19

Time: 12:00 PM - 1:00 PM

Room: Washington

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

Session Type:
Regular Session (60 minutes)

Track:
Analytics

Level: Beginner

Session Code:

Date: October 19

Time: 3:40 PM - 4:40 PM

Room: Washington

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

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Analytics

Level: Beginner

Session Code:

Date: October 19

Time: 9:15 AM - 10:15 AM

Room: Washington

When it comes to choosing a database, always there are considerations about picking a relational (SQL) or non-relational (NoSQL) data structure. While both are viable options, there are certain key differences between these two options that users must keep in mind.This session will cover the most important distinctions and will make a difference between two of a key players in the Microsoft database world: SQL Server and Azure Cosmos DB.  The session will also illustrate some of the fundamental differences between these databases - the language, scalability and structure which cause this distinctions to have  implications for the right choice.So which database is right for your business the attendance will take informations in this session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Administration

Level: Intermedia

Session Code:

Date: October 19

Time: 10:45 AM - 11:45 AM

Room: Chicago

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

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Administration

Level: Beginner

Session Code:

Date: October 19

Time: 12:00 PM - 1:00 PM

Room: Chicago

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

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: October 19

Time: 2:20 PM - 3:20 PM

Room: Redmond

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

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Administration

Level: Advanced

Session Code:

Date: October 19

Time: 2:20 PM - 3:20 PM

Room: Chicago

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

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: October 19

Time: 10:45 AM - 11:45 AM

Room: Redmond

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

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: October 19

Time: 3:40 PM - 4:40 PM

Room: Redmond

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