SQLSaturday #230 - Rheinland 2013
Event Date: 07/13/2013 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: Introduction to Microsoft Big Data – Part I
Abstract: Wir leben in einem Datenzeitalter! Nach Schätzungen in 2006, betrug das weltweite “Datenuniversum” ca. 0.18 Zettabytes (10^21 Bytes bzw. 1 Mrd. Terrabyte). In 2011 hat sich dieses Volumen sogar verzehnfacht (1,8 Zettabytes). Somit wird in vielen Anwendungsszenarien das Thema Big Data und Big Processing immer wichtiger. Klassische relationale Datenbanksysteme, sowie Statistik- und Visualisierungstools, sind oft nicht in der Lage, derart große Datenmengen zu verarbeiten. Für Big Data kommt daher eine neue Art von Software zum Einsatz, die massiv parallel auf bis zu hunderten oder tausenden von Prozessoren bzw. Servern arbeitet, wie z.B. Microsoft HDInsight. In dieser Session stellen wir anhand eines praktischen Szenarios vor, wie konkrete Aufgabenstellungen mit HDInsight in der Praxis gelöst werden können: 1. Grundlagen von HDInsight Server Service. 2. Mit Azure HDInsight Service arbeiten. 3. MapReduce-Jobs mit Javascript und .NET Code implementieren.
Speaker(s):
- Georg Urban Sascha Dittmann
Track and Room: Openness - N/A
Title: Analysing Data with Power View
Abstract: Power View is Microsoft’s Data Visualisation tool, and is used to analyse data. Using demos, we learn about using Power View to analyse data, whilst assessing it based on current cognitive research around Data Visualisation principles by luminaries such as Stephen Few, Tufte and others. We will:
- investigate Power View based on current cognitive research around Data Visualisation principles
- examine how data can be analysed with Power View
- look at where Power View is supplemented by other parts of the Microsoft Business Intelligence stack
Come to this session if you really want to think about the best ways of presenting data to your Business Intelligence data consumers, and see how to apply these principles in Power View.
Speaker(s):
- Jen Stirrup
Track and Room: BI - N/A
Title: Reporting Services mit Geospatial Visualization
Abstract: Reporting Services mit Geospatial Visualization konkret: „Von Adressdaten bis zur Daten-Darstellung im SSRS Mapcontrol in 3 Schritten.“ Jedes Unternehmen hat Adressdaten in der relationalen Form [Strasse], [PLZ] und [Ort] Im ersten Schritt wird der Übergang zu Geodaten in der Form von Längen- und Breitengrad dargestellt. Die Frage nach der Datenquelle und der Datenqualität ist ebenfalls Thema dieses Abschnitts. Im nächsten Schritt erfolgt die Auswahl des geeigneten Kartenmaterials. Hervorzuheben ist das Datenmatching der Karte mit den Adressdaten. Auch die Eigenerstellung von Kartenausschnitten wird an einem Beispiel erläutert. Im dritten Schritt erfolgt die Verwendung und Konfiguration des Controls und der Bezug zu den Reportdaten.
Speaker(s):
- Alexander Karl
Track and Room: DEV - N/A
Title: SQL Azure from Plan, to Backup, to Cloud
Abstract: Microsoft released SQL Azure more than two years ago - that’s enough time for testing (I hope!). So, are you ready to move your data to the Cloud? If you’re considering a business (i.e. a production environment) in the Cloud, you need to think about methods for backing up your data, a backup plan for your data and, eventually, restoring with Red Gate Cloud Services. In this session, you’ll see the differences, functionality, restrictions, and opportunities in SQL Azure and On-Premise SQL Server 2008/2008 R2/2012. We’ll consider topics such as how to be prepared for backup and restore, and which parts of a cloud environment are most important: keys, triggers, indexes, prices, security, service level agreements, etc.
Speaker(s):
- Tobias Koprowski
Track and Room: Azure Big Data - N/A
Title: StreamInsight: Complex Event Processing by MS
Abstract: The number of sensors is growing and growing and brings us closer to the “Internet of things”. Applications, that have to process a big amount of data from event streams are a logical consequence. Some developers might have heard from Reactive Extensions (Rx) already, but Microsoft offers with StreamInsight (SI) another comprehensive platform for these scenarios.
In this session you will learn what a great addition for your toolbox StreamInsight is, if you have to develop applications, that have to handle complex events (CEP- Complex Event Processing). See how you can start with this technologie and how easy it is to jump in for .NET developers.
Speaker(s):
- Constantin Klein
Track and Room: DEV - N/A
Title: FILETABLEs: What They Are and How to Use Them
Abstract: Have you ever had the need to access documents in your database as if they were files in the file system? SQL Server 2012 introduces a brand new method for managing large data objects (BLOBs) in a database. FILETABLEs provide access to data using Transact-SQL - just like any other table inside the database, while at the same time also provide access to the data using the operating system File I/O API - i.e. just like any other folder in the file system. In this session you will learn how to upgrade your document management solutions by migrating your large data to FILETABLEs. The session covers two most typical migration scenarios: migrating from a distributed data store, where files are stored outside the database, and from a homogeneous d
Speaker(s):
- Matija Lah
Track and Room: Azure Big Data - N/A
Title: SQL Server under Attack - Angriffsszenarien
Abstract: Obwohl SQL Server als “secure by default” gelten kann, finden sich in der Praxis immer wieder verschiedenste Schwachstellen. Teilweise sind diese umgebungsbedingt (siehe SQL Authentifizierung), oder einfach unbedacht durch nicht ausreichend sensibilisierte Administratoren oder Entwickler implementiert. In dieser rein Demo-basierten Session werden verschiedene Angriffsszenarien auf verschiedenen Ebenen des SQL Server gezeigt. - Auf vielfachen Wunsch auch einige Advanced SQL-Injection Beispiele. - Hinweis: Eine Anleitung zum Hacking wird hier nicht gegeben (dafür würde die Zeit auch nicht ausreichen), sondern es soll für das Thema sensibilisiert werden. - (fast) keine Folien: Demos Demos Demos
Speaker(s):
- Andreas Wolter
Track and Room: DBA - N/A
Title: oData- Selbst gemacht
Abstract: Häufig ist es doch so, dass man eine Anwendung mit einem wunderschönen Datenbankmodel hat, in das viel Investiert wurde. Die Anwendung selber aber ein bisschen Altbacken und nicht mehr auf der Höhe der Zeit ist. User wünschen sich neue Kanäle, beispielsweise als Tablet oder Smartphone Lösungen. Doch wie die Infrastruktur aufsetzen? Datenbank Online schalten? Eher nicht! Und was ist mit Self Service BI, à la PowerPivot? Usern direkten Zugriff geben? No-Go! Als mögliche Lösung für die genannten Probleme stelle ich oData vor. Ich gehe kurz auf die Definition und die daraus gegebenen Möglichkeiten von oData ein. Anhand verschiedener Praxisbeispiele zeige ich danach wie eigene oData Feeds erstellt werden können und wie diese oder auch fremde Data Feeds mit anderen Applikationen konsumiert werden können. Security und Fallstricke von oData dürfen dabei natürlich nicht außer Acht gelassen werden.
Speaker(s):
- Rafael Dabrowski
Track and Room: Openness - N/A
Title: Introduction to Microsoft Big Data – Part II
Abstract: Im zweiten Teil unserer Microsoft Big Data Session geht es darum, wie Big Data Informationen über „klassisches“ SQL zugänglich gemacht werden können und wie sich mit der neuen PolyBase-Engine unstrukturierte Hadoop-Daten mit relationalen Data Warehouse-Daten einfach verknüpfen lassen. In der Hadoop-Welt wird der SQL-Zugriff über die Komponente Hive ermöglicht. Über den Microsoft Hive ODBC-Konnektor können die üblichen BI-Tools, wie PowerPivot, diesen Zugriff direkt nutzen. Die PolyBase-Engine schließlich wird ein Bestandteil des SQL Server 2012 Parallel werden und erlaubt einem transparenten SQL-Zugriff, egal, wo sich die Daten befinden. Die Themen im Überblick: 1. Hadoop-Daten mit Hive erschließen. 2. Big Data Auswertungen mit Excel PowerPivot Power View. 3. SQL Server 2012 Parallel Data Warehouse. 4. PolyBase als Brücke zwischen der untrukturierten und strukturierten Big Data Welt.
Speaker(s):
- Sascha Dittmann
Track and Room: Openness - N/A
Title: From SQL Traces to Extended Events. The next big switch.
Abstract: This session will give you insight into both of the current tracing technologies in SQL Server with emphasis on Extended Events.
The old SQL Trace which has served us well over the past 10 or so years is on its way out because the overhead and details it produces are no longer enough to deal with today’s loads. The new Extended Events are a new lightweight tracing mechanism built directly into the SQLOS thus giving us information SQL Trace just couldn’t. They were designed and built with performance in mind and it shows. Mastering Extended Events requires learning at least one new skill: XML querying. We’ll look at how the Extended Events work with only a brief overview of old SQL Trace architecure.
Speaker(s):
- Mladen Prajdić
Track and Room: DBA - N/A
Title: SQL Server 2012 Memory Management
Abstract: SQL Server 2012 brings a wide range of changes from its previous versions - one key change is the way SQL Server memory is managed. With releases prior to SQL Server 2012, there were 2 memory managers, these have been merged into 1 with the latest version, and that’s just the start of the changes for SQL Server memory. This session will dive into questions related to memory primarily for SQL Server 2012.
Speaker(s):
- Neil Hambly
Track and Room: DBA - N/A
Title: Performance Manageability der tempdb
Abstract: Eine Systemdatenbank im SQL Server, die es in sich hat und trotzdem oft genug ein Schattendasein führt. Missverständnisse und widersprüchliche Aussagen zum Best Practice der tempdb heizen die anhaltende Diskussion in der SQL Server Community immer wieder an. In dieser Session schauen wir uns die tempdb genauer an und untersuchen den Einfluss der Konfiguration und Hardware auf die Performance. Damit Schwierigkeiten im täglichen Betrieb mit der tempdb schnell erkannt werden, betrachten wir die Möglichkeiten zum Monitoring. Abschliessend gehen wir der Frage nach: Gibt es “die tempdb” für Jedermann?
Speaker(s):
- Torsten Schüßler
Track and Room: Azure Big Data - N/A
Title: Hadoop Now, Next and Beyond
Abstract: With the rise of Apache Hadoop, a next-generation enterprise data architecture is emerging that connects the systems powering business transactions and business intelligence. Hadoop is uniquely capable of storing, aggregating, and refining multi-structured data sources into formats that fuel new business insights. Apache Hadoop is fast becoming the defacto platform for processing Big Data.
Speaker(s):
- Mrinal Devadas
Track and Room: Openness - N/A
Title: The SSIS Script Task Component from A - Z
Abstract: Trying to accomplish a task in SSIS but there is no standard component available? Or perhaps you have a really strange file format. Learn how to use the Script task and script component in this session. I’ll talk about how to recognise when you should use it and how to use it. I’ll bring lots of practical examples
Speaker(s):
- André Kamman
Track and Room: DEV - N/A
Title: The Developer Side of Master Data Services
Abstract: The Master Data Services offers an easy to use toolset to work with Master Data. In this session we will explore the hidden power of MDS to integrate this service in our solutions. MDS provides ways to programmatically accessed all tasks. We will see how to automate all the functions of MDS and how to build our own frontends for our data stewards. Take your MDS Project on a higher level.
Speaker(s):
- Sascha Lorenz
Track and Room: DEV - N/A
Title: Microsoft PDW im Projekteinsatz
Abstract: Die Flagschiffversion des SQL Servers, Parallel Data Warehouse (PDW), ist ein recht junges Produkt. Erfahrungen mit Proof of Concepts gibt es schon einige, doch kaum einer hat bisher echte Projekterfahrungen sammeln können. Das Vortragsteam ist seit Mitte 2012 aktiv in einem der ersten PDW Projekte und berichtet über die Erfahrungen im Projekteinsatz.
Speaker(s):
- Thomas Strehlow
Track and Room: BI - N/A
Title: SQL Server basierte SharePoint 2013 Apps mit LightSwitch entwickeln
Abstract: In Visual Studio LightSwitch hat sich mit dem Update 2 für Visual Studio einiges getan. So ist es nun beispielsweise möglich Datenbank-Apps für SharePoint 2013 zu entwickelt. In dieser Session gibt Frank Geisler einen Überblick über die Möglichkeiten und zeit an einen praktischen Beispiel wie die SharePoint 2013 App Entwicklung mit Visual Studio LightSwitch funktioniert.
Speaker(s):
- Frank Geisler
Track and Room: Azure Big Data - N/A
Title: Einsatzmöglichkeiten von Window Functions
Abstract: Bereits ab der Version 2005 erweitern diese Funktionen die Möglichkeiten von T-SQL. Im Zusammenhang mit Common Table Expressions lassen sich komplexe Sachverhalte einfach auswerten. Mit SQL Server 2012 gab es noch einmal eine Erweiterung dieser Funktionen. Wir werden uns die Grundlagen anschauen und anhand einiger Beispiele die Einsatzmöglichkeiten betrachten.
Speaker(s):
- Christoph Muthmann
Track and Room: DEV - N/A
Title: Die Qual der Wahl - nicht-relationale Datenbanken im Überblick
Abstract: „SQL Server“ ist ein mächtiges und etabliertes Stück Infrastruktur. Trotzdem gibt es Szenarien, die einen Einsatz von alternativen Datenbanken – häufig auch etwas irreführend als „NoSQL“-Datenbanken“ bezeichnet - rechtfertigen. Dieser Vortrag gibt einen Überblick über die verschiedenen nicht-relationalen Datenbankalternativen. Er bringt Licht in den Datenbankdschungel aus 150 Produkten und erklärt, welcher Typ sich für welche Problemstellung eignet.
Am konkreten Beispiel wird gezeigt, welche neuen Möglichkeiten sich beim Einsatz ergeben, z.B. für mobile Apps und clientorientierte Anwendungen á la Google Mail.
Speaker(s):
- Jan Steemann
Track and Room: Openness - N/A
Title: From MDS to SSRS - a short walkthrough
Abstract: MDS makes the administration and maintenance of your master data quite easy and comfortable. But how is the effect on your business interfaces? This session will present demos of how the changes to your master data will effect your cube and reports - and how quick they can be available to your business users.
Speaker(s):
- Gabi Münster
Track and Room: DBA - N/A
Title: Advanced Indexing
Abstract: So you know all about heaps, clustered indexes, and nonclustered indexes, but are still not satisfied? Then this is just the session for you! Hugo will explore advanced features such as included columns, indexed views, and filtered indexes. You will find out how they are stored on disk, and how SQL Server uses them to satisfy queries. Then, you will see the tools SQL Server itself hands you to help identify just the right subset of indexes. And finally, you will get an stunning demonstration of just how bad you can hurt performance by following all those recommendations and creating too many indexes.
Speaker(s):
- Hugo Kornelis
Track and Room: Azure Big Data - N/A
Title: DataExplorer - the reason you might not need SQL Server
Abstract: The DataExplorer plugin for Excel( which is currently in preview) is targeting Excel users and Business Analysts by providing them a homegrown ETL process without any additional Servers. Powered by the flexibility of the “M” language, DataExplorer is capable reaching out for such diverse sources as OData, File System, HDInsight or Facebook, for example. Besides providing an accessible interface for the non-IT people, the real potential behind DataExplorer lies in creating customizable functions and processes far beyond any GUI. Join me for an hour of “DataExploration”! :)
Speaker(s):
- Niko Neugebauer
Track and Room: BI - N/A
Title: Advanced DQS Integration
Abstract: Mit dem Data Quality Client steht dem Data Steward ein Endbenutzer konformes Produkt zur Verfügung, mit dem er schnell und einfach Daten bereinigen, standardisieren und mit zusätzlichen Informationen anreichern kann. Aber auch mit Excel oder den SQL Server Integration Services kann auf die Data Quality Services zugegriffen werden. In dieser Session zeigen wir, wie DQS in andere Umgebungen integriert werden kann, welche Möglichkeiten sich daraus ergeben und was dabei zu beachten ist.
Speaker(s):
- Tillmann Eitelberg
Track and Room: BI - N/A
Title: Inside the Columnstore Index - Deep Dive
Abstract: You have heard the marketing speak. You may have seen the demos. And maybe you have even played with the feature - columnstore indexes, the amazing “go faster” switch in SQL Server 2012! But do you know how they work? Come to this session to find out. We will lift the hood to give you a fascinating in-depth view of how columnstore indexes are built and read, how batch-mode execution operates, and how these features work together to achieve an amazing performance boost.
Speaker(s):
- Hugo Kornelis
Track and Room: DBA - N/A
Title: Powershell: The DBA as a consumer
Abstract: Focus for this session is demonstrating some quick benefits Powershell brings to day-to-day operations for a DBA and some gotchas experienced during the learning curve.
Speaker(s):
- Johan Bijnens
Track and Room: DBA - N/A
Title: Big Data - Hype or Reality?
Abstract: We can read about Big Data nearly daily in the news and how Big Data helps for cancer care, can help you win Jeopardy and helps Facebook and Google to make a lot of money. But what is behind Big Data? In this session I will try to demystify the buzzwords and talk about what customers really want to do with it. We will also have a look at Microsofts Big Data offering including some live demos with HDInsight, Hadoop, Hive and Data Explorer.
Speaker(s):
- Marcel Franke
Track and Room: Openness - N/A
Title: Social Text, Sentiment and Tone Analysis
Abstract: We live in a world of social data. There are tweets, Facebook posts, updates, book reviews or forum discussions written in Social Networks. As an insight, we can find sentiment in all these social texts. This session reviews some text mining and integration techniques for extracting and incorporating these insights from Big Data into our analytical platform. Real life samples and practical demos will be shown using Microsoft technologies. Co-speaker: Paco Gonzalez (SolidQ BI Mentor)
Speaker(s):
- Ruben Pertusa Lopez
Track and Room: BI - N/A
Title: TSQL Performance Tips
Abstract: SQL Server optimizer doesn’t use and index seek for execution of your query although the quer is high selective? What is better, when and why: LIKE vs: SUBSTRING, IN vs. EXISTS, SUBQUERY vs. JOIN. Why you should not use the UPPER or LOWER functions? How to avoid non-SARG-able WHERE clauses? Which query takes about 3 minutes in SQL Server 2008 and only one second in SQL Server 2012?
In this session we will advice how to avoid common developer mistakes and show how bad designed queries reduce the SQL Server optimizer’s capabilities for choosing an optimal execution plan.
Speaker(s):
- Miloš Radivojević
Track and Room: Azure Big Data - N/A
Title: DDD und relationale Daten - Ein Widerspruch?
Abstract: Besonders bei Greenfield-Projekten bietet Domain-Driven Design (DDD) hervorragende Ansätze für den Anwendungsentwurf. Die verschiedenen Muster und Konzepte helfen dabei, eine strukturierte und wartbare Anwendung zu schaffen. In der Praxis treffen wir jedoch selten auf Neuentwicklungen, sondern vielmehr auf bestehende Systeme mit komplexen Strukturen, die über Jahre hinweg gewachsen sind. Die Aufgabe vieler Entwickler ist es, genau solche Anwendungen zu warten oder weiterzuentwickeln. Dieser Vortrag zeigt, wie die Bausteine des DDD dabei helfen können, ein objektorientiertes Domänenmodel mit vorhandenen Datenbanken zu verknüpfen.
Speaker(s):
- Dennis Traub
Track and Room: DEV - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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.
Mladen Prajdić
Twitter: - @MladenPrajdic
LinkedIn: Mladen Prajdić
Contact: http://weblogs.sqlteam.com/mladenp
Mladen Prajdić is a Data Platform MVP from Slovenia. He’s been programming for 20 years, developing different types of applications in .Net (C#) and SQL Server, ranging from standard line-of-business, image-processing applications to high performace and IoT applications. He’s a regular speaker at various conferences and usergroup meetings, really likes to optimize slow SQL statements, analyze performance, and find unconventional solutions to difficult SQL Server problems. In his free time, he also develops a very popular add-in for SSMS, called the SSMS Tools Pack (www.ssmstoolspack.com).
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.
Rafael Dabrowski
Contact: http://www.oh22.net
Rafael Dabrowski ist bei der oh22data AG als Application Developer tätig. Hauptsächlich beschäftigt Rafael sich mit Microsoft SharePoint und den unterschiedlichsten Webtechnologien, u.a. Webservices. Neben der Entwicklung gibt er regelmäßig Schulungen für Endkunden. Er hat in der Vergangenheit u.a. Erfahrungen im PHP Bereich gesammelt und für diverse CMS Systeme sowie für den Oxid eShop Erweiterungen entwickelt. Heute ist Rafael fast ausschließlich im .Net Umfeld unterwegs.
Neil Hambly
Twitter: - Neil_Hambly
LinkedIn: Neil Hambly
Contact: http://dataidol.com/NeilHambly
Neil Hambly is a SQL Server consultant, founder and consultant at Datamovements, a Gold Microsoft Data Analytics Consulting company. Neil has 20+ years in a variety of SQL Server roles and is an MCT. He is a regular presenter (200+ events) at user groups, and PASS events, including PASS Summit and SQLSaturday, and many UK events (SQLBits, SQLRelay). Neil is the leader of PASS London (UK), a Professional Development VC, a Melissa Data MVP, and a SQL Cruise Technical Lead, who loves Guinness, whisky, and dancing.
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.
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).
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.
Hugo Kornelis
Contact: http://sqlblog.com/blogs/hugo_kornelis/default.aspx
Hugo is co-founder and RD lead of perFact BV, a Dutch company that improves analysis methods and develops computer-aided tools to generate completely functional applications from the analysis deliverable. The platform for this development is SQL Server. In his spare time, Hugo likes to share and enhance his knowledge of SQL Server by frequenting newsgroups and forums, reading and writing books and blogs, and attending and speaking at conferences. Hugo is also a SQL Server MVP since 2006.
Georg Urban Sascha Dittmann
Contact: http://www.microsoft.com
Sascha Dittmann ist Softwareentwickler und -architekt bei der Ernst Young GmbH, sowie freier IT Trainer und Consultant. Kontakt: http://www.sascha-dittmann.de / Georg Urban arbeitet bei der Microsoft Deutschland GmbH als Senior Technologieberater im Application Platform Team. Kontakt: http://blogs.technet.com/b/sqlteamgermany
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.
Dennis Traub
Contact: http://dennistraub.de
Dennis Traub ist selbstständiger Entwickler und Berater mit besonderem Interesse an Domain-Driven Design, agilen Entwicklungsmethoden und Software Craftmanship. Sein derzeitiger Schwerpunkt liegt auf Web- und Cloud-basierten Geschäftsanwendungen sowie Systemen für Qualitätsmanagement und Sicherheit im Luftverkehr. In seiner Freizeit steht Dennis anderen Entwicklern bei StackOverflow und in Usergroups mit Rat und Tat zur Seite. Im Internet erreicht man ihn am besten bei Twitter unter @DTraub.
Thomas Strehlow
Wir beabsichtigen mit 2 Leuten zu Sprechen. Hier nur eine Vita:
Thomas Strehlow ist seit 1993 im Umfeld Business Intelligence aktiv. In den ersten Jahren entwickelte er DWH Projekte im Umfeld Netzmanagement großer Mobilfunkunternehmen. 1999 gründete er die ORAYLIS GmbH. Nach Erfahrungen mit den gängigen BI Produkten spezialisierte sich die ORAYLIS konsequent auf Microsoft BI und wurde 2006 Microsoft Gold Partner. Die persönlichen Schwerpunkte liegen in der Architektur von DWH Systemen.
Miloš Radivojević
Twitter: - MilosSQL
LinkedIn: Miloš Radivojević
Contact: https://milossql.wordpress.com/
Miloš Radivojević is a database consultant located in Vienna, Austria. He is Data Platform MVP and specializes in SQL Server for application developers and performance and query tuning. Currently, he works as a principal database consultant in bwin GVC (the largest regulated online gaming company in the world). He is co-founder of the SQL Pass Austria and speaks regularly at local and international database conferences. He is also co-author of the books SQL Server 2016 Developer’s Guide, SQL Server 2017 Developer’s Guide and Mastering SQL Server 2017.
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.
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.
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.
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.
Jen Stirrup
Contact: http://www.jenstirrup.com
Jen is a database strategist, small business owner, SQLFamily and community advocate, public speaker and blogger. Jen was elected Director-At-Large (elect) for the Professional Association of SQL Server, responsible for the EMEA regions plus the Virtual Chapter portfolio. Jen is passionate about all things data and business intelligence, helping leaders derive value from their Microsoft SQL Server, SharePoint and Office365 investments.
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.
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.
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.
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
Jan Steemann
Contact: http://www.triagens.de
Jan Steemann ist Spezialist für hochperformante Webanwendungen und NoSQL-Datenbanken bei der triAGENS GmbH in Köln. Sein aktuelles Projekt ist die Entwicklung von ArangoDB, einer Open Source Multi-Model Datenbank.
Torsten Schüßler
Contact: http://www.insidesql.org/blogs/tosc
Torsten Schüßler ist Kind der Sinclair ZX81 Generation. Als Student entwickelte und administrierte er, unter anderem, Datenbanksysteme unter Sybase SQL Server 4.0 und kam so zum MS SQL Server. Er ist einer der ersten Regulars von InsideSQL, und berichtet in seinem Blog auf www.insidesql.org über SQL Server und PASS.
André Kamman
Contact: http://andrekamman.com
André is a freelance SQL Server specialist. In previous roles he’s done a lot of DBA work on 100’s of servers where he discovered his love for Powershell and automating processes in general. Today the better part of his day he’s building and tuning ETL processes. André is a SQL Server MPV, Dutch PASS Chapter Leader and organiser of SQL Rally Amsterdam and SQLSaturday Holland
Hugo Kornelis
Contact: http://sqlblog.com/blogs/hugo_kornelis/default.aspx
Hugo is co-founder and RD lead of perFact BV, a Dutch company that improves analysis methods and develops computer-aided tools to generate completely functional applications from the analysis deliverable. The platform for this development is SQL Server. In his spare time, Hugo likes to share and enhance his knowledge of SQL Server by frequenting newsgroups and forums, reading and writing books and blogs, and attending and speaking at conferences. Hugo is also a SQL Server MVP since 2006.
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.
Mrinal Devadas
Contact: http://hortonworks.com
Mrinal Devadas
Sponsors
The following is a list of sponsors that helped fund the event: