SQLSaturday #772 - Munich 2018
Event Date: 10/27/2018 00:00:00
Event Location:
- Microsoft Deutschland GmbH
- Walter-Gropius-Str. 5
- Munich, Bavaria, 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: Auf auf in die Cloud, ihr Datenbanken [DE]
Abstract: Immer mehr Firmen möchten die Microsoft Public Cloud Azure nutzen, wissen aber nicht so recht wie man die Datenbanken dorthin bekommt. Neben dem virtuellen Server gibt es auch die Azure SQL Databases, welche in zahlreichen Solution völlig ausreichend sind und sich flexibel an die Bedürfnisse anpassen lassen. Dieser Vortrag zeigt die verschiedenen Möglichkeiten des Deployments ebenso der Migration und gibt Hinweise, worauf bei der Migration zu achten ist bzw welche Features eventuell (noch) fehlen. Es wird eine Demo-reiche Session, aus der jeder etwas mitnehmen kann wie zum Beispiel Powershell-Ideen, Ansätze für Hochverfügbarkeit oder wie man Kosten reduzieren kann.
Speaker(s):
- Björn Peters
Track and Room: Administration - New York
Title: Data Overview and Manipulation – T-SQL, R, Python [EN]
Abstract: In a real data mining or machine learning project, you spend more than half of the time on data preparation and data understanding. The R language is extremely powerful in this area. The Python language is a match. Of course, you do work with data by using T-SQL. You will learn in this session how to get data understanding with really quickly prepared basic graphs and descriptive statistics analysis. You can do advanced data preparation with many data manipulation methods available out of the box and in additional packages fro R and Python. After this session, you will understand what tasks the data preparation involves, and what tools you have in SQL Server suite for these tasks.
Speaker(s):
- Dejan Sarka
Track and Room: Analytics - Redmond
Title: From SQL to R – Leverage Your T-SQL Knowledge to Learn R [EN]
Abstract: You are already familiar with T-SQL and are eager to learn R but do not know where to start? Start from what you already know: T-SQL. Both languages have many things in common on some levels, but are very different on others. You will learn how to begin your first steps in the new language and how to perform the most common tasks, typical for R: statistics, machine learning data visualization. This session will kick you off to the new language by using analogies from T-SQL. You will learn how to write your first R-scripts, make usage of packages and will leave this session with a basic understanding of typical use-cases of R and how to integrate that into your existing environment with SQL Server.
Speaker(s):
- Markus Ehrenmueller-Jensen
Track and Room: Analytics - Redmond
Title: Continuous Delivery for BI projects [EN]
Abstract: If you are releasing new reports, SSAS cubes or SSIS packages on a regular basis, you’ve probably offered up your share of blood, toil, tears and sweat on getting them delivered into production in working condition. Continuous Delivery is a way to bridge the gap between developers and IT professionals and for that we need to address the both the toolchain to support the practices as well as the mindset on the team. Microsoft offers a set of tools that’ll help you on your journey towards the end goal: Maximize predictability, efficiency, security and maintainability of operational processes.
We will in detail be looking at:
Agile Development Frame of Mind The Path Ahead (direction) Visual Studio Online (tool) Feature/User Story/Work Item (concept) Team Services Code Branching (concept) Build Agents (tool) Releases (tool)
Speaker(s):
- Jens Vestergaard
Track and Room: Business Intelligence - Washington
Title: The joy of analytics - Let’s paint a Data Warehouse into the cloud [EN]
Abstract: There are a lot of possibilities get insights out of your data, and since years we are doing this with “old-fashioned” techniques in our “classical” data warehouse environments. But the world is changing, and so its data. Where the data years ago was always structured, the growth of different data types now seems to be infinite. We are struggling with saving data with changing schemas and getting insights of new data types like social media, video, and pictures.
In this whiteboard session, I would like to talk with you about modern ways to store, analyze and visualize data. We will draw a Modern Data Warehouse and have a look at the ways to get more insights out of your data and why the cloud could help us.
Come and join my session and draw a Modern Data Warehouse together.
Speaker(s):
- Andre Essing
Track and Room: Analytics - Redmond
Title: Power BI deployment strategy for publishing and maintenance [EN]
Abstract: Power BI: Minutes to create and seconds to impress.
Yes, it takes minutes to create and share Power BI reports. Which means every user who has relevant Power BI access can create Workspaces, Apps, reports, dashboards and schedules. With no deployment strategy, maintaining Power BI service could become a terrible job. In this session, I will cover how having a having deployment strategy can make a terrible maintenance job seamless.
This session will include: What happens when a user creates a Power BI app workspace How to control user access Working with different environments Creating and sharing reports using Power BI Apps How to monitor dataset schedules and failure notifications How to use Power BI API to document your organisation Power BI Service
Speaker(s):
- Prathy Kamasani
Track and Room: Business Intelligence - Washington
Title: Azure SQL Database Tips and Tricks for Beginners [EN]
Abstract: Microsoft released SQL Azure more than eight years ago - that’s enough time for testing. So, are you ready to move your data to the Cloud? If you’re considering a business (aka production environment) in the Cloud, you need to think about methods for back up your data, a backup plan for your data and, eventually (sic!) restoring data.
In this session, you’ll see the differences, functionalities, restrictions, and opportunities in SQL Azure DB and On-Premise SQL Server 2008/2008 R2/2012/2014/2016/2017. We will look for 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: Administration - New York
Title: The Microsoft Power Platform - What is it? [EN]
Abstract: May I introduce you to the Microsoft Power Platform!? This new term was introduced by Satya Nadella and James Philips as the serving foundation for building powerful (cloud-baked) applications. PowerApps as the data manipulation part, Microsoft Flow as the connecting workflow engine and Power BI for analysis and reporting. In addition, the Common Data Service (CDS) and the Common Data Model (CDM) provide a solid framework for data storage and modelling. Join me in this session if you want to get an overview about the involved technologies, how they work together, see them live working together in many demos and how they will definitely change the way of building powerful solutions in the future!
Speaker(s):
- Wolfgang Strasser
Track and Room: Business Intelligence - Washington
Title: Embrace and Extend: First-Class Activity and 3rd Party Ecosystem for SSIS in ADF
Abstract: This session focuses on the deeper integration of SQL Server Integration Services (SSIS) in Azure Data Factory (ADF) and the broad extensibility of Azure-SSIS Integration Runtime (IR). We will first show you how to provision Azure-SSIS IR – dedicated ADF servers for lifting shifting SSIS packages – and extend it with custom/3rd party components. Preserving your skillsets, you can then use the familiar SQL Server Data Tools (SSDT)/SQL Server Management Studio (SSMS) to design/deploy/configure/execute/monitor your SSIS packages in the cloud just like you do on premises. Next, we will guide you to trigger/schedule SSIS package executions as first-class activities in ADF pipelines and combine/chain them with other activities, allowing you to inject/splice built-in tasks/data transformations in your ETL/ELT workflows, automatically provision Azure-SSIS IR on demand/just in time, etc. And finally, you will learn about the licensing model for ISVs to develop paid components/extensions.
Speaker(s):
- Tillmann Eitelberg
Track and Room: Business Intelligence - Washington
Title: The Solisyon Nerd-Quiz
Abstract: Nerdolisyon geht in die Dritte Runde! Quizmaster Ben Weissman hostet DAS Quiz für Nerds, Geeks und Fans, bei dem jede richtige Antwort mit einem Preis belohnt wird. Ihr wisst alles über Star Trek, Wars und Gate, schlaft im DC-PJ in der MARVEL-Bettwäsche und kennt die Frage zur Antwort 42? Dann seid ihr beim Solisyon Nerd-Quiz genau richtig! Für diejenigen, die jetzt den Kopf geschüttelt haben, ist das Quiz eine Pflichtveranstaltung: Dort wird euch geholfen. Spielt mit oder schaut zu und lernt fürs Leben – Spaß habt ihr in jedem Fall.
Nerdolisyon Round Three: Quizmaster Ben Weissman will be hosting THE Quiz for nerds, geeks and fans where EVERY right answer wins a prize. You know everything about Star Trek, Wars and Gate, sleep with DC-PJs in MARVEL-bedding sets knowing the question that is answered with 42? Then the game is on! For those that’s a negative for, the Solisyon Nerd Quiz is MANDATORY: there is still hope! Join in, watch, learn and laugh with us.
Speaker(s):
- Ben Weissman
Track and Room: Sponsor/Lunch Session - New York
Title: Common Data Service – Your new Enterprise Data Repository [EN]
Abstract: Conmmon Data Services are a quite new offering in the Microsoft Data Platform. This session will explain how to use it in combination with Power BI, Apps or Dynamics 365. We will have a closer look in using CDS for Data Governance, Analytics and App Development. We will show loading scenarios in Power Query style, but also detect the Master Data functionality in the cool service.
Speaker(s):
- Oliver Engels
Track and Room: Business Intelligence - Washington
Title: 13 reasons why my query is slow [EN]
Abstract: What if we could analyze a single query with thirteen different performance problems? In this session we’ll explore a query, understand and fix all thirteen problems.
1- There is a nonsargable filter 2- An index is missing 3- It is a query optimizer mistake 4- The subquery is unnecessary 5- Query join order is incorrect 6- A filtered statistic is missing 7- Scalar functions are running twice per each row 8- High number of reads on worktable 9- An unknown syntax could be used 10- Memory grant wasn’t enough 11- Distributed query doesn’t look good 12- Residual predicates 13- Avoid window spool ondisk
Speaker(s):
- Fabiano Amorim
Track and Room: Development - Redmond
Title: From relational to Multimodel : Azure Cosmos DB [EN]
Abstract: Azure Cosmos DB is Microsoft’s globally distributed, multi-model database. This is NoSQL in the cloud. In this session, you’ll see how to use it to create columnar tables, JSON documents and graphs, you’ll understand what that means, see what’s the difference with relational tables, and how it can be useful for you.
Speaker(s):
- Rudi Bruchez
Track and Room: Development - Chicago
Title: Connecting SQL and Blockchain: The Azure Blockchain Workbench [EN]
Abstract: Getting a PoC for a Blockchain project running is hard enough. Connecting Blockchain data to classical databases, making them available to analytics or standard applications is worse (ever queried LevelDB?). Microsofts new “Azure Blockchain Workbench” let you do this in hours, not months. We will see how to
- Deploy a Blockchain on Azure in a breeze
- Generate templates for smart contracts
- Connect them to IoT devices
- Interact with the contracts via a simple UI
- Get all the data into a “real” database automatically
Speaker(s):
- Christoph Seck
Track and Room: Development - Chicago
Title: TensorFlow as a Service [DE]
Abstract: Wer mit beliebten KI-Frameworks, wie beispielsweise TensorFlow, CNTK, Caffe, Chainer Co, ein Modell bauen wollte, musste sich bislang selbst um die komplette Infrastruktur kümmern und seine Data Science IDE entsprechend konfigurieren. Doch das hat jetzt ein Ende. In dieser Session zeigt Sascha Dittmann wie man mit der Azure Machine Learning Workbench und dem Azure Batch AI Dienst eine durchgängige und einfach zu nutzende Data Science Umgebung aufbaut. Mit dieser lassen sich dann im großem Umfang parallel experimentieren, sowie Deep Learning- und KI-Modelle trainieren.
Speaker(s):
- Sascha Dittmann
Track and Room: Analytics - Redmond
Title: Power Metal mit Power BI [DE]
Abstract: Im, nicht immer ganz ernst gemeinten, Vortrag zeigen Dr. Benjamin Kettner und der deutsche Data Platform MVP Frank Geisler unterschiedliche Einsatzmöglichkeiten von Power BI und Artificial Intelligence am Beispiel einer Datenbank aus dem Bereich Heavy Metal (Finanzdaten kann ja jeder…;)). Es wird sowohl auf Streaming Data wie auch auf die Einbindung von Web-Services wie auch auf verschiedene AI Techniken wie z.B. Klassifizierungsalgorithmen eingegangen. Neben der Technik steht auch der Spaß im Vordergrund dieser lebhaften Session. In diesem Sinne: Metal will never die! ;)
Speaker(s):
- Frank Geisler
Track and Room: Business Intelligence - Washington
Title: Becoming a hipster DBA, a guide to Github and CI/CD for Admins [EN]
Abstract: The use of securing your code in source control and testing it automatically with a continuous integration tool is not something developers need to be convinced of. But DBAs have traditionally not used any of these techniques. It’s also not that straight forward for them. Checking the outcome of a typical DBA script usually involves the need for infrastructure to be available in a certain state and tests that check the changes made to that infrastructure. This session will combine an introduction level talk about Git(hub) and Continuous Integration with the complexity of Infrastructure testing aimed ad DBAs.
Speaker(s):
- André Kamman
Track and Room: Administration - New York
Title: Let’s build SSIS packages with Biml – live [EN]
Abstract: You have heard about Biml? Maybe even seen a session about it before but still have doubts, how easy you can make something useful out of it? In this session, we’ll use Biml to build and populate a staging area including the corresponding SSIS packages. But there won’t be any pre-compiled demos! Everything is happening live! Starting with a blank staging database, we’re going to end up with a complete solution over the course of this session, to prove that it is not just easy to adapt existing Biml code but also to start from scratch and still be successful very quick!
Let’s see, how that goes…
Speaker(s):
- Ben Weissman
Track and Room: Business Intelligence - New York
Title: Azure SQL Managed Instance - Microsofts next try [EN]
Abstract: Mit der neuen Azure Datenbanklösung will Microsoft nun den nächsten Schritt nach den PaaS Lösungen einer Azure Datenbank als Single DB und Elastic Pool machen. Was bringt die neue Lösung nun für Vorteile. In dieser Session soll die neue Lösung den bisherigen gegenübergestellt werden und auf die Möglichkeiten eingegangen werden.
Speaker(s):
- Maic Beher
Track and Room: Administration - New York
Title: PowerShell for the DBA: Why I love my inner pig-dog [EN]
Abstract: DBAs and sysadmins never have time for the fun stuff. We are always restoring a DB for a dev or setting up a new instance for that new BI project. What if I told you that you can make all that time consuming busy-work disappear?
In this session we will learn to embrace the power in PowerShell to allow us to sit back and relax….. or rather focus on the real work of designing better, faster systems instead of fighting for short time slots when we can do actual work.
Along the way we will see that we can benefit from the wide world of PowerShell expertise and avoid re-inventing the wheel, again!
Speaker(s):
- William Durkin
Track and Room: Administration - New York
Title: Stop everything! T-SQL tips to make a Developer life easier [EN]
Abstract: Writing a better code is always a difficult challenge. In this session we are going to investigate some common issues and learn new tips that will help you to be a better developer and then help the DBA keep his databases safer.
Speaker(s):
- Marcos Freccia
Track and Room: Development - Chicago
Title: Epidemic Plague: Superficial Indexing [EN]
Abstract: Proper indexing is a very time and cost-effective way to improve SQL performance. Yet hardly anyone gets it right or knows how different ways to write a query affects indexing and performance. In this session I’ll explain why this knowledge is sparse and what developers can do about it. Finally we will go through the most important indexing mistakes by example and discuss them during a short live quiz with the audience.
Speaker(s):
- Markus Winand
Track and Room: Development - Chicago
Title: The Query Store and Query Tuning in SQL Server [EN]
Abstract: For the most part, query tuning in one version of SQL Server is pretty much like query tuning in the next. Azure SQL Database and SQL Server 2016 introduced the most important change to query tuning in ages, the Query Store. This session will explore how the Query Store works in Azure, SQL Server 2016 and SQL Server 2017. You will learn how Query Store changes the methods you use to troubleshoot and tune query performance. With the information in this session, not only will you understand how the Query Store works, but you’ll know everything you need in order to put it to work with your own SQL Server databases.
Speaker(s):
- Grant Fritchey
Track and Room: Development - Chicago
Title: Writing PowerShell with VS Code [EN]
Abstract: We should be using VS Code to write our PowerShell code. In this presentation I will show you how to set up VS Code, which extensions I use, and some of the features that make writing PowerShell easy using VS Code.
Speaker(s):
- Rob Sewell
Track and Room: Development - Chicago
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Rob Sewell
Twitter: - sqldbawithbeard
LinkedIn: Rob Sewell
Contact: http://sqldbawithabeard.com
Rob was once a production SQL Server DBA, but is now generally found automating the Data Platform and providing training for clients. He has a passion for PowerShell, Data, and DevOps. He is an MVP, an officer for the DevOps PowerShell VG, and has spoken and volunteered at many PowerShell and Data events. He is a member of the committee that organises Data In Devon and the European PowerShell Conference. He is a proud supporter of the Data and PowerShell communities.
He relishes sharing and learning and can be found doing both via Twitter @sqldbawithbeard and his blog sqldbawithabeard.com. He spends most of his time looking at a screen and loves to solve problems.
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.
Khoder Elzein
Twitter: - @khoderelzein
LinkedIn: Khoder Elzein
Khoder is responsible for presales at Theobald Software and always has an attentive ear for business partners. When travelling in Germany or abroad, he provides customer support at PoCs, workshops and on training courses. He also looks after the product management development. Khoder has been working in IT since the turn of the millennium; he has been a member of team Theobald since 2009 and enjoys working as speaker, blogger and trainer.
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
Markus Ehrenmueller-Jensen
Twitter: - MEhrenmueller
LinkedIn: Markus Ehrenmueller-Jensen
Contact: http://www.savorydata.com
Markus Ehrenmueller-Jensen, as the founder of Savory Data, has a long history of providing customer solutions in the areas of data engineering, data science, and Business Intelligence. He is a certified software engineer, a graduated business educator, and professor of Databases Project Management at HTL Leonding, and is certified as an MCSE MCT. He is a published author and writes articles for well-known journals. He co-founded PASS Austria and organizes SQLSaturdays in Austria. Markus is a founding member of Power BI Usergroup Austria. Since 2017 Markus was awarded as an Microsoft Data Platform MVP.
Sascha Dittmann
Twitter: - SaschaDittmann
LinkedIn: Sascha Dittmann
Contact: http://www.sascha-dittmann.de/
Sascha Dittmann ist Cloud Solution Architect bei der Microsoft Deutschland GmbH und unterst#252;tzt hierbei Kunden beim Implementierungsprozess erfolgreicher Cloud-L#246;sungen. Seine Schwerpunkte liegen in der Softwareentwicklung f#252;r die Microsoft Azure Plattform, sowie im SQL Server Business Intelligence und Big Data Bereich.
Bevor er Ende 2015 zu Microsoft kam, war er viele Jahre bei der heutigen Ernst amp; Young GmbH t#228;tig; Davon 13 Jahre als Softwareentwickler und 3 Jahre als Solution Architect. W#228;hrend dieser Zeit Gr#252;ndete er auch die Community-Webseiten cloudbloggers.de und cloudbloggers.net und war Mitbegr#252;nder des .NET Stammtischs Rheinhessen. Zwischen 2012 und 2015 wurde er 4-mal mit dem MVP-Award im Bereich Microsoft Azure ausgezeichnet.
Marcos Freccia
Twitter: - @sqlfreccia
LinkedIn: Marcos Freccia
Contact: http://marcosfreccia.wordpress.com
Currently working as a Microsoft SQL Server DBA at Zalando SE, Marcos has over 9 years of SQL Server experience, working from small to enterprise environments with High Availability, Disaster Recovery, Database Optimization, etc.. Holding several Microsoft certifications such as: MCITP DBA DEV, MCSE Data Plataform and his last certification on Microsoft Azure Design and Implement Cloud Data Platform Solutions. In 2013 Marcos was awarded as a Microsoft MVP by his contributions in the Brazilian SQL Server community. Marcos is a frequent speaker in the SQL Server Community and he was the organizer of the first SQLSaturday in South Brazil.
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.
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.
Dejan Sarka
Twitter: - DejanSarka
Contact: http://blogs.solidq.com/dsarka/Home.aspx
Dejan Sarka, MCT and Data Platform MVP, is an independent trainer and consultant that focuses on development of database and business intelligence applications. Besides projects, he spends about half of his time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or co-author of eighteen books about databases and SQL Server. Dejan Sarka has also developed many courses and seminars for Microsoft, Radacad, SolidQ, and Pluralsight.
Björn Peters
Twitter: - https://twitter.com/sql_aus_hh
LinkedIn: Björn Peters
Contact: http://www.sql-aus-hamburg.de
I’ve started with SQL Server 6.5 but only as a sys-admin and not as DBA. Later I’d worked as a full DBA with SQL Server 2000 and my love to SQL Server started. In 2015 I’d got more interested in SQL PASS and tried to speak for the first time… the main part of my job is to work as DB-Admin and solution architect but I’m trying to widen my horizons. In 2016 I’ve visited and volunteered at the German SQLSaturdays und SQLGrillen and since October 2016 I’m the organizer of Azure Meetup Hamburg.
Andre Essing
Twitter: - @aessing
LinkedIn: Andre Essing
Contact: http://www.andreessing.de/
Andre Essing advises, in his role as Technology Solutions Professional, customers in topics all around the Microsoft Data Platform. Since version 7.0, Andre gathering experience with the SQL Server product family, where he has focused on infrastructure topics, mission-critical systems and security. Today Andre concentrates on working with data in the cloud, like Modern Data Warehouse architectures, Artificial Intelligence and new scalable database systems like Azure Cosmos DB.
In addition to his work at Microsoft, Andre is engaged in the community as a chapter leader for the PASS chapter in Bavaria, Germany. You can meet him as a speaker at user groups and international conferences.
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”.
Ben Weissman
Twitter: - bweissman
LinkedIn: Ben Weissman
Ben Weissman has been working with SQL Server since SQL Server 6.5, mainly in the BI/Datawarehousing field. He is a Data Platform MVP, MCSE Data Management and Analytics, and a Certified Data Vault Data Modeler. He is also the first BimlHero Certified Expert in Germany and a co-author of ‘SQL Server Big Data Clusters’ and ‘The Biml Book’. Ben has been involved in more than 150 BI Projects and is always looking for ways to become more productive and make SQL Server even more fun! Together with his team at Solisyon, Ben provides training, implementation and consultancy for SQL/BI developers and data analysts in upper-mid-market companies around the globe.
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.
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.
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).
Fabiano Amorim
Twitter: - mcflyamorim
LinkedIn: Fabiano Amorim
Contact: http:\blogfabiano.com
Fabiano Amorim is a Data Platform MVP that loves to conquer complex, challenging problems—especially ones that others aren’t able to solve. He first became interested in technology when his older brother would bring him to his work meetings at the age of 14. With over a decade of experience, Fabiano is well known in the database community for his performance tuning abilities. When he isn’t working, he loves to read and spend time with his family.
Prathy Kamasani
Twitter: - @pkamasani
LinkedIn: Prathy Kamasani
Contact: http://prathy.com/
Prathy Kamasani is a Microsoft Valuable Professional working as an independent MSBI contractor based in London. She specialises in Power BI, SSIS, SSAS and SSRS. Prathy organisers London Power BI user group and co-organizes the London PASS Local Group. She is a regular speaker at events like SQLSaturday and local user groups.
Grant Fritchey
Twitter: - @gfritchey
LinkedIn: Grant Fritchey
Contact: http://scarydba.com
Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.
Markus Winand
Twitter: - https://twitter.com/MarkusWinand
LinkedIn: Markus Winand
Contact: http://use-the-index-luke.com/
Markus Winand tunes developers for high SQL performance. He also published the book quot;SQL Performance Explainedquot; and offers in-house training as well as remote coaching at http://winand.at/
Maic Beher
Maic Beher ist als Consultant in Industrie, Mittelstand und internationalem Finanzumfeld seit über 15 Jahren unterwegs. Seine Schwerpunkte befinden sich dabei im Aufbau angepasster Betriebskonzepte mit Hochverfügbarkeitskomponenten, beim Design der Datenbanksicherheit im Verbund mit den weiteren Fachbereichen und bei den Lösung von Performanceproblemen. Als Microsoft zertifizierter Trainer schult er regelmäßig die SQL MOC Kurse, hält aber auch auf Kunden zugeschnittene Kurse an.
Cornelia Matthesius
Cornelia “Conny” Matthesius discovers the broad field of BI development since 2011 for her job in a medical technology company. She could never do this without the wonderful people in the SQL Server community and tries to return their favors by baking chocolate chip cookies and co-organizing the local PASS group in Hamburg.
Rudi Bruchez
Twitter: - nepasderanger
LinkedIn: Rudi Bruchez
Contact: http://www.babaluga.com/
(same as before)
Ben Weissman
Twitter: - bweissman
LinkedIn: Ben Weissman
Ben Weissman has been working with SQL Server since SQL Server 6.5, mainly in the BI/Datawarehousing field. He is a Data Platform MVP, MCSE Data Management and Analytics, and a Certified Data Vault Data Modeler. He is also the first BimlHero Certified Expert in Germany and a co-author of ‘SQL Server Big Data Clusters’ and ‘The Biml Book’. Ben has been involved in more than 150 BI Projects and is always looking for ways to become more productive and make SQL Server even more fun! Together with his team at Solisyon, Ben provides training, implementation and consultancy for SQL/BI developers and data analysts in upper-mid-market companies around the globe.
Jens Vestergaard
Twitter: - @vestergaardj
LinkedIn: Jens Vestergaard
Contact: http://www.t-sql.dk
Jens performs the traditional BI disciplines from imports in Integration Services through data consolidation in Analysis Services, to report in Power BI or Reporting Services. Jens has worked with The Stack since SQL 2000 and has a core competence in Integration Services and Analysis Services. Along with the certified skills in Microsoft SQL Server, Jens has also worked with Microsoft .Net platform for more than 15 years and currently manages a BI Platform in Azure for the CatMan Solution application(s).
Oliver Engels
Twitter: - @oengels
Contact: http://www.ssis-components.net
Oliver Engels is CEO of oh22data AG, a Microsoft Gold Partner in Germany specializing in CRM and BI. His special interests are Azure, Data Governance and Integration, Visualisation Tools like SSRS, Power BI, Tableau, R, and SharePoint. He has worked with SQL Server since version 6.5 and is a founder and Board member of PASS Germany, a PASS Regional Mentor, and runs the Frankfurt PASS Local Group. For more than seven years he is a Microsoft Data Platform MVP and a Microsoft pTSP.
Sponsors
The following is a list of sponsors that helped fund the event: