SQLSaturday #605 - Rheinland 2017

Event Date: 06/10/2017 00:00:00

Event Location:

  • Bonn-Rhein-Sieg University of Applied Sciences
  • Grantham-Allee 20
  • Sankt Augustin, North Rhine-Westphalia, Germany

PDF of Schedule

This event has completed. All data shown below is from the historical XML public data available.

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).

Sessions

This is a list of sessions from the event, based on the schedule in the XML files.

Title: So you installed R, now what? A journey through the Tidyverse

Abstract: By now, all the SQL world should have heard about the R language, especially since Microsoft is committed to integrate it into their data platform products.

So you installed the R base system and the IDE of your choice. But it’s like buying a new car - nobody is content with the standard. You know there are packages to get you started with analysis and visualisation, but which ones?

A bundle called The Tidyverse comes in handy, consisting of packages mostly (co-)authored by Hadley Wickham, one of the brightest minds in the R ecosystem.

We will take a look at the most popular Tidyverse ingredients like ggplot2, dplyr and readr, and we’ll have lots of code demos on real world examples.

Speaker(s):

  • Thomas Hütter

Track and Room: 2 - DEV - Track 2

Title: Zombie Attack Against Clustered Indexes - Who really need them!

Abstract: Clustered Index zombies come out of their graves to make the peace loving Heaps to one of them in your databases. Try to attack them or find a fair way to make them living together in peaceful harmony.

If you ask experts about using a clustered index you will in most cases hear the following statements: Yes, you need a narrow and contiguous clustered index for your table for good performance. Last but not least Microsoft Azure Databases requires clustered indexes but there might be situations when workloads and queries will suffer from wrong implemented clustered indexes.

Watch the demos which show in an impressive way that clustered indexes are not always the best choice. Build your clustered indexes wise or - as the demos will show - forgo for it for a better scaling. Become aware of the pros and cons of Clustered Indexes and make a wise decision when to use clustered indexes and the correct key attributes for it.

Speaker(s):

  • Uwe Ricken

Track and Room: 1 - DBA - Track 1

Title: Enabling Citizen Data Science with Microsoft

Abstract: In times past, Data Science was only for those elite few with a rare combination of skills including advanced knowledge of statistics.

Microsoft has been making sure that everyone can participate in the data revolution by giving people access to predictive API’s, in-database advanced analytics and drag-and-drop predictive experiments. All thanks to SQL Server 2016 and the Cortana Intelligence Suite in Azure.

These advances have given people with less knowledge of statistics and programming the ability to become what Gartner calls citizen data scientists. Should we be worried about fools-with-tools or should we embrace the democratization of data science as the golden age of data?

Using a combination of theory and demo’s, we explore Microsoft’s solutions to ensure democratization of data science and the possible dangers that lurk below the surface.

Speaker(s):

  • Jan Mulkens

Track and Room: 5 - BI - Track 5

Title: Hello, my name is Tux, I would like to join the #SQLFamily - SQL Server goes Linux [DE]

Abstract: SQL Server und Windows, seit Jahren ein unzertrennliches Paar und eine gute Kombination für die Verarbeitung von Daten. Mit SQL Server vNext wird sich dies jedoch ändern, denn aus dem Norden Europas, genauer aus Helsinki, möchte ein kleiner Pinguin der SQL Server Community beitreten.

Die kommende SQL Server Version wird es nicht mehr ausschließlich für Windows geben. Ein Deployment der relationalen Datenbank Engine wird in naher Zukunft auch auf Linux und innerhalb von Docker möglich sein. Somit bietet der SQL Server nun mehr Einsatzmöglichkeiten und Anwendungsfälle als je zuvor.

Aber wie funktioniert SQL Server on Linux? Was wird unterstützt, was nicht? Welche Szenarien sind möglich? Alle diese Punkte möchte in dieser Session besprechen.

Speaker(s):

  • Andre Essing

Track and Room: 4 - Mixed - Track 4

Title: Azure Machine Learning: From Design to Integration

Abstract: Machine Learning is a subfield of computer science concerned with systems that learn from data. So this isn’t about systems that follow explicitly programmed instructions, but rather about systems that find patterns and trends within datasets, and use them to deliver insight and predictions.

In this session, you will learn how an Azure Machine Learning solution comes to life: From the creation of a workspace, to the preparation of data, to experimentation with Machine Learning algorithms, and then finally to the integration and embedding of predictive insights into applications.

This session has been specifically designed to describe Machine Learning fundamentals, and to help enable and inspire existing data professionals taking their first steps to leverage cloud-based predictive models delivered with Azure Machine Learning. It is guaranteed to thrill you with potential, and excite you with the relative ease by which it can be accomplished.

Speaker(s):

  • Peter Myers

Track and Room: 5 - BI - Track 5

Title: Big Data - Big Quality? A governance round-trip through the possibilities of the MS data platform

Abstract: In the times of data explosion, a dazzling array of information streams and unbelievable possibilities of different techniques to manage data via the Microsoft Data Platform, this session asks the question: what about data curation? We dive into the requirements of modern data governance and curation and show in examples, what the Microsoft Data Platform has to offer: Can SQL Server Master Data Service (MDS), Data Quality Services (DQS) and Integration Service (SSIS) help? Which options offers the Azure Data Catalog and how does the Microsoft Common Data Service come into play? We also look at the potential of the new integrated languages in the Data Platform like R or U-SQL. At the end of this session you will have an overview and understanding of the possibilities, that Microsoft Data Platform offers you to address your data curation requirements.

Speaker(s):

  • Oliver Engels

Track and Room: 4 - Mixed - Track 4

Title: Dynamic Data Masking Row Level Security in Azure SQL Database

Abstract: Microsoft has introduced native capability to the database engine around masking sensitive data and restricting access at the row level. Allowing us new options for building more secure Data Platform solutions. However, it is important to understand the differences from our previous options in order to be able to gain the most benefit from these new technologies.

Join me as we look in more detail at how we can engineer these features into our Data Platform solutions. Starting with identifying the problems they are trying to solve, through their core architecture and on to potential design patterns for their use. As with any security technology solution, there are a number of ways to use these features. However, as with all security features there are gaps in coverage, using them effectively in a layered approach is vital.

After this session, you will be in a position to start looking at whether your systems can benefit from these features.

Speaker(s):

  • John Martin

Track and Room: 2 - DEV - Track 2

Title: Das andere NoSQL: Graph DBs

Abstract: NoSQL ist ja inzwischen auch bei uns Microsofties angekommen. Hadoop in diversen Varianten (klar), DocumentDB etc. etc. Einzig bei GraphDBs sieht es noch recht mau aus. Trinity ist inwischen zwar Open Source, rührt sich sonst aber rein gar nicht. Trotzdem: Die Gerüchteküche zu vNext brodelt und spätestens seit der LinkedIn Übername sollte es MS dämmern, dass da noch was ist. Grund genug für uns einen näheren Blick zu riskieren: Was können GraphDBs besser als der NoSQL Rest und unser vertrauter SQL Server? Und warum? Als Beispiel wählen wir den wohl etabliertesten Vertreter, Neo4J. Mal schauen ob der SQL Server dem nicht doch das Wasser abgraben kann. Und vielleicht liefert die Gerüchteküche ja auch schon erstes genießbares ab …

Speaker(s):

  • Christoph Seck

Track and Room: 4 - Mixed - Track 4

Title: Azure Cloud kills SQL BI?

Abstract: Die BI Komponenten des SQL Servers wie SSIS oder SSAS sind seit Jahrzehnten erfolgreich am Markt vertreten und werden mit jedem Release erweitert. Das Public Cloud Angebot Microsoft Azure bietet inzwischen auch viele DWH Komponenten als Platform-as-a-service Dienste an. In dem Vortrag werden diese beiden Welten miteinander verglichen und verschiedene, auch hybride Architektur-Ansätze diskutiert und natürlich gibt es ein Einschätzung ob es SQL BI wie einst dem Radio Star gehen wird.

Speaker(s):

  • Stefan Kirner

Track and Room: 5 - BI - Track 5

Title: Einstieg in SQL Server Integration Services (SSIS)

Abstract: Die Session beginnt mit einem Überblick und einer Vorstellung der “Integration Services”. Wikipedia beschreibt dazu die Informationsintegration als “das Zusammenführen von Informationen aus verschiedenen Datenbeständen”.

Das Einstiegsbeispiel zeigt dazu die Datenzusammenführung mit dem Import-Wizard.

Für komplexere Datenlade-Vorgänge hilft ein Blick in “DWH-Ladevorgänge” sodass sowohl Dimensionen mit Historisierung als auch “inkrementelles Laden” an Beispielen vorgestellt werden..

.. und das alles so, daß Einsteiger sehr gut folgen können.

Speaker(s):

  • Alexander Karl

Track and Room: 6 - Jumpstart (101) - Track 6

Title: Let’s have some fun(ctional) with M (Power Query/Power BI) language!

Abstract: You know how to use Power BI or Power Query to load data from different sources but you want to go further than limiting yourself to the UI? You’re tired to look at auto-generated code and don’t understand the key concepts of this powerful ETL language? Then, this session is for you. During 60 minutes, you’ll learn how to write code in this functional language. Starting with syntax, primitive and structured values; we’ll quickly jump to the creation of expressions and functions and the usage of some recurrent patterns. This session contains many demos and real-life use-cases that you’ll be able to transpose to your own projects.

Speaker(s):

  • Cédric Charlier

Track and Room: 5 - BI - Track 5

Title: ETL und DWH Design mit Metadaten - vom Developer zum Architekten!

Abstract: In dieser Session erörtern wir die Bedeutung von Metadaten für die Beschreibung eines ETL und DWH Designs unter Berücksichtigung von Themen wie initialem Aufbau, Wartung und Support sowie Dokumentation und Compliance. Darüber hinaus sehen wir uns an, wie wir - das richtige Metadaten-Modell vorausgesetzt - mit wenigen Klicks aus dem Modell danach auch eine entsprechende SSIS Solution etc. ableiten können.

Speaker(s):

  • Ben Weissman

Track and Room: 5 - BI - Track 5

Title: Real-world Hybrid solutions with Microsoft SQL Server and Azure

Abstract: The cloud is now a fact of business life, and adoption is growing fast. However, Microsoft has invested heavily in SQL Server 2016. So, the question you need to ask is: What is the best way to extract the highest value from both your on-premises data platform and the cloud? SQL Server 2016 is architected to work smoothly with the cloud in a hybrid environment, helping you overcome complexity while optimize your existing assets. This session will showcase the synergy between features in SQL Server and the cloud by demonstrating a real-world application scenario, highlighting a solution that lets you take advantage of the cloud in your terms without impacting your existing end-user applications. Incorporating the best-of-class features in SQL Server 2016 as well as data platform features in the cloud, including SQL DW. Session and demos will show you how to decrease costs and deployment times, increase customer service, and leverage the hybrid capabilities of SQL Server 2016 smoothly.

Speaker(s):

  • Scott Klein

Track and Room: 3 - Cloud - Track 3

Title: Security für Anfänger

Abstract: „In welcher Zeitung kann man lesen, dass eine Frau ihren Mann aus der Wohnung wirft? In “Schöner Wohnen!”. Was dieser Satz mit Sicherheit im Microsoft SQL Server zu tun hat, erfährt man in diesem einstündigen Überblick über die einzelnen Sicherheitskomponenten von Microsoft SQL Server. Angefangen von den korrekten Sicherheitseinstellungen für das Dienstkonto von Microsoft SQL Server geht es im Treppenhaus der Datenbanken gleich weiter. Welche Rechte sollte man einem Login erteilen, ohne dabei die Sicherheit des Systems oder die Sicherung der Daten zu gefährden. Einmal im „ehrenwerten Mietshaus“ angekommen, möchte man selbstverständlich gleich die nette Mietwohnung beziehen. Aber HALT! - was darf ich überhaupt in meiner Wohnung? Ein Rechtsanwalt ist nach Besuch dieser Session nicht mehr erforderlich. In dieser Session werden die folgenden Schwerpunkte mit Beispielen und Übungen vermittelt: • Richtige Konfiguration des Dienstkontos von Microsoft SQL Server und SQL Server Agent • Die

Speaker(s):

  • Uwe Ricken

Track and Room: 6 - Jumpstart (101) - Track 6

Title: Data Platform für die Cloud

Abstract: Daten stehen im Zentrum fast aller Anwendungen und im Cloud-Zeitalter gibt es nicht nur neue Regeln für Software - Stichwort Apps - sondern auch für die benötigten Technologien und Services einer Data Platform, die die Basis für diese modernen Anwendungen sein soll.

Kein Wunder also, dass sich kaum ein anderer Bereich in Microsoft Azure so schnell verändert wie die Cloud Data Platform. Und dabei geht es keinesfalls nur um “SQL Server in the cloud”. Ganz im Gegenteil. Im Bereich “Data Storage” hat sich DocumentDB als NoSQL-Dokumentendatenbankdienst hinzugesellt. Neue Angebote wie Azure Data Lake haben das Licht der Welt erblickt und speziell der “Analytics” Bereich wartet mit Machine Learning, Stream Analytics, Data Factory und nicht zuletzt Event Hubs mit zahlreichen interessanten neuen Services auf.

Gewinnen Sie in dieser Session einen Überblick über die Plattform und lernen Sie mögliche Einsatzszenarien kennen, damit Sie für Ihre nächsten Datenherausforderungen gewappnet si

Speaker(s):

  • Constantin Klein

Track and Room: 3 - Cloud - Track 3

Title: Women in Technology – Was hat sich im letzten Jahr getan?

Abstract: Nach dem Prinzip “Steter Tropfen höhlt den Stein” möchten wir uns gerne erneut zusammen mit euch dem Thema “Women in Technology” widmen. Dem Rückblick auf Aktivitäten im Umfeld der PASS Deutschland möchten wir gerne eine offene Gesprächsrunde mit euch folgen lassen. Dabei interessiert uns nicht nur, wie ihr die Situation aktuell empfindet, sondern wir würden uns sehr über Feedback freuen, ob und wie sich eure Situation seit dem letzten Jahr geändert hat. Gab es z.B. neue Aktivitäten in eurer Firma? Teilnahmen an Aktivitäten wie “Girl’s day” oder “Komm, mach MINT”. Habt ihr selber Aktivitäten ins Leben gerufen? Oder Wünsche und Vorschläge, was die PASS mal veranstalten soll?

Speaker(s):

  • Gabi Münster

Track and Room: 4 - Mixed - Track 4

Title: Power BI, wie cool ist das denn?

Abstract: Ja, ja, ja… wieder Mal so ne Marketing Session zum Thema Power BI. 5 Minutes to wow oder wie war der Spruch?

Nö, das machen wir mal nicht. Die Abschluß-Session im Beginners Track macht einfach mal, was Spass macht mit PBI. Wie cool ist das denn, bringt den KollegInnen der Data Platform Gemeinde das, was der Speaker richtig wow findet an Power BI und warum man sich dieses Toolset mal näher anschauen sollte.

Wir rauschen ohne viel Slideshow durch die verschiedensten Themen von PBI und schauen uns an, was wir im Bereich von Datentransformation, Modellierung und Visualisierung so alles Feines machen können und was sonst noch so drum herum passiert und Spaß macht. Ist ne coole Sache die Software. Einfach mal reinschauen …

Speaker(s):

  • Oliver Engels

Track and Room: 6 - Jumpstart (101) - Track 6

Title: Worst Practices Less known limitations for Columnstore Indexes

Abstract: Have you ever considered a situation where Columnstore Index can be quite the opposite of what one expect from it? A slow, wasteful source of painfully slow queries, lagging the performance, consuming irresponsible amount of resources … What about some less known limitations for building Columnstore Indexes ? The ones that will bite you suddenly in the middle of the project - when you do not expect it at all ?

Let me show you how to achieve that ;)

Speaker(s):

  • Niko Neugebauer

Track and Room: 1 - DBA - Track 1

Title: ETL in the cloud

Abstract: Welche Möglichkeiten gibt es die klassischen SSIS Pakete für den ETL Prozess in die Cloud zu bringen? In Azure werden hier Data Factory, Runbooks, Logic App oder Functions angeboten. Was verbirgt sich hier hinter den einzelnen Diensten und was kann ich damit machen? Exemplarisch wird hier aufgezeigt wie diese Komponenten zusammengesetzt werden können, um die Bewirtschaftung eines DWH’s in der Cloud zu bewerkstelligen.

Speaker(s):

  • Alexander Klein

Track and Room: 3 - Cloud - Track 3

Title: Power BI for the Data Scientist

Abstract: R is THE language for Data Scientists. Therefore, it is no surprise that Microsoft also integrated it into the latest release of PowerBI. In this session I will show how to use an existing R-script in PowerBI, combine it with other data sources and leverage other native features of PowerBI like cross-filtering, highlighting, etc. The final step is then to publish the workbook to the PowerBI web service, schedule refreshes and share it with your colleagues.​

Speaker(s):

  • Gerhard Brueckl

Track and Room: 5 - BI - Track 5

Title: Was ist SQL?

Abstract: In seiner Session “Was ist SQL?” erklärt Data Platform MVP Frank Geisler was eigentlich genau SQL ist und wie sich SQL von anderen Programmiersprachen unterscheidet. Es wird gezeigt wie man Daten aus einem relationalen Datenbanksystem abruft, filtert und die Anzahl der zurück gelieferten Felder beschränkt. Dann werden wir erste Datenbankobjekte erstellen und sehen wie man in diese Daten einfügen, löschen und verändern kann. Zum Schluss gibt es noch ein bisschen Theorie zum Aufbau relationaler Datenbankschemata und wie man diese per Joins abfragen kann …

Speaker(s):

  • Frank Geisler

Track and Room: 6 - Jumpstart (101) - Track 6

Title: PowerShell for the DBA: Why I love my inner pig-dog

Abstract: 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(s):

  • William Durkin

Track and Room: 1 - DBA - Track 1

Title: FileTables mit Reporting Services im Einsatz

Abstract: Von der Konzepterstellung bis hin zur fertigen Anwendung sehen wir ein Projekt, welches eine Vertragsverwaltung mit FileTables realisiert. Anwender sollen selber in der Lage sein neue FileTables anzulegen und eine Berechtigungsstruktur zu pflegen. Die Reporting Services kommen für die Darstellung der Verträge zum Einsatz und es werden verschiedene Möglichkeiten zur Auswertung gezeigt. Abschließend werden noch andere Möglichkeiten zum Export der Dokumente vorgestellt.

Speaker(s):

  • Christoph Muthmann

Track and Room: 2 - DEV - Track 2

Title: Using Resource Governor for fine grained tuning

Abstract: Resource Governor first appeared in SQL Server 2008, several years ago and since that, very few people tried to use it and actually did that for their production workloads. Neither did you? Then come to my session to see the real world examples on how Resource Governor can help you to optimize your database applications and data processing.

Speaker(s):

  • Sergey Olontsev

Track and Room: 1 - DBA - Track 1

Title: Einführung in SQL Server Reporting Services (SSRS)

Abstract: TBD

Speaker(s):

  • Christian Storms

Track and Room: 6 - Jumpstart (101) - Track 6

Title: “Industrie 4.0” goes SQL Server

Abstract: In dieses Session “verbinden” wir eine SPS (=SpeicherProgrammierbareSteuerung), d.h. konkret die Hardware hinter “Industrie 4.0” mit einem SQL Server um Schaltvorgänge und Messwerte zigfach pro Sekunde in der SQL Datenbank zu persistieren und auszuwerten.

Speaker(s):

  • Alexander Karl

Track and Room: 4 - Mixed - Track 4

Title: SQL Server Installation

Abstract: „Next, Next, Next… Finish“ oder wie man einen SQL Server optimaler bereitstellen kann

Wenn man die gängigen Best-Practices außer Acht lässt, muss man sich nicht wundern, wenn das Essen nicht schmeckt. Nicht nur die richtigen Parameter müssen gesetzt werden, damit die Würze passt, sondern auch schon in der Vorbereitung auf die Zubereitung können Fehler gemacht werden. Und hat man sich die ganze Zeit über an das Rezept gehalten, so wird das Essen auch jedem schmecken, allerdings kommt nach dem Kochen auch noch die Kür… die Gäste wollen gehegt und gepflegt werden, dies sollte man nicht außer Acht lassen. Nur wenn man alles bedacht hat, wird der Abend zu einem großen Erfolg.

Speaker(s):

  • Björn Peters

Track and Room: 6 - Jumpstart (101) - Track 6

Title: Azure Automation - Deployment, Backup und Skalierung von SQL Servern

Abstract: Azure SQL Server oder Azure SQL Datenbank Maintenance mit Azure Automation

  • SQL Datenbanken und Server deployen
  • SQL Datenbanken und Server starten und stoppen/abhängen
  • SQL Server sichern
  • Datenbanken sichern
  • SQL Datenbanken und Server nach Bedarf resizen

Speaker(s):

  • Björn Peters

Track and Room: 3 - Cloud - Track 3

Title: SQL Server and Docker. What, How and Why

Abstract: Docker has come to windows, and also SQL Server is coming to Linux. Can you run SQL Server in Docker? Why would you? In this session I’ll show you what Docker is, what you can use it for and what the use case is regarding SQL Server. I’m using SQL Server on Docker for Windows myself in test environments for instance, it turns out to be very usefull in Continuous Integration and database upgrade testing scenarios. We’ll discuss production scenarios as well.

Speaker(s):

  • André Kamman

Track and Room: 1 - DBA - Track 1

Title: Data Science für Datenbankentwickler

Abstract: Hast Du Dich als Datenbankentwickler schon einmal gefragt, wie Du Deine Datenbank-Projekte mit Data Science Technologien erweitern kannst? Wie kannst Du Dein vorhandenes Wissen wiederverwenden und was muss Du noch lernen? In dieser Session stellt Sascha Dittmann verschiedene Lernpfade vor, um als Datenbankentwickler in die Welt des Data Science eintauchen zu können. Für seine Praxisbeispiele nutzt er dabei verschiedene Werkzeuge, wie beispielsweise die SQL Server R Services, Apache Spark mit dem Microsoft R Server und die R Tools für Visual Studio, um bekanntes Wissen mit Neuen zu vereinen.

Speaker(s):

  • Sascha Dittmann

Track and Room: 2 - DEV - Track 2

Title: Was ist für mich als Datenbankentwickler neu in Visual Studio 2017?

Abstract: In Visual Studio 2017 hat sich einiges im Bereich Datenbankentwicklung getan. In der Enterprise Version sind die Tools SQL Prompt, SQL Search und Readyroll von Redgate hinzugekommen und auch sonst gibt es einiges an Änderungen und Neuerungen. In seinem demolastigen Vortrag wird Dataplatform MVP Frank Geisler diese Neuerungen vorstellen und zeigen wie Datenbankentwickler mit den Tools effektiver und produktiver arbeiten können. Neben der Arbeitserleichterung steht bei den Neuerungen auch DLM (Database LifeCycle Management) im Fokus.

Speaker(s):

  • Frank Geisler

Track and Room: 2 - DEV - Track 2

Abstract: SQL Server 2012 introduced an important extension to its integrated Full-text Search, namely the Statistical Semantic Search. In this session you will learn how to install and configure this new functionality, how to use it to extend your existing full-text search capabilities, and how to utilize it properly to improve your information management solutions. You will learn how to automatically extract key phrases from your documents, and how to find similarities between individual documents of your information corpus based on the key phrases that they contain.

Speaker(s):

  • Matija Lah

Track and Room: 2 - DEV - Track 2

Title: Database tuning advisor vs. database management views

Abstract: Tuning your SQL queries is one of the most important tasks of your daily business but how can we achieve this for existing execution plans? This session is about the difference of the database tuning advisor and the missing index database management views of the query engine. You will learn the limitations of both approaches in order to avoid applying wrong indexes.

Speaker(s):

  • Torsten Strauss

Track and Room: 1 - DBA - Track 1

Title: Der Weg - SQL Server in Azure IaaS und weiter nach PaaS - Azure SQL DB, Elastic Pools DWH

Abstract: Wie baut man eigentlich eine SQL Server VM in Azure richtig auf und warum eigentlich? Ich zeige euch wieso und wo die Reise noch weiter hingeht… Azure SQL Database und Azure SQL DWH.

Speaker(s):

  • Patrick Heyde

Track and Room: 3 - Cloud - Track 3

Title: Azure Analysis Services – The next step to BI in the cloud

Abstract: With Azure Analysis services a new BI service has been made available for cloud development. What is already available, what are chances and expectations for the future? And how might your analysis strategy change because of the cloud?

Speaker(s):

  • Gabi Münster

Track and Room: 3 - Cloud - Track 3

Title: Query Store beim SQL Server 2016 – Licht und Schatten

Abstract: Query Store im SQL Server 2016: Lernen Sie die Möglichkeiten mit dieser neuen Funktion kennen und erfahren Sie, wie Veränderungen in der Performance von einzelnen Statement nachvollziehbar gemacht werden und Tuning-Maßnahmen mit diesen Informationen umgesetzt werden können. Wir werfen einen Blick auf die Details, die Granularität der Daten, Einschränkungen und Anwendungsfälle. Diese Einführung soll Entscheidungshilfe sein, ob ein Verwenden des Query Stores für Ihre Umgebung/Ziele sinnvoll ist.

Speaker(s):

  • Michael Saß

Track and Room: 4 - Mixed - Track 4

Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Gabi Münster

Twitter: - @SQLMissSunshine

LinkedIn: Gabi Münster

Gabi Münster is working as a Business Intelligence consultant and team lead and brings in her experience with SQL Server, data warehousing, relational and multidimensional database design and implementation, report and dashboard design, and Master Data Services, as well as project management into the community as a regional PASS Local Group lead. She is also passionate about motivating other women to start a technical career and therefore initiates and supports “Women in Technology” events. Apart from SQLSaturdays, she also spoke at SQLBits, SQL Nexus, Tuga IT, and 2015’s and 2017’s PASS Summit. In October 2017 Gabi received her first Data Platform MVP award.

Gerhard Brueckl

Twitter: - gbrueckl

LinkedIn: Gerhard Brueckl

Contact: http://blog.gbrueckl.at

Gerhard has been working with Microsoft BI tools since 2006 mainly focusing on Microsoft SQL Server and its components. As a consultant and architect he designed various enterprise BI solutions primary in the German-speaking areas. His personal interest has always been on analytical databases and their capabilities. In 2012 he achieved the SSAS Maestro certification. He is also very active in the community, has its own blog and speaks at conferences all over the world on a regular basis.

Michael Saß

Als Senior Systems Consultant im Bereich Information Management bei Quest in Köln ist er für die SQL Server-, DB2- und VMware-Lösungen verantwortlich. Aufgrund seiner langjährigen Praxiserfahrung kann er die Kunden für einen optimalen Einsatz der Lösungen gut beraten. Nach Abschluss der Ausbildung zum mathematisch-technischen Assistenten arbeitete er bei Itergo, IT-Dienstleister der ERGO Gruppe, als Datenbankadministrator für DB2 auf z/OS und AIX sowie für SQL Server. Er arbeitete in zahlreichen Datenmigrations- und Data Warehouse-Projekten mit. Seit 2006 arbeitet er in seiner jetzigen Position und beschäftigt sich seitdem intensiv mit dem Thema SQL Server. In seiner Freizeit betätigt er sich als Handwerker und Wanderer.

Constantin Klein

Twitter: - KostjaKlein

Contact: http://kostjaklein.wordpress.com

Constantin is working at Syntax Systems GmbH Co. KG. He mainly deals with the design and development of solutions based on Microsoft products and technologies. Since 2010 he was each year designated Most Valuable Professional (MVP) for the Microsoft Data Platform. In addition he is member of the board of Just Community e.V. (http://www.justcommunity.de) and PASS Deutschland e.V. (http://www.sqlpass.de). He also leads the .NET User Group Frankfurt/Germany (http://dnug-frankfurt.de). Find his blog at: http://kostjaklein.wordpress.com

Stefan Kirner

Stefan Kirner ist Teamleiter BI Solutions bei der inovex GmbH in Karlsruhe und besch#228;ftigt sich seit dem SQL Server 2000 mit dem Microsoft BI Stack. In diversen spannenden Business Intellligence Projekten in unterschiedlichsten Branchen hat er als Entwickler, Architekt und Projektleiter die Entwicklung der Microsoft BI amp; Analytics Komponenten von kargen DTS Zeiten an bis heute verfolgt. Inzwischen hat sich der Horizont der Data Management L#246;sungen nat#252;rlich auch auf viele Dienste in der Cloud erweitert. Stefan ist Microsoft Certified Systems Expert (MCSE). Seit 2006 leitet er die SQL PASS Regionalgruppe Karlsruhe und er unterst#252;tzt Microsoft Deutschland als Partner-Technical Solution Professional im Presales Bereich.

Oliver Engels

Twitter: - @oengels

Contact: http://www.ssis-components.net

Oliver Engels is CEO of oh22data AG, a Microsoft Gold Partner in Germany specializing in CRM and BI. His special interests are Azure, Data Governance and Integration, Visualisation Tools like SSRS, Power BI, Tableau, R, and SharePoint. He has worked with SQL Server since version 6.5 and is a founder and Board member of PASS Germany, a PASS Regional Mentor, and runs the Frankfurt PASS Local Group. For more than seven years he is a Microsoft Data Platform MVP and a Microsoft pTSP.

Alexander Karl

Twitter: - sqlfabrik

Alexander Karl is database-developer and certified MCT for Windows and SQL Server with .net-CDE GmbH. For more than 18 years he has been working with Database-, Datawarehouse- and Reporting-Solutions for companies from medium-sized enterprises to Group level. His spectrum includes Serversizing, Programming to optimize performances as well as Report- and Chartdesign; in trainings and seminars he conveys participants well-founded theoretical knowledge complemented with his practical.

Sergey Olontsev

Twitter: - SergeyOlontsev

LinkedIn: Sergey Olontsev

Contact: http://SergeyOlontsev.com/

I have been working with SQL Server since SQL Server 2000 version as a database administrator, developer, consultant and trainer, focusing on high availability and disaster recovery solutions, ETL, troubleshooting and performance tuning, developing high performance solutions . I’m a regular speaker at SQL Server user group meetings, SQLSaturday events and other conferences. An owner of MCM certification and MVP award on SQL Server.

Peter Myers

LinkedIn: Peter Myers

Peter Myers is a consultant, trainer and presenter, and has worked with Microsoft database and development products since 1997. Today he specializes in all Microsoft Business Intelligence products and also authors training course content for Microsoft products and services.

He has a broad business background supported by a bachelor’s degree in applied economics and accounting, and he extends this with extensive experience backed by current MCSE certifications. He has been a Data Platform MVP since 2007.

Frank Geisler

Twitter: - @Frank Geisler

LinkedIn: Frank Geisler

Contact: http://www.gdsbi.de

Frank Geisler is owner and CEO of GDS Business Intelligence GmbH. He is SQL Server MVP, MCT, MCSE – Business Intelligence, MCSE – Data Plattform and MCSE - Azure Solutions Architect. In his Job he is building Business Intelligence Systems based on Microsoft Technology, mainly on SQL Server and SharePoint.

Cédric Charlier

Twitter: - @Seddryck

LinkedIn: Cédric Charlier

Contact: http://seddryck.wordpress.com

Cédric is a talented architect and Data Platform MVP active in the domain of Business Intelligence and Data warehousing. He has more than 10 years of successful experiences with SQL Server in European industrial groups and services companies. Driven by quality and reliability, he is the main developer of an open-source solution for testing BI solutions (cubes, etl, reports) named NBi (www.nbi.io). Cedric also advocates for the introduction and general usage of agile practices in BI’s world.

Scott Klein

Twitter: - SQLScott

Contact: http://aka.ms/sqlscott

Scott Klein is a senior consultant with SQL Solutions Group with over two decades of experience working with Microsoft SQL Server. Prior to SSG, Scott spent almost 10 years at Microsoft, traveling the globe as a technical evangelist training and speaking about SQL Server and Microsoft’s Azure data services. Scott’s recent focus has been on advanced analytics, including big data and IoT, providing real-world training to help bring intelligence to your data. Scott has authored several books focusing on data and data analytics. Scott is continuously striving and looking for ways to help developers and companies grok the wonderful world of data.

Sascha Dittmann

Twitter: - SaschaDittmann

LinkedIn: Sascha Dittmann

Contact: http://www.sascha-dittmann.de/

Sascha Dittmann is working as a Data Solution Architect at Microsoft. In his role he supports customers to implement successful cloud solutions. His focus is on Microsoft Azure, SQL Server Business Intelligence, Big Data as well as Data Science. Before he joined Microsoft in 2015, he was working for Ernst Young as a Software Developer (13 years) and Solution Architect (3 years). During this time he founded the community websites cloudbloggers.de and cloudbloggers.net as well as the user groups .NET Stammtischs Rheinhessen and Xamarin User Group Frankfurt. He’s an author of several technical articles and a regular speaker at user groups and conferences. Between 2012 and 2015 he received 4 Microsoft MVP awards for Microsoft Azure.

Uwe Ricken

Twitter: - https://twitter.com/dbBerater

LinkedIn: Uwe Ricken

Contact: http://www.sqlmaster.de

Uwe Ricken is working with IT systems since the 90’s. The primary passion for developments with Microsoft SQL Server expanded in 2007 with his engagement as a DBA for Deutsche Bank AG in Frankfurt am Main. After 6 years of operational experiences as a DBA and over 14 years as a developer of complex database models he achieved the “Microsoft Certified Master – SQL Server 2008” certification which “was” the highest technical certification. In the same year he earned his first award as a Data Platform MVP for his support to the Microsoft SQL Server community in Germany and Europe. Uwe Ricken is a speaker on many international conferences and events and preferred topics are “Database Internals”, “Indexing” and “Development”.

Patrick Heyde

Twitter: - https://twitter.com/patrickheyde

Contact: http://blogs.technet.com/b/patrick_heyde/

Patrick Heyde ist Technical Evangelist f#252;r SharePoint Development/Office 365 und SQL amp; BI amp; Microsoft Azure. Patrick ist seit 2007 bei Microsoft und in den Schwerpunkten: Performance, Upgrade, Customization, Skalierbarkeit und L#246;sungs- amp; Architekturberatung unterwegs. Seit einiger Zeit baut er aktiv Azure Prototypen auf und unterstützt ISV-Partner bei Ihrer Cloud-Migration. Für diese Projekte sucht zunehmend unterstützenden Partner Consultants mit Azure Know-How.

Björn Peters

Twitter: - https://twitter.com/sql_aus_hh

LinkedIn: Björn Peters

Contact: http://www.sql-aus-hamburg.de

I’ve started with SQL Server 6.5 but only as a sys-admin and not as DBA. Later I’d worked as a full DBA with SQL Server 2000 and my love to SQL Server started. In 2015 I’d got more interested in SQL PASS and tried to speak for the first time… the main part of my job is to work as DB-Admin and solution architect but I’m trying to widen my horizons. In 2016 I’ve visited and volunteered at the German SQLSaturdays und SQLGrillen and since October 2016 I’m the organizer of Azure Meetup Hamburg.

Björn Peters

Twitter: - https://twitter.com/sql_aus_hh

LinkedIn: Björn Peters

Contact: http://www.sql-aus-hamburg.de

I’ve started with SQL Server 6.5 but only as a sys-admin and not as DBA. Later I’d worked as a full DBA with SQL Server 2000 and my love to SQL Server started. In 2015 I’d got more interested in SQL PASS and tried to speak for the first time… the main part of my job is to work as DB-Admin and solution architect but I’m trying to widen my horizons. In 2016 I’ve visited and volunteered at the German SQLSaturdays und SQLGrillen and since October 2016 I’m the organizer of Azure Meetup Hamburg.

William Durkin

Twitter: - @sql_williamd

LinkedIn: William Durkin

Contact: http://williamdurkin.com

William Durkin is a DBA, Data Platform MVP, and Data Platform Architect for Data Masterminds (http://datamasterminds.io). He uses his decade of experience with SQL Server to help multinational corporations achieve their data management goals. Born in the UK and now based in Germany, William has worked as a Database Developer and DBA on projects ranging from single server installations, up to environments spanning 5 continents, using a range of high availability solutions. William is a regular speaker at conferences around the globe, organizes the popular event SQLGrillen (http://sqlgrillen.com).

Gabi Münster

Twitter: - @SQLMissSunshine

LinkedIn: Gabi Münster

Gabi Münster is working as a Business Intelligence consultant and team lead and brings in her experience with SQL Server, data warehousing, relational and multidimensional database design and implementation, report and dashboard design, and Master Data Services, as well as project management into the community as a regional PASS Local Group lead. She is also passionate about motivating other women to start a technical career and therefore initiates and supports “Women in Technology” events. Apart from SQLSaturdays, she also spoke at SQLBits, SQL Nexus, Tuga IT, and 2015’s and 2017’s PASS Summit. In October 2017 Gabi received her first Data Platform MVP award.

Ben Weissman

Twitter: - bweissman

LinkedIn: Ben Weissman

Ben Weissman has been working with SQL Server since SQL Server 6.5, mainly in the BI/Datawarehousing field. He is a Data Platform MVP, MCSE Data Management and Analytics, and a Certified Data Vault Data Modeler. He is also the first BimlHero Certified Expert in Germany and a co-author of ‘SQL Server Big Data Clusters’ and ‘The Biml Book’. Ben has been involved in more than 150 BI Projects and is always looking for ways to become more productive and make SQL Server even more fun! Together with his team at Solisyon, Ben provides training, implementation and consultancy for SQL/BI developers and data analysts in upper-mid-market companies around the globe.

Alexander Karl

Twitter: - sqlfabrik

Alexander Karl is database-developer and certified MCT for Windows and SQL Server with .net-CDE GmbH. For more than 18 years he has been working with Database-, Datawarehouse- and Reporting-Solutions for companies from medium-sized enterprises to Group level. His spectrum includes Serversizing, Programming to optimize performances as well as Report- and Chartdesign; in trainings and seminars he conveys participants well-founded theoretical knowledge complemented with his practical.

Andre Essing

Twitter: - @aessing

LinkedIn: Andre Essing

Contact: http://www.andreessing.de/

Andre Essing advises, in his role as Technology Solutions Professional, customers in topics all around the Microsoft Data Platform. Since version 7.0, Andre gathering experience with the SQL Server product family, where he has focused on infrastructure topics, mission-critical systems and security. Today Andre concentrates on working with data in the cloud, like Modern Data Warehouse architectures, Artificial Intelligence and new scalable database systems like Azure Cosmos DB.

In addition to his work at Microsoft, Andre is engaged in the community as a chapter leader for the PASS chapter in Bavaria, Germany. You can meet him as a speaker at user groups and international conferences.

Frank Geisler

Twitter: - @Frank Geisler

LinkedIn: Frank Geisler

Contact: http://www.gdsbi.de

Frank Geisler is owner and CEO of GDS Business Intelligence GmbH. He is SQL Server MVP, MCT, MCSE – Business Intelligence, MCSE – Data Plattform and MCSE - Azure Solutions Architect. In his Job he is building Business Intelligence Systems based on Microsoft Technology, mainly on SQL Server and SharePoint.

Christoph Muthmann

LinkedIn: Christoph Muthmann

Contact: http://www.insidesql.org/blogs/cmu/

Christoph Muthmann ist seit vielen Jahren mit dem Design und der Administration von Datenbanken besch#228;ftigt. Sein Schwerpunkt ist die Weiterentwicklung und Administration der SQL Server mit #252;ber 600 Datenbanken, welche er seit ca. 1996, beginnend mit der Version 6.5 betreut. Seit 2008 ist er SQL Server MVP, berichtet in seinem Blog auf insidesql.org #252;ber SQL Server und PASS und seit 2010 unterst#252;tzt er aktiv die PASS Regionalgruppe K#246;ln/Bonn/D#252;sseldorf.

Uwe Ricken

Twitter: - https://twitter.com/dbBerater

LinkedIn: Uwe Ricken

Contact: http://www.sqlmaster.de

Uwe Ricken is working with IT systems since the 90’s. The primary passion for developments with Microsoft SQL Server expanded in 2007 with his engagement as a DBA for Deutsche Bank AG in Frankfurt am Main. After 6 years of operational experiences as a DBA and over 14 years as a developer of complex database models he achieved the “Microsoft Certified Master – SQL Server 2008” certification which “was” the highest technical certification. In the same year he earned his first award as a Data Platform MVP for his support to the Microsoft SQL Server community in Germany and Europe. Uwe Ricken is a speaker on many international conferences and events and preferred topics are “Database Internals”, “Indexing” and “Development”.

André Kamman

Twitter: - @andrekamman

Contact: http://andrekamman.com

André Kamman is a DBA and SQL Server Solutions Architect for CloudDBA. He has done a lot of DBA work on 1000’s of servers where he discovered his love for Powershell, architecting SQL Server solutions, building and tuning ETL processes (with BIML). He also likes to work with MPP platforms APS and AzureDW. André is a Data Platform MVP, Dutch PASS Chapter Leader and organiser of SQLSaturday Holland.

Jan Mulkens

Twitter: - https://twitter.com/JanMulkens

LinkedIn: Jan Mulkens

Contact: http://www.janmulkens.be

Jan Mulkens is a Microsoft MVP in AI, a Solution Expert at Ordina Belgium, and a Microsoft Data Platform BI Consultant. In his spare time, he is a speaker at conferences and user groups in Europe and he organizes two user groups and a conference in Belgium. Power BI Days conference (www.powerbidays.com), Belgium Microsoft Advanced Analytics User Group (bit.ly/msaaug), and Flemish Power BI User Group (meetup.powerbibelgium.com).

Oliver Engels

Twitter: - @oengels

Contact: http://www.ssis-components.net

Oliver Engels is CEO of oh22data AG, a Microsoft Gold Partner in Germany specializing in CRM and BI. His special interests are Azure, Data Governance and Integration, Visualisation Tools like SSRS, Power BI, Tableau, R, and SharePoint. He has worked with SQL Server since version 6.5 and is a founder and Board member of PASS Germany, a PASS Regional Mentor, and runs the Frankfurt PASS Local Group. For more than seven years he is a Microsoft Data Platform MVP and a Microsoft pTSP.

Alexander Klein

Twitter: - @SQL_Alex

LinkedIn: Alexander Klein

Alexander Klein is a senior Business Intelligence consultant with more than 15 years of experience. He focuses on Business Intelligence and Data Warehouse projects with Microsoft technologies like SQL Server, Power BI, Azure ML or Cortana Intelligence.

Since 2008, he has been a self-employed consultant in large and medium-sized projects in all sectors across Europe. He has been visiting SQLSaturdays and other Data Conference all over Europe since 2013. Speaker at national and international events since 2017.

Christian Storms

Ich arbeite seit 8 Jahren mit SQL Technologien. Mein Schwerpunkt liegt im Bereich der Visualisierung. Dazu kommen dabei verschiedene Tools zum Einsatz.

Christoph Seck

Christoph works as a BI Architect for KI Performance. With SQL Server and its BI Stack he is dealing for more than 15 years. He is cofounder and chapter leader of the German PASS chapter of Hannover, Visiting Lecturer at the University of Hildesheim and regular speaker at conferences and German PASS events on DWH topics and agile project management.

Thomas Hütter

Twitter: - DerFredo

LinkedIn: Thomas Hütter

Contact: https://sqlfredo.wordpress.com/

Thomas holds a degree in Business Administration, but has been a data explorer and a developer at heart ever since the days of dBase and Turbo Pascal. He touched his first SQL Server at V6.5 and used covering indexes before they became a feature.

Thomas has been developing in Navision/Dynamics/Business Central systems for quite some time (since 2001, one year before MS acquired Navision), joined PASS in 2006 and got his hands on R in 2014 (the year before MS bought Revolution Analytics). He has worked for ISVs as well as end-user companies, as a developer, consultant, accidental DBA and is an author for data-related articles as well as a speaker at SQL events across Europe.

Matija Lah

Twitter: - @MatijaLah

LinkedIn: Matija Lah

Contact: http://milambda.blogspot.com

Matija Lah has more than a decade of experience working with Microsoft SQL Server, mostly architecting data-centric solutions in the legal domain. His contributions to the SQL Server community have led to the Microsoft Most Valuable Professional award in 2007 (Data Platform), which he held until 2017. In 2008 Matija joined SolidQ as a Mentor, located in Central and Eastern Europe. He spends most of his time on projects involving advanced information management, and natural language processing.

John Martin

Twitter: - SQLDiplomat

LinkedIn: John Martin

Contact: https://www.mssqltips.com/sqlserverauthor/291/john-martin/

John Martin is a Data Platform Engineer working in the financial sector, as well as Vice President Marketing for the PASS organization and currently a Microsoft Data Platform MVP. Previously John has worked as a product manager for SentryOne and a Premier Field Engineer with Microsoft UK.

John has over a decade of experience working with SQL Server and the Microsoft Data Platform. Working as a DBA, developer and consultant for Microsoft, he has been lucky enough to see how best, and how not, to use SQL Server and the Data Platform effectively.

Niko Neugebauer

Twitter: - NikoNeugebauer

LinkedIn: Niko Neugebauer

Contact: http://www.nikoport.com

Niko Neugebauer is a Data Platform Consultant. A SQL Server MVP with over 20 years of experience in IT, he is passionate about the Microsoft Data Platform and community. Founder of the Portuguese SQL Server User Group and the main organizer of the first SQLSaturday event outside of North America (#78 Portugal), Niko speaks regularly at events such as PASS Summit, SQLRally, SQLBits, and SQLSaturday events around the world. Niko loves sharing information and knowledge and has authored over 130 blog posts on Columnstore Indexes, and regularly contributes to the open-sourced CISL library focused on Columnstore Indexes.

Torsten Strauss

Torsten Strauß (MVP, MCSE Data Platform, MCSE Data Management and Analytics, MCT) has been working with Microsoft SQL Server since the turn of the millennium. He currently works as Database Engineer and Microsoft SQL Server Evangelist for BP Europe SE and as Principal Consultant for Sarpedon Quality Lab. Torsten has delivered more than 100 presentations about Microsoft SQL Server at national and international conferences and user groups in recent years.

Sponsors

The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page