SQLSaturday #687 - Slovenia 2017

Event Date: 12/09/2017 00:00:00

Event Location:

  • Faculty of Computer Science
  • Vecna pot 113
  • Ljubljana, Ljubljana, Slovenia

PDF of Schedule

This event has completed. All data shown below is from the historical XML public data available.

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).


This is a list of sessions from the event, based on the schedule in the XML files.

Title: Scale-Out your SSIS Package Executions

Abstract: With a rising number of parallel SQL Server Integration Services (SSIS) package executions the resource requirements on the SSIS server can be a limiting factor. In older SQL Server versions, scale-out architectures needed to be implemented by hand and required a lot of manual implementation effort. Beginning with SQL Server 2017, SSIS provides a built-in scale-out functionality for package executions. After the definition of scalability-types, the SSIS scale-out architecture and the involved system-parts are introduced. The attendees will learn the basics, get checklists and best practices when building up their own SSIS scale-out cluster. In addition to the configuration using SSMS other configuration options (command line, T-SQL,..) are presented. Behind the scenes information like logging, the programmability interfaces and configuration options will be shared.


  • Wolfgang Strasser

Track and Room: BI/DEV - P22: BI/DEV

Title: €20M+ fines and prison: General Data Protection Regulation (GDPR)

Abstract: Do you hold data on EU citizens? If so GDPR applies to you.

From the 25th May 2018 organisations who fail to implement appropriate technical and organisational measures that ensure and demonstrate that they are compliant will be liable for a fine of €20M or 4% of annual global turnover – whichever is GREATER. Also, prison.

As a professional who works with data it is wise to ensure that you understand GDPR.

DISCLAIMER: I am not a lawyer.

Let me repeat: I AM NOT A LAWYER.

I am not qualified to give legal advice. However, I do know a thing or two about delivering software. In this talk I will bring your attention to the main aspects of GDPR and discuss some of the consequences this has on the use of production data and database lifecycle management (DLM).

I will focus on technical problems that we need to address. You can (and should) hire your own lawyers to provide legal advice.


  • Alex Yates

Track and Room: DEV - P01: DEV

Title: Data Modeling and Design for New Features in SQL Server and Cosmos DB

Abstract: With the availability of new Graph Database features in SQL Server 2017 and the new Cosmos DB, Microsoft’s globally-distributed, multi-model database service for managing data at scale, database architects are expected to create and translate data models to non-relational physical database designs.  For decades, data modeling and database design has been focused on the relational model, yet we have all these new features to model for.

In this session, we’ll look at: Why these features still need data modelsHow to prepare data models, logical and physical, for these target featuresHow these features change the data model/database design processHow tools support these new features (or don’t)How to approach tuning for these non-relational featuresFinally, we end with 10 tips for working with non-relational features while still maintaining data model-driven database design.


  • Karen Lopez

Track and Room: DEV/DBA - P20: DBA/DEV

Title: Advanced insides into System Versioned Temporal Tables

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.


  • Uwe Ricken

Track and Room: DEV - P01: DEV

Title: Understand better Transaction Isolation Levels

Abstract: SQL Server is an extraordinarily powerful engine of relational databases, which lets you achieve high scalability of data platform. For many years SQL Server gains more and more new features and more efficient mechanisms including InMemory or ColumnStore Indexes. However, there is still many companies not using those features and struggling with performance issues, which the root cause turn out the problems with concurrency. Let’s back to the basis then in order to better understand transaction isolation levels available in SQL Server. On this session we will learn about a concurrency issue, (not)expected behaviours, lost modifications and consider how to cope with them. I will tell what the optimistic and pessimistic concurrency models are, when use it and what tempdb has in common with them. Also, we will see in practice how dangerous (NOLOCK) might be which has being used so passionately by developers.


  • Kamil Nowinski

Track and Room: DEV/DBA - P20: DBA/DEV

Title: Building an End to End IoT Solution Using Raspberry Pi Sensors Azure

Abstract: The Internet of Things is the new kid on the block offering a wealth of possibilities for data streaming and rich analytics. Using a Raspberry Pi 3 we will take an end to end look at how to interact with the physical world collecting sensor values and feeding that data in real-time into cloud services for manipulation and consumption. This will be a heavily demonstrated session looking at how such an environment can be setup using the Microsoft offerings including; Windows 10 IoT Core, a C# Universal Windows Platform application, an Azure IoT Event Hub, Azure Stream Analytics, Azure SQL DB and Power BI. This is an overview of what’s possible, but showing exactly how to build such a simplified solution with a session which will be 90% demonstrations. In addition, spare Raspberry Pi devices will be available for the audience to pass around and look at. This will hopefully add that level excitement of what hardware is now available and what it can do when setup with Microsoft software.


  • Paul Andrew

Track and Room: BI/DEV - P22: BI/DEV

Title: State-of-the-Art Machine Learning Algorithms in R from Microsoft

Abstract: Do you fancy learning regression and classification in one hour? We will start with linear regression, simple but powerful machine learning algorithm. With it you will learn about correlation coefficient, loss function, optimization algorithms and regularization. At the end of this section we will built a ML model using Fast linear model with Stochastic Dual Coordinate Ascent (SDCA) optimization. Next step is get to know artificial neural networks, their architecture, activation functions and backpropagation algorithm. This allows us to build a (better?) model using rxNeuralNet and N#. Evaluation metrics for regression models will conclude first part of the session. In the second part we will use almost the same ML algorithms for classification — the difference is that Logistic regression will replace Linear regression. Finally we will learn about Evaluation metrics for classification models, which allows us to pick the very best model for problems we are going to solve together.


  • Marcin Szeliga

Track and Room: BI - P19: BI

Title: SQL Server on Linux - SQL Server 2017 goes cross platform!


  • How it started - Project Drawbridge, Slava with his brother!

  • SQL PAL (SQL Platform Abstraction Layer)

  • SQLOSv2

  • The (very small) host extension which is platform specific

  • Installation with demo,yes that fast!

  • Backups and Restores cross platform

  • Clustering on Linux

  • AlwaysOn Availability Groups cross platform

  • SQL Agent for Log Shipping

  • Compiling/Deploying CLR code for both platforms with demo

  • How the Linux layer is compiled

  • Debugging a combined Windows PE and Linux ELF execution including getting a stack dump

  • New DMVs for Linux and DMVs which are replaced as they are not cross platform

  • Active Directory Integration with demo

  • Performance goals

  • Limitations with the current implementation


  • David Williams

Track and Room: DBA - P21: DBA

Title: A Game of Hierarchies: Introduction to Graph Processing with SQL

Abstract: Hierarchies are the bread and butter of most business applications and you find them almost everywhere:

  • Product Categories
  • Sales Territories
  • Bill of Material
  • Calendar and Time Even when there is a big need from a business perspective, the solutions in relational databases are mostly sort of awkward. The most flexible hierarchies are usually modeled as self-referenced tables. If you want to successfully query such self-referenced hierarchies, you will need either loops or recursive Common Table Expressions. SQL Server 2017 comes now with a different approach: Graph Database. Join this session for a journey through best practices to transform your hierarchies into useful information. We will have fun playing around with a sample database based on G. R. R. Martin’s famous “Game of Thrones”.


  • Markus Ehrenmueller-Jensen

Track and Room: DEV - P01: DEV

Title: Azure Data Factory vs SSIS, the Ins and Outs.

Abstract: ADF provides a managed way to orchestrate the collection, movement and transformation of structured and semi-structured data together. It works both with on-premises and cloud data and it has - of course - a powershell interface, enabling you to manage it without the bling of the Azure portal. But is it useful, is it fast, is it easy and powerful to use ? And most of all is Azure Data Factory the new SSIS ? These are some of the questions that might arise, when reading about this new PaaS and that we will answer together in this demo packed session where will we go through orchestration, consumption and administration of data through the ADF pipeline.


  • Regis Baccaro

Track and Room: BI/DEV - P22: BI/DEV

Title: Design Seamless Upgrades to SQL Server 2017 with Query Store

Abstract: One of the biggest fears most customers have is upgrading to a new release of Microsoft SQL Server and having performance degrade, because of changes in query execution plans. SQL Server 2016 mitigated this risk by the introduction of the Query Store and the ability to easily force execution plans.

In this session, you will learn about the data that the query store captures to identify queries that have regressed. You will learn about patterns for upgrades that allow you to upgrade with minimal impact to user performance. You will see demos of how to identify when a query has regressed in either plan or performance, and you will get some hints for the future of the Query Store with Adaptive Plans in SQL Server 2017.


  • Joseph D’Antoni

Track and Room: DEV/DBA - P20: DBA/DEV

Title: T-SQL User-Defined Functions, or: How to kill performance in one, easy step

Abstract: User-defined functions in SQL Server are very much like custom methods and properties in .Net languages. At first sight, they seem to be the perfect tool to introduce code encapsulation and reuse in T-SQL. So why is this feature mostly avoided by all T-SQL gurus? The reason is performance. In this session, you will learn how user-defined functions feed the optimizer with misleading and insufficient information, how the optimizer fails to use even what little information it has, and how this can lead to shocking query performance. However, you will also see that there is a way to avoid the problems. With just a little extra effort, you can reap the benefits of code encapsulation and reuse, and still get good performance.


  • Hugo Kornelis

Track and Room: DEV - P01: DEV

Title: On-premises Power BI with Power BI premium and/or Power BI Report Server

Abstract: Recently Microsoft announced capacity based license system, this offering leverages on-premises report publishing. Using this functionality user can now publish reports to Power BI service (Cloud) or Power BI Report Server ( on-premises).

In this session, Prathy will talk about what options are available for On-Premises report publishing. What is Power BI Report Server how is it different from existing SQL Server Reporting Services(SSRS), how licensing works, what are the benefits of Power BI report server and how quickly we can create and deploy Power BI reports to SQL Server Reporting Services Portal / Power BI Report Server portal


  • Prathy Kamasani

Track and Room: BI - P19: BI

Title: Dimensional Modeling Design Patterns: Beyond the Basics

Abstract: Dimensional modeling is one of cornerstones of successful Business Intelligence initiatives. Even with new technologies like PowerPivot and Analysis Services Tabular models, you need to represent your organization’s data in a way that is accessible for end users and IT staff alike. An effective dimensional model will also ensure that your data warehouse or data mart will be responsive and capable of accommodating emerging requirements.

In this session, we will dive deeper into the art of dimensional modeling. We will look at how and when to create the different types of fact and dimension tables, Including patterns for enriching dimensional data, creating usable hierarchies for efficient navigation, and tracking historical changes. After attending this session you will be able to confidently assess the quality of your organization’s dimensional model and recommend and implement changes. Bring your toughest quandaries to help make this an interactive and engaging session.


  • Jason Horner

Track and Room: BI - P19: BI

Title: A Masters view on Locking and blocking

Abstract: How do the wait stats show you that you have a locking issue? This session will show you how to detect and view blocking and lock waits, and understand the cause of it. An extensive walkthrough of the different isolation levels and their respective benefits and drawbacks. And finally a real-world quick list of suggestions on what you can do to solve some of the common issues I come across in my daily work.


  • Mikael Wedham

Track and Room: DEV/DBA - P20: DBA/DEV

Title: Self-Healing Query Execution in SQL 2017

Abstract: In this session we’ll look at two of the big performance improvements introduced with SQL 2017: Adaptive Query Processing and Automatic Tuning. We will discuss the mechanics of each feature, highlight any implementation considerations, and, of course, have a look at the features in action. Scripts will be made available for your own experimentation.


  • Christina Leo

Track and Room: DBA - P21: DBA

Title: Tools and Tips for Data Warehouse Developers

Abstract: Have you ever accidentally pressed the wrong combination of keys, stared at your screen in utter confusion, then spent the next ten minutes trying to figure out what you just pressed that did that really cool thing?

In this session, I will show you some of what I have learned and discovered that has made me say “Oh wow! Why did I not know this yesterday!?” - including features in SQL Server Management Studio (SSMS) and SQL Operations Studio (SOS), keyboard shortcuts, free tools and scripts, Biml for SQL Server Integration Services (SSIS), and even a couple of things I used to think were only useful for those scary DBAs.


  • Cathrine Wilhelmsen

Track and Room: BI/DEV - P22: BI/DEV

Title: Scoped assignments – Threat or salvation? Some real life experiences…

Abstract: Did you ever reach the state in your multidimensional projects when you just didn’t want to implement a new scoped assignment? Will it have any side effects on existing scopes? How about performance? Sometimes your projects get that complex. You will need to choose between many options and it might get hard to even measure the impact or test out all consequences. This session will not answer all your questions, but you will get some real life experiences on what better not to do…


  • Gabi Münster

Track and Room: BI - P19: BI

Title: Crazy Data Science

Abstract: Data is the most valuable asset to any company right now and you can gain a corporate advantage through the insights your data can provide. However, implementing Advanced Analytics can also lead to very….interesting….results. Remember that algorithm that named paint colors? That’s nothing compared to what you are going to witness in this session. From analyzing demonic possession based on selfies, to analyzing how “metal” a song is. In this session, presented by mad data scientists Tomaž Kaštrun and Enrico van de Laar, we will explore all the crazy things that are possible with data science. And who knows? You might even learn a thing or two!


  • Enrico van de Laar

Track and Room: BI/DEV - P22: BI/DEV

Title: Dynamic Search Conditions

Abstract: A common requirement in database applications is that users need a function to search a set of data from a large set of possible search conditions. The challenge is to implement such searches in a way that isboth maintenanble and efficient in terms of performance. This session looks at the two main techniques to implement such searches and highlights their strengths and limitaitons.


  • Erland Sommarskog

Track and Room: DEV - P01: DEV

Title: Datawarehouse Lightning Performance with Columnstore!

Abstract: During this session we will be talking about Columnstore Indexes and how to use them. We will be showing you tips tricks on how to get the performance you want out of Columnstore. We will show you the concepts on how to efficiently load data to your Columnstore tables, how to get your Columnstore properly created, and some dangers with performance you might face when working with Columnstore Indexes as seen in the field! After this session things like segment elimination, auto adjust buffer size, Delta Store,… will no longer be a mysterious concept for you you will be ready to start implementing the different flavors of Columnstore Indexes in your environment.


  • Stijn Wynants

Track and Room: BI/DEV - P22: BI/DEV

Title: Hidden gems of SQL Server 2016

Abstract: SQL Server 2016 is full of new features and improvements. Some of them are “Killer” features like Query Store, Temporal Tables, R Integration, etc., which are discussed a lot and we always can get a lot of information about them. And in the same time, SQL Server 2016 have several fantastic features and improvements, which are more hidden from our sight.

In this session, we will learn a lot about these features and improvements. Which features? This is a secret :) Come to the session and discover them with me!


  • Denis Reznik

Track and Room: DEV/DBA - P20: DBA/DEV

Title: Introducing dbatools 1.0

Abstract: Join PowerShell MVPs Chrissy LeMaire and Rob Sewell as they discuss the newest release of dbatools in-depth. In this session, you’ll learn about key Enterprise features, tips tricks and how you can integrate dbatools into your daily toolset, no matter if you are Dev or Ops.


  • Chrissy LeMaire

Track and Room: DEV/DBA - P20: DBA/DEV

Title: Power Query - The Best thing that ever happened in Excel

Abstract: Excel so far had three “official” revolutions. One being the Pivot Table, second one Tables in Excel and the last one obviously Power Pivot. But Power Query (aka Get Transform aka Data Explorer) trumps them all. This session will show you why this outrageous claim actually makes sense. This will be a full demo session that will prove the title right case by case and should also give you an understanding that if you do not use Power Query in Excel, you are not using Excel at all!


  • Gašper Kamenšek

Track and Room: BI - P19: BI

Title: SQL Server and R for real-time predictions

Abstract: Embedding your R (and soon Python!) models in SQL Server enables you to add predictive capabilities to your applications and your analytics without adding expensive components or going outside your network via expensive API calls.

In this demo-packed talk, you’ll see how you can go from a model built in R to making predictions on the fly in SQL Server 2016.


  • Stephanie Locke

Track and Room: BI - P19: BI

Title: The All Flash DBA

Abstract: We are at a major turning point in the world of storage; the transition from spinning disk to flash and as we move into this new world a lot of conventional wisdom will be turned on its head. Things such as the use of compression, putting different database components on different volumes, the desire to chase large readaheads for sequential scan workloads, how well mixed workloads are handled, the multi threaded log writer and delayed durability, besides this, the session will also cover nand flash fundamentals at 300 level.


  • Christopher Adkin

Track and Room: DBA - P21: DBA

Title: Security Enhancements in SQL Server 2016

Abstract: In this session will be shown how to obfuscate critical data in real time using Dynamic Data Masking, a new feature in SQL Server 2016, also will be covered two other topics, Always Encrypted, defined as Help to protect data at rest and in motion with the master key residing with the application avoiding application changes, because they are not required, finally Row-Level security that consists in set access control to table rows based on users rights.



Track and Room: DBA - P21: DBA

Title: SQL Server Installation 101

Abstract: Have you ever wondered why SQL Server is not starting after the installation or got an error message? Did you have performance issues right after the installation? This session is about the minimum basic settings you may need to set up before,during and after your installations. This session would be great for accidental as well as experienced DBA’s to learn or get more ideas about SQL Server installations. The following topics will be covered:

  • pre-installation checklists
  • automate and standardize installation
  • post-installation checklist
  • basic database settings best practices in general


  • Janos Berke

Track and Room: DBA - P21: DBA

Title: Migrating your local database to Azure SQL DB

Abstract: Azure SQL Database is becoming more and more easy to use, but migration is still a pain point when planning it. In this session I am going to show you some ways to migrate your existing database to Azure SQL Database and how to achieve the same performance.


  • Marcos Freccia

Track and Room: DBA - P21: DBA

Title: Tricky ways to optimize your T-SQL queries

Abstract: Curious about optimizing your queries? Have you already know how to catch and analyse query plans? Do you think you did all your best to achieve maximum performance? If yes, come to this session. No slides, but only practical examples. I will show you some real tasks that I came across, some almost perfect query plans, but we will go a little bit further, when knowing our data will help us to achieve better results.


  • Sergey Olontsev

Track and Room: DEV - P01: DEV


This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Joseph D’Antoni

Twitter: - jdanton

LinkedIn: Joseph D’Antoni

Contact: http://joeydantoni.com

Joseph D’Antoni is a Senior Consultant and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry Associates and lives in Malvern, PA. He is a frequent speaker at major tech events like Microsoft Ignite, PASS Summit, and Enterprise Data World. He blogs about all topics technology at joeydantoni.com. He believes that no single platform is the answer to all technology problems. Joseph holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft book “Introducing SQL Server 2016”.

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.

Enrico van de Laar

Twitter: - twitter.com/evdlaar

LinkedIn: Enrico van de Laar

Contact: https://www.enricovandelaar.com

Enrico has been working with data in all kinds of formats and sizes for over 15 years. He is a Data Advanced Analytics Consultant for Dataheroes where he helps organisations take their first steps in the world of Advanced Analytics. Enrico is a Data Platform MVP since 2014 and a frequent speaker on various data related events all over the world. He authored the book “Pro SQL Server Wait Statistics” and blogs about technologies like Microsoft SQL Server and Azure Machine Learning on his blog at www.enricovandelaar.com


Twitter: - leonel_abreu


An IT Pro who likes to play chess and baseball.

System Engineer degree since 2007, formerly Data Warehousing teacher at university levels from 2008 to 2009. Microsoft Student Partner during the years 2006 - 2007, Second Place in Microsoft Andean Imagine Cup (2006), MCTS, MCITP and MCP with over a decade of experience with SQL Server, working in BI, DBA, Database Development, .net Development, SharePoint and other several areas.

Since 2014 based in Barcelona, Spain. Learning enthusiast and always with passion for new technologies and new challenges.

Mikael Wedham

Twitter: - @wedham

Contact: http://www.wedham.com

Mikael Wedham is the first SQL Server MCM in Sweden and the only one who also is a Microsoft Certified Trainer. He has been paid to do things in SQL Server since 1993. His long experience makes him an appreciated speaker at events and conferences all over Europe. To be prepared for deep dives, he is also certified as an Open Water Scuba Instructor.

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”.

Sergey Olontsev

Twitter: - SergeyOlontsev

LinkedIn: Sergey Olontsev

Contact: http://SergeyOlontsev.com/

I have been working with SQL Server since SQL Server 2000 version as a database administrator, developer, consultant and trainer, focusing on high availability and disaster recovery solutions, ETL, troubleshooting and performance tuning, developing high performance solutions . I’m a regular speaker at SQL Server user group meetings, SQLSaturday events and other conferences. An owner of MCM certification and MVP award on SQL Server.

Jason Horner

Twitter: - jasonhorner

LinkedIn: Jason Horner

Contact: http://blog.jasonhorner.com

Hi, my name is Jason I’m a practice lead at Redapt. I spend most of my day helping clients solve business problems mostly in the Data and Advanced Analytics spaces. Sometimes this involves various and sundry cloud technologies including Azure Data Factory, Azure SQL Data Warehouse, Azure Data Lake Store, Azure Databricks, HDInsight and Azure SQL Database. I’m fluent in several languages including: SQL, C#, Python, and PowerShell.

I’m a Microsoft Certified Master of SQL Server (MCM) and have been recognized for my technical excellence and evangelism efforts by Microsoft by being awarded the Most Valuable Professional (MVP) for the last 5+ years.

In my off hours I like to snowboard, karaoke, ride roller coasters, and play arcade games

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.

Janos Berke

Twitter: - @JanosBerke

LinkedIn: Janos Berke

Contact: http://www.iamberke.com

I am an IT professional with over a decade of technical and management experience. I am using SQL Server since version 6.5. Currently I am a consultant and helping companies in SQL Server design, migrations, operation and developments as well as providing customized training .

David Williams

Twitter: - @smooth1x1

LinkedIn: David Williams

Contact: http://justdave.info

David is a cross product DBA (SQL Server, DB2, Oracle, Informix, Sybase) who has worked for 25 years as a DBA for both private, local/central government customers including a Fortune 50 investment bank. Certifications include MCSE 2014 Data Platform, MCTS SQL Server 2008 DBA and Developer as well as certifcations in other products. David has spoken at multiple SQLSaturdays as well as local usergroups and is a regular volunteer at events including SQLBits.

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.

Regis Baccaro

Twitter: - @regbac

LinkedIn: Regis Baccaro

Contact: http://theblobfarm.wordpress.com

Regis has more than 15 years of experience with SQL Server, SharePoint and .Net as an architect and developer. R#233;gis is a SQL Server MVP since 2014 and a frequent speaker at SQL conferences, a PASS Regional Mentor and the founder of SQLSaturday Denmark community event. He is also a certified industry trainer on the APS/PDW platform. In his freetime he is an avid runner, cook and farmer.

Erland Sommarskog

Contact: http://www.sommarskog.se

Erland Sommarskog is an independent consultant based in Stockholm, working with SQL Server since 1991. He was first awarded SQL Server MVP in 2001, and has been re-awarded every year since. His focus is on systems development with the SQL Server Database Engine and his passion is to help people to write better SQL Server applications.

Christina Leo

Twitter: - christinaleo

Contact: http://christinaleo.net

Christina Leo is a Cloud Solution Architect at Microsoft specialising in the Data and AI Platform. Prior to joining Microsoft in 2016, she worked as an independent consultant focusing on T-SQL and BI development, as well as database performance tuning in the finance and investment banking sector. When she isn’t sharing her 18 years of technical experience with the data community, you can find her racing around the Solent on a 40’ sailboat or often in the Thames on a little Laser.

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.

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.

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.

Stephanie Locke

Twitter: - @stefflocke

LinkedIn: Stephanie Locke

Contact: https://itsalocke.com

Steph Locke leads a life of data, coffee, books and board games. During the day, Steph runs her own consultancy helping people start doing data science. Steph enjoys being her own gal as it means she gets to spend plenty of time building communities to provide platforms for people to help each other be better with data.

Marcin Szeliga

LinkedIn: Marcin Szeliga

Data Philosopher. Since 2006 invariably awarded Microsoft Most Valuable Professional title in the Data Platform category. A speaker at numerous conferences across Europe, as well as at user groups meetings. The author of many books and articles devoted to Microsoft Data Platform. An independent consultant, database-centric application practitioner and architect totally focused on SQL Server and Azure. Huge fan of Data Science and Machine Learning.

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.

Kamil Nowinski

Twitter: - @NowinskiK

LinkedIn: Kamil Nowinski

Contact: https://sqlplayer.net

Blogger, speaker, #sqlfamily member. Microsoft Data Platform MVP. Data passionate, Data engineer and Architect. Over 13 years of programming and experience with SQL Server databases, he worked both as developer and administrator big databases designing systems from the scratch. Passionate about tuning database engines, code transparency and maximising performance database engine. Currently, he is expanding new horizons as a contractor in the UK market, making troubleshooting, prototyping BI and Big Data solutions, enhancing existing processes among Microsoft stuff environments, popularizing the DevOps approach and efficient solutions in the cloud. An originator of the “Ask SQL Family” podcast and founder of SQLPlayer blog.

Gašper Kamenšek

Twitter: - https://twitter.com/ExcelUnplugged

LinkedIn: Gašper Kamenšek

Contact: http://excelunplugged.com

Microsoft MVP for Excel since 2016 Lead Author @ ExcelUnplugged.com (voted one of the top 40 blogs for Excel Worldwide) Speaker @ 50+ conferences Trainer with 900+ courses Trainer with 5000+ attendees

Stijn Wynants

Twitter: - SQLStijn

LinkedIn: Stijn Wynants

Contact: http://swyssql.wordpress.com

Stijn is a Microsoft Premier Field Engineer on Data AI and a DataMinds core member. He is also one of the organizers of the local user group sessions the yearly event called DataMinds Connect (SQL Server Days). He is a speaker at various international events (SQLSaturday,PASS Summit,Difinity,…). He spends his days tuning SQL Servers solving problems with the full data platform. His focus is primarily on sql server core, but has also done various BI ETL projects. He gets his kicks out of Columnstore indexes tuning queries but shivers at the sight of an SSAS cube.

When Stijn is not working with SQL Server, you can probably find him enjoying the local cuisine local beers or enjoying time with his wife and his dog.

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.

Karen Lopez

Twitter: - @datachick

LinkedIn: Karen Lopez

Contact: http://datamodel.com

Karen Lopez is a Sr. Project Manager and Architect for InfoAdvisors. A frequent speaker at conferences and local user groups, she has 20+ years of experience in project and data management on large, multi-project programs. Karen is a chronic volunteer, a Data Platform MVP, and an active advocate for science, technology, engineering, and mathematics (STEM) education and data quality.

Karen’s presentations are known for their lively and interactive approach to learning. Her motto: “Love Your Data!”

Christopher Adkin

Twitter: - ChrisAdkin8

LinkedIn: Christopher Adkin

Contact: http://www.chrisadkin.io

Chris is a freelance SQL consultant who has been working with SQL Server since 2000, his passion is for squeezing every last drop of performance out of SQL Server and understanding the database engine at a level which conventional tools cannot provide any insights on.

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

Paul Andrew

Twitter: - mrpaulandrew

LinkedIn: Paul Andrew

Contact: https://mrpaulandrew.com/

Paul Andrew is a principal consultant and architect, specializing in big data solutions on the Microsoft Azure cloud platform. Paul’s data engineering competencies include Azure Data Factory, Data Lake, Databricks, Stream Analytics, Event Hub, IoT Hub, Functions, Automation, Logic Apps, and of course the complete SQL Server Business Intelligence stack.

He has many years’ experience working within healthcare, retail, and gaming verticals, delivering analytics using industry leading methods and technical design patterns.

Paul is a STEM ambassador and a very active member of the data platform community delivering training and technical sessions at conferences both nationally and internationally.

He is a father, husband, swimmer, cyclist, r

Chrissy LeMaire

Twitter: - @cl

LinkedIn: Chrissy LeMaire

Contact: https://netnerds.net

Chrissy LeMaire is a Data Platform and PowerShell MVP who has worked in IT for over 20 years. She works for General Dynamics and serves as the SQL Server DBA at NATO Special Ops HQ in Belgium. She is also an avid scripter, and has used PowerShell since it was introduced in 2005 at the Microsoft Professional Conference in Los Angeles. Chrissy is the creator of the popular dbatools PowerShell module for SQL Server.

Chrissy recently achieved her MS in Systems Engineering at Regis University ‍


The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page