Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 24
What if we could analyze a single query with thirteen different performance problems? In this session we’ll explore a query, understand and fix all thirteen problems. 

1- There is a nonsargable filter
2- An index is missing
3- It is a query optimizer mistake
4- The subquery is unnecessary
5- Query join order is incorrect
6- A filtered statistic is missing
7- Scalar functions are running twice per each row
8- High number of reads on worktable
9- An unknown syntax could be used
10- Memory grant wasn’t enough
11- Distributed query doesn't look good
12- Residual predicates
13- Avoid window spool ondisk
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Intermedia

Session Code:

Date: October 27

Time: 3:40 PM - 4:40 PM

Room: Redmond

Immer mehr Firmen möchten die Microsoft Public Cloud Azure nutzen, wissen aber nicht so recht wie man die Datenbanken dorthin bekommt.
Neben dem virtuellen Server gibt es auch die Azure SQL Databases, welche in zahlreichen Solution völlig ausreichend sind und sich flexibel an die Bedürfnisse anpassen lassen.
Dieser Vortrag zeigt die verschiedenen Möglichkeiten des Deployments ebenso der Migration und gibt Hinweise, worauf bei der Migration zu achten ist bzw welche Features eventuell (noch) fehlen.
Es wird eine Demo-reiche Session, aus der jeder etwas mitnehmen kann wie zum Beispiel Powershell-Ideen, Ansätze für Hochverfügbarkeit oder wie man Kosten reduzieren kann.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Administration

Level: Beginner

Session Code:

Date: October 27

Time: 5:00 PM - 6:00 PM

Room: New York

Microsoft released SQL Azure more than eight years ago - that's enough time for testing. So, are you ready to move your data to the Cloud? If you’re considering a business (aka production environment) in the Cloud, you need to think about methods for back up your data, a backup plan for your data and, eventually (sic!) restoring data. 

In this session, you’ll see the differences, functionalities, restrictions, and opportunities in SQL Azure DB and On-Premise SQL Server 2008/2008 R2/2012/2014/2016/2017. We will look for topics such as how to be prepared for backup and restore, and which parts of a cloud environment are most important: keys, triggers, indexes, prices, security, service level agreements, etc.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Administration

Level: Beginner

Session Code:

Date: October 27

Time: 3:40 PM - 4:40 PM

Room: New York

Mit der neuen Azure Datenbanklösung will Microsoft nun den nächsten Schritt nach den PaaS Lösungen einer Azure Datenbank als Single DB und Elastic Pool machen. Was bringt die neue Lösung nun für Vorteile. In dieser Session soll die neue Lösung den bisherigen gegenübergestellt werden und auf die Möglichkeiten eingegangen werden.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Administration

Level: Beginner

Session Code:

Date: October 27

Time: 12:00 PM - 1:00 PM

Room: New York

The use of securing your code in source control and testing it automatically with a continuous integration tool is not something developers need to be convinced of. But DBAs have traditionally not used any of these techniques. It's also not that straight forward for them. Checking the outcome of a typical DBA script usually involves the need for infrastructure to be available in a certain state and tests that check the changes made to that infrastructure. This session will combine an introduction level talk about Git(hub) and Continuous Integration with the complexity of Infrastructure testing aimed ad DBAs.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Administration

Level: Intermedia

Session Code:

Date: October 27

Time: 2:20 PM - 3:20 PM

Room: New York

Conmmon Data Services are a quite new offering in the Microsoft Data Platform. This session will explain how to use it in combination with Power BI, Apps or Dynamics 365. We will have a closer look in using CDS for Data Governance, Analytics and App Development. We will show loading scenarios in Power Query style, but also detect the Master Data functionality in the cool service.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: October 27

Time: 9:15 AM - 10:15 AM

Room: Washington

Getting a PoC for a Blockchain project running is hard enough. Connecting Blockchain data to classical databases, making them available to analytics or standard applications is worse (ever queried LevelDB?).
Microsofts  new "Azure Blockchain Workbench" let you do this in hours, not months. 
We will see how to
- Deploy a Blockchain on Azure in a breeze
- Generate templates for smart contracts
- Connect them to IoT devices
- Interact with the contracts via a simple UI
- Get all the data into a "real" database automatically
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Beginner

Session Code:

Date: October 27

Time: 9:15 AM - 10:15 AM

Room: Chicago

If you are releasing new reports, SSAS cubes or SSIS packages on a regular basis, you've probably offered up your share of blood, toil, tears and sweat on getting them delivered into production in working condition.
Continuous Delivery is a way to bridge the gap between developers and IT professionals and for that we need to address the both the toolchain to support the practices as well as the mindset on the team. Microsoft offers a set of tools that'll help you on your journey towards the end goal: Maximize predictability, efficiency, security and maintainability of operational processes.

We will in detail be looking at:

Agile Development Frame of Mind
        The Path Ahead (direction)
	Visual Studio Online (tool)
	Feature/User Story/Work Item (concept)
Team Services
	Code Branching (concept)
	Build Agents (tool)
        Releases (tool)
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: October 27

Time: 12:00 PM - 1:00 PM

Room: Washington

In a real data mining or machine learning project, you spend more than half of the time on data preparation and data understanding. The R language is extremely powerful in this area. The Python language is a match. Of course, you do work with data by using T-SQL. You will learn in this session how to get data understanding with really quickly prepared basic graphs and descriptive statistics analysis. You can do advanced data preparation with many data manipulation methods available out of the box and in additional packages fro R and Python. After this session, you will understand what tasks the data preparation involves, and what tools you have in SQL Server suite for these tasks.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics

Level: Advanced

Session Code:

Date: October 27

Time: 2:20 PM - 3:20 PM

Room: Redmond

This session focuses on the deeper integration of SQL Server Integration Services (SSIS) in Azure Data Factory (ADF) and the broad extensibility of Azure-SSIS Integration Runtime (IR). We will first show you how to provision Azure-SSIS IR – dedicated ADF servers for lifting & shifting SSIS packages – and extend it with custom/3rd party components. Preserving your skillsets, you can then use the familiar SQL Server Data Tools (SSDT)/SQL Server Management Studio (SSMS) to design/deploy/configure/execute/monitor your SSIS packages in the cloud just like you do on premises. Next, we will guide you to trigger/schedule SSIS package executions as first-class activities in ADF pipelines and combine/chain them with other activities, allowing you to inject/splice built-in tasks/data transformations in your ETL/ELT workflows, automatically provision Azure-SSIS IR on demand/just in time, etc. And finally, you will learn about the licensing model for ISVs to develop paid components/extensions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: October 27

Time: 3:40 PM - 4:40 PM

Room: Washington

Proper indexing is a very time and cost-effective way to improve SQL performance. Yet hardly anyone gets it right or knows how different ways to write a query affects indexing and performance. In this session I'll explain why this knowledge is sparse and what developers can do about it. Finally we will go through the most important indexing mistakes by example and discuss them during a short live quiz with the audience.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Intermedia

Session Code:

Date: October 27

Time: 2:20 PM - 3:20 PM

Room: Chicago

Azure Cosmos DB is Microsoft's globally distributed, multi-model database. This is NoSQL in the cloud. In this session, you'll see how to use it to create columnar tables, JSON documents and graphs, you'll understand what that means, see what's the difference with relational tables, and how it can be useful for you.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Beginner

Session Code:

Date: October 27

Time: 3:40 PM - 4:40 PM

Room: Chicago

You are already familiar with T-SQL and are eager to learn R but do not know where to start? Start from what you already know: T-SQL. Both languages have many things in common on some levels, but are very different on others. You will learn how to begin your first steps in the new language and how to perform the most common tasks, typical for R: statistics, machine learning & data visualization.
This session will kick you off to the new language by using analogies from T-SQL. You will learn how to write your first R-scripts, make usage of packages and will leave this session with a basic understanding of typical use-cases of R and how to integrate that into your existing environment with SQL Server.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Analytics

Level: Beginner

Session Code:

Date: October 27

Time: 10:45 AM - 11:45 AM

Room: Redmond

You have heard about Biml? Maybe even seen a session about it before but still have doubts, how easy you can make something useful out of it? In this session, we’ll use Biml to build and populate a staging area including the corresponding SSIS packages. But there won’t be any pre-compiled demos! Everything is happening live! Starting with a blank staging database, we’re going to end up with a complete solution over the course of this session, to prove that it is not just easy to adapt existing Biml code but also to start from scratch and still be successful very quick!

Let’s see, how that goes…
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: October 27

Time: 10:45 AM - 11:45 AM

Room: New York

Power BI: Minutes to create and seconds to impress. 

Yes, it takes minutes to create and share Power BI reports. Which means every user who has relevant Power BI access can create Workspaces, Apps, reports, dashboards and schedules. With no deployment strategy, maintaining Power BI service could become a terrible job. 
In this session, I will cover how having a having deployment strategy can make a terrible maintenance job seamless.

This session will include:
What happens when a user creates a Power BI app workspace
How to control user access
Working with different environments
Creating and sharing reports using Power BI Apps 
How to monitor dataset schedules and failure notifications
How to use Power BI API to document your organisation Power BI Service
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: October 27

Time: 10:45 AM - 11:45 AM

Room: Washington

Im, nicht immer ganz ernst gemeinten, Vortrag zeigen Dr. Benjamin Kettner und der deutsche Data Platform MVP Frank Geisler unterschiedliche Einsatzmöglichkeiten von Power BI und Artificial Intelligence am Beispiel einer Datenbank aus dem Bereich Heavy Metal (Finanzdaten kann ja jeder...;)). Es wird sowohl auf Streaming Data wie auch auf die Einbindung von Web-Services wie auch auf verschiedene AI Techniken wie z.B. Klassifizierungsalgorithmen eingegangen. Neben der Technik steht auch der Spaß im Vordergrund dieser lebhaften Session. In diesem Sinne: Metal will never die! ;)
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: October 27

Time: 2:20 PM - 3:20 PM

Room: Washington

DBAs and sysadmins never have time for the fun stuff. We are always restoring  a DB for a dev or setting up a new instance for that new BI project. What if I told you that you can make all that time consuming busy-work disappear?

In this session we will learn to embrace the power in PowerShell to allow us to sit back and relax..... or rather focus on the real work of designing better, faster systems instead of fighting for short time slots when we can do actual work.

Along the way we will see that we can benefit from the wide world of PowerShell expertise and avoid re-inventing the wheel, again!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Administration

Level: Beginner

Session Code:

Date: October 27

Time: 9:15 AM - 10:15 AM

Room: New York

Writing a better code is always a difficult challenge. In this session we are going to investigate some common issues and learn new tips that will help you to be a better developer and then help the DBA keep his databases safer.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Beginner

Session Code:

Date: October 27

Time: 10:45 AM - 11:45 AM

Room: Chicago

Wer mit beliebten KI-Frameworks, wie beispielsweise TensorFlow, CNTK, Caffe, Chainer & Co, ein Modell bauen wollte, musste sich bislang selbst um die komplette Infrastruktur kümmern und seine Data Science IDE entsprechend konfigurieren.
Doch das hat jetzt ein Ende.
In dieser Session zeigt Sascha Dittmann wie man mit der Azure Machine Learning Workbench und dem Azure Batch AI Dienst eine durchgängige und einfach zu nutzende Data Science Umgebung aufbaut. Mit dieser lassen sich dann im großem Umfang parallel experimentieren, sowie Deep Learning- und KI-Modelle trainieren.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics

Level: Intermedia

Session Code:

Date: October 27

Time: 9:15 AM - 10:15 AM

Room: Redmond

There are a lot of possibilities get insights out of your data, and since years we are doing this with "old-fashioned" techniques in our "classical" data warehouse environments. But the world is changing, and so its data.
Where the data years ago was always structured, the growth of different data types now seems to be infinite. We are struggling with saving data with changing schemas and getting insights of new data types like social media, video, and pictures.

In this whiteboard session, I would like to talk with you about modern ways to store, analyze and visualize data. We will draw a Modern Data Warehouse and have a look at the ways to get more insights out of your data and why the cloud could help us.

Come and join my session and draw a Modern Data Warehouse together.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics

Level: Beginner

Session Code:

Date: October 27

Time: 12:00 PM - 1:00 PM

Room: Redmond

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