SQLSaturday #409 - Rheinland 2015
Event Date: 06/13/2015 00:00:00
Event Location:
- Hochschule Bonn-Rhein-Sieg
- Grantham-Allee 20
- Sankt Augustin, Germany
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: Tracing with Extended Events – Top Features
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 MCM + MCSM Andreas Wolter will demonstrate 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, get a callstack for further analysis within the Debugger, how to do advanced analysis directly inside the GUI, how to audit Database and Table-access with Standard edition, analyze deadlocks without old-fashioned TraceFlags based on the built-in system_health session, this session is just for you. Having started my lectures on Tracing with Extended Events in 2012 under the slogan “Hasta la vista, Profiler”, I hope to convince the last one, to kick Profiler out of the door.
Speaker(s):
- Andreas Wolter
Track and Room: 1 - DBA - Track 1
Title: Defensive T-SQL Datenbankentwicklung
Abstract: Bei der Entwicklung von Programmlogik in T-SQL Code kann man sehr viele Fehler machen die aus falschen oder unscharfen Annahmen bestehen und die dazu f#252;hren, dass der T-SQL Code nicht das macht was man vermutet, gar keine Ergebnisse oder gar falsche Ergebnisse liefert. Dieses Verhalten, das auf den ersten Blick nicht-deterministisch zu sein scheint ist relativ schwierig zu debuggen. Um Situationen zu vermeiden in denen der T-SQL Code nicht das tut was er soll muss man versuchen m#246;glichst viele der impliziten Annahmen die man bei der Entwicklung von Programmlogik in SQL triff zu eliminieren - das versteht man unter defensiver Datenbankentwicklung. Anhand von praktischen Beispielen demonstiert SQL Server MVP Frank Geisler klassische Fehler die man machen kann und was man tun muss um diese Fehler zu vermeiden
Speaker(s):
- Frank Geisler
Track and Room: 2 - DEV - Track 2
Title: Hätte ich auf der Titanic überlebt? Machine Learning in Microsoft Azure
Abstract: Machine Learning oder Data Science sind in einer Zeit, in der die Menge an Daten stetig zunimmt, wertvolle Hilfsmittel. Dementsprechend gehören Data Scientists derzeit zu den begehrtesten Experten in der IT-Branche. Die Einsatzbereiche sind vielfältig und reichen von der Vorhersage von Fußballergebnissen über persönliche Kaufempfehlungen in Online-Shops bis zum Ergreifen präventiver Wartungsmaßnahmen in der industriellen Produktion.
In diesem Vortrag werden wir Microsoft Azure Machine Learning vorstellen - ein Dienst von Microsoft Azure, mit dem Entwickler Predictive Analytics-Modelle anhand von Machine Learning-Algorithmen bauen und als Cloud Service veröffentlichen können. Dabei gehen wir einen End-to-End Workflow durch, mit dem wir die Überlebenschancen auf der Titanic berechnen können: wir entnehmen existierende Daten, erstellen darauf basiert verschiedene Modelle, die gleich in Anwendungen eingebaut werden können.
Speaker(s):
- Olivia Klose
Track and Room: 3 - Cloud - Track 3
Title: You don’t need Enterprise Edition to do that!
Abstract: The most coveted features of SQL Server are made available in Enterprise Edition and are sometimes released into Standard Edition a few years later. This often leaves a vast group of users who “window shop” the latest and greatest features and return to the office wishing they never saw those features presented. This session will show you how you can achieve the same, or at least a similar, outcome to those features without having to fork out for Enterprise Edition licenses or breaking any license agreements. You will leave the session with a set of solution concepts that you can build upon or extend and maybe save you and your company a nice pile of cash.
Speaker(s):
- William Durkin
Track and Room: 2 - DEV - Track 2
Title: Qualit#228;tsmanagement im DWH Projekt
Abstract: Hoffen Sie noch, oder Testen Sie schon? In der klassischen Software Entwicklung geht nix ohne (behaupten sie dort jedenfalls), bei DWH Projekten ist es anscheinend Magie. Systematische Tests sind da nur der Anfang. Denkt man genauer #252;ber Qualit#228;tssicherung nach, f#228;llt einem noch diverses weiteres ein: Anforderungs-Reviews, Standards, Pair Programing, Continous Delivery etc. etc. Aandererseits, ist es wirklich notwendig den Projektumfang gleich zu verdoppeln? In dieser Session wollen wir uns einerseits den Werkzeugkasten des potentiell Sinnvollen anschauen, inklusive aktueller Testtools wie NBi und der entsprechenden Frameworks. Andererseits soll ein Rahmen geschaffen werden, der hilft zu beurteilen, welche dieser Werkzeuge wann wirklich zum Einsatz kommen sollten. Sind etwa Unit Tests beim ETL unverzichtbar und Deployment Tests reiner Luxus?
Speaker(s):
- Christoph Seck
Track and Room: 4 - Mixed - Track 4
Title: Performanceeinflussfaktoren einer BI-Applikation mit Praxisbeispielen
Abstract: Die Analyse von Daten und die daraus gewonnen Information bieten Unternehmen potentielle Wettbewerbsvorteile und sind deshalb f#252;r mittelst#228;ndige Unternehmen bis hin zu internationalen Gro#223;konzernen nicht mehr wegzudenken. Mit der steigenden Relevanz der Analysen, steigt nat#252;rlich auch die Anforderungen an die analytischen Systeme. Dabei spielt vor allem das Stichwort „Performance“ eine wichtige Rolle. Aus diesem Grund m#246;chte ich einen #220;berblick #252;ber verschiedenen Einflussfaktoren auf Performance bieten. An einem Praxisbeispiel m#246;chte ich die Relevanz von einigen dieser Einflussfaktoren aufzeigen und ein Konzept f#252;r ein Monitoring vorstellen.
Speaker(s):
- Bastian Sold
Track and Room: 4 - Mixed - Track 4
Title: Big Data for the SQL Ninja
Abstract: As more enterprises start implementing big data solutions, how does the DBA support these efforts and do they have the skills and knowledge to integrate big data solutions into your current architecture and processes? This demo-filled session has two purposes; first, to help DBAs understand how to apply their existing SQL Server skills in understanding and utilizing HDInsight and related technologies. Big data technologies don’t need to be intimidating, and this session will help DBAs see how they can easily apply their current skill when working with big data. Second, this session will show how SQL Server and HDInsight be used together to create solutions to solve big data problems without the complexities of massive learning curves and using technologies DBAs are already familiar with. We’ll look at technologies that make working with big data much less daunting, including HiveQL and Sqoop, both of which don’t require a rocket science degree to use.
Speaker(s):
- Scott Klein
Track and Room: 3 - Cloud - Track 3
Title: Azure Stream Analytics - Internet der Dinge in Echtzeit
Abstract: Eine st#228;ndig wachsende Anzahl an Sensoren bringt uns dem „Internet der Dinge“ kontinuierlich n#228;her. Anwendungen, die sehr schnell eine gro#223;e Menge der erzeugten Daten verarbeiten, analysieren und mit Vorhersagemodellen kombinieren m#252;ssen, sind eine logische Konsequenz. Daraus ergeben sich aber eine Reihe von Fragen: Welche Herausforderungen verbergen sich in der Verarbeitung von Datenstr#246;men? Welche Alternativen bietet der Microsoft-Kosmos zur In-Flight Datenverarbeitung und wie gelingt der Einstieg? Diesen Fragen wollen wir in dieser Session auf den Grund gehen und zus#228;tzlich zeigen wie mit Azure Stream Analytics ein neuer Cloud-Service bei dieser Problematik weiterhilft.
Speaker(s):
- Constantin Klein
Track and Room: 3 - Cloud - Track 3
Title: SQL Server Monitoring - Piloten fliegen auch nicht Blind
Abstract: Ein Flugzeug, nehmen wir mal den A380, ohne Instrumententafel, Warnleuchten und Statusanzeigen, wer m#246;chte da schon freiwillig einsteigen. Schlie#223;lich w#228;re dies ein Blindflug ohne Statusinformation, undenkbar. Leider werden heute noch sehr viele SQL Server Umgebungen genauso betrieben, ohne jeglich #220;berwachung. Fehler werden in einer solchen Umgebung meist erst erkannt, wenn die Anwender sich melden und bereits zu sp#228;t ist. Auch die Analyse der Fehler wird erschwert, wenn nicht sogar unm#246;glich. Warum ist das kritisch? Wie kann man hier besser vorgehen? Ein Monitoring durch Anwender sollte keine L#246;sung sein.
Speaker(s):
- Andre Essing
Track and Room: 1 - DBA - Track 1
Title: Understanding Solving Columnstore Problems
Abstract: Dive deep into Columnstore Indexes and discover their advantages and some of the limitations. Look into some of the Columnstore Indexes myths, understand more complex concepts of Batch Mode Query Processing with another depth.
Can you make your Columnstore queries ran even faster ? Can you actually lower the Degree of Parallelism and get a better performance ? How much memory does Columnstore Index actually use when working with queries ? How can you test your Columnstore queries in Row Mode and what is the actual difference between Row Batch Modes.
The answers on those questions are to be revealed at this session.
Speaker(s):
- Niko Neugebauer
Track and Room: 5 - BI - Track 5
Title: Data Vault in der Praxis mit dem SQL Server
Abstract: Data Vault ist als alternativer Modellierungsansatz f#252;r Data Warehouse Umgebungen mittlerweile sehr bekannt geworden. Dennoch fehlt vielen Teams noch die Praxis zur Bewertung der Methode, um in der Architekturphase eines Data Warehouse eine Entscheidung begr#252;nden zu k#246;nnen. Diese Session gibt Entscheidern und Entwicklern einen #220;berblick #252;ber die in der Methode vorgeschlagenen Artefakte, skizziert einen Architekturansatz f#252;r das sogenannte Core Data Warehouse und zeigt die Vorteile auf gegen#252;ber der klassischen Denormalisierung im Data Warehouse in der Realisierung mit dem SQL Server und den SQL Server Integration Services.
Speaker(s):
- Sascha Lorenz
Track and Room: 4 - Mixed - Track 4
Title: String Concatenation Done Right
Abstract: Numerous techniques for concatenating string data can be found online, and even in some books. In this session you will learn two of them that are reliable, and fairly easy to understand, implement, and deploy. You will also learn how to control the order of the values being concatenated, a feature that is not natively provided by SQL Server.
Speaker(s):
- Matija Lah
Track and Room: 2 - DEV - Track 2
Title: Restoring Databases with Powershell
Abstract: Build plan of approach to structured point in time restores of databases ( e.g. from Production to QA ) using Powershell as an easy helper tool to ensure all steps are being performed.
Speaker(s):
- Johan Bijnens
Track and Room: 1 - DBA - Track 1
Title: Build your own Monitoring Environment with Powershell
Abstract: Let’s build a Powershell script together that will use Remoting to run whatever script you like in parallel on any number of servers. We’ll talk about remoting, remoting across domains or even without, how to run scripts in the background and in parallel. I’ll show you how to store the results and report on it across all your servers in one go.
Speaker(s):
- André Kamman
Track and Room: 1 - DBA - Track 1
Title: A Programmatic Journey Through SSISDB
Abstract: With the advent of SQL Server Integration Services Catalog (SSISDB) a new place of storing, executing and monitoring SSIS packages came into existence. In this session, Wolfgang will show you different aspects of programmability in the context of SSISDB. Beginning with a short overview of the underlying database objects, a deeper look at SSISDB’s stored procedures will follow. A side-step from TSQL to C# and the available Integration Services SDK illustrates a different view accessing SSISDB. Concluding, the analysing and reporting aspect of SSISB programmability is shown with some exemplified SQL Server Reporting services reports.
Speaker(s):
- Wolfgang Strasser
Track and Room: 2 - DEV - Track 2
Title: Index Fragmentation
Abstract: In this session you will learn the difference between the internal and external index and heap fragmentation and how to detect it. You will get a deeper understanding of the reasons of fragmentation like
- page split
- index fill factor
- ghost record
- forwarding record
- heap PFS insert algorithm
- batch insertion
- database shrink / auto growth
Speaker(s):
- Torsten Strauss
Track and Room: 1 - DBA - Track 1
Title: Maintenance Plans ad Hoc
Abstract: Maintenance Plans for Beginners (but not only) | Each of experienced administrators used (to some extent) what is called Maintenance Plans - Plans of Conservation. During this session, I’d like to discuss what can be useful for us to provide functionality when we use them and what to look out for. Session at 200 times the forward-300, with the opening of the discussion.
Speaker(s):
- Tobias Koprowski
Track and Room: 1 - DBA - Track 1
Title: SQL Server Enterprise-Konsolidierung
Abstract: Die Weiterentwicklung von SQL Server schreitet immer schneller voran. Wer den Anschluss nicht verlieren m#246;chte, der muss migrieren. Angesichts der immer leistungsf#228;higer werdenden Hardware, den vielen Virtualisierungsm#246;glichkeiten und dem Bestreben, Kosten einzusparen, liegt es nahe, gleichzeitig den vielerorts existierenden, im letzten Jahrzehnt organisch gewachsenen SQL Server-Zoo zu konsolidieren.
Hatte der Chef „Mal eben konsolidieren“ gesagt? Dieser Vortrag zeigt auf, wie gro#223; das Chaos tats#228;chlich werden kann und versucht gleichzeitig, eine Anleitung zu dessen Bew#228;ltigung zu sein, getreu dem Motto: „Wenn man das Chaos kennt, ist es schon keines mehr.“
Speaker(s):
- Bodo Michael Danitz
Track and Room: 4 - Mixed - Track 4
Title: SSIS Performance Tuning Deep Dive
Abstract: Habt ihr euch schon immer gefragt, warum eure SSIS-Pakete nicht schneller laufen? Warum ist bei 35 MB/s Ladeperformance Schluss? In dieser Session m#246;chte ich euch zeigen, wie ihr eure SSIS-Pakete deutlich schneller ausf#252;hren lassen k#246;nnt. Ich stelle dabei verschiedene Parallelisierungsstrategien vor, gehe auf die verschiedenen Vor- und Nachteile ein und gebe euch allgemeine Tipps im Bereich Performance Tuning.
Speaker(s):
- Marcel Franke
Track and Room: 5 - BI - Track 5
Title: SQL Server vs. Azure DocumentDB – Ein Battle zwischen XML und JSON
Abstract: Seit dem SQL Server 2000 hielt St#252;ck f#252;r St#252;ck die XML-Unterst#252;tzung Einzug in die Microsoft RDBMS Welt. Mit der Azure DocumentDB kam die zweite, hauseigene NoSQL-Datenbank in der Microsoft Cloud hinzu, welche die Daten im JSON-Format verarbeitet. In dieser Session werden wir anhand eines Praxisbeispiels step-by-step, d.h. von den vorbereitenden Schritten, #252;ber das Schreiben bis hin zum Lesen der Daten, diese beiden Technologien gegen#252;berstellen. Dabei arbeiten wir die Vor- und Nachteile der einzelnen Ans#228;tze heraus und zeigen Best Practices auf.
Speaker(s):
- Sascha Dittmann
Track and Room: 3 - Cloud - Track 3
Title: Test-driven database development
Abstract: While software developers use unit testing for a long time, many database developers still write stored procedures using SQL Server Management Studio, test code on either a production server or a copy of it and manually check the results. But what to do when your database project become so complex? Unit-testing for database projects could be a solution. I will tell you about some products you can use and how they can make your life as a database developer easier.
Speaker(s):
- Sergey Olontsev
Track and Room: 2 - DEV - Track 2
Title: PowerBI on SAP HANA
Abstract: SAP HANA is ubiquitous nowadays and it will also remain a hot topic in the future. But besides the technical specifications it is also very important how to work with the data in the end and the majority of users still relies on Microsoft Excel here. Especially Office 365 and Power BI enables users to work with this data in a whole new way. In this session I will show how to combine the best of both worlds by using Power BI to load and analyze data that resides in SAP HANA and will highlight the most common pitfalls and what you have to consider.
Speaker(s):
- Gerhard Brueckl
Track and Room: 5 - BI - Track 5
Title: Kerberos: Alptraum oder Zusammenspiel?
Abstract: Wer mit Kerberos zu tun hatte kennt die Schwei#223;perlen beim Einrichten auf der Stirn. Wie einst bei Douglas Adams gilt auch hier: KEINE PANIK! In diesem Vortrag erl#228;utere ich, was man unter Kerberos und Delegierung versteht, wie eine optimale Konfiguration im Zusammenspiel SQL Server + SharePoint mit Reporting Services aussieht – und vor allem: Wie man Troubleshooting durchf#252;hren kann ohne wahnsinnig zu werden.
Speaker(s):
- Mark A. Kuschel
Track and Room: 4 - Mixed - Track 4
Title: Hochverf#252;gbarkeit mit AlwaysOn f#252;r die SSISDB
Abstract: Seit der Version SQL 2012 haben die Integration Services mit der SSISDB eine eigene Datenbank. Zeitgleich wurde neben dem klassischen Mirroring und dem Clustering die Hochverf#252;gbarkeitstechnik AlwaysON eingef#252;hrt. In diesem Vortrag wird der generelle Aufbau einer AlwaysOn-L#246;sung f#252;r eine User-Datenbank gezeigt. Anschlie#223;end wird die SSISDB mit in das AlwaysOn-Konstrukt aufgenommen und auf die Besonderheiten z.B. der Verschl#252;sselung eingegangen. Am Ende wird ein Weg f#252;r einen automatischen Wiederanlauf eine SSIS-Paketes nach einem Failover demonstriert.
Speaker(s):
- Stefan Grigat
Track and Room: 5 - BI - Track 5
Title: A journey through the Modern Data Warehouse
Abstract: The traditional data warehouse has been the key of our business analytics architecture for many years. In a world ruled by the data culture concept, new challenges are emerging: data growth; unstructured data; hidden patterns and cloud-born data. Which is the best architecture in order to get over these new challenges? Join this session and learn how to enable the Modern Data Warehouse in your organization using Cubes, HDInsight, AzureML, Stream Analytics and DocumentDB. All through a continuous example using a retail shop scenario.
Speaker(s):
- Ruben Pertusa Lopez
Track and Room: 5 - BI - Track 5
Title: Azure Rocks - Patrick plays with SQL and other technology a bit
Abstract: lets say demo demo and demo. it’s based on Azure, SQL and other technology to demontrate non-traditional IT thinking.
Speaker(s):
- Patrick Heyde
Track and Room: 3 - Cloud - Track 3
Title: Under Construction - Power BI for Developers?
Abstract: Power BI is the Self-Service BI offering of Microsoft to all Information Workers out there, but hey: Is there anything for the macro geeks and development folks? This session will have a look on anything you can do or should not do with the Power BI offering in the cloud and on your desktop. What’s in it if you want to go beyond the self-service experience? Is there more than create your own cool “M” functions? Let’s see in this session.
Speaker(s):
- Tillmann Eitelberg
Track and Room: 2 - DEV - Track 2
Title: Using BIML as an SSIS Design Patterns Engine
Abstract: Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, one of the authors of SSIS Design Patterns, demonstrates the flexibility of BIML in this session.
Speaker(s):
- Andy Leonard
Track and Room: 5 - BI - Track 5
Title: Securing your SQL Azure Database. How?
Abstract: Do you think that your data is not secured in the cloud? Is that one of the reasons for you to not migrate at least some workloads there? Things changed in the last few months in terms of Azure database security. In this session we will take a closer look at what the features Row Level Security(RLS) and Dynamic Data Masking can do for your business and how they can help you secure your data.
Speaker(s):
- Boris Hristov
Track and Room: 3 - Cloud - Track 3
Title: CDC - Change Data Capture in Detail
Abstract: Change data capture records insert, update, and delete activity that is applied to a SQL Server table. This makes the details of the changes available in an easily consumed relational format. Column information and the metadata that is required to apply the changes to a target environment is captured for the modified rows and stored in change tables that mirror the column structure of the tracked source tables.
This session demonstrates the basic concepts, detailed components and implementation strategies of CDC. The demo is based on a real scenario which has been implemented that way!
Speaker(s):
- Uwe Ricken
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.
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.
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.
Ruben Pertusa Lopez
Twitter: - @rpertusa
LinkedIn: Ruben Pertusa Lopez
Contact: http://www.sqlpass.es
Ruben is a Global BI/BigData Manager and Global Data Lead Architect at DUFRY HQ, member of PASS Spanish Group and founder of SQLSaturday Barcelona and Madrid. MCP and MCSA in SQL Server 2012 and also awarded with Microsoft MVP Data Platform. With more than 9 years of experience, he has been working in top projects for leading worldwide companies and teaching in the SolidQ BI Master. He has presented at the SQL Server 2008 R2 and 2014 Spanish launch event, PASS BA Chicago, TechNet Webcasts, Microsoft Partner Program and SolidQ Summit events.
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.
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.
Bastian Sold
I started to work at Bayer Business Services GmbH on 01.09.2012 as a student. Since 2013 I am working with a BI System based on Microsoft SQL Server R2 which deals with advanced analysis to financial data. This year I am going to finish my bachelor and start to work for bayer as fulltime employee.
Boris Hristov
Twitter: - https://twitter.com/BorisHristov
LinkedIn: Boris Hristov
Contact: http://borishristov.com/blog/
Boris is a SQL Server Consultant, but also an Author for Pluralsight and a SQL Server MVP. He is frequently speaking at conferences all accross Europe and is heavily involved in training students and organizations in what he calls quot;The Art of SQL Serverquot;. Boris is frequently blogging and is the host of SQLHangouts.
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.
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
Marcel Franke
Contact: http://dwjunkie.wordpress.com
Marcel Franke is a Practice Lead based in Germany with around 10 years of experiences in building and designing Data Warehouse amp; Big Data solutions based on the Microsoft platform. His focuses are Advanced Analytics, Data Science, and large scale BI Applications. Marcel is part of an advisory and research team supporting the largest Analytical installations on SQL Server and Open Source software in the German speaking area (Germany, Austria, and Switzerland).
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.
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”.
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.
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.
Bodo Michael Danitz
LinkedIn: Bodo Michael Danitz
Bodo Michael Danitz has been a freelanced consultant for database systems since his studies of electrical engineering. He worked as a developer on Oracle platforms for 8 years. With SQL Server 6 in 1995 he left the Oracle platform to be deep diving into SQL Server DBA matters. His specialties are performance tuning, very large databases, and high availability subjects. He also won fame for his expertise in tuning Microsoft Dynamics as well as for his own products branded under SQLSunrise#174;.
Johan Bijnens
Twitter: - @alzdba
LinkedIn: Johan Bijnens
Johan Bijnens is a database firefighter, involved with SQLserver since 2000, who works at Aperam Genk as member of the Industrial IT support department. Involved in designing architectural solutions based on the Microsoft SQL Server Platform. Performing operational performance and troubleshooting support in co-operation with the dev teams.
Stefan Grigat
Contact: http://blog.oraylis.de/author/sgrigat/
Stefan Grigat ist BI Consultant bei ORAYLIS. Er hat mehr als 8 Jahre Erfahrung mit SQL Server und ist MCSE BI. Neben langer Erfahrung mit HA-L#246;sungen f#252;r Trading- und Kraftwerksystemen ist er beratend f#252;r verschiedene Kunden in den Bereichen Datenanalyse und Auswertung, ETL-Workflow und Reporting t#228;tig. Bei internen Schulungen vermittelt er theoretisches Wissen erg#228;nzt mit Praxiserfahrung. Seit der SQL 2005 liegt seine T#228;tigkeit neben der Verf#252;gbarkeit in der Entwicklung mit SSIS, SSRS und SSAS.
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.
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
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).
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.
Patrick Heyde
Contact: http://aka.ms/patrickheyde
Patrick Heyde ist Technical Evangelist für SharePoint Development und SQL BI und Microsoft Azure. Patrick ist seit 2007 bei Microsoft und neben der Beratung von Microsoft Partnern und Microsoft Enterprise Kunden stark involviert bei Prototypprojekt. Mehr Details über Ihn findet man bei XING-Patrick_Heyde, auf seinem Technet-Blog (http://aka.ms/patrickheyde) und über Twitter: @patrickheyde
Olivia Klose
Twitter: - http://twitter.com/oliviaklose
LinkedIn: Olivia Klose
Contact: http://oliviaklose.com
Olivia Klose is Technical Evangelist at Microsoft Germany. She is focussing on Microsoft Azure and Big Data, and was beforehand speaker for Windows Client. Prior to joining Microsoft, she studied Computer Science with Mathematics at the University of Cambridge (B.A. Hons, M.A.), the Technical University of Munich (M.Sc.) and IIT Bombay. Here, she focussed on Machine Learning in Medical Imaging.
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.
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.
Andy Leonard
Twitter: - AndyLeonard
LinkedIn: Andy Leonard
Contact: https://andyleonard.blog
Andy Leonard is founder and Chief Data Engineer at Enterprise Data Analytics, Microsoft Data Platform MVP, creator of the DILM (Data Integration Lifecycle Management) Suite, an SSIS trainer, consultant, developer, Business Intelligence Markup Language (Biml) developer and BimlHero, SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of “The Biml Book and SQL Server Integration Services Design Patterns” and author of “Managing Geeks - A Journey of Leading by Doing”, “Data Integration Lifecycle Management with SSIS”, “Building Custom Tasks for SSIS”, and the “Stairway to Integration Services”. Andy blogs at andyleonard.blog where you can learn more on the About Andy page.
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.
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.
Sascha Lorenz
Twitter: - saschalorenz
LinkedIn: Sascha Lorenz
Contact: http://saschalorenz.blogspot.com
Sascha works for the PSG GmbH since 1994 as a Principal Consultant focusing on the Microsoft Data Platform. He is active in the SQL community as an organizer of the Hamburg (Germany) PASS Chapter, as a speaker on SQL Server related events and rewarded as a former Data Platform MVP.
Sponsors
The following is a list of sponsors that helped fund the event: