SQLSaturday #494 - Vienna 2016
Event Date: 04/01/2016 00:00:00
Event Location:
- JUFA Wien City
- 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: What a boozy day at the Guinness factory teaches us about Analytics
Abstract: Anyone who can type commands into R but that does not mean that can ‘do’ statistics for analytics. They may even misuse those methods, and it’s an entirely different thing to really understand what’s happening. This is vital, because this knowledge is what really drives each phase of your analysis and create effective models for the business to use in order to create actionable insights. It can be difficult to see when someone is building faulty statistical models, especially when their intentions are good, and their results look pretty! Results are important, and it’s down to you to create models that are sound and robust.
Drinking Guinness is optional, but admittedly might be preferred for this intensive session.
In this session, we will look at modeling techniques in Predictive Analytics using R, using our boozy day at the Guinness factory as a backdrop to understanding why statistical learning is important for analytics today.
Speaker(s):
- Jen Stirrup
Track and Room: Business Intelligence - Solid Q
Title: Best Practices – Jeder kann sie haben, die perfekte SQL Server Installation
Abstract: Best Practices sind Empfehlungen, die eine optimale Systemkonfiguration f#252;r einen stabilen und performanten Betrieb widerspiegeln. Diese beruhen meist auf den Aussagen der Hersteller und den unz#228;hligen Erfahrungen der Community. Alle diese Erfahrungen, Tipps und Empfehlungen zusammen ergeben dann eine Anleitung, wie ein System zu konfigurieren sein sollte. Auch f#252;r den SQL Server sind solche Best Practices zu finden und man soll Sie sogar schon in den PASS Regionalgruppen, auf SQLSaturdays und auf der SQL Konferenz gesichtet haben. Doch leider treten Best Practices auf vielen SQL Server Systemen nur vereinzelt auf. H#228;ufig k#246;nnen jedoch viele Performance- und Stabilit#228;tsprobleme durch die Implementierung der richtigen Best Practices beseitigt werden. Von den BIOS Einstellungen, #252;ber die Windows Settings bis hin zum SQL Server m#246;chte ich aufzeigen, was bei einer SQL Server Installation zu beachten ist und wie ein SQL Server stabil und performant nach Best Practices eingerichtet werden
Speaker(s):
- Andre Essing
Track and Room: Administration - Profisee
Title: UNIQUEIDENTIFIER als Prim#228;rschl#252;ssel im SQL Server
Abstract: Ob es eine Best-Practice ist, einen UNIQUEIDENTIFIER als Prim#228;rschl#252;ssel im SQL Server zu verwenden - dar#252;ber kann man streiten. UNIQUEIDENTIFIER haben eine Vielzahl unterschiedlicher Vorteile aus einer Entwickler-Perspektive, aber aus der Administrations-Perspektive verursachen sie eine Vielzahl unterschiedlicher Performance Probleme. Im Rahmen dieses Vortrags werden wir uns dem UNIQUEIDENTIFIER als Prim#228;rschl#252;ssel widmen, und Sie werden Schritt f#252;r Schritt sehen, in welche Performance-Fallen Sie laufen k#246;nnen, wenn Sie nicht genau aufpassen. Zus#228;tzlich bekommen Sie eine Reihe unterschiedlicher Tipps, die Ihnen die tagt#228;gliche Arbeit mit dem UNIQUEIDENTIFER als Prim#228;rschl#252;ssel erleichtern werden.
Speaker(s):
- Klaus Aschenbrenner
Track and Room: Development - Pure Storage
Title: Microsoft Azure Machine Learning Algorithms
Abstract: Focus of this session will be explanation of algorithms available for predictive analytics in Azure Machine Learning service. Algorithms will be grouped by learning style (Supervised, semi-supervised and unsupervised) and will take a look into 1) regression algorithms, 2) Regularization algorithms, 3) Decision trees algorithms, 4) Naive Bayes algorithms, 5) Dimension reduction algorithms, 6) Associated learning (not Kernel) Algorithms and 7) Clustering algorithms. With theory explained we will look into data samples and later examples in ML for these algorithms. Within this session we will explore, which algorithm is used and useful for what kind of empirical problem and which is suitable for particular data-set.
Speaker(s):
- Tomaž Kaštrun
Track and Room: Business Intelligence - Solid Q
Title: Performance: Es ist nicht immer die Datenbank schuld!
Abstract: Die Benutzer beschweren sich, dass die Applikation zu langsam ist. Die Entwickler beschuldigen die Datenbank. Wie kann die Ursache f#252;r das Performance-Problem gefunden werden?
Viel zu oft wird die Datenbank beschuldigt der Grund f#252;r Performance- und Skalierbarkeits-Probleme zu sein. In vielen F#228;llen ist das Problem nicht die Datenbank selbst, sondern vielmehr auf welche Art und Weise die Applikation auf die Datenbank zugreift. Zu den h#228;ufigsten Problemen z#228;hlen u.a. das Anfordern von zu vielen Daten, ineffiziente SQL Abfragen, schlechte Wahl von Indexen, …
Basierend auf Praxisbeispielen wird gezeigt wie Performance-Probleme analysiert werden k#246;nnen um schneller die Ursache zu ermitteln und das Problem zu l#246;sen. Based on real life examples, you will learn how to approach performance problems, how to figure out if the database is really to blame and how to end the finger pointing between developers and DBAs.
Speaker(s):
- Sonja Chevre
Track and Room: Development - Dell Software
Title: Neuigkeiten zu Reporting Services 2016
Abstract: „The box is back“ unter diesem Motto standen viele Vortr#228;ge auf dem PASS Summit 2015. Was Microsoft damit sagen m#246;chte ist, dass nach den gro#223;en Investments in die Cloud L#246;sungen in den letzten Jahren nun auch wieder in die On-Premises L#246;sungen und hier insbesondere in den SQL Server investiert wird. In Bezug auf Reporting Services bedeutet dass, das es neue und verbesserte Funktionen gibt. Eine dieser neuen Funktionen stellt die Integration von Datazen Dashboards und KPIs als mobile Berichte in Reporting Services dar. Auch neu ist, dass man Reporting Services Berichte in ein Power BI Dashboard „anpinnen“ kann und dass man nun die Berichtsparameter #252;ber dem Bericht anordnen kann. In seiner Session wird Frank #252;ber die Neuereungen in Reporting Services 2016 sprechen und diese in zahlreichen Demos pr#228;sentieren.
Speaker(s):
- Frank Geisler
Track and Room: Business Intelligence - Solid Q
Title: R, Rattle und SQL Server 2016
Abstract: Im SQL Server 2016 hat Microsoft mit Revolution Analytics R eine volle Predictive Suite bzw. Bibliothek in die Standard Datenbank inkludiert. Mit R kann man allerlei Berechnungen, Analysen und vor allem Prognosen erstellen. Wie kann ich mit diesem Werkzeug Nutzen aus meinen Daten ziehen? Wo finde ich wirklich relevante Zusammenh#228;nge in den Daten, wie kann ich diese Zusammenh#228;nge in der Datenbank nutzen? Diese Session bietet einen kurzen Einstieg in die Welt von R mit Rattle, dem Tool zur einfachen und auch komplexen Analyse von Daten. Darauf aufbauend wird aus den Ergebnissen ein Modell generiert und in der Datenbank implementiert. Der Focus dieser Session liegt in der Arbeit mit R und den Daten.
Speaker(s):
- Mario Schnalzenberger
Track and Room: Cloud Big Data - Pure Storage
Title: Load Testing With SQL Server Tools
Abstract: It’s often difficult to know how your SQL Servers will perform under different loads. By performing load testing, we can gain these key insights, perform modifications to existing configurations, and understand the impact on performance levels.
Come learn about the native tools at our disposal for performing these important load tests and how we can identify when performance levels begin to drop. Using demos of these native tools – including Distributed Replay Utility (DRU), Database Tuning Adviser (DTA), Perfmon, Extended Events, and Profiler – we’ll see how to plan and perform a load test project, gain an understanding of SQL Server’s performance under varying load scenarios, and discover which tell-tale indicators can help alert us to performance degradation.
Speaker(s):
- Neil Hambly
Track and Room: Administration - Dell Software
Title: Biml for Beginners: Speed up your SSIS development
Abstract: SSIS is a powerful tool for extracting, transforming and loading data, but creating and maintaining a large number of SSIS packages can be both tedious and time-consuming. Even if you use templates and follow best practices you often have to repeat the same steps over and over and over again. Handling metadata and schema changes is a manual process, and there are no easy ways to implement new requirements in multiple packages at the same time.
It is time to bring the Don’t Repeat Yourself (DRY) software engineering principle to SSIS projects. First learn how to use Biml and BimlScript to generate SSIS packages from database metadata and implement changes in all packages with just a few clicks. Then take the DRY principle one step further and learn how to update all packages in multiple projects by separating and reusing common code.
Speed up your SSIS development by using Biml and BimlScript, and see how you can complete in a day what once took more than a week!
Speaker(s):
- Cathrine Wilhelmsen
Track and Room: Business Intelligence - Profisee
Title: SQL Server 2014 Memory-optimized Data Exchange
Abstract: SQL Server 2014 introduces Extreme Transaction Processing, a brand new memory-optimized data management feature, targetting OLTP workloads. In this session you will learn about two new, and not very well known, features that you can use to share sets of data between modules - either within the database, or between client applications and databases:
- Memory-optimized Table Variables; and
- Memory-optimized Table-valued Parameters.
Speaker(s):
- Matija Lah
Track and Room: Development - Profisee
Title: Instructor-Led Lab: Azure SQL DB in Action
Abstract: This instructor-led lab is a 100% demo/lab show! Attendees have the option to actively follow the instructor during this tour around some of the most interesting Azure SQL DB features. Please bring your own PC if you plan to do the labs by yourself.
Speaker(s):
- Oliver Lintner
Track and Room: Cloud Big Data - Microsoft
Title: The Top 8 Reasons for Your Transaction Performance Problems
Abstract: Transaction is running slow! How many times have you seen this message on your production system or heard it from users? It’s time to isolate and resolve these issues!
Typical reasons for transaction delays include slow transaction logs, page splits, blocking, over-indexing, and even some configuration settings of your database or instance. Query-tuning tips are slightly different than those for transactions, and this session is about OLTP performance troubleshooting. See some typical scenarios of transaction delays and the reasons behind them. This session will help you in your performance troubleshooting efforts and improve your level of confidence.
Speaker(s):
- Margarita Naumova
Track and Room: Administration - Dell Software
Title: Getting started with Microsoft Azure Data Services
Abstract: Get a comprehensive overview of the Microsoft Azure Data Services (SQL, NoSQL, KeyValue and more). Learn how easy it is to get started and how these services can support you in managing, securing and scaling your data.
Speaker(s):
- Oliver Lintner
Track and Room: Cloud Big Data - Microsoft
Title: From Personal BI to Managed BI with Power BI
Abstract: Power BI was initialy a Self-Service BI oriented solution. Personal BI can become a nightmare when not managed. Data governance and data stewardship are good practices to avoid dataset-hell and leverage data culture of your company. In that session, you’ll discover ways to manage your Power BI assets by process, organization and some tools like Azure Data Catalog.
Speaker(s):
- Jean-Pierre Riehl
Track and Room: Business Intelligence - Pure Storage
Title: Microsoft Azure Overview
Abstract: Microsoft Azure is a flexible, open, and secure cloud built for business. Access a broad collection of integrated cloud services that accommodate many languages and operating systems. Join this session to get an introduction into the cloud platform and discover, at a high level, what powerful data and analytics services it provides.
Speaker(s):
- Oliver Lintner
Track and Room: Cloud Big Data - Microsoft
Title: Der faule DBA | 7 Schritte zu einer automatisierten Datenbankumgebung
Abstract: Was mehr als 2 mal h#228;ndisch gemacht werden muss wird automatisiert! Diese Session zeigt in 7 Schritten einen Weg zur automatisierten Datenbankumgebung, pr#228;sentiert mit Beispielen und Geschichten aus der Arbeitswelt. Es werden konkrete Anwendungsbeispiele, Tipps und Tricks pr#228;sentiert, jedoch liegt der Fokus darauf, eine Bild dar#252;ber zu bekommen, wie man den Weg der Automatisierung beschreiten k#246;nnte.
Speaker(s):
- Markus Wagner
Track and Room: Administration - Profisee
Title: Hacking Into SQL Server for Fun and Profit
Abstract: In this session we’ll explore several methods of hacking into SQL Server instances. Some methods assume you have Windows Administrator privileges on the box; others only require access to your physical network. We’ll cover SQL injection, memory dumps, man-in-the-middle, pass-the-hash, and other attack vectors. Armed with this knowledge, you should be able to go back to your job and make a difference in your network security.
Speaker(s):
- Argenis Fernandez
Track and Room: Administration - Pure Storage
Title: Indexes, beyond the basics
Abstract: Do you know all about heaps, clustered indexes, and nonclustered indexes, but still aren’t satisfied? Then this is the session for you! Learn about advanced features such as included columns, indexed views, and filtered indexes. Discover how they are stored on disk and how SQL Server uses them to satisfy queries. Then, see the tools SQL Server hands you to help identify just the right subset of indexes. Finally, get an stunning demonstration of just how badly you can hurt performance by creating too many indexes.
Speaker(s):
- Hugo Kornelis
Track and Room: Development - Dell Software
Title: Tabular vs. Multidimensional in SQL Server Analysis Services
Abstract: Since 2012, SQL Server Analysis Services has two engines: Tabular and Multidimensional. Somebody believes Multidimensional is granny stuff and aim to learn only Tabular. Somebody trust only the good-old well-debugged code of Multidimensional, and ignores Tabular. We try to use a more informed approach: by looking at the difference in features, hardware requirements, scalability, required knowledge and business needs, we will discuss which engine to use for different kinds of projects. The goal is to teach when to use what, and to avoid the common (and very expensive) mistake of choosing the wrong technology.
Speaker(s):
- Alberto Ferrari
Track and Room: Business Intelligence - Solid Q
Title: Top 10 SSAS Solution Design Best Practices
Abstract: Proper design of cubes, dimensions, hierarchies and attributes is critical to optimal performance of SQL Server Analysis Services solutions.
I’ve collected a number of best practices during the years I’ve spent on building and maintaining OLAP cubes. In this session, we will go through the most important ten of these, so you can consider them in your everyday work when you build analytical back-end solutions with SSAS. Join this session, and see how these tips and best practices can save your precious time.
Speaker(s):
- Zoltán Horváth
Track and Room: Business Intelligence - Dell Software
Title: Lightning Talks
Abstract: F#252;nf zehnmin#252;tige Kurz-Vortr#228;ge. Agenda folgt.
Speaker(s):
- Markus Ehrenmueller-Jensen
Track and Room: Lightning Talks - Dell Software
Title: Watch Brent Tune Queries
Abstract: You’re in a dark room with an ugly query. What do you do next? Microsoft Certified Master Brent Ozar shares his time-tested method of tuning queries starting with simplifying, analyzing the execution plan, making index tweaks, and measuring improvements with statistics. You’ll learn a repeatable process you can use to make queries go faster.
Speaker(s):
- Brent Ozar
Track and Room: Development - Profisee
Title: Azure SQL Database vs. Azure SQL Data Warehouse
Abstract: Microsoft hat f#252;r die Speicherung der Daten im SQL Server in Azure zwei Angebote. Zum einen die Azure SQL Database und das Azure Data Warehouse. In diesem Vortrag werde ich auf die Unterschiede beider Versionen eingehen und auch vergleichen, wie sie sich gegen#252;ber einem SQL Server On-Premise unterscheiden. Wir werden weiterhin auf Themen wie Skalierbarkeit, Performance und Kosten eingehen.
Speaker(s):
- Marcel Franke
Track and Room: Cloud Big Data - Pure Storage
Title: Ye Olde Cluster Curiosity Shoppe - A miscellany of SQL Clustering top tips
Abstract: Welcome to the strange and mysterious world of SQL Server Failover-Clustering and enter Ye Olde Cluster Curiosity Shoppe where we will reveal a miscellany of top tips, tricks and advice gained from nearly two decades of installing and troubleshooting SQL Clusters.
Roll-up roll-up! Come and see: The Shrunken Head; The Bearded Lady; Many Headed Cluster; The Marie Celeste; The Zombie; Installation of Death; The Bodysnatcher; Montezuma’s Revenge …and many more exhibits and top tips from the field.
Speaker(s):
- Mark Broadbent
Track and Room: Administration - Solid Q
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Oliver Lintner
Oliver joined Microsoft Austria in 2011 as a, so called, quot;Premier Field Engineer (PFE) for Developmentquot;. Over more than three years he supported many different Microsoft customers around Europe before he moved on and became a Technical Evangelist (TE) for Azure. As a TE, most of his time Oliver engages with different MS customers working on exciting projects around the Microsoft Azure cloud platform.
Klaus Aschenbrenner
Twitter: - @Aschenbrenner
Contact: http://www.SQLpassion.at/blog
Klaus Aschenbrenner provides independent SQL Server consulting services across the United States and Europe, focusing on the .NET Framework and SQL Server 2005 and 2008. In 2004 and 2005, he received the Microsoft MVP award for his support of the .NET community. Klaus has also written a book, “Pro SQL Server 2008 Service Broker,” published by Apress (2008).
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.
Zoltán Horváth
Twitter: - @zoltanhorvath
LinkedIn: Zoltán Horváth
Contact: http://addictivemeasures.blogspot.com
Zolt#225;n is a BI specialist with more than a decade of expertise. He leads the Hungarian User Group of Microsoft SQL Server (HUG-MSSQL), the Hungarian Chapter of PASS. MCSE: BI and MCSE: Data Platform. SQL Server MVP since 2015.
Alberto Ferrari
Twitter: - @FerrariAlberto
Contact: http://www.sqlbi.com
Alberto Ferrari started working with SQL Server in 2000 and immediately focused his interest on Business Intelligence. He and Marco Russo created sqlbi.com, where they publish extensive content about Business Intelligence. Alberto published several books about Analysis Services, Power BI, and Power Pivot. He is a Microsoft MVP and he earned the SSAS Maestro title, the highest level of certification on Microsoft Analysis Services technology.
Today, Alberto’s main activities are in the delivery of DAX and data modeling workshops for Power BI and Analysis Services all around the world. Alberto offers consulting services on large and complex data warehouses to provide assessments and validation of project analysis or to perform specific problem-solving activities.
Alberto is a well-known speaker at many international conferences, like PASS Summit, SQLBits, and Microsoft Ignite. He loves to be on stage both at large events and at smaller user groups meetings, exchanging ideas with other SQL and BI fans. When traveling for work, he likes to engage with local user groups to provide evening sessions about his favorite topics. Thus, you can easily meet Alberto by looking up local Power BI user groups during scheduled courses. Outside of SQLBI, most of Alberto’s personal time is spent practicing video games, in the vain hope of eventually beating his son.
Margarita Naumova
LinkedIn: Margarita Naumova
Contact: www.maginaumova.com; http://blogs.technet.com/b/magi/
Magi Naumova is SQL Server Architect and Consultant, speaker and trainer, Microsoft Certified Master, MVP Data Platform, MCT, Founder of SQL Master Academy, founder and leader of the Bulgarian SQL User group. She has more than 15 years SQL Server training and consulting experience. Magi is a former member of Microsoft Services Worldwide Technical Leadership Team, а Microsoft Women worth watching http://zd.net/1lwNYKH Currently she speaks, writes, trains and consults people on SQL Server technology. She runs a Data Platform consulting company part of which is SQL Master Academy training program. It helps hundreds of specialists to feel knowledgeable in their daily work or to find an inspirational career path in the world of SQL Server.
Brent Ozar
Twitter: - BrentO
LinkedIn: Brent Ozar
Contact: https://www.BrentOzar.com
Brent Ozar loves to make SQL Server faster. He created sp_Blitz and the SQL Server First Responder Kit. He shares what he’s learned at BrentOzar.com.
Hugo Kornelis
Twitter: - Hugo_Kornelis
LinkedIn: Hugo Kornelis
Contact: http://sqlblog.com/blogs/hugo_kornelis/default.aspx
Hugo Kornelis is an established SQL Server community expert who spends a lot of time at various conferences. He is author of “the Execution Plan Reference” (sqlserverfast.com/epr), blogger, technical editor of Grant Fritchey’s “SQL Server Execution Plans, 3rd edition” and some other books, and Pluralsight author. He was awarded SQL Server MVP and Data Platform MVP 12 times (2006 - 2016, and 2019-present).
When not working for the community, he is busy at his day job: freelance database developer/consultant.
Hugo has over 20 years of SQL Server experience in various roles. He loves to write and tune complex queries, but he also has a strong database design background.
When not working for the community, he is busy at his day job: freelance database developer/consultant.
Hugo has over 20 years of SQL Server experience in various roles. He loves to write and tune complex queries, but he also has a strong database design background.
Oliver Lintner
Oliver joined Microsoft Austria in 2011 as a, so called, quot;Premier Field Engineer (PFE) for Developmentquot;. Over more than three years he supported many different Microsoft customers around Europe before he moved on and became a Technical Evangelist (TE) for Azure. As a TE, most of his time Oliver engages with different MS customers working on exciting projects around the Microsoft Azure cloud platform.
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.
Jen Stirrup
Twitter: - @jenstirrup
LinkedIn: Jen Stirrup
Contact: http://www.jenstirrup.com
Jen Stirrup, Microsoft Regional Director and MVP is a well-known Business Intelligence and Data Visualization expert, author, data strategist, and Master of Business Administration (MBA) student in London. Jen leads a boutique analytics consultancy, delivering strategic advice to companies large and small.
Jen has presented in Africa, India, Europe and North America. Jen has presented at Ignite, Techorama, TechEd, PASS Summit, SQLBits, and SQLSaturday events in Europe and the US. She also delivers the MAPA Azure Architects course worldwide with Microsoft team members. Jen was also featured on the Best of PASS Summit 2015 DVD as one of the top 10 speakers. Jen also was awarded PASS prestigious PASSion Award in 2012
Markus Wagner
Started as Junior DBA at bwin in Vienna, and with a few intermezzos in between, I#39;m still here as a Senior Database Engineer focusing on operational automation, big database server infrastructure. In my spare time a do a lot of nerdy things like, playing and watching multiplayer online games and from time to time producing some new tunes.
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.
Andre Essing
Twitter: - @aessing
LinkedIn: Andre Essing
Contact: http://www.andreessing.de/
Andre ist Senior Consultant und Trainer bei der Trivadis GmbH. Er sammelt seit Version 7.0 Erfahrungen mit dem SQL Server und hat seinen Schwerpunkt auf die Infrastruktur gelegt. Spezialisiert hat er sich hierbei auf den Bereich Mission Critical Systems. Neben der T#228;tigkeit als Consultant, vermittelt Andre sein Wissen in Trainings. Au#223;erdem engagiert sich Andre in der Community als Chapter Leader bei der PASS in Bayern und als Organisator des SQLSaturdays in M#252;nchen. Er betreibt einen Blog unter www.andreessing.de.
Jean-Pierre Riehl
Twitter: - djeepy1
LinkedIn: Jean-Pierre Riehl
Contact: http://blog.djeepy1.net
Architect, Consultant, Trainer and also Manager, Jean-Pierre leads the Data BI Practice at AZEO, a French Microsoft “pure-player” partner. Jean-Pierre is MVP Data Platform since 2008 and speaks at many events in France and in Europe. JP leads the local community (GUSS) and organize events in France since 2011 : MS Cloud Summit, Les Journées SQL Server, SQLSaturday, etc. JP is passionate by data concerns in business like Data Governance, Data Quality or Data Vizualisation and since 2010, he’s specialized in Self-Service BI. His favorite topic is Power BI and business usages and technical architectures that go with.
Argenis Fernandez
Twitter: - DBArgenis
LinkedIn: Argenis Fernandez
Contact: http://blog.purestorage.com/author/argenisfernandez/
Argenis is a Principal Architect at Pure Storage. He works with customers around the world to make sure they don’t have to worry much about their infrastructure for Data. He is a former Data Platform MVP, former VMware vExpert, Microsoft Certified Master, and more recently worked in the Microsoft Azure Data/SQL Server engineering team as a Principal PM in the Tiger team.
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.
Mario Schnalzenberger
Mario Schnalzenberger ist seit 20 Jahren in der IT-Industrie t#228;tig und hat sich in den letzten acht Jahren im Bereich Statistik und Big Data an der Universit#228;t und im Predictive Bereich besch#228;ftigt. Seit zwei Jahren ist er im cubido-Team und unterst#252;tzt die Kunden in diesem spannenden Umfeld. Mario hat Abschl#252;sse in Statistik, Volkswirtschaftslehre und Sozial- und Wirtschaftswissenschaften. Er unterrichtet seit 7 Jahren an der Universit#228;t Linz und anderen Hochschulen in #214;sterreich sowie der HTL Leonding. Er tr#228;gt regelm#228;#223;ig bei verschiedensten Konferenzen in den vielf#228;ltigen Themen der angewandten Statistik, Informatik und Big Data vor.
Sonja Chevre
Twitter: - https://twitter.com/SonjaChevre
LinkedIn: Sonja Chevre
Contact: http://apmblog.dynatrace.com/
Sonja is a Technical Product Manager at Dynatrace, a company specialized in helping customers improve their application performance, with more than 15 years experience in software development.
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).
Cathrine Wilhelmsen
Twitter: - @cathrinew
LinkedIn: Cathrine Wilhelmsen
Contact: https://www.cathrinewilhelmsen.net/
Cathrine loves teaching and sharing knowledge :) She is based in Norway and works as a Senior Business Intelligence Consultant in Inmeta, focusing on Data Warehousing, Data Integration, Analytics, and Reporting projects. Her core skills are Azure Data Factory, SSIS, Biml and T-SQL development, but she enjoys everything from programming to data visualization. Outside of work she’s active in the SQL Server community as a Microsoft Data Platform MVP, BimlHero Certified Expert, author, speaker, blogger, organizer and chronic volunteer.
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.
Brent Ozar
Twitter: - BrentO
LinkedIn: Brent Ozar
Contact: https://www.BrentOzar.com
Brent Ozar loves to make SQL Server faster. He created sp_Blitz and the SQL Server First Responder Kit. He shares what he’s learned at BrentOzar.com.
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.
Oliver Lintner
Oliver joined Microsoft Austria in 2011 as a, so called, quot;Premier Field Engineer (PFE) for Developmentquot;. Over more than three years he supported many different Microsoft customers around Europe before he moved on and became a Technical Evangelist (TE) for Azure. As a TE, most of his time Oliver engages with different MS customers working on exciting projects around the Microsoft Azure cloud platform.
Alberto Ferrari
Twitter: - @FerrariAlberto
Contact: http://www.sqlbi.com
Alberto Ferrari started working with SQL Server in 2000 and immediately focused his interest on Business Intelligence. He and Marco Russo created sqlbi.com, where they publish extensive content about Business Intelligence. Alberto published several books about Analysis Services, Power BI, and Power Pivot. He is a Microsoft MVP and he earned the SSAS Maestro title, the highest level of certification on Microsoft Analysis Services technology.
Today, Alberto’s main activities are in the delivery of DAX and data modeling workshops for Power BI and Analysis Services all around the world. Alberto offers consulting services on large and complex data warehouses to provide assessments and validation of project analysis or to perform specific problem-solving activities.
Alberto is a well-known speaker at many international conferences, like PASS Summit, SQLBits, and Microsoft Ignite. He loves to be on stage both at large events and at smaller user groups meetings, exchanging ideas with other SQL and BI fans. When traveling for work, he likes to engage with local user groups to provide evening sessions about his favorite topics. Thus, you can easily meet Alberto by looking up local Power BI user groups during scheduled courses. Outside of SQLBI, most of Alberto’s personal time is spent practicing video games, in the vain hope of eventually beating his son.
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.
Sponsors
The following is a list of sponsors that helped fund the event: