SQLSaturday #230 - Rheinland 2013

Event Date: 07/13/2013 00:00:00

Event Location:

  • Hochschule Bonn-Rhein-Sieg
  • Grantham-Allee 20
  • Sankt Augustin, 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: 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:

Back to the SQLSaturday Event List

Back to the home page