SQLSaturday #679 - Vienna 2018
Event Date: 01/19/2018 00:00:00
Event Location:
- Jufa Wien
- Mautner-Markhof-Gasse 50
- Vienna, Vienna, Austria
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: Worst Practices Less Known Limitations for Columnstore Indexes [DE/EN]
Abstract: Have you ever considered a situation where Columnstore Index can be quite the opposite of what one would expect from it? A slow, wasteful source of painfully slow queries, lagging the performance, consuming irresponsible amount of resources …
Setting the wrong expectations (it won’t run 100 times faster on EVERY query), selecting the wrong architecture (partition by 100s of rows instead of millions), using and aggregating by the large Strings in the fact tables – this list is actually quite large.
What about some of the less known limitations for building Columnstore Indexes? The ones that will bite you suddenly in the middle of the project – when you do not expect it at all?
Let me show you how to achieve those painful mistakes and you will surely know how to avoid them :)
Speaker(s):
- Niko Neugebauer
Track and Room: Development - DBPLUS
Title: Comparing Predictive Mining Models from R, Python, SSAS, and Azure ML [EN]
Abstract: There is a lot of overlapping in Microsoft BI suite. For advanced analytics, like data mining, you can use SQL Server Analysis Services (SSAS), or R, or Python, or Azure ML. The question arises which tool to use. The answer is simple, through another question. Why not all of them? In data mining, you typically create multiple predictive models for the same task, and then evaluate them to select the best one. So why wouldn’t you even use different tools for different models? You will learn how to evaluate the predictive models. Then you will see how to bring all of the mining models together and compare them no matter of the source they come from. You will see how you can use SQL Server Integration Services, Excel, and other tools for this task.
Speaker(s):
- Dejan Sarka
Track and Room: BI (Advanced Analysis, Visualization, Information Delivery) - Solysion
Title: Implementing a hybrid data warehouse [EN]
Abstract: The last couple of years have seen the emergency of “Big Data”, “Cloud” and “Internet of Things”. Subsequently, Gartner at the 2016 Gartner Summit in Barcelona declared the Enterprise data warehouse (EDW) as dead. Which of course is silly. Sensible companies don’t just throw money out of the window. But they need to adapt and change when new opportunities arrive. Enter the hybrid data warehouse. Combining the power of big data and cloud with your trusty EDW.
This session will take a look at a few different approaches to a hybrid data warehouse, with components such as SQLServer 2016, Azure Data Lake, HDInsight, Azure Analysis Services, Azure SQL Data warehouse and Polybase, with some scenarios where the approaches might become relevant. And some pitfalls you need to know about along the way.
Speaker(s):
- Johan Ludvig Brattås
Track and Room: Cloud (Application Development Deployment) - SolidQ
Title: Advanced insides into System Versioned Temporal Tables [DE/EN]
Abstract: SQL Server 2016 introduces support for system-versioned temporal tables as a database feature that brings built-in support for providing information about data stored in the table at any point in time rather than only the data that is correct at the current moment in time.
This session takes you behind the basics of Temporal Tables and answers - after a short introduction - the following questions:
- How to handle the change of NULL constraints?
- Can Temporal Tables be renamed and what happens to the System Versioned table?
- What will happen if you change meta data (data length, data type, …)?
- What happens if you drop a column or add another column to the Temporal Table?
- what about security for the system versioned table?
- what about calculated columns in the temporal table?
- …
You are interested in the answers to all the above questions (and more). This session will answer EVERY question about Temporal Tables.
Speaker(s):
- Uwe Ricken
Track and Room: Administration (Platform, Architecture) - Solysion
Title: Deadlocks. Everything you ever wanted to ask but were too shy. [EN]
Abstract: It’s not a secret that a deadlock - it’s not very good. Definition of deadlock is very simple and quite clear: This is an exceptional situation when two concurrent queries request same resources but in a different order.
Classic deadlock can occur when two concurrent transactions are modifying data from the two tables in a different order. Unfortunately, in real life deadlocks often are more complex and unobvious. One of the rules, which I always keep in mind, sounds: “You can not design a database, in which the occurrence of deadlock is impossible”. And we should deal with them. The algorithm is simple:
- Catch the deadlock
- Find the root cause
- Design and implement a solution. In practice, these steps can be tricky and may require different types of analysis.
In this session, we will look at ten various deadlocks scenarios and find the root cause of the deadlocks. Then, you will see how it will be easy to get the solutions for the deadlock issue if we did the secon
Speaker(s):
- Denis Reznik
Track and Room: Administration (Platform, Architecture) - Quest
Title: Data Science for beginners [EN]
Abstract: Data science can be hard to grasp, complex and big, but making data science easy to understand and bringing it closer to all who want to tackle this new emerging field is an important task in world of data. Exploring, extracting and finding hidden gems from data using statistical and mathematical methods, computer science and several different technologies is essentially what data science is doing. In practice this means, data science is an iterative process of harvesting data, managing and cleaning the data, performing analysis and and at the end interpreting, visualizing and using information that will bring insights to end-user, business people and making decisions much easier. We will focus on answering 5 simple questions.
1) is this weird? 2) is A better than B, respectively? 3) how much / many of this is needed? 4) this belong to group A? 5) what is next?
Session we will look into technologies that can be tackled using SQL Server 2016 and ML Azure.
Speaker(s):
- Tomaž Kaštrun
Track and Room: BI (Advanced Analysis, Visualization, Information Delivery) - Idera
Title: SQL Server Availability Groups Configuration, Maintenance and Troubleshooting [EN]
Abstract: SQL Server Availability Group is a still newest HA feature available in SQL Server, even it’s (highly) available from SQL Server 2012. After you successfully configure and deploy your first AG, you will need to further monitor and maintain AG to ensure that your environment stays highly available after deployment in production. Also, troubleshooting is a part of every DBA’s real life and we will not even avoid this part. In this session, besides looking on the AG newest features in SQL Server 2016/2017, we will address most common scenarios of administration, monitoring and troubleshooting of Availability Groups. This session is useful for DBA’s that are using or considering Availability Groups for high availability in SQL Server 2016/2017.
Speaker(s):
- Karol Papaj
Track and Room: Administration (Platform, Architecture) - Idera
Title: Adopting Database Lifecycle Management (DLM) at a large Viennese software house [EN]
Abstract: At Greentube business is booming. However, for the last few years they have faced increasing problems scaling their product and headcount.
Like many orgs, Greentube has a complicated SQL Server backend which supports many apps.
In 2016, despite best efforts, the database was not in source control, deployments were manual and the production database schemas were out of sync. The core database team was struggling to keep up with the business’s rapid growth because so much time was wasted firefighting unexpected issues.
The business recognised that the database was a bottleneck on the company’s growth. And that was an expensive problem.
Come and learn from Manoj Lona, the DB Team Lead at Greentube, and Alex Yates, a DLM Consultant from DLM Consultants, about how last year they made the necessary technical and organisational changes that today enable GreenTube to deploy their database at the click of a button - allowing them to scale their product and headcount to meet business
Speaker(s):
- Alex Yates
Track and Room: Development - Trivadis
Title: Benchmarking like a Pro [EN]
Abstract: Exciting times ahead! You bought a license for SQL Server 2016 and you are going to upgrade to the new shiny version of SQL Server on a beefy new machine! Fantastic! Except that you have no idea how your application will work on the new version. There’s a new cardinality estimator in 2016: how will it affect performance? The new features in In-Memory OLTP and Columnstore Indexes look really promising, but how will your workload take advantage of these features? The best way to know for sure is to conduct a benchmark and compare it to your current system. In this demo-intensive session you will discover how to capture a meaningful workload in production and how to replay it against your test system. You will also learn which performance metrics to capture and compare, and which tools can help you in the task.
Speaker(s):
- Gianluca Sartori
Track and Room: Administration (Platform, Architecture) - Quest
Title: Fun with Legal Information in SQL Server: Correlating Offers and Counter-offers [EN]
Abstract: In this session you will learn about a typical challenge in legal information management: how to determine whether two (or more) offers to sell, or purchase, products (or services) represent the basis of a legally binding contract. You will learn which techniques are used to correlate the data in terms of the range of objects, their quantities, their qualitative properties, while also taking into account the temporal properties of the offers. You will also learn how clustered columnstore indexes can be used to improve the efficiency of the queries needed to solve this important legal problem.
Speaker(s):
- Matija Lah
Track and Room: Development - Solysion
Title: Industry 4.0 in a box [DE]
Abstract: IoT is often associated with developer boards such as the Raspberry PI or Arduino. However, IoT has not only played an important role under the slogan “Industry 4.0”, many industry companies are using IoT in their production lines since years.
To show the potential of the Azure IoT in connection with industry components, we have took a conveyor belt, a sorting unit and sensor technologies built-in in a small flightcase. All these industry components are communicating directly to an Azure IoT Hub.
See how we can analyze the generated data with Stream Analytics and building Power BI dashbaords with streaming data. We will also show how we can interact with the components via cloud 2 device messages if the analysis shows errors or disfunctionalities and how Cortana Analytics can help minimize errors.
Speaker(s):
- Tillmann Eitelberg
Track and Room: Development - SolidQ
Title: Hacking SQL Server [EN]
Abstract: How easy is it to hack a SQL Server? In this session we’ll see examples on how to exploit SQL Server, modify data and take control, while at the same time not leaving a trace. We’ll start by gaining access to a SQL Server (using some “creative” ways of making man-in-the-middle attacks), escalating privileges and tampering with data at the TDS protocol level (e.g. changing your income level and reverting without a trace after payment), hacking DDM, RLS, and more. More important, we’ll also cover recommendations on how to avoid these attacks, and take a look at the pros and cons of new security features in SQL Server 2016. This is a demo-driven session, suited for DBAs, developers and security consultants. Disclaimer: No actual crimes will be committed. Please do not send agents to my house again.
Speaker(s):
- André Melancia
Track and Room: Administration (Platform, Architecture) - Quest
Title: Azure SQL DW: Optimization technics to maximize performance [EN]
Abstract: Azure SQL DW is powerful MPP cluster for processing a big amount of structured data. But, it still requires optimization to maximize performance and optimize resource usage. Some technics almost similar to what we do with our regular SQL Server, some of them not due to MPP architecture. In this session, I will cover next topics:
- how to minimize the time of data loading
- how to choose a right distribution type
- data movement minimization
- how scaling and resource class could help to improve data processing performance
- maximize Column Store index performance
- update statistics
- partitioning strategy
Speaker(s):
- Sergiy Lunyakin
Track and Room: Cloud (Application Development Deployment) - SolidQ
Title: SQL Query Performance Monitoring und Analyse [DE]
Abstract: Dieser Vortrag beschäftigt sich anhand konkreter Praxisbeispiele mit dem SQL Query Performance Monitoring und der Analyse mit dem DBPLUS Performance Monitor™.
Der Vortrag gibt Antworten auf die Fragen: Wie identifiziert man schnell unter abertausenden SQL-Abfragen die Wesentlichen hinsichtlich CPU, logischem bzw. physischem IO zu einem spezifischen Zeitpunkt oder über Zeit? Wie lassen sich verändernde Ausführungsplänen auffinden und über Zeit historisch analysieren? Welche Abfragen wurden heute erstmalig ausgeführt bzw. sind für eine Lastspitze zu einer bestimmten Zeit verantwortlich? Welche Abfragen greifen auf eine bestimmte Tabelle zu? Wie kann ich in Sekunden Lastprofile historisch vergleichen und visualisieren? Und wie geht das überhaupt bereits ab SQL Server Version 2005 ohne den Query Store, Instanzweit und Datenbankübergreifend und ohne T-SQL in einer intuitiven grafischen Oberfläche?
Speaker(s):
- Michael Roedeske
Track and Room: Administration (Platform, Architecture) - DBPLUS
Title: M and Power Query Beyond Limits [EN]
Abstract: Power Query is the transformation engine in Power BI. This is the engine that you do all data preparation before loading data into the model. This is the keystone of your Power BI solution. In this session, you will learn what things Power Query can do. M is the language behind the scene of Power Query, you will learn how M can be more beneficial than the Power Query Graphical interface. You will see demos of transformations that you can do with M Code. This session is full of live demos. Prepare to be amazed with what Power Query can do with heaps of demos in this session.
Speaker(s):
- Reza Rad
Track and Room: BI (Advanced Analysis, Visualization, Information Delivery) - DBPLUS
Title: Azure Analysis Services - An important step for BI in the cloud? [DE / EN]
Abstract: Since April 2017 another fascinating PaaS in the Microsoft Cloud reached general availability: Azure Analysis Services. But why should you switch from your existing on-premise solution to the cloud or plan your new approach with it? What are the big advantages of Azure Analysis Services? And what actually are the differences to PowerBI? Why is Azure Analysis Services an important step to enhancing the possibilities for BI in the cloud? This session offers answers to your questions and provides insight to support the positioning of Azure Analysis Services in your Business Intelligence strategy.
Speaker(s):
- Gabi Münster
Track and Room: BI (Advanced Analysis, Visualization, Information Delivery) - DBPLUS
Title: Shaving of Microseconds [DE / EN]
Abstract: This session is a compilation of extreme techniques I had to use over time to make very fast operations go a bit faster. It will cover multiple areas (indexing, table design, data access layer, schemas, object naming, datatyped, collations physical data placement and more. All examples given in this session are from real world cases of some of the most demaning workloads in the world.
Speaker(s):
- Thomas Grohser
Track and Room: Development - Quest
Title: PowerShell for the DBA: Why I love my inner pig-dog [DE/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 (Platform, Architecture) - Idera
Title: Understanding the Power BI data model [EN]
Abstract: In this session we will look at all the important topics that are needed to get your Power BI modelling skills to the next level. We will cover the in memory engine, relationships, DAX filter context, DAX vs M and DirectQuery.
Speaker(s):
- Kasper de Jonge
Track and Room: BI (Advanced Analysis, Visualization, Information Delivery) - Idera
Title: Lockless in Seattle: Using In-Memory OLTP Transaction Processing [EN]
Abstract: Locks and latches have long been the mechanism used to implement SQL Server concurrency control, but with the introduction of In-Memory OLTP the paradigm has shifted. Are we really looking at the Brave New World of Transaction Processing or a dystopian nightmare?
In this session, we will understand how In-Memory OLTP architecture is implemented and how its mechanics function. We will learn what transactional bad dependencies and other considerations are introduced by its use and what capabilities are provided by SQL Server 2016.
Speaker(s):
- Mark Broadbent
Track and Room: Development - DBPLUS
Title: Lightning Talks (5 speakers, 5 talks, 10min each) [EN]
Abstract: Alexander Arvidsson - Speak Your Hands Asgeir Gunnarsson - Analysis Services Documentation Solution Erik Monchen - Sharing in Power BI Marcos Freccia - My 5 favorite Powershell commands Jan Mulkens - Data Science, easy until it’s not
Speaker(s):
- Markus Ehrenmueller-Jensen
Track and Room: Lightning Talks - Solysion
Title: DB Application Monitoring with Azure Application Insights [DE / EN]
Abstract: Modern cloud-based applications consists of many different services, databases, apps, websites, etc. Application monitoring is crucial because without it, it nearly impossible to quickly find the root cause of problems. Microsoft offers the PaaS offering Application Insights for this use case. In this session, long-time Azure MVP Rainer Stropek introduces Application Insights. He will focus on those features that are relevant for data-driven applications. You will see dependency tracking for SQL Server, performance monitoring, App Insights Analytics, Power BI integration and many other features.
Speaker(s):
- Rainer Stropek
Track and Room: Cloud (Application Development Deployment) - Trivadis
Title: Champions League Final Battle - Tableau vs. Power BI [EN]
Abstract: If you look into the Gardner Quadrant you will see two major players in Self-Service BI: Tableau and Power BI. Of course there is a lot in the press, but hey, here are two guys one Microsoft MVP and a Tableau Expert and these to will hold a final of these massive competitors battling on a real world exercise. If you are interested to see the differences in playing skills, tackling, pressing and how the goal keepers handle penalties. have a look. After that session you are prepared and know whether a Tableau or Power BI come in and says: I can do this in my tool better… and we can tell you: It will be fun as well to see the battle.
Speaker(s):
- Oliver Engels
Track and Room: BI (Advanced Analysis, Visualization, Information Delivery) - Idera
Title: Power BI Server - On Premises [DE / EN]
Abstract: In dieser Session zeigen wir was mit dem Power BI Server, den man inzwischen auch lokal installieren kann möglich ist. Neben der Installation erklären wir die Unterschiede zur Cloud-Variante, erläutern die Bereitstellung des Servers mit und ohne SQL Server 2017. Außerdem zeigen wir, wie man den Power BI Server in andere Umgebungen wie beispielsweise SharePoint oder eigene Applikationen integrieren kann.
Speaker(s):
- Frank Geisler
Track and Room: BI (Advanced Analysis, Visualization, Information Delivery) - SolidQ
Title: Build your next BI solution in azure [DE/EN]
Abstract: Azure bietet eine Vielzahl von Diensten und Services an, die man zu einer BI Solution in der Cloud zusammenstellen kann. Welche Möglichkeiten bietet aktuell Azure um eine zeitgemäße BI Architektur zu erstellen? Die Komponenten, die derzeit angeboten werden reichen von Azure SQL DB und SQL DWH über Data Factory, Stream Analytics, Logic App bis hin zu Analysis Services und Power BI um nur ein paar zu nennen. Das ist eine sehr gute Toolbox, mit der man sehr schnell die ersten Erfolge erreichen kann. Schritt für Schritt wird hier erklärt wie man das klassische ETL in der Cloud erstellt und die Ergebnisse in Power BI analysieren kann.
Speaker(s):
- Alexander Klein
Track and Room: Cloud (Application Development Deployment) - SolidQ
Title: Einstieg in Azure SQL Databases und Powershell Automation [DE]
Abstract: Einstieg in das Thema SQL Datenbanken in der Microsoft Cloud, von A wie Allgemeines, nach B wie Backup, dann über P wie Powershell nach R wie Restore. Ich gebe einen Überblick, welche Möglichkeiten es gibt eine Azure SQL Database zur Verfügung zu stellen, wie höhere Anforderungen realisiert werden können, ebenso gehe ich auf das Thema Kostenersparnis ein.
Wir werden uns verschiedene Deployments anschauen, auf das Thema Backup und auf die unterschiedlichen betrieblichen Leistungsanforderungen eingehen.
Speaker(s):
- Björn Peters
Track and Room: Cloud (Application Development Deployment) - Trivadis
Title: Cardinality Estimator with SQL Server 2014 and 2016 [EN]
Abstract: Cardinality Estimator had a major upgrade in SQL Server 2014 version and 2016. After a few introductory words, I will speak about model assumptions of Cardinality Estimator, calculation direction, model selection of Cardinality Estimator and improvements in SQL Server versions 2014 and 2016. I will also have a few demos where I will demonstrate how to optimally use the new features.
Speaker(s):
- Dean Savović
Track and Room: Administration (Platform, Architecture) - Solysion
Title: SQL Server auf Linux: Benchmarking und Tuning [DE]
Abstract: Im März 2016 überraschte Microsoft mit der Ankündigung, den SQL Server auch für Linux-Betriebssysteme bereitzustellen. Hier werden die Mechanismen der Bereitstellung von SQL Server vNext/2017 auf Linux erläutert (Installation und Zugriff) und darauf eingegangen, wie es mit Performance und Tuning aussieht. Hierbei kommt es auch zum Vergleich von Ausführungsplänen zwischen Linux und Windows. Auch wird es ein Benchmark-Vergleich zwischen SQL Server auf Linux und Windows geben.
Speaker(s):
- Michael Saß
Track and Room: Administration (Platform, Architecture) - Quest
Title: Biml: I got the basics - what’s next? [DE/EN]
Abstract: So you have made first contact with Biml and are excited? Good!
You’re wondering, if Biml can do more than just transfer data from SQL table to another? Great!
Because Biml does so much more than just simple SSIS packages. We’ll explore the potential on how to improve your existing packages using BimlScript and LINQ. Topics covered, amongst others, are derived columns, incremental changes and how to handle flat files.
You’ll leave with sample code and hopefully a couple of ideas on how to bring your Biml development to the next level.
Speaker(s):
- Ben Weissman
Track and Room: BI (Advanced Analysis, Visualization, Information Delivery) - Trivadis
Title: Introduction to U-SQL and Data Lake [EN]
Abstract: U-SQL is the new kid on the SQL language block. In this session we’ll look at the what, where, why and how of the language. Is it a query language? Is it a data transformation language? Will it replace T-SQL? Should you learn it? Where is it? What is Data Lake? We’ll discuss all this and more.
Speaker(s):
- Alex Whittles
Track and Room: Cloud (Application Development Deployment) - Trivadis
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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.
Kasper de Jonge
Kasper de Jonge is a Program Manager on the SQL Server Analysis Services team, based out of Redmond, WA. With more than 5 years of experience as a developer and consultant on data warehousing solutions using all products from the Microsoft BI stack, Kasper has worked on everything from corporate intranets using SharePoint and Analysis Services to near real-time reporting in the cloud. He has presented at many technical conferences, including PASS Summit and SQLSaturday. You can read Kasper’s blog at http://www.powerpivotblog.nl.
Rainer Stropek
Twitter: - @rstropek
LinkedIn: Rainer Stropek
Contact: https://www.software-architects/devblog
Rainer Stropek is co-founder and CEO of the company software architects and has been serving this role since 2008. At software architects Rainer and his team are developing the award-winning SaaS time tracking solution “time cockpit”. Previously, Rainer founded and led two IT consulting firms that worked in the area of developing software solution based on the Microsoft technology stack. Rainer is recognized as an expert concerning .NET development, software architecture and databases. In 2010 Rainer has become one of the first MVPs for the Microsoft Windows Azure platform. In 2015, Rainer also became a Microsoft Regional Director. 2016, Rainer also got the MVP award for Visual Studio and Developer Technologies.
Michael Saß
Als Senior Systems Consultant im Bereich Information Management bei Quest in Köln ist er für die SQL Server-, DB2- und VMware-Lösungen verantwortlich. Aufgrund seiner langjährigen Praxiserfahrung kann er die Kunden für einen optimalen Einsatz der Lösungen gut beraten. Nach Abschluss der Ausbildung zum mathematisch-technischen Assistenten arbeitete er bei Itergo, IT-Dienstleister der ERGO Gruppe, als Datenbankadministrator für DB2 auf z/OS und AIX sowie für SQL Server. Er arbeitete in zahlreichen Datenmigrations- und Data Warehouse-Projekten mit. Seit 2006 arbeitet er in seiner jetzigen Position und beschäftigt sich seitdem intensiv mit dem Thema SQL Server. In seiner Freizeit betätigt er sich als Handwerker und Wanderer.
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.
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.
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.
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”.
Alexander Klein
Twitter: - @SQL_Alex
LinkedIn: Alexander Klein
Alexander Klein is a senior Business Intelligence consultant with more than 15 years of experience. He focuses on Business Intelligence and Data Warehouse projects with Microsoft technologies like SQL Server, Power BI, Azure ML or Cortana Intelligence.
Since 2008, he has been a self-employed consultant in large and medium-sized projects in all sectors across Europe. He has been visiting SQLSaturdays and other Data Conference all over Europe since 2013. Speaker at national and international events since 2017.
Reza Rad
Twitter: - Rad_Reza
LinkedIn: Reza Rad
Contact: http://radacad.com/blog
Reza Rad is a Microsoft Regional Director, MVP, author, trainer, speaker and consultant. He is a Microsoft Data Platform MVP for nine years from 2011. Reza wrote many books on Power BI subjects including the Power BI from Rookie to Rock Star, and Pro Power BI Architecture. Reza is the invited speaker at the world’s well-known conferences such as Microsoft Ignite, Microsoft Business Applications Summit, Ignite Tour, PASS Summit, and many other conferences. Reza is an active blogger and writes regularly about Power BI at https://radacad.com.
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.
Karol Papaj
Karol Papaj is a mentor with SolidQ. He works with SQL Server since version 6.5 as a consultant and trainer. Karol is a regular speaker at conferences in Slovakia and other European countries. For his work for community in Slovakia he was awarded by Microsoft as a Most Valued Professional. Karol is also teaching courses with focus on High Availability, Performance Tuning and T-SQL Programming.
Thomas Grohser
LinkedIn: Thomas Grohser
Thomas Grohser has spent most of the past 26+ years exploring the deeper inner workings of SQL Server and its features while working for entertainment, pharmaceutical, and financial services industries. His primary focus is to architect, plan, build, and operate reliable, highly available, secure, and scalable infrastructures for SQL Server. Over the years he has managed thousands of SQL Server instances, processing trillions of rows, taking up petabytes of storage. Thomas has been a Microsoft Data Platform MVP for 9 years and has spoken regularly at conferences, SQLSaturdays, and user groups for 12 years.
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.
Asgeir Gunnarsson
Twitter: - bidgeir
LinkedIn: Asgeir Gunnarsson
Ásgeir Gunnarsson is a Data Platform MVP and Chief Consultant at Datheos in Denmark. He works on Business Intelligence solutions using the whole of the Microsoft BI stack. Ásgeir has been working in BI since 2007 both as a consultant and internal employee. Before turning to BI, Ásgeir worked as a technical trainer and currently teaches BI courses at the Continuing Education Department of the University of Iceland.
Ásgeir speaks regularly at events both domestically and internationally, and is the group leader of the Icelandic PASS Group, as well as the Icelandic Power BI User Group.
Ásgeir is passionate about data and loves solving problems with BI.
Alex Yates
Twitter: - @alexyates
LinkedIn: Alex Yates
Contact: http://www.workingwithdevs.com
Alex Yates has been helping organisations to apply DevOps principles to relational database development and deployment since 2010. He’s most proud of helping Skyscanner develop the ability to deploy 95 times a day. Originally for Redgate, later for DLM Consultants, Alex has worked with clients on every continent except Antarctica – so he’s keen to meet anyone who researches penguins.
A keen community member, he co-organises SQL Relay, is the founder of www.SpeakingMentors.com and has been recognised as a Microsoft Data Platform MVP since 2017.
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).
Denis Reznik
Twitter: - https://twitter.com/DenisReznik
LinkedIn: Denis Reznik
Contact: http://reznik.uneta.com.ua
Denis Reznik is a Data Architect at Intapp, Inc. He has more than ten years experience in software development, database design, and performance tuning for cloud and on-premises solutions. In 2010 Denis became Microsoft Data Platform MVP and maintains MVP status today. Apart from his professional career, Denis actively participates in the development of the Ukrainian Data Community.
Alexander Arvidsson
Twitter: - arcticdba
LinkedIn: Alexander Arvidsson
Contact: http://www.arcticdba.se
Alexander is a principal solutions architect at Atea in Linköping, Sweden. Nobody really knows what it means to be a principal solutions architect, but he spends his days helping clients of all shapes and sizes to take better care of their data.
He has spent the last 23 years toying with databases and related infrastructure services such as storage, networking and virtualization, occasionally emerging from the technical darkness to attend a Star Wars convention somewhere in the world.
He is a frequent international speaker, a Data Platform MVP, podcaster, blogger and a Microsoft Certified Trainer, focusing on SQL Server, the Azure data stack and Power BI.
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.
Dean Savović
Twitter: - https://twitter.com/dsavovic
LinkedIn: Dean Savović
Contact: http://www.savovic.com.hr
Dean is Senior DBA practicing SQL Server since version 7.0 and main areas of interest are performance tuning and troubleshooting SQL Server database. He speaks at Microsoft Windays Croatia, ATD Croatia, SSWUG, KulenDayz Croatia, SQLSaturday events, etc… Primary focus is on OLTP databases with occasional adventures with Business Intelligence. He finished Faculty of Electrical Engineering and Computing and MBA on Faculty of Economics in Zagreb. His premise was that it is very useful to combine technical knowledge with management process knowledge that help us in our everyday work. He works in SPAN which is specialized in data management field on Microsoft SQL Server.
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.
Tillmann Eitelberg
Twitter: - @_Tillmann
LinkedIn: Tillmann Eitelberg
Contact: http://www.ssis-components.net
Tillmann Eitelberg is CEO and co-founder of oh22information services GmbH, which specializes in data integration and data management. Tillmann is an active blogger at www.ssis-components.net, writing regularly about data quality topics and his passion: spatial data. In addition, he has published several SSIS components on Codeplex and GitHub. Tillmann is a Data Platform MVP, a board member of PASS Germany e.V., a PASS CL for the Cologne/Bonn region, and a PASS RM.
Niko Neugebauer
Twitter: - NikoNeugebauer
LinkedIn: Niko Neugebauer
Contact: http://www.nikoport.com
Niko Neugebauer is a Data Platform Consultant. A SQL Server MVP with over 20 years of experience in IT, he is passionate about the Microsoft Data Platform and community. Founder of the Portuguese SQL Server User Group and the main organizer of the first SQLSaturday event outside of North America (#78 Portugal), Niko speaks regularly at events such as PASS Summit, SQLRally, SQLBits, and SQLSaturday events around the world. Niko loves sharing information and knowledge and has authored over 130 blog posts on Columnstore Indexes, and regularly contributes to the open-sourced CISL library focused on Columnstore Indexes.
Mark Broadbent
Twitter: - @retracement
LinkedIn: Mark Broadbent
Contact: http://tenbulls.co.uk
Mark Broadbent is a Data Platform MVP and SQL Server MCM with more than 20 years of experience working with SQL Server and principal of SQLCloud, a consultancy specializing in concurrency control and highly available solutions. He is the founder of the UK’s SQLSaturday Cambridge (its first and largest), SharePoint Saturday Cambridge, the Hybrid Virtual Chapter and the East Anglia SQL User Group.
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.
Johan Ludvig Brattås
Twitter: - intoleranse
LinkedIn: Johan Ludvig Brattås
Contact: http://brattas.org/sqlmusings
Johan Ludvig Brattås is a managing consultant at Capgemini, and a dedicated community guy. He has worked with MS SQL server since late 1999, mostly with BI in one form or another. The last 6 years, most of his work has been in Azure working on data platforms, Power BI and the last three years expanding to Azure IoT and Stream Analytics.
Combining his passion for Microsoft SQL Server with his passion for sharing knowledge, he has spoken at various events in the SQL Community. This is also a way to give back to the community for all the things he has learned over the years. When not working, Johan Ludvig either spends his time with his kids, playing with new technology, or teaching coeliacs how to bake glutenfree food.
Erik Monchen
Twitter: - erikmonchen
LinkedIn: Erik Monchen
Erik has worked with the Microsoft BI products for over 7 years at different organizations in The Netherlands, Germany and the United States, responsible in the areas of information gathering to information delivery.
Jan Mulkens
Twitter: - https://twitter.com/JanMulkens
LinkedIn: Jan Mulkens
Contact: http://www.janmulkens.be
Jan Mulkens is a Microsoft MVP in AI, a Solution Expert at Ordina Belgium, and a Microsoft Data Platform BI Consultant. In his spare time, he is a speaker at conferences and user groups in Europe and he organizes two user groups and a conference in Belgium. Power BI Days conference (www.powerbidays.com), Belgium Microsoft Advanced Analytics User Group (bit.ly/msaaug), and Flemish Power BI User Group (meetup.powerbibelgium.com).
Gianluca Sartori
Twitter: - http://twitter.com/#!/spaghettidba
LinkedIn: Gianluca Sartori
Contact: http://spaghettidba.com
Gianluca Sartori is a Data Platform MVP, independent consultant and performance tuning specialist. He has been working in the software industry since 1999 and has been working with SQL Server ever since. He also works as a SQL Server trainer and in his spare time he writes technical articles and participates the SQL Server forums. Gianluca enjoys presenting SQL Server topics at conferences in Europe and in Italy in particular. He is currently working as lead DBA at a famous Formula 1 team.
Michael Roedeske
LinkedIn: Michael Roedeske
Michael graduated from the State Academy for Data Processing in Boeblingen, Germany, as State-Certified IT Specialist with a business information systems specialisation in 1998. In the first years of his career he was involved in IT infrastructure projects. Soon afterwards he moved into a commercial software environment. In the following years he assumed functions in this field as Technical Architect for Oracle, Microsoft SQL Servers and Microsoft Dynamics AX further organisational and project management roles in business intelligence and software development projects. He founded webtelligence IT consulting GmbH as its Managing Partner in summer 2011 to provided professional Microsoft SQL server database platform services and products.
Alex Whittles
Twitter: - @PurpleFrogSys
LinkedIn: Alex Whittles
Contact: http://www.PurpleFrogSystems.com/blog
Alex is a Data Platform MVP, and is the owner and lead consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the UK. He specializes in Data Warehouse modelling, ETL, Cubes, MDX amp; DAX. He#39;s a chartered engineer amp; has an MSc in Business Intelligence.
He runs the Birmingham (UK) SQL Pass chapter amp; Azure user groups, and is on the SQLBits and SQL Relay committees in the UK.
Alex is a regular speaker at global events including SQLBits, PASS Summit, SQL Relay, SQLSaturdays as well as numerous SQL Pass chapters around Europe
Sergiy Lunyakin
Twitter: - slunyakin
LinkedIn: Sergiy Lunyakin
Contact: https://slunyakin.wordpress.com
Sergiy Lunyakin (MCSA, MCSE, MCTS) is a Big Data Architect at SoftServe, Inc. He has extensive experience in designing and developing Big Data Analytics, Data Warehouse, and BI solutions, using both on-premises and cloud products. In 2016, Sergiy became Microsoft Data Platform MVP and has since maintained his MVP status. Sharing knowledge is another one of his passions. He regularly speaks at international conferences such as SQLSaturday, SQLDay, SQLNexus, and SQLBits. He also runs the Lviv SQL Server User Group in Ukraine and organizes SQLSaturday Lviv.
Tomaž Kaštrun
Twitter: - @tomaz_tsql
LinkedIn: Tomaž Kaštrun
Contact: http://www.tomaztsql.wordpress.com
Tomaž Kaštrun is BI developer and data analyst. His main focus are data mining, T-SQL development, programming and query optimization. He has been working with SQL server since version 2000. He is Microsoft Certified Professional, Microsoft MVP for data platform and Microsoft trainer.
André Melancia
Twitter: - AndyPT
LinkedIn: André Melancia
Contact: http://Andy.PT
Owner / Principal Consultant at LunarCat.PT Microsoft Certified Trainer (MCT) focusing on SQL Server, Azure, IoT and Security.
19+ years’ fun developing information and multimedia systems, DBA, project and IT management.
Data Community Portugal, IT Pro Portugal and PowerShell Portugal communities organiser. IPv6 Portugal, DNSSec Portugal and Windows Development Portugal online communities moderator. Actively volunteering, organising, speaking or just participating at community meetings and events around the world.
Proud uncle and food devouring expert, with dangerous рuϧϧy cat as companion.
Go to http://Andy.PT and you’ll know the same as the NSA…
Sponsors
The following is a list of sponsors that helped fund the event: