SQLSaturday #525 - Rheinland 2016

Event Date: 06/11/2016 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: Best practices in modelling Power pivot.

Abstract: Power pivot in Excel and SQL server have quite similar user interfaces. Beneath that there are huge strategic differences between the desktop and the server product. Excel users knows the business, so they are the best to build models to the company’s needs. So you let the user prototype their models in Excel Power pivot, while bearing in mind that you want to port that model to SSAS Power pivot as a corporate app.

There are best practices you should stick to in order to port the model without problems. This session will discuss the advantage and disadvantages of porting Excel Power pivot model to SSAS. Then there are practices you should learn the Excel user in building formulas, structuring Power pivot models and the way they have to look at data. For the data pro’s there are some tricks to support the Excel user in building their model.

Speaker(s):

  • Henk Vlootman

Track and Room: 5 - BI - Track 5


Title: SQL Server Release Management - SPs, CUs und CODs, ich verstehe nur Bahnhof

Abstract: Ein wichtiges, aber immer wieder stark vernachl#228;ssigtes Thema beim SQL Server ist das Release Management. Warum sollte ich das System auch anfassen, es k#246;nnte ja etwas schief gehen – „Never change a running system“. Es gibt jedoch viele Gr#252;nde warum ein sauberes Release Management und das updaten der Datenbankserver wichtig sind. Angefangen von Bugs die zu einem Datenverlust f#252;hren k#246;nnen, bis hin zu Sicherheitsl#252;cken. Service Packs und Cumulative Updates haben durchaus ihre Daseinsberechtigung. Keine Software ist Fehlerfrei. Damit aber nicht genug, auch die Modernisierung von Systemen geh#246;rt mit zu einem richtigen Release Management mit dazu. Diese Session erkl#228;rt, warum Updates wichtig sind und wann dieses eingespielt werden sollten. Aber auch das Thema Support-Zyklen und das Upgrade auf die eine neuere SQL Server Version werden beleuchtet.

Speaker(s):

  • Andre Essing

Track and Room: 4 - Mixed - Track 4


Title: The (Consumer) Internet of Things on your arm - MS Band PowerBI connected

Abstract: The Internet of Things (IOT) gets more and more attraction - not only on the business but also on the customer side. Connected fridges, cars and smart watches - always and everywhere connected! In this session Wolfgang will show you some possibilities of the Microsoft Band 2 SDK: how-to connect and read sensor data out of this device. But what should be done with that data? Power BI seems to be an ideal candidate for analyzing and presenting those kind of data. The different types of real-time analytics (Stream Analytics, Power BI API, ..) will be presented and their pros and cons will be envisioned. The challenge: Let’s prepare a real-time dashboard of Band2 data in Power BI in 60 minutes!

Speaker(s):

  • Wolfgang Strasser

Track and Room: 4 - Mixed - Track 4


Title: Are Temporal Tables a useful feature?

Abstract: Temporal Tables are a new feature in SQL Server 2016. This session will start with an overview of the basic functionality of Temporal Tables based on a real world scenario. After the core concepts of Temporal Tables have been implemented the session will dive deeper into the functionality of it with all its really great benefits but there is no lunch for free. This session will demonstrate what’s not working fine with Temporal Tables and it’s common drawbacks when you will work with this feature of SQL Server 2016. Fasten seat belts and get an overview of the core concept of Temporal Tables and decide for yourself, whether you would use it or kick it away :)

Speaker(s):

  • Uwe Ricken

Track and Room: 2 - DEV - Track 2


Title: Die Quadratur des Kreises? Wie NoSQL und der SQL Server zueinander finden.

Abstract: Bei der Umsetzung von IoT-Projekten passt die Realit#228;t oftmals nicht zu den hybriden Cloud-Szenarien. Schmalbandige, instabile oder erst gar nicht vorhandene Internetverbindungen sorgen daf#252;r, dass viele Szenarien in der Praxis nicht umsetzbar sind. In F#228;llen, wo eine eingeschr#228;nkte Konnektivit#228;t die Nutzung von Cloud-Services einschr#228;nkt, muss daher eine alternative Architektur entwickelt werden. Die Nutzung g#252;nstiger Devices zur lokalen Datenspeicherung und Vorab-Analyse kann hier eine L#246;sung darstellen. F#252;r die schnelle, ressourcenschonende Datenspeicherung von semi-strukturierten Daten haben sich an vielen Stellen NoSQL Datenbanken etabliert. Wir zeigen, wie eine hybride Architektur aus NoSQL Datenbanken auf Devices im Feld und einem zentralen SQL Server aufgebaut werden kann und welche Vor- und Nachteile sie mit sich bringt.

Speaker(s):

  • Benjamin Kettner

Track and Room: 4 - Mixed - Track 4


Title: Joga f#252;r die Datenbank - Stretch Database in SQL Server 2016

Abstract: Mit dem SQL Server 2012 fing es an, das Backup landete verschl#252;sselt in der Cloud. Mit dem SQL Server 2014 ging es weiter, erste kompletten Datenbank-Dateien (MDF, NDF und LDF) k#246;nnen nativ von der Azure Cloud verschl#252;sselt abgelegt werden (#ByeByeTraditionelleFestplatten) oder auch die Replication mit Cloud gemanaged Datenbanken haben neue Geo-HA-Szenarien -Services erm#246;glicht. Neue Architekturen zu einer flexibleren Hardware-, Software- und Lizenzstruktur entstanden. Mit dem SQL Server 2016 geht die Reise weiter. Lassen sie sich #252;berraschen wie ein SQL Server 2016 mit quasi unbegrenzter Hardware laufen kann. Die Businesssicht soll nat#252;rlich nicht zu kurz kommen mit den Themen Sicherheit und Preis-Kalkulation.

Speaker(s):

  • Patrick Heyde

Track and Room: 3 - Cloud - Track 3


Title: Performanceoptimierung mit Hilfe des Plancache

Abstract: In dieser Session sehen wir, was der Plancache ist und welche unterschiedlichen Informationen er uns geben kann. Wir lernen Parameter f#252;r den Server oder einzelne Datenbanken kennen und wie wir gezielt kleinere oder gr#246;#223;ere Teile des Plancache bereinigen k#246;nnen. Parameter Sniffing und der Einsatz von Plan Guides runden diesen Teil ab. Abschlie#223;end lernen wir ein Dashboard kennen, mit dem wir uns dem Plancache in grafischer Form n#228;hern. Die Analyse unserer Performance-Daten soll uns gezielt einzelne Datenbanken oder Statements zeigen, wo weitere Aktivit#228;ten notwendig sind. Gerade bei Systemen mit vielen Datenbanken wird die genauere Eingrenzung auf die Verursacher der Last vereinfacht.

Speaker(s):

  • Christoph Muthmann

Track and Room: 2 - DEV - Track 2


Title: The current state of Powershell DSC for DBAs

Abstract: Powershell Desired State Configuration (DSC) is a declarative configuration management system. Most DBAs are probably using unattended installs followed by a bunch of post configuration scripts make sure our SQL Server instances are production ready. We will take a look at how Powershell DSC works, and how this can be used by DBAs to install, configure and manage SQL Servers. We will try to answer questions like:

How does Powershell DSC work How would a DBA use Powershell DSC Are the resources to manage SQL Server mature enough

After this session you are better equiped to decide if Powershell DSC is useful for you, now or in the near future.

Speaker(s):

  • André Kamman

Track and Room: 1 - DBA - Track 1


Title: JSON XML; seit SQL 2016 gilt es die jeweiligen Vorteile abzuw#228;gen

Abstract: Die Session beginnt mit „JSON“ und zeigt an einem Syntax-Vergleich die #196;hnlichkeiten zu XML. Sowohl die unterschiedlichen Einsatzszenarien als auch der technische Background von JSON und XML bedingen jedoch einen unterschiedlichen Funktions- und Sprachumfang. Deshalb werden zun#228;chst, soweit m#246;glich, die Parallelen aufgezeigt. Insbesondere die T-SQL Erweiterungen „FOR JSON“ und „OpenJSON“ sind sehr #228;hnlich implementiert im Vergleich zu „FOR XML“ und „OpenXML“. Weiterhin sind jetzt im T-SQL die neuen Funktionen „IsJSON“, „JSON_VALUE“ und „JSON_QUERY“ enthalten. Gibt es diese als T-SQL Funktionen auch f#252;r XML oder k#246;nnen die Ergebnisse mit XML-Methoden berechnet werden ? XML hat dar#252;ber hinaus einige weitere Features, die das Speichern (und indexieren) und Abfragen (insbesondere mit XQuery) in relationalen Tabellen betreffen. Diese werden ebenfalls beispielhaft aufgezeigt. Ziel der Session ist aufzuzeigen, wann welche Sprache jeweils Vorteile bringt.

Speaker(s):

  • Alexander Karl

Track and Room: 2 - DEV - Track 2


Title: Are You a DBA by Accident? Welcome to the Club!

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

  • Markus Ehrenmueller-Jensen

Track and Room: 1 - DBA - Track 1


Title: 360#176; around Azure Data Lake – Storage, Analytics and Development Part 2

Abstract: The second part of the combo will go deep dive into the new language U-SQL. Oliver, Sascha and Tillmann will explain the concepts of the new language as a mix of SQL and C#. They will take Visual Studio and show the power of the new analytical language by creating complex queries, building functionality in C#, creating extractors, using federation to combine different data streams and tools like Azure Data Factory or SSIS to integrate into your landscapes. The combo session will close by explaining how to debug and monitor your U-SQL scripts on the Azure Data Lake Services and what you need to know controlling the service from a cost perspective.

Speaker(s):

  • Oliver Engels

Track and Room: 3 - Cloud - Track 3


Title: Analysieren von SQL Server Workloads mit DMVs und XEvents

Abstract: Diese Session f#252;hrt durch eine beispielhafte Performance-Analyse unter der Verwendung von DMVs und Extended Events. Wir sehen, wie man eine Top-Down Analyse mit eingebauten Tools durchf#252;hren kann und wie man eine feingradige Analyse selbst mittel den „Wait Statistics“ durchf#252;hren kann um Performance-Problemen und Bottlenecks auf die Schliche zu kommen. Zur Identifizierung von Plan-#196;nderungen wird auch die neue Query Data Store von SQL Server 2016 zum Einsatz kommen. Wer auf dem Feld der Performance-Analysen noch neu ist oder sehen m#246;chte, wie man an die Herausforderung herangehen kann, wird hier praktische Einblicke erhalten, wie man eine Workload analysieren kann. – Die Session ist „Profiler-free“ ;-)

Speaker(s):

  • Andreas Wolter

Track and Room: 1 - DBA - Track 1


Abstract: Learn about typical challenges in legal information retrieval, the techniques used in querying data by determining its legal relevance, and how SQL Server 2016 can be used to simplify some of these techniques. For instance, a very important element of legal proceedings is determining which law should be used. Legal rules change over time, resulting in multiple versions of the same law. Laws do not last forever, and can be replaced by other laws (one old law can be replaced by one or more new laws). The timeline of events that are relevant to a particular court case provide one set of criteria to be used to determine the correct law and the correct version of the law. Another example is the trade of products and/or services. In order for a contract to be valid there must be a clear correlation between the offer to buy (or to sell) a product or a service and the corresponding counter-offer. They must both be valid simultaneously, they must both specify the same products or services, and

Speaker(s):

  • Matija Lah

Track and Room: 2 - DEV - Track 5


Title: Rock Solid SQL Server Settings. Not Just “Next, Next, Finish”

Abstract: Default application settings are aimed at the average user. With SQL Server being installed hundreds of thousands, if not millions of times across the globe, this average is inevitably far from your specific use case. With that in mind, we must take a look at what settings are available inside SQL Server that you can change to allow SQL Server to perform better.

We will discuss settings that can provide immediate improvements at the instance, database or object level.

You will leave this session with an understanding of what settings are available to you and how to approach making changes to your environment that can cause great performance improvements, without having to change your applications.

Speaker(s):

  • William Durkin

Track and Room: 1 - DBA - Track 1


Title: Neue Benutzerinteraktionen mit der Cortana Intelligence Suite

Abstract: Die Anforderungen an die Verarbeitung von Daten im Big Data Umfeld liegen auf dem Tisch. Aber bisher musste man sich aus dem Zoo an verf#252;gbaren Azure Services selbst die Richtigen zusammensuchen, um g#228;ngige IoT Szenarien abzubilden: wie z.B. Vorhersagen #252;ber das Kaufverhalten zu treffen oder Predictive maintenance (PdM) L#246;sungen zu entwickeln. Au#223;erdem entwickelt sich die Art, wie Benutzer mit Software interagieren, st#228;ndig weiter. Aus einem Konglomerat an Services wurde daher eine durchg#228;ngige Suite um neuartige und intelligente L#246;sungen zu entwickeln und das Kind hat endlich auch einen Namen: Cortana Intelligence Suite!

In diesem Talk besch#228;ftigen wir uns mit dem gesamten Stack vom skalierbaren Dateneingang, #252;ber die Echtzeit-Datenverarbeitung bis hin zu pr#228;diktiven Vorhersagen und modernen Visualisierungen in PowerBI. Bleibt am Ende immer noch die Frage: Wo steckt nun Cortana? – Aber auch das werden wir in diesem Talk kl#228;ren.

Speaker(s):

  • Constantin Klein

Track and Room: 3 - Cloud - Track 3


Title: SSIS f#252;r Faulpelze – Einf#252;hrung in BIML

Abstract: Jeder der sich mit dem Thema Datenbeladung per SSIS besch#228;ftigt wei#223;: 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#228;sst.

Speaker(s):

  • Ben Weissman

Track and Room: 5 - BI - Track 5


Title: What is the Internet-of-Things and why should you care?

Abstract: You work with SQL Server. Awesome. Starting today you have two choices: 1) you can stick with what you currently do and watch as the technology future passes you by, or 2) you can start learning and working with next big industry trend in data. This session will take you on an end-to-end journey of IoT, the Internet-of-things, from data generation to data movement, discussing topics such as “big data” and looking at all the services and technologies that help you understand your data. Simply, this session will help you understand the Internet or “YOUR” things.

Speaker(s):

  • Scott Klein

Track and Room: 4 - Mixed - Track 4


Title: From SQL to R and beyond

Abstract: You heard about the “R” language and it’s growing popularity for data analysis. Now you need a walk-through on what is possible analyzing your data? Then this session is for you:

You’ll get a short introduction how R came to be, and what the R ecosystem looks like today.

Then we will extract sales data from different companies off a Navision ERP database on SQL Server.

Our data will be cleaned, aggregated and enriched in the RStudio environment. We’ll generate different diagrams on-the-fly to gain first insights.

Finally we’ll see how to use the Shiny framework to display our data on a map, interactively changing our criteria, and showing us where the white spots really are.

Speaker(s):

  • Thomas Hütter

Track and Room: 2 - DEV - Track 2


Title: R Services in SQL Server - Revolution oder Spielzeug?

Abstract: Data Mining war gestern, Data Science ist heute! Mit SQL Server 2016 l#228;sst Microsoft der Sprache R neue Fl#252;gel wachsen. In dieser Session seht ihr die nahtlose Integration der R Services in der SQL Server Datenbank sowie in Reporting Services, welche analytischen M#246;glichkeiten sich dadurch ergeben. Ebenso gehen wir auf die Unterschiede zwischen SQ Server R Services und dem eigenst#228;ndigen R Server bestehen und was es mit ScaleR auf sich hat. Und nat#252;rlich darf auch der Einblick in ein R Projekt nicht fehlen.

Speaker(s):

  • Mark A. Kuschel

Track and Room: 2 - DEV - Track 2


Title: The log, the whole log and nothing but the log

Abstract: This session focuses on the transaction log. It begins with a quick glance on what goes on in and around the log in the different recovery modes. You’ll then get a deep dive into log sequence numbers, how to find them and what that info means. The context for theese demos is the backup database and backup log commands. Finally you’ll see a demo in which we will recover a database from a total data-drive crash without losing one single transaction.It’s all about the log…

Speaker(s):

  • Mikael Wedham

Track and Room: 1 - DBA - Track 1


Title: Join Operatoren

Abstract: In dieser Session (Level 300) stellen wir einen Vergleich zwischen Nested Loop, Merge und Hash Join an. Dabei erarbeiten wir die Vor- und Nachteile (Memory Grant, Performance, IO) und ein Verst#228;ndnis f#252;r die Limitationen dieser Join Operatoren. Am Ende der Session werden wir vorhersagen k#246;nnen, f#252;r welchen Join Operator sich der SQL Server bei einer bestimmten Abfrage entscheidet um ggf. Performanceproblemen zu antizipieren. Ein grundlegendes Verst#228;ndnis der Interpretation des Abfrageplans und -Statistiken wird hierbei vorausgesetzt.

Speaker(s):

  • Torsten Strauss

Track and Room: 4 - Mixed - Track 4


Title: Bioinformatics on Azure

Abstract: If people think about big data, they always think about Twitter or Facebook. But there are other areas where much more data amounts incurred and the analyzes are more complex. In this talk, we talk about a real example from bioinformatics. We will explain the actual scenario and how the various Microsoft platforms from SQL Server to Azure Data Lake and Power BI could help us – or not.

Speaker(s):

  • Tillmann Eitelberg

Track and Room: 4 - Mixed - Track 4


Title: SQL Security in the Cloud

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.

Speaker(s):

  • Tobias Koprowski

Track and Room: 3 - Cloud - Track 3


Title: Cloud Wars – what‘s the smartest data platform?

Abstract: Die gro#223;en Public Cloud Anbieter locken inzwischen mit vielversprechenden Platform-as-a-service Angeboten um Daten jeglicher Art performant und kosteneffizient zu speichern und zu verarbeiten. Neben unterschiedlichen Datenbanken gibt es dazu Dienste f#252;r Batch- und Realtime-Processing. In diesem Vortrag werden einige der wichtigen data-driven-services anhand eines typischen IoT Szenarios aus der Praxis beleuchtet. Dazu gehen drei Schwergewichte des Cloud Business ins Rennen: Microsoft Azure vs. Amazon Web Services vs. Google Cloud Platform

Speaker(s):

  • Stefan Kirner

Track and Room: 3 - Cloud - Track 3


Title: What’s new in Reporting Services 2016?

Abstract: The box is back! Das war das Mantra, das Microsoft auf dem PASS Summit 2015 verbreitet hat. Bezogen auf Reporting Services bedeutet das, dass viel in neue und erweiterte Funktionen investiert wurde. Eine der neuen Funktionen ist, dass Datazen Dashboards und KPIs nun Bestandteil der Reporting Services geworden sind, dass man Reporting Services Berichte auf ein Power BI Dashboard pinnen kann oder dass man Parameter in Berichten besser anordnen kann. In seiner Session wird Data Platform MVP Frank Geisler #252;ber die neuen Funktionen sprechen und diese auch praktisch in zahlreichen Demos demonstrieren.

Speaker(s):

  • Frank Geisler

Track and Room: 5 - BI - Track 5


Title: 360#176; around Azure Data Lake – Storage, Analytics and Development Part 1

Abstract: In the first part of the session combo Oliver, Sascha and Tillmann will explain the concepts behind a data lake, what is different to current approaches of data storage and how it is implement on Azure. They will look behind the scenes and give you advise on data upload, security and how to use the API to integrated Azure Data Lake into your application. With an introduction to Azure Data Lake Analytics, by explaining how to create analytical jobs, how the distribution system YARN works and the creation of the first queries with U-SQL against the data lake this session will end

Speaker(s):

  • Oliver Engels

Track and Room: 3 - Cloud - Track 3


Title: Power BI Desktop – Leveraging the magic of Power BI - ON-PREM

Abstract: It won’t be long before we host the majority of our data, compute power, reporting, and BI visualizations in the cloud, but we’re not all there quite yet. In this presentation, we will discuss ONLY those options that are available on-premises, covering functionality differences between Power BI and Power BI Desktop as well as the critical integration of .pbix dashboards and visualizations with other enterprise reporting and collaboration tools, such as SharePoint, PowerPoint, Excel, and SQL Server Reporting Services. We’ll also highlight the Microsoft BI roadmap for SQL Server 2016, SSRS, Power BI, Datazen, and what it means specifically for on-premise customers.

Speaker(s):

  • Sam Lester

Track and Room: 5 - BI - Track 2


Title: Slowly Changing Dimensions mit den MDS

Abstract: Vieles spricht daf#252;r die Master Data Services in DWH Projekten einzusetzen - und nicht nur dort. In dieser Session wollen wir uns (nach einer kurzen #220;bersicht zu den MDS Basics) auf einen Aspekt konzentrieren: “Slowly Changing Dimensions”. W#228;hrend die neuen Temporal Tables hier viel versprechen und wenig halten, bieten die MDS schon in der alten Version (bis 2014) solide Unterst#252;tzung. Mit dem 2016er wird es dann fast zum Selbstl#228;ufer. Wir werden uns beides anschauen. Vorkenntnisse zu den MDS sind nicht notwendig, solides SQL schon.

Speaker(s):

  • Christoph Seck

Track and Room: 5 - BI - Track 5


Title: Scripting tabular models

Abstract: Introducing the new scripting language for tabular models. Before SQL Server 2016 tabular models was wrapped into a multidimensional constructs. TMSL is the new native language for tabular which is build on JSON - this makes it easy to understand, modify and deploy.

During this session I will go through and explain some examples on generating a SSAS tabular model by using the new TSML to demonstrate how powerfull this feature is and how you can use it to save time and effort.

Speaker(s):

  • Bent Pedersen

Track and Room: 5 - BI - Track 5


Speakers

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

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.

Mikael Wedham

Twitter: - @wedham

Contact: http://www.wedham.com

Mikael Wedham is the first SQL Server MCM in Sweden and the only one who also is a Microsoft Certified Trainer. He has been paid to do things in SQL Server since 1993. His long experience makes him an appreciated speaker at events and conferences all over Europe. To be prepared for deep dives, he is also certified as an Open Water Scuba Instructor.

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.

Markus Ehrenmueller-Jensen

Twitter: - MEhrenmueller

LinkedIn: Markus Ehrenmueller-Jensen

Contact: http://www.savorydata.com

Markus Ehrenmueller-Jensen, as the founder of Savory Data, has a long history of providing customer solutions in the areas of data engineering, data science, and Business Intelligence. He is a certified software engineer, a graduated business educator, and professor of Databases Project Management at HTL Leonding, and is certified as an MCSE MCT. He is a published author and writes articles for well-known journals. He co-founded PASS Austria and organizes SQLSaturdays in Austria. Markus is a founding member of Power BI Usergroup Austria. Since 2017 Markus was awarded as an Microsoft Data Platform MVP.

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

Andreas Wolter

Twitter: - AndreasWolter

LinkedIn: Andreas Wolter

Contact: http://www.andreas-wolter.com/blog/

Andreas Wolter is a Program Manager for SQL Server- and Azure Security at Microsoft. In this role he is working on Security features of SQL Server, Azure SQL Database and Managed Instance. He is currently focusing on “Separation of Duties”-concepts and RBAC-Integration. He has 18 years of experience with SQL Server before joining Microsoft and is the founder of Sarpedon Quality Lab, the Germany-based company specialized on SQL Server HA, Performance and Security. He is Microsoft Certified Master (MCM) for SQL Server and Microsoft Certified Solutions Master for the Data Platform (MCSM) and was recognized as MVP for multiple years in row.

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.

Tillmann Eitelberg

Twitter: - @_Tillmann

LinkedIn: Tillmann Eitelberg

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

Tillmann Eitelberg is CEO and co-founder of oh22information services GmbH, which specializes in data integration and data management. Tillmann is an active blogger at www.ssis-components.net, writing regularly about data quality topics and his passion: spatial data. In addition, he has published several SSIS components on Codeplex and GitHub. Tillmann is a Data Platform MVP, a board member of PASS Germany e.V., a PASS CL for the Cologne/Bonn region, and a PASS RM.

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.

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.

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.

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.

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.

Henk Vlootman

Twitter: - Henk4Excel

LinkedIn: Henk Vlootman

Contact: http://www.vlootman.nl

Henk Vlootman is trainer in Excel and Power pivot to managers throughout the world in the Dutch or English language since 1992. I also do assignments from the industry, partly consultancy and partly direct modelling. I do seminars and congresses. With Michiel Rozema (Rubicon, The Netherlands, I wrote the quot;Practice Book PowerPivot in Excel.quot; At this moment, again with Michiel Rozema I’m finishing a new Power pivot book. I write a monthly blog on Power BI for two different Dutch (financial) e-magazine. I’m manager of the LinkedIn group Power BI Gebruikersgroep. Henk is board member of the Dutch Power BI gebruikersgroep.

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.

Wolfgang Strasser

Twitter: - wstrasser

LinkedIn: Wolfgang Strasser

Contact: http://workingondata.wordpress.com/

Wolfgang Strasser creates solutions based on the Microsoft Data Platform tools in his day-to-day job as Business Intelligence consultant. Either using SQL Server Database Engine, SSIS, reporting with SSAS and SSRS, implementing Power BI solutions or cloud tools for data analysis - the data-tools-landscape is broadening every day! Based on his professional careers as a software developer he likes to work on structured development processes. Wolfgang shares his knowledge with the community at many national and international events. For his community work, Wolfgang has been awarded with the Microsoft MVP Award for Data Platform in October 2015

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.

Bent Pedersen

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

LinkedIn: Bent Pedersen

Contact: http://www.biblog.eu

Bent is a Data Platform MVP and working as Senior Business Analytics Architect at Kapacity A/S, where he have been working with enterprise customers on solutions with SSAS Tabular, SQL Server and in general Azure Data Platform services for the last years. During the past years, he concentrated on working with architecturing, devOps, Automation, testing and simplifying development processes for the Azure Data Platform.

Andre Essing

Twitter: - @aessing

LinkedIn: Andre Essing

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

Andre ist Senior Consultant und Trainer bei der Trivadis GmbH. Er sammelt seit Version 7.0 Erfahrungen mit dem SQL Server und hat seinen Schwerpunkt auf die Infrastruktur gelegt. Spezialisiert hat er sich hierbei auf den Bereich Mission Critical Systems. Neben der T#228;tigkeit als Consultant, vermittelt Andre sein Wissen in Trainings. Au#223;erdem engagiert sich Andre in der Community als Chapter Leader bei der PASS in Bayern und als Organisator des SQLSaturdays in M#252;nchen. Er betreibt einen Blog unter www.andreessing.de.

Tobias Koprowski

Twitter: - @KoprowskiT

LinkedIn: Tobias Koprowski

Contact: http://koprowskit.eu/geek/

Founder of Shadowland Consulting. In January 2015 decided to permanently leave Poland and discover new worlds. Actually settled in Hucknall (The Last home of The Byron Family). Community leader focused on SQL Server, SharePoint, security, collaboration and ITIL, DR, BCM, and SLA. Love licensing stuff.

Microsoft Certified Trainer, freelancer, and consultant. Subject Matter Expert at Microsoft. Member of Microsoft Terminology Community, Friends of RedGate PLUS, PASS, ISSA, ACM and more. Since 1st July 2010 Data Platform MVP. Creator of SQLDAY Conference and Conference CEO 2009-2011. Co-Leader of PASS East Midlands Group. Speaker at group meetings and conferences. STEM Ambassador.

Traveler. Coffee Addicted.

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.

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).

Benjamin Kettner

Twitter: - DataMonsterBen

Contact: https://www.tsql-ninja.com

Dr. Benjamin Kettner is a mathematician, founder and CTO of ML!PA Consulting GmbH. His fokus lies on consulting his clients technically and strategically for implementation of projects in different areas of the data platform. Er is regional chapter lead of the Berlin chapter of PASS, since 2020 he is a Microsoft MVP and he is a regular speaker on different events.

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.

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.

Sam Lester

Contact: http://blogs.msdn.com/b/samlester

Sam Lester has spent the past 14 years working for Microsoft in various SQL Server related roles. After nearly 12 years working in the SQL Server development team in Redmond, WA, he has recently made the switch to a consulting role to work hands-on with European customers. While in the product group, Sam worked on numerous features including setup, migration, SSMS/manageability, Utility Control Point, Data-Tier Application Component, SSDT, Intellisense, amp; TSQL Debugger.

Mark A. Kuschel

Twitter: - @Irgendware

Contact: http://www.mark-kuschel.name

Mark is Head of Microsoft BI in Hamburg, Northern Germany. He is working as project manager and consultant since 11 years with Microsoft .Net and since 7 years primary with Microsoft Business Intelligence / Data Analytics tools. His experience is emphasized by an MCITP f#252;r SQL Server 2008 Business Intelligente certification.

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”.

Sponsors

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

Back to the SQLSaturday Event List

Back to the home page