Build Schedule

Advanced Filters:
  • Track

    clear all








  • Speaker


  • Level


  • Session Type

Sessions Found: 27
It is 2016! Launch year! For the Data Platform Community at no time there were more possibilities and tools to transform data with Microsoft than today! This session will help you to find a way through the jungle. Based on a use case, we compare the tool sets in live demos and show the different approaches and when to choose what. We provide a decision matrix including the comparison by the variety of data sources, learning curve, security, scalability and many more. 
In this comparison you will find "M" (Power Query Language), SSIS (Integration Services), POLY (Polybase integration in SQL Server 2016), ADF (Azure Data Factory), ADLA (Azure Data Lake Analytics / U-SQL) and R (the Statistical Scripting Language that ships now with SQL 2016)
This gives you a good starting point for new data transformation projects or to review existing under the new approaching technologies.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence (BI)

Level: Beginner

Session Code:

Date: October 08

Time: 12:00 PM - 1:00 PM

Room: Track 4 - BI

Mit dem SQL Server 2016 wurden im Bereich Analytics durch die Integration von R neue Möglichkeiten geschaffen. Die Integration von R in den SQL Server bietet dabei Möglichkeiten, die weit über Ad-Hoc Analysen hinaus gehen. 
In der Session zeigen wir, wie man ein Vorhersagemodell in R in eine Standard-Software-Lösung integriert. Dafür haben wir eine Vorhersage für eine Kennzahl im ERP der Firma abas auf Basis von reellen Unternehmensdaten  entwickelt und in die Lösung integriert. Zusätzlich präsentieren wir den konkreten Weg zur Entwicklung des Vorhersagemodells sowie die Integration in abas ERP.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence (BI)

Level: Intermedia

Session Code:

Date: October 08

Time: 2:30 PM - 3:30 PM

Room: Track 4 - BI

When I joined runtastic.com to build their very first centralized data warehouse with Microsoft SQL Server, no one really felt in charge of the server – so the responsibility fell into my humble hands. Besides my duties as a business intelligence architect (designing & implementing the database, ETL & cube), I had to quickly come up with a solution for the most important administrative tasks:
•	Disaster Recovery and Failover
•	Database Maintenance
•	Capacity Management
•	Job & Performance Monitoring
In this session I will invite you to discuss the pros & cons of the solutions I came up with and you will leave the session with helpful concepts and scripts which you can use freely.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Administration (DBA)

Level: Beginner

Session Code:

Date: October 08

Time: 2:30 PM - 3:30 PM

Room: Track 1 - DBA

What exactly does it mean to have optimistic concurrency? What is the alternative? Is SQL Server 2012's SNAPSHOT Isolation optimistic? How can SQL Server 2014’s In-Memory OLTP provide truly optimistic concurrency? In this session, we’ll look at what guarantees the various isolation levels provide, the difference between pessimistic and optimistic concurrency, and the new data structures in SQL Server 2014 that allow the enormous benefits of having totally in-memory storage with no waiting!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Development (DEV-OPS)

Level: Intermedia

Session Code:

Date: October 08

Time: 12:00 PM - 1:00 PM

Room: Track 2 - DEV

In this session we take a look and a deep dive into Aure Data Lake, a new feature on Azure that will enable amost anyone to work with BIG DATA. It combines C# and SQL to a language that is way more intuitive than what we are used to.

Azure Data Lake Store, our new repository for data of various origins – we can collect, store and share data from this lake as we see fit. Azure Data Lake Analytics, a new way to scale and use your analytics on AZURE and BIG Data, it introduces U-SQL a new language combined of C# and T-SQL to make the task of analyzing BIG Data easier and more comprehendible. Azure Data Lake Tools for Visual Studio, provide an integrated development environment that spans the Azure Data Lake, dramatically simplifying authoring, debugging and optimization for processing and analytics at any scale. After this session, you will have an understanding of the new feature, and will hopefully be inspired to use it either in a Proof Of Concept or in a Production scenario.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud & Big Data

Level: Intermedia

Session Code:

Date: October 08

Time: 10:45 AM - 11:45 AM

Room: Track 3 - Cloud

Bauer BI hat's nicht einfach. Viel Arbeit im Stall und dann soll er noch Daten über seine Schweine auswerten! Mit Excel kennt er sich ja aus, aber wie soll er hier für die Kontrolleure vom Landwirtschaftministerium eine Übersicht erstellen? Wie gut dass es seinen Nachbarn gibt - der stellt Bauer BI einen neuen Gehilfen im Datenstall vor: Power BI! 
Begleiten Sie uns auf der Datenanalysereise von Bauer BI und Power BI. Vielleicht kommt ja auch noch real-time streaming aus dem Schweinestall hinzu und schon haben wir ein Power BI Dashboard für das Landwirtschaftministerium. Und Bauer BI ist glücklich..
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence (BI)

Level: Beginner

Session Code:

Date: October 08

Time: 5:15 PM - 6:15 PM

Room: Track 4 - BI

Wer schon erste Erfahrungen mit Biml gesammelt hat, der weiß, welches Potenzial dahinter steckt. Er weiß aber auch, dass es sich um einen Baukasten handelt - viele Funktionen muss man sich mühsam erarbeiten. Oder man übernimmt sie einfach! In dieser Session zeigt Deutschlands erster und einziger BimlHero anhand von Beispielen, wie ihr eure Biml Solutions mit Hilfe von BimlScript und LINQ auf die nächste Ebene bringt. Unter anderem betrachten wir Themen wie Timestamps und sonstige derived columns (sowohl mit Transformern als auch manuell), Beibehaltung von Indizes aus dem Warehouse oder Vorsystem
sowie die Inkrementelle Übernahme von Änderungen in eine Staging Area. Den verwendeten Beispielcode gibt es natürlich direkt zum mitnehmen, selbst ausprobieren und weiterentwickeln.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence (BI)

Level: Intermedia

Session Code:

Date: October 08

Time: 3:45 PM - 4:45 PM

Room: Track 4 - BI

Columnstore Technology has received one of the biggest number of improvements across all SQL Server 2016 technologies. Discover Operational Analytics and InMemory Analytics for the OLTP workloads with updatable Nonclustered Columnstore Indexes, Data Warehousing with vastly enhanced Clustered Columnstore Index that now can have all the typical functionalities of a well-designed & high performing database such as Unique Constraints, Foreign Keys and Secondary Indexes. Discover all the maintenance improvements that will allow to operate and manipulate the Columnstore structures with more precision and insights.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Development (DEV-OPS)

Level: Intermedia

Session Code:

Date: October 08

Time: 9:15 AM - 10:15 AM

Room: Track 2 - DEV

Have you ever been in the situation that an application performed well the last day and - suddenly - you run into problems? Although you have Index Maintenance jobs and statistics up to date you will monitor a big degrade of performance! This session will demonstrate in a over 80 percent demo based presentation the following scenarios which happend this way in real life!
- Why performance degradation in spite of maintenance jobs?
- just one more database in the result set and the query runs really bad - why?
- usage of literals is completely different from the usage of variables - why?
- identical data types but the query runs in part perfect and in part bad...
- your execution plan shows an INDEX SEEK - but the table will be scanned!
- you get a query from the business which performs really bad but when you test it it runs pretty cool - why?
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Development (DEV-OPS)

Level: Intermedia

Session Code:

Date: October 08

Time: 10:45 AM - 11:45 AM

Room: Track 2 - DEV

Um nach dem Mittagessen wieder langsam wach zu werden, veranstalten wir mit euch das ultimative SQL Quiz - freut euch auf Fragen um alles rund um den SQL Server aus verschiedensten Kategorien!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Sponsor Session

Level: Beginner

Session Code:

Date: October 08

Time: 1:30 PM - 2:30 PM

Room: Track 1 - DBA

Polybase is a feature originally coming from APS but is now finally also available in native SQL Server 2016. It allows you to query external data sources, foremost Hadoop, directly from within SQL Server and combine it with any other data that already resides in your database. Especially the rise of the whole Hadoop data platform in the current markets makes this feature very interesting and is definitely worth a closer look. This session will guide you through the process of setting up Polybase on Hadoop and Azure Blob Stores, showing some real-world use-cases and highlight the most common pitfalls that you may encounter.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud & Big Data

Level: Advanced

Session Code:

Date: October 08

Time: 5:15 PM - 6:15 PM

Room: Track 3 - Cloud

Your cold data growth is getting out of control, storage consumption is increasing faster than your budget, your end-users won't (or can't) tell you what can delete or truncate, but they demand their cold or archived data always be online and available. Now you have tables so big that you dread re-indexing, and you have to look for ever more creative solutions to manage this data, while still remaining compliant. There’s a solution that lets you take advantage of the Cloud, on your terms, all without impacting your existing end-user applications or queries. Come find out how you can move your data securely and transparently, free up disc space and reduce your enterprise storage consumption, while retaining full control from the on-premises SQL Server. You’ll reduce maintenance operations time and resources, plus lower overall cost. Learn how SQL Server Stretch database will simplify your journey to the Cloud!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud & Big Data

Level: Intermedia

Session Code:

Date: October 08

Time: 2:30 PM - 3:30 PM

Room: Track 3 - Cloud

Heute im Angebot eine Gericht das sowohl den Data-Veganer, als auch den Deep-Learning-Fruitarier befriedigen sollte: Cognitive Services Allerlei. Unser Chefkoch serviert eine ausgewogene Mahlzeit aus ein bisschen Computer Vision, gespickt mit ein wenig Spracherkennung. Natürlich darf der orientalische Geschmack von Language Understanding in Form von LUIS nicht fehlen. Immer wieder werden nebenbei klassische Geschmacksknospen angesprochen in Form von ein wenig Grundlagen zum Thema Deep Learning. Abschließend werden wir uns ein buntes Dessert aus Bot Framework gönnen. Natürlich werden Demos und Anwendungen dem ganzen Gericht einen runden Abschluss bieten. Ein guten Appetit wünschen wir schon im Voraus.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud & Big Data

Level: Beginner

Session Code:

Date: October 08

Time: 12:00 PM - 1:00 PM

Room: Track 3 - Cloud

With the introduction of SQL 2016 and all its new features, Hybrid BI is more in focus then ever. Doing BI is no longer bound to be on-premise or in the cloud. With all the new features and the Azure platform Microsoft has made it easier then ever to implement a hybrid platform.

When working with a hybrid platform your organisation will be able to select strategy and features based on the highest ROI. During this session I will go through three different aspects of Hybrid BI which is infrastructure, data-storage and reporting. 

As part of this i will go through the advantages and disadvantages of each area to supply you with the information you need to choose the right direction for your platform.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud & Big Data

Level: Intermedia

Session Code:

Date: October 08

Time: 9:15 AM - 10:15 AM

Room: Track 3 - Cloud

Have you ever seen this message "Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON" ?
Have you ever witnessed Kerberos mentioned in a conversation - or in a forum - and seen developers shiver, sysadmins crawl back under their rock and project managers fear for the consumed hours ?
Have you ever wondered why it seems so complicated ?
If you answered yes to any of these question then this demo-packed session is for you.
Because Kerberos is something that anyone who must deploy SQL Server wishes they didn’t have to worry about. It truly affects all aspects of SQL Server including the engine, Reporting Services, Analysis Services, SharePoint and PowerPivot. Furthermore we will have a close look at how to diagnose problems and troubleshoot the three-headed beast when it breaks loose.
This session is based on many hours spent sweating in setting up Kerberos in BI and SharePoint environments and explaining support people how to troubleshoot and fix Kerberos issues when they a
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence (BI)

Level: Intermedia

Session Code:

Date: October 08

Time: 10:45 AM - 11:45 AM

Room: Track 4 - BI

Die Datennutzung, d.h. die effektive Sammlung, Auswertung und Reporting von organisationsrelevanten Informationen, ist eine der wichtigsten Aufgaben, die CIOs derzeit als wettbewerbsfähigen Vorteil betrachten und für die CFOs bereit sind, erheblich zu investieren.
Zahlreichen branchenführenden Unternehmen ist es bereits gelungen, ihre Geschäftsabläufe von „datenblind“ auf „datengestützt“ umzustellen. Der Business Intelligence (BI)-Bereich wächst zweistellig.
Erfahren Sie in diesem Vortrag, wie Sie mit BI Office Ihr Investment in Microsoft optimieren können und zu einem datengestützten Unternehmen werden. Sehen Sie, wie dies mit Microsofts Power BI zusammenspielt. Hören Sie dazu auch hilfreiche Praxisbeispiele.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Sponsor Session

Level: Beginner

Session Code:

Date: October 08

Time: 1:30 PM - 2:30 PM

Room: Track 2 - DEV

How easy is it to hack a SQL Server? 
In this session we'll see a few examples on how to exploit SQL Server, modify data and take control, while at the same time not leaving a trace.
We'll start by gaining access to a SQL Server (using some "creative" ways of making man-in-the-middle attacks), escalating privileges and tampering with data at the TDS protocol level (e.g. changing your income level and reverting without a trace after payment), and more. 
Most importantly, we'll also cover recommendations on how to avoid these attacks, and take a look at the pros and cons of new security features in SQL Server 2016.
This is a demo-driven session, suited for DBAs, developers and security consultants (Jedi level). 
Disclaimer: No actual state secrets will be revealed. Please do not send agents to my house again.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Administration (DBA)

Level: Beginner

Session Code:

Date: October 08

Time: 3:45 PM - 4:45 PM

Room: Track 1 - DBA

There are many community scripts out there that DBAs can use without having to write them yourself. Like Ola Hallengrens scripts, or Brent Ozars or sp_WhoIsActive by Adam Machanic. But how about Powershell? Turns out, this world is still a bit unknown to the DBA but there is a fast growing community with extremely useful scripts for day to day SQL Server management. In this session we will take a look into my favourite scripts and we will also write a bit of Powershell ourselves.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Administration (DBA)

Level: Intermedia

Session Code:

Date: October 08

Time: 5:15 PM - 6:15 PM

Room: Track 1 - DBA

We will cover the following scenarios:
o	Loading JSON data into the database
o	Transforming Data with the database
o	Servicing JSON to the application layer
o	Advanced scenarios when working with JSON
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Development (DEV-OPS)

Level: Intermedia

Session Code:

Date: October 08

Time: 3:45 PM - 4:45 PM

Room: Track 2 - DEV

Kennt ihr das? Man möchte keinen weiteren Scope mehr in seinem Cube implementieren, weil man die Seiteneffekte nicht mehr überblickt? Oder weil man mit jeder Berechnung um die Performance fürchtet?
Gerade mulitdimensionale Lösungen können so komplex werden. Die Möglichkeiten sind vielfältig und mit zunehmender Komplexität wird es immer schwieriger, die Auswirkungen einer Änderung zu testen. Diese Session kann das Problem auch nicht lösen, aber an konkreten Praxisbeispielen Probleme und Lösungsmöglichkeiten aufzeigen.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence (BI)

Level: Intermedia

Session Code:

Date: October 08

Time: 9:15 AM - 10:15 AM

Room: Track 4 - BI

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