sqlsathistory

Nr: 579

Back to Main list

SQLSaturday #579 - Vienna 2017

Start Time (24h) Speaker Track Title
10:45:00 David Postlethwaite Administration (Enterprise Database Deployment) SQL 2016 New features [EN]
10:45:00 Suha Güngören BI (Architecture, Development, Administration, Analytics, Vizualization) Data Science Track in the Microsoft Professional (Degree) Program [EN]
10:45:00 Tobias Koprowski Administration (Enterprise Database Deployment) SQL Security in the Cloud [EN]
10:45:00 Florian Mader Development (Application Database) SQL Server on Linux [DE]
10:45:00 Thomas Martens BI (Architecture, Development, Administration, Analytics, Vizualization) R 101 - What is this R thing, and is it worth some effort? [DE]
10:45:00 Markus Ehrenmueller-Jensen Lightning Talks Lightning Talks (Ehrenmüller, Zunzer, Brückl, Monchen Strasser)
10:45:00 Oliver Lintner Cloud Application Development Deployment Introduction into Microsoft Azure [DE]
12:00:00 Gabi Münster Lightning Talks Women in Technology – Ein Thema in Österreich? [DE]
13:00:00 Gianluca Sartori Administration (Enterprise Database Deployment) New Security Features in SQL Server 2016
13:00:00 Cédric Charlier BI (Architecture, Development, Administration, Analytics, Vizualization) Automating the testing of your BI solutions with NBi [EN]
13:00:00 Mario Meir-Huber Cloud Application Development Deployment Doing Hadoop with Azure HDInsight [DE]
13:00:00 LEONEL ABREU Development (Application Database) A time travel with temporal tables [EN]
13:00:00 André Melancia Cloud Application Development Deployment If a machine can learn, why can't YOU learn Azure Machine Learning? [EN]
13:00:00 Emma Page BI (Architecture, Development, Administration, Analytics, Vizualization) Maximierung Ihres Investments in Microsoft mit Pyramid Analytics [DE]
14:15:00 Ben Weissman BI (Architecture, Development, Administration, Analytics, Vizualization) SSIS für Faulpelze – Einführung in Biml [DE]
14:15:00 Mihail Mateev Cloud Application Development Deployment Business Intelligence for Modern IoT Solutions in Microsoft Azure [EN]
14:15:00 Kevin Feasel Development (Application Database) Peanut Butter Chocolate: Integrating Hadoop with SQL Server [EN]
14:15:00 Raoul Holzer Cloud Application Development Deployment Azure 101 for DB Administrators [DE]
14:15:00 Oliver Frost Development (Application Database) Exploring Dark Data with SQL Server 2016 and R [EN]
14:15:00 Chrissy LeMaire Administration (Enterprise Database Deployment) Modern Database Administration using PowerShell and dbatools [EN]
15:30:00 Gianluca Sartori Development (Application Database) SQL Server Infernals: Worst Practices in Action [EN]
15:30:00 Tomaž Kaštrun Administration (Enterprise Database Deployment) SQL Server 2016 R Integration for database administrators [EN]
15:30:00 Gabi Münster BI (Architecture, Development, Administration, Analytics, Vizualization) Multi-client SSAS deployment : What's MDS got to do with? [DE]
15:30:00 Frank Geisler BI (Architecture, Development, Administration, Analytics, Vizualization) Microsoft Business Intelligence für alle mobilen Plattformen [DE]
15:30:00 Dejan Dular Development (Application Database) In the name of the resources: Aggregating data [EN]
15:30:00 Andreas Wolter Administration (Enterprise Database Deployment) Extended Events – The Top Features for efficient Traces [DE]
16:45:00 Janos Berke Administration (Enterprise Database Deployment) What is new in SQL Server 2016 Availability Group [EN]
16:45:00 Oliver Engels BI (Architecture, Development, Administration, Analytics, Vizualization) Apply the Power of Azure Data Lake Analytics to Your BI Landscape [DE]
16:45:00 Mario Schnalzenberger Cloud Application Development Deployment IoT in the wild [DE]
16:45:00 Alexander Klein Cloud Application Development Deployment Recommendations in Azure ML and Cognitive Services [DE]
16:45:00 Sergiy Lunyakin BI (Architecture, Development, Administration, Analytics, Vizualization) Azure SQL Data Warehouse: What, Where, How [EN]

SessionID: 54394

SQL 2016 New features [EN]

Back to calendar

Event Date: 20-01-2017 - Session time: 10:45:00 - Track: Administration (Enterprise Database Deployment)

Speaker: David Postlethwaite

Title: SQL 2016 New features [EN]

Abstract:

SQL 2016 is now here packed with new features such Always Encrypted, Dynamic Data Masking, temporal tables, stretched tables, Query Store, Live Query stats and more. This talk gives an overview of what#39;s new and improved in SQL Server 2016 and demonstrates some of these features

SessionID: 54418

Data Science Track in the Microsoft Professional (Degree) Program [EN]

Back to calendar

Event Date: 20-01-2017 - Session time: 10:45:00 - Track: BI (Architecture, Development, Administration, Analytics, Vizualization)

Speaker: Suha Güngören

Title: Data Science Track in the Microsoft Professional (Degree) Program [EN]

Abstract:

Gain the skills you need to help you get the job you want - and use new, innovative solutions and knowledge services to build up your skills.

When you apply for a job in data science, employers want to know if you can analyze and visualize data with Excel or Power BI and whether you can use R or Python to explore the data. They also want to know that you understand key topics, like statistics and machine learning.

Use the latest tools to solve real-world data problems It takes more than knowledge to be effective as a data scientist—technical skills and real-world experience with data are critical. The courses in the Microsoft Professional Program include hands-on labs so you can practice with tools used by data scientists in the field today.

We show you in that session, how you can benefit from this Microsoft Professional Degree Program - Data Science, how we enrich the Microsoft content with additional services and what you can expect from this best-of-breed solution

SessionID: 54525

SQL Security in the Cloud [EN]

Back to calendar

Event Date: 20-01-2017 - Session time: 10:45:00 - Track: Administration (Enterprise Database Deployment)

Speaker: Tobias Koprowski

Title: SQL Security in the Cloud [EN]

Abstract:

Our data should be secure. And our environment too. What we can do for maximize security in a hybrid environment, where SQL Server exist in two forms: premise and cloud. How organize our job, how control our data if we use Windows Azure SQL Database - The Cloud Database. Physical security, policy based management, auditing, encryption, federation, access and authorization. All of those subjects will be covered on my session.

SessionID: 54673

SQL Server on Linux [DE]

Back to calendar

Event Date: 20-01-2017 - Session time: 10:45:00 - Track: Development (Application Database)

Speaker: Florian Mader

Title: SQL Server on Linux [DE]

Abstract:

“I double checked the calendar but it's not 1th April...” (‏@ildivenire) Tatsächlich, am 7. März 2016 stellt Microsoft Pläne für SQL Server auf Linux vor. Warum Microsoft das tut, wie SQL Server on Linux so manchen Entwicklungsprozess revolutionieren kann und was mit den Preview Releases bereits möglich ist, zeige ich in meiner Session.

SessionID: 55144

R 101 - What is this R thing, and is it worth some effort? [DE]

Back to calendar

Event Date: 20-01-2017 - Session time: 10:45:00 - Track: BI (Architecture, Development, Administration, Analytics, Vizualization)

Speaker: Thomas Martens

Title: R 101 - What is this R thing, and is it worth some effort? [DE]

Abstract:

SessionID: 56676

Lightning Talks (Ehrenmüller, Zunzer, Brückl, Monchen Strasser)

Back to calendar

Event Date: 20-01-2017 - Session time: 10:45:00 - Track: Lightning Talks

Speaker: Markus Ehrenmueller-Jensen

Title: Lightning Talks (Ehrenmüller, Zunzer, Brückl, Monchen Strasser)

Abstract:

Markus Ehrenmüller-Jensen: Burst Your Sun (Glasses) - Improve your Datavizualisation

Heino Zunzer: Testing your database with tSQLt Gerhard Brückl: Polybase – Big Data meets SQL Server Erik Monchen: SQL Server Reporting Services - What's new Wolfgang Strasser: Power BI und ihre On-Premises Daten

SessionID: 56893

Introduction into Microsoft Azure [DE]

Back to calendar

Event Date: 20-01-2017 - Session time: 10:45:00 - Track: Cloud Application Development Deployment

Speaker: Oliver Lintner

Title: Introduction into Microsoft Azure [DE]

Abstract:

Microsoft Azure is a flexible, open, and secure cloud built for business. It provides access to a broad collection of integrated cloud services that accommodate many languages and operating systems. Join this session to get an introduction into the cloud platform and discover, at a high level, what powerful data and analytics services it provides.

SessionID: 54708

Women in Technology – Ein Thema in Österreich? [DE]

Back to calendar

Event Date: 20-01-2017 - Session time: 12:00:00 - Track: Lightning Talks

Speaker: Gabi Münster

Title: Women in Technology – Ein Thema in Österreich? [DE]

Abstract:

Weltweit ist die Anzahl von Frauen in technischen Berufen und speziell in der IT niedriger als in anderen Berufsgruppen. Wie gestaltet sich die Situation in Österreich? Und welche Gründe könnten hierzulande Einfluss darauf haben?

In einer offenen Gesprächsrunde möchten wir euch Zahlen und Fakten zu dem Thema sowie eigene Erfahrungsberichte präsentieren. Viel mehr sind wir aber an euren Erfahrungen und Meinungen interessiert? Musstet ihr Hindernisse in euren Berufsweg überwinden? Wünscht ihr euch Frauen im Team? Seid ihr auf der Suche nach Angestellten und würdet euch über weibliche Mitarbeiter freuen? Jeder ist hier gefragt und willkommen.

Genauso wichtig ist für uns, wie ihr die Rolle der PASS in diesem Kontext seht. Können wir etwas tun? Sollten wir auch? Was würdet ihr euch von uns wünschen?

Wir freuen uns auf eine rege Beteiligung. :-)

SessionID: 54359

New Security Features in SQL Server 2016

Back to calendar

Event Date: 20-01-2017 - Session time: 13:00:00 - Track: Administration (Enterprise Database Deployment)

Speaker: Gianluca Sartori

Title: New Security Features in SQL Server 2016

Abstract:

In this session we will explore the new features introduced with SQL Server 2016 to enhance security.

Always Encrypted is a new technology that protects your data not only at rest, but also throughout the whole interaction between the application and the database. Dynamic Data Masking is another interesting feature that allows us to protect sensitive data by masking it to all users that don’t have enough privileges to see the actual contents. Row Level Security allows showing to end users only the data they’re entitled to access, without changing the applications’ code. We will demonstrate the use of these three features with example applications and we will explore the use cases where these technologies represent a big leap from previous custom implementations.

SessionID: 54850

Automating the testing of your BI solutions with NBi [EN]

Back to calendar

Event Date: 20-01-2017 - Session time: 13:00:00 - Track: BI (Architecture, Development, Administration, Analytics, Vizualization)

Speaker: Cédric Charlier

Title: Automating the testing of your BI solutions with NBi [EN]

Abstract:

If you want to accelerate the testing of your BI solutions, the best strategy is the automation of your tests with the help of a dedicated framework. During this session, we’ll take a look to the features of the open-source framework named “NBi” (www.nbi.io). This framework is providing support for automated tests on the fields of databases, cubes, reports and ETLs, without the need of .Net skills. The demos will show us the best approaches to quickly and effectively assert the quality of BI developments. We'll go a step further, generating the tests by an interesting system of templates and test-cases sources.

SessionID: 55037

Doing Hadoop with Azure HDInsight [DE]

Back to calendar

Event Date: 20-01-2017 - Session time: 13:00:00 - Track: Cloud Application Development Deployment

Speaker: Mario Meir-Huber

Title: Doing Hadoop with Azure HDInsight [DE]

Abstract:

SessionID: 55052

A time travel with temporal tables [EN]

Back to calendar

Event Date: 20-01-2017 - Session time: 13:00:00 - Track: Development (Application Database)

Speaker: LEONEL ABREU

Title: A time travel with temporal tables [EN]

Abstract:

Temporal Tables is a new feature in SQL Server 2016, that allows to see the data (in one or more tables) exactly as they were in a point of time ago.

In this session will be shown the most useful scenarios:

  1. Auditing efects
  2. Trending Analytics
  3. A cloud based approach to handle Historical Data

SessionID: 55066

If a machine can learn, why can't YOU learn Azure Machine Learning? [EN]

Back to calendar

Event Date: 20-01-2017 - Session time: 13:00:00 - Track: Cloud Application Development Deployment

Speaker: André Melancia

Title: If a machine can learn, why can't YOU learn Azure Machine Learning? [EN]

Abstract:

Are you a DBA or Developer and would like to get started with AzureML the EASY WAY?

AzureML isn't just for "data scientists"... Anyone can use it! And after this session you'll be using it too... Disclaimer: Sadly, AzureML still can't predict what's on your girlfriend's mind. Nothing ever will.

SessionID: 56697

Maximierung Ihres Investments in Microsoft mit Pyramid Analytics [DE]

Back to calendar

Event Date: 20-01-2017 - Session time: 13:00:00 - Track: BI (Architecture, Development, Administration, Analytics, Vizualization)

Speaker: Emma Page

Title: Maximierung Ihres Investments in Microsoft mit Pyramid Analytics [DE]

Abstract:

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-Markt 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 und hören Sie dazu hilfreiche Praxisbeispiele.

SessionID: 54090

SSIS für Faulpelze – Einführung in Biml [DE]

Back to calendar

Event Date: 20-01-2017 - Session time: 14:15:00 - Track: BI (Architecture, Development, Administration, Analytics, Vizualization)

Speaker: Ben Weissman

Title: SSIS für Faulpelze – Einführung in Biml [DE]

Abstract:

Jeder der sich mit dem Thema Datenbeladung per SSIS beschäftigt weiß: Viel von dem was wir tun ist weder technisch anspruchsvoll noch kreativ. Es ist eine Wiederholung der Wiederholung der Wiederholung. Warum also nicht langweilige Tasks automatisieren und sich auf die spannenden Themen konzentrieren? In diesem Vortrag schauen wir uns in einigen Demos gemeinsam an, wie sich eine komplette Staging-Umgebung mit BIML aufbauen und warten lässt.

SessionID: 54740

Business Intelligence for Modern IoT Solutions in Microsoft Azure [EN]

Back to calendar

Event Date: 20-01-2017 - Session time: 14:15:00 - Track: Cloud Application Development Deployment

Speaker: Mihail Mateev

Title: Business Intelligence for Modern IoT Solutions in Microsoft Azure [EN]

Abstract:

This talk is about the main types of BI, used in IoT systems. Presentation is also about the most used Azure components, related to BI. You will see several real-life examples for BI in IoT solutions in different areas: smart energy systems, charging stations for electric cars and logistic systems.

SessionID: 54870

Peanut Butter Chocolate: Integrating Hadoop with SQL Server [EN]

Back to calendar

Event Date: 20-01-2017 - Session time: 14:15:00 - Track: Development (Application Database)

Speaker: Kevin Feasel

Title: Peanut Butter Chocolate: Integrating Hadoop with SQL Server [EN]

Abstract:

So you jumped on the bandwagon and set up a Hadoop cluster…but now what? Your database developers and app developers know how to integrate with and develop against SQL Server, but the Hadoop world is a completely different experience. This talk will help bridge the gap between SQL Server and Hadoop, using tools such as SQL Server Integration Services and Sqoop to migrate data between a Hadoop cluster and a SQL Server instance, as well as PolyBase to integrate the two like never before.

SessionID: 54906

Azure 101 for DB Administrators [DE]

Back to calendar

Event Date: 20-01-2017 - Session time: 14:15:00 - Track: Cloud Application Development Deployment

Speaker: Raoul Holzer

Title: Azure 101 for DB Administrators [DE]

Abstract:

Die Cloud ist derzeit das Thema in der IT. Microsoft hat mit seiner Cloud Plattform Azure eine umfassende Lösung für die Entwicklung und den Betrieb von Anwendungen bereitgestellt, die in vielen Szenarien (Serverless-Computing, Mobile-Anwendungen, etc.) eingesetzt werden kann. Da es auch für Datenbank Administratoren und Entwickler interessant ist, welche Anwendungen auf meine Datenbank zugreifen, möchte ich in dieser Session einen kurzen Einblick in die verschiedenen Services von Azure liefern. Mit prägnanten Beispielen wird gezeigt, wie diese eingesetzt werden können und in Verbindung mit einem SQL Server stehen. Ebenso möchte ich zeigen, wie die Verwaltung und Einrichtung eines Azure-Kontos funktioniert und welche Tipps und Tricks es gibt, um Kosten zu sparen.

SessionID: 55084

Exploring Dark Data with SQL Server 2016 and R [EN]

Back to calendar

Event Date: 20-01-2017 - Session time: 14:15:00 - Track: Development (Application Database)

Speaker: Oliver Frost

Title: Exploring Dark Data with SQL Server 2016 and R [EN]

Abstract:

With the addition of R into SQL Server 2016, Microsoft have provided a few extra degrees of freedom for the standard SQL developer. You can now use the R language to wrangle, clean and collect external data, using libraries and functionality that simply wasn’t available to you before with regular T-SQL. Performing data enrichment at scale with SQL Server or even Microsoft R Server can provide extremely valuable new insights for your clients and start reaping the benefits of big data.

In this session, Consolidata’s Oliver Frost shows you how to develop your own application for tapping into ‘dark data’. Ollie will demonstrate how to stream live tweets, perform aggregations in R and pipe the output to a Power BI dashboard, giving you a full end-to-end experience of the importance of learning some basic R code in 2016.

This session is for anyone who is new to R and is interesting expanding their skill set beyond their comfort zone in SQL Server.

SessionID: 55134

Modern Database Administration using PowerShell and dbatools [EN]

Back to calendar

Event Date: 20-01-2017 - Session time: 14:15:00 - Track: Administration (Enterprise Database Deployment)

Speaker: Chrissy LeMaire

Title: Modern Database Administration using PowerShell and dbatools [EN]

Abstract:

In this session, I’ll feature some crazy useful PowerShell commands from the dbatools module. This SQL Server-centric toolset, which has evolved into an open-source community project with over 20 contributors, includes commands like Remove-SqlDatabaseSafely, Set-SqlTempDbConfiguration, Find-SqlDuplicateIndex, Show-SqlWhoIsActive, Test-SqlPowerPlan and Repair-SqlOrphanUser.

Join for me for this electric, demo-heavy session to learn how to greatly simplify your life as a DBA.

SessionID: 54357

SQL Server Infernals: Worst Practices in Action [EN]

Back to calendar

Event Date: 20-01-2017 - Session time: 15:30:00 - Track: Development (Application Database)

Speaker: Gianluca Sartori

Title: SQL Server Infernals: Worst Practices in Action [EN]

Abstract:

Let’s face it: Best Practices are too many to really know them all and choose which ones should be applied first. Does your telephone ring all the time? Do your users ask for that “quick report” that instead takes ages and keeps changing every time you think it’s done?

Have you ever thought that in dire times avoiding Worst Practices could be a good starting point and you can leave fine tuning for a better future? If the answer is “yes”, then this session is for you: we will discover together how not to torture a SQL Server instance and we will see how to avoid making choices that in the long run could turn out to be not as smart as they looked initially.

SessionID: 54592

SQL Server 2016 R Integration for database administrators [EN]

Back to calendar

Event Date: 20-01-2017 - Session time: 15:30:00 - Track: Administration (Enterprise Database Deployment)

Speaker: Tomaž Kaštrun

Title: SQL Server 2016 R Integration for database administrators [EN]

Abstract:

SQL Server 2016 came equipped with R Microsoft Server and native integration of R Language.

R is a powerful language and environment for statistical computing, data mining, predictive analytics and visualizations.

This session will explore possibilities on how R integration can work for DBA. And how it can help them with their daily tasks. Extending the possibilities of statistical analysis and predictions beyond customer related world into administrative world.

SessionID: 54702

Multi-client SSAS deployment : What's MDS got to do with? [DE]

Back to calendar

Event Date: 20-01-2017 - Session time: 15:30:00 - Track: BI (Architecture, Development, Administration, Analytics, Vizualization)

Speaker: Gabi Münster

Title: Multi-client SSAS deployment : What's MDS got to do with? [DE]

Abstract:

A typical business case: A customer needs an analytical approach for several departments. Some requirements are identical, others differ. How do you design your architecture? Do you prefer building one big solution containing everything or do you build several small solutions, repeatedly building the shared requirements?

In this session we are looking into one possible approach: Build a large solution containing all client views. Maintain the client-specific master data in MDS 2016. The client specific deployment is designed to use AMO based on a client specific configuration.

But how about the Tabular mode? Let's find out together if we can apply a similar approach by using TOM, the AMO extension for tabular model in SQL Server 2016.

SessionID: 54843

Microsoft Business Intelligence für alle mobilen Plattformen [DE]

Back to calendar

Event Date: 20-01-2017 - Session time: 15:30:00 - Track: BI (Architecture, Development, Administration, Analytics, Vizualization)

Speaker: Frank Geisler

Title: Microsoft Business Intelligence für alle mobilen Plattformen [DE]

Abstract:

Cloud First, Mobile First! Das gilt auch für SQL Server 2016. In dieser Session betrachten wir die mobilen Fähigkeiten von SQL Server 2016. Der Reporting Service hat nun umfangreiche Möglichkeiten, um Daten und Analysen auf mobilen Geräten darzustellen Die Session beleuchtet Erstellung, Datenzugriff, Sicherheit, Design und Verteilung und zeigt an Beispielen, dass die Reporting Services 2016 wirklich „Mobile First“ sind. Ein Vergleich mit den mobilen Lösungen von Power BI, der Cloud-Lösung für Self-Service-BI, rundet die Session ab.

SessionID: 54945

In the name of the resources: Aggregating data [EN]

Back to calendar

Event Date: 20-01-2017 - Session time: 15:30:00 - Track: Development (Application Database)

Speaker: Dejan Dular

Title: In the name of the resources: Aggregating data [EN]

Abstract:

The queries that are used for reports are usually the least efficient because you are dealing with huge amounts of data from tables sometimes joined many, many times. In this session we will go through good and bad examples of aggregating the data from your relational database. You will see tips on how to get good use of the indexes, how to lower the number of actual table queries and other tricks that will make your queries run faster.

SessionID: 56195

Extended Events – The Top Features for efficient Traces [DE]

Back to calendar

Event Date: 20-01-2017 - Session time: 15:30:00 - Track: Administration (Enterprise Database Deployment)

Speaker: Andreas Wolter

Title: Extended Events – The Top Features for efficient Traces [DE]

Abstract:

Extended Events, which entered the product in SQL Server 2008, are replacing the old SQL Trace Profiler - and there are many good reasons for that. In this session you will see a selection of the most fascinating possibilities using this Tracing Framework. If you want to find out how to trace in a flexible and lightweight way, how to do advanced analysis directly inside the GUI, how to audit Database and Table-access without Auditing, how to analyze deadlocks without old-fashioned TraceFlags based on the built-in system_health session, this session is just for you. You will also learn how to use the GUI in an effective way for top-down-analysis and what is possible with some XQuery scripting.

SessionID: 54841

What is new in SQL Server 2016 Availability Group [EN]

Back to calendar

Event Date: 20-01-2017 - Session time: 16:45:00 - Track: Administration (Enterprise Database Deployment)

Speaker: Janos Berke

Title: What is new in SQL Server 2016 Availability Group [EN]

Abstract:

SQL Server 2016 has lots of new features and changes in Availability Group. This session is about the new things and demo about the followings: Workgroup cluster + AAG, Direct Seeding, DB_FAILOVER and Load balancing secondary replica.

SessionID: 54885

Apply the Power of Azure Data Lake Analytics to Your BI Landscape [DE]

Back to calendar

Event Date: 20-01-2017 - Session time: 16:45:00 - Track: BI (Architecture, Development, Administration, Analytics, Vizualization)

Speaker: Oliver Engels

Title: Apply the Power of Azure Data Lake Analytics to Your BI Landscape [DE]

Abstract:

Azure Data Lake Analytics (ADLA) is a new service from Microsoft for Analytics on Big Data Workload. U-SQL as a query language offers extraordinary query and transformation power by combining C# and SQL together. Nice! But: How do you integrate this service into your existing BI workload?

In this session you will learn how to integrate relational databases (SQL Azure DB, Azure DWH, or SQL Server) by federation with ADLA, how to trigger jobs from on-prem systems like SSIS, and how to orchestrate the service via Azure Data Factory. Through live demos you will see that this service gives you great computing power for your BI landscape and integration is not that difficult.

SessionID: 55143

IoT in the wild [DE]

Back to calendar

Event Date: 20-01-2017 - Session time: 16:45:00 - Track: Cloud Application Development Deployment

Speaker: Mario Schnalzenberger

Title: IoT in the wild [DE]

Abstract:

In this session the learnings and architecture of an implemented IoT prototype will be presented. It implements a full working IoT solution with as less as possible individual coding and as such ready “made” components were preferred. Therefore, components like Azure IoTHub, Azure Stream Analytics, Azure Data Factory, Azure Logic Apps, Azure SQL Database, Power BI, and many more were put together. The implemented approach includes alarming, aggregation (Stream Analytics) and concludes with Machine Learning processes.

You will see an active solution with all parts working in a ready-made demo up to the dashboards in Power BI. So get ready for an interesting practical view on IoT in the "wild".

SessionID: 56177

Recommendations in Azure ML and Cognitive Services [DE]

Back to calendar

Event Date: 20-01-2017 - Session time: 16:45:00 - Track: Cloud Application Development Deployment

Speaker: Alexander Klein

Title: Recommendations in Azure ML and Cognitive Services [DE]

Abstract:

Wer schon erste Erfahrungen mit Azure ML gesammelt hat, der weiß wie schwer es ist zum Teil ein passenden Algorithmus zu finden, der auf die gestellt Aufgabe passt.

Die Cognitive Services werden immer mächtiger und einfach anzusprechen.

Mit dem Fokus auf Vorschläge (Kunden die dieses Produkt kauften, kauften auch ...) vergleiche ich Azure ML und Cognitive Servies Recommendations. Das Ergebnis ist bei beiden das gleiche, ein Vorschlag welcher Artikel auch interessant sein könnte. Nur das wie ist für den Developer deutlich anders.

SessionID: 56178

Azure SQL Data Warehouse: What, Where, How [EN]

Back to calendar

Event Date: 20-01-2017 - Session time: 16:45:00 - Track: BI (Architecture, Development, Administration, Analytics, Vizualization)

Speaker: Sergiy Lunyakin

Title: Azure SQL Data Warehouse: What, Where, How [EN]

Abstract:

Have you heard about Azure SQL DWH? Do you want to move your current DWH into the Cloud? Can I use Azure SQL DWH like my regular DWH on-premise?

In this session I'm going to answer on these questions. Also, I will prodive information where is better to use Azure SQL DWH and what is more important, how to use it.