SQLSaturday #508 - Kyiv 2016

Event Date: 05/21/2016 00:00:00

Event Location:

  • Hotel “Cosmopolite”
  • 6 Vadima Getmana str.
  • Kyiv, Kiev Oblast, Ukraine

PDF of Schedule

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

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

Sessions

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

Title: Advanced BIML - for the advanced ETL developer

Abstract: This is not your regular Agile yada yada BIML session. By now you already know that BIML is a great productivity enhancement to SSIS. You also know that you can build metadata driven solution and include C# code in your BIML scripts or snippets. If you don’t know what I’m talking about this session is not for you. If you - on the other hand - want to know how to build a modular BIML framework, do real C# development and include it in your BIML code so that you can pass custom objects around for optimized performance and code reuse then this session is for you. I promise you no more than 5 slides but a lot of demos and real life experience acquired from major BIML projects. We will also have a look at how to harness integration and unit tests in the setup with a twist of Continuous Integration.

Speaker(s):

  • Regis Baccaro

Track and Room: BI Platform Architecture, Development Administration - Room3

Title: Revolutionary R integration in SQL Server 2016

Abstract: The R integration brings a lot of benefits and new scenarios to on premises data platform systems: • R can greatly simplify collection of different data. • Data manipulation and preparation can also be way easier with R. • You can use R to quickly explore and visualize data. • Last but not least, R brings the whole power of modern data mining techniques to SQL Server.
As if this was not enough, you can use familiar user interface and SQL Server Enterprise R Services to work with large datasets and multi-threaded, multi-core, multi-process computations. So, even if you don’t know R at all, come and see how natural this language is for everybody who already think in rows and columns.

Speaker(s):

  • Marcin Szeliga

Track and Room: Advanced Analysis Techniques - Room1

Title: Mastering DML Operations like a master

Abstract: DML operations mean lots of work for the database engine of Microsoft SQL Server. Understanding the details of a transaction may give you great benefits when planning workloads for INSERT, UPDATE and DELETE operations. This session will demonstrate the huge difference of allocation data in a heap and in a clustered index. If you don’t know the benefits of correct record size and / or you are wondering how you could release allocated data pages in a professional way this session may give you all the answers.

  • data page allocation and its difference for heaps and clustered indexes
  • what is the amount of translog when you update data in a heap and/or in a clustered index
  • delete data from a heap and what is the huge difference to a clustered index?
  • speed up ETL processes by usage of the right strategy for INSERTS and DELETES
  • Page Splits vs. Forwarded Records
  • do you really need a clustered index in a table? Pro’s and Con’s of clustered indexes for DML operations

Speaker(s):

  • Uwe Ricken

Track and Room: Professional Development - Room1

Title: DBA Vs. Hacker: Protecting SQL Server

Abstract: This was never showed before, a Hacker and DBA fighting against the time! The brilliant hacker mind trying to intrude and gain access inside of SQL Server to steal the most valued data using the Kalil Linux distribution when in other side the DBA avoing such achievement by using the security best practice and features available on SQL Server.

A Hacker’s goal is to find vulnerabilities in a system and a DBA’s goal is to make the environment secure and reliable. In this session we will learn how to protect SQL Server from the various forms of attacks that a smart hacker can throw at you. Let’s dig in the Hacker thought process to understand the inception of the attack and how to defeat the invasion. Join with me in this internal session using SQL Server and Kali Linux for the ultimate security showdown!

Speaker(s):

  • Luan Moreno Medeiros Maciel

Track and Room: Enterprise Database Administration Deployment - Room1

Title: Introducing the SQL Server 2016 Query Store

Abstract: With the release of the public preview versions of SQL Server 2016 we were finally able to play with, in my opinion, one of the most exciting new features in SQL Server 2016, the Query Store! The Query Store serves as a flight recorder for your query workload and provides valuable insights into the performance of your queries. It doesn’t stop there however, using the performance metrics the Query Store records, we can decide which Execution Plan SQL Server should use when executing a specific query. If those two features aren’t enough, the Query Store provides all this information inside easy-to-use reports and Dynamic Management Views (DMVs) removing a great deal of the complexity of query performance analysis. During this session we will take a thorough look at the Query Store, it’s architecture, the build-in reporting, DMVs and the performance impact of enabling the Query Store. No matter if you are a DBA or developer, the Query Store has information that can help you!

Speaker(s):

  • Enrico van de Laar

Track and Room: Enterprise Database Administration Deployment - Room1

Title: Think Connected – Modern IoT Solutions with Microsoft Azure

Abstract: The Internet of Things is becoming reality at a rapid pace. Many objects in the real world can be connected to the Internet. Cloud computing is the best option for the IoT backend. Microsoft Azure offers the best set of services, required for the Internet of Things solutions, including a wide set of storages, websites, cloud services, Azure Service Bus / Event Hubs, Mobile Services, AD authentication and many data platform and BI related products like Azure SQL Database, DocumentDB, Azure Storage, Azure Stream Analytics, Machine Learning, Power BI and more..
This talk is about the main business cases and main architectural challenges, related to the actual and new IoT systems and particularly predictive services, based on Microsoft Azure.

Speaker(s):

  • Mihail Mateev

Track and Room: Cloud Application Development Deployment - Room4

Title: Upgrade, upgrade and more upgrade -know about SQL Server platform upgrade

Abstract: Why Upgrade? Data Platform Upgrade topic has been a popular session that I’ve presented in major conferences like Microsoft Tech-Ed (North America, Europe India) and SQLbits since 2008.

In this session, we will overview in depth end-to-end upgrade process that covers the essential phases, steps and issues involved in upgrading SQL Server (2000 to 2012), SQL Server 2014 (with a good overview on 2016 too) by using best practices and available resources.

What to-do and what not-to-do?

A popular session that I have been presenting since the year 2008, in MS Tech-Ed, SQLSaturday SQLbits UK. We will cover the complete upgrade cycle, including the preparation tasks, upgrade tasks, and post-upgrade tasks. Real-world examples from my Consulting experience expanding on why how such a solution.

Speaker(s):

  • Satya Jayanty

Track and Room: Enterprise Database Administration Deployment - Room3

Title: Storage, Backup and Restore Management in the Cloud World

Abstract: The world has changed. The work is changing. Some feature from our dreams come true. In The World of Cloud we can store our data in the cloud. We can create Backup and very easy (?) Restore to and from any point of The World of The Cloud. But… how to manage that? Which tools, applications, ideas, solutions we can use for this? In this workshop we will test our cloud environment, and solutions. We will focus on Windows Azure SQL Database, SQL Server on Premise, BLOB Storage and many of free tools which we can use for our comfortable work. We will talk about best and worse practices and of course we will test those procedures.

Requirements for this workshop:

  • Windows 8 or 8.1 (preffered) / Windows 7 is possible (some workshop feature will not work) / Windows 10 is possible too
  • SQL Server 2012 minimum in Standard Edition installed (SQL Server 2014 preffered) {LINK: http://bit.ly/1I7gEn4}
  • Active Microsoft Azure Account {LINK: http://bit.ly/1n0AV52}

Speaker(s):

  • Tobias Koprowski

Track and Room: Enterprise Database Administration Deployment - Room2

Title: Azure Data Lake Analytics. Dive into Big Data with Microsoft U-SQL lanuage.

Abstract: With Azure Data Lake a new SQL-based language called U-SQL has been introduced, that combines the familiarity of SQL with new extensions for Big Data processing and easier user-extensibility. In this session I will explain the main concepts of the new language and show examples of how to use it to query unstructured, semi-structured and structured data. Discover the similarities to the SQL and database objects you know and call out some of the important differences. We will discuss tools and practices to monitor, tune and improve performance of U-SQL. What parameters to look for, how to absorb metrics, what features to tune and how to make sure you can run massive scale Big Data environments.

Speaker(s):

  • Vitalii Bondarenko

Track and Room: BI Platform Architecture, Development Administration - Room5

Title: JSON XML; since SQL 2016 it is important to weigh respective advantage

Abstract: The session begins with „JSON“ and shows with a syntax-comparison the similarities to XML. Both the different operational scenarios and the technical background of JSON and XML, however, require a different range of functions and language. Therefore, initially, as far as practicable the parallels will be demonstrated. Especially the T-SQL extensions „FOR JSON“ and „OpenJSON“ are very similarly implemented in comparison to „FOR XML“ and „OpenXML“. Furthermore the new functions „IsJSON“, „JSON_VALUE“ and „JSON_QUERY“ are now contained in T-SQL. Do they also have these as T-SQL functions for XML or can these results be calculated with XML-methods? Additionally, XML has some more features which concern saving ( and indexing ) and requesting (in particular with XQuery) in relational tables. These will also be demonstrated exemplary. The goal of the session is to show, when which language is of advantage in which case.

Speaker(s):

  • Alexander Karl

Track and Room: Application Database Development - Room2

Title: Continuous Integration and the Data Warehouse

Abstract: Continuous Integration is not normally associate with data warehouse projects due to the perceived complexity of implementation. John will be showing how modern tools make it simple to apply continuous integration techniques to data warehouse projects. In particular, the session will cover:

  • Setting up SQL Server Data Tools for automated deployments: DAC Publish profiles SQLPackage.exe

  • Automating your build and deployments with PowerShell and psake

  • Guide to configuring TeamCity as your build server

  • Automated Integration and Regression testing of your Data Warehouse using NBi test framework

  • Automating cube and tabular model deployment

  • On-going management of OLAP databases using the SSAS Partition Manager

Speaker(s):

  • John Tunnicliffe

Track and Room: BI Platform Architecture, Development Administration - Room2

Title: Power BI Workshop

Abstract: В этом тренинге Вы научитесь как использовать Power BI Desktop+Power BI Service чтобы создавать готовые решения, которые включают информационные dashboards, возможности self-service анализа и BI на мобильных устройствах. Во время курса мы создадим решение использующее различные источники данных с интерактивной визуализацией, которое может быть использовано как локально аналитиками так и совместно с другими пользователями в облачном сервисе Power BI Service. В курсе так же будут рассмотрены компоненты традиционных BI решений, архитектура Power BI и их различие в подходах и применении. По окончанию курса Вы будете знать - как использовать PowerQuery для объединения и трансформации данных из нескольких источников; PowerPivot и DAX для моделирования данных, создания вычислений и KPI; как создавать информативные и интерактивные отчёты в Power BI используя различные способы визуализации, как организовать совместную работу с информацией с использованием Dashboards и Groups в Power BI Service

Speaker(s):

  • Sergiy Lunyakin

Track and Room: Other - Room1

Title: DevOps’ing or how to build, release and provision environments on

Abstract: During this session we will talk about DevOps practices in general and also see some demos about how to automate your builds, how to manage your releases, how to manage different environments and create them on a fly.

I will show the demo app which consists of 3 parts - client app, server api and database. I will show how to automate builds for all parts of your project. I will show how to provide different configuration settings for different environments. I will show how you can create new environment on a fly, deploy your app there, run some integration and UI automation tests, etc. I will show how to automate all routine stuff and focused more on innovation, not maintenance.

Speaker(s):

  • Anton Boyko

Track and Room: Cloud Application Development Deployment - Room4

Title: Big Data with Azure: where to begin? Concepts and best practices

Abstract: In order to ascertain the abilities of cloud computing platform, let us overview what is available offered on Microsoft Azure.

Microsoft Azure has the ability to move, store and analyze data within the cloud. It is essential to evaluate multiple opportunities and options with Microsoft Azure data insights. In this session let us talk about strategies on data storage, data partitioning and availability options with Azure. A tour on how best these Azure components can help you achieve success for your Big Data platform.

Speaker(s):

  • Satya Jayanty

Track and Room: Advanced Analysis Techniques - Room4

Title: Relation Theory - back to basics

Abstract: During the session we will talk about how to avoid modification anomalies and improve the performance of your DBMS.

Speaker(s):

  • Mariya Shirokopetleva

Track and Room: Application Database Development - Room4

Title: Tabular SSAS 2016. What’s new?

Abstract: Что нового в 2016 табуляре? Ка использовать его? Что такое Super DAX? А тут есть и переменные? Обсудим новинки dax и архитектуры табуляр.

Speaker(s):

  • Eugene Polonichko

Track and Room: BI Platform Architecture, Development Administration - Room3

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.

Speaker(s):

  • Erland Sommarskog

Track and Room: Application Database Development - Room1

Title: PBM and PowerShell for DBA

Abstract: SQL Server provides a wealth of excellent functionalities and tools that are able to greatly facilitate the life of a database administrator. During this session we will discuss the Policy Based Management and PowerShell, we’ll show how to manage not only a single SQL Server instance, but also multiple instances. All this in practical way – most of the time we will spent on demonstrations, not sterile theory.

Speaker(s):

  • Andrzej Kukula

Track and Room: Enterprise Database Administration Deployment - Room5

Title: Anomaly Detection

Abstract: Anomaly detection is one of the most advanced data mining and machine learning tasks. There are many statistical procedures and data mining algorithms that can be used for it, including Expectation-Maximization Clustering, and Principal Component Analysis. In this session, you will learn through presentation and demos how to detect the low quality data areas with some basic statistics and with advanced algorithms. You will see how you can use T-SQL queries, R code in SQL Server, SSAS Data Mining, and Azure ML for this complex task.

Speaker(s):

  • Dejan Sarka

Track and Room: Advanced Analysis Techniques - Room2

Title: SQL 2016. Super speed with in-memory OLTP.

Abstract: On this session, I will describe the principles of in-memory internals and usage. After the session, you can find opportunities how to implement this modern technology in your environment and improve a performance. We will dive into all processes inside new in-memory engine and will get understanding how to use all sort of objects like:

  1. Durable/non-durable tables
  2. New sorts of indexes
  3. Native compiled objects
  4. Table-valued functions Etc…

Speaker(s):

  • Oleg Alekseev

Track and Room: Professional Development - Room3

Title: @Table vs #Table: шаблони використання, спільні характеристики, міфи

Abstract: MS SQL Server надає дві можливості для зберігання тимчасових наборів даних: тимчасові табиці та табличні змінні. Вважається, що табличні треба використовувати для маленьких об’ємів даних (бо вони живуть в оперативній пам’яті), а тимчасові таблиці - для великих. Подивимося, чи дійсно це так; чи можна за такими характеристиками порівнювати ці об’єкти.

Speaker(s):

  • Andrii Zrobok

Track and Room: Application Database Development - Room5

Title: XML, XQuery и трюки с производительностью

Abstract: При работе с XML и XQuery существует великое множество #171;подводных камней#187;, которые могут приводить к каверзным проблемам с производительностью. В рамках доклада будут рассмотрены общие рекомендации о как эффективно создавать, хранить и обрабатывать XML.

Speaker(s):

  • Sergey Syrovatchenko

Track and Room: Application Database Development - Room5

Title: Real-Time Dashboards on PowerBI

Abstract: Power BI enables you to create beautiful and very informative dashboards for business users. You can use embedded connectors to many sorts of data sources for getting your data. Moreover, you can get data from real-time data sources as well, for instance monitoring systems, sensors, web sites etc, and get the most from your data. Join this session to learn how to use PowerBI REST API to add real-time dashboards.

Speaker(s):

  • Sergiy Lunyakin

Track and Room: BI Information Delivery - Room3

Title: What is Azure Data Lake? How to position it in Big Big Data business?

Abstract: Big Data and Data Warehousing have taken a giant leap in the last few months and are now the helm of any data platform discussion.

This session delves into Microsoft’s play in the Big Data workload, and paints the end-to-end picture of effective solutions.

Session covers the importance of building a Data Lake, nurturing its potential with Hadoop and other analytics options and an important chapter in the Microsoft Data Platform story.

Speaker(s):

  • Umit Sunar

Track and Room: Strategy and Architecture - Room4

Title: AD 2015. 2 AM. A Disaster just began…

Abstract: 2AM. We sleeping well. And our mobile ringing and ringing. Message: DISASTER! In this session (on slides) we are NOT talk about potential disaster (such BCM); we talk about: What happened NOW? Which tasks should have been finished BEFORE. Is virtual or physical SQL matter? We talk about systems, databases, peoples, encryption, passwords, certificates and users. In this session (on few demos) I’ll show which part of our SQL Server Environment are critical and how to be prepared to disaster. In some documents I’ll show You how to be BEST prepared.

Speaker(s):

  • Tobias Koprowski

Track and Room: Strategy and Architecture - Room1

Title: Индексы в SQL Server. Сборник рецептов.

Abstract: В данном докладе я попытался объединить лучшие практики по использованию и обслуживанию индексов. О чем будем говорить:

  1. Кластерные, некластерные, фильтрованные индексы. Зачем они нужны, в каких случаях необходимо их создавать и какими они должны быть.
  2. Как правильно писать запросы, чтобы не исключать возможности использования индексов.
  3. Как правильно обслуживать индексы, чтобы не оказать SQL Server “медвежью услугу”.

Будет мало текста - будет, в основном, демонстрация!

О чем не будем говорить:

  1. XML, Columnstore индексы.
  2. Внутренняя архитектура хранения индексов.

Speaker(s):

  • Andriy Pogorelov

Track and Room: Application Database Development - Room3

Title: PostgreSQL and Big Data

Abstract: PostgreSQL very popular RDBMS. In this talk I will describe interesting abilities of this database to handle Big Data, such as build-in data types and functions, various indexes, sharding methodology, various extensions, backup strategies.

Speaker(s):

  • Alexey Vasiliev

Track and Room: Strategy and Architecture - Room2

Title: Managing Database Changes in Source Control

Abstract: There are a number of challenges while collaborating on database development. When someone in a team changes database objects in a shared database, another team member may overwrite those changes. This will lead to the data loss. The best way to resolve such challenges is to start using database version control. In this session, we will talk about the source control basics, and also have a look at how to start source controlling your SQL Server databases.

Speaker(s):

  • Andrey Langovoy

Track and Room: Application Database Development - Room3

Title: SQL Server 2016 for DBA

Abstract: SQL Server 2016 introduces new features that can make day-to-day life of DBA much easier. On the session there will be presented new feature Query Store that provides DBAs with insight on query plan choice and performance. It simplifies performance troubleshooting by enabling you to quickly find performance differences caused by changes in query plans. Live Query Statistics will be also shown that provides real-time insights into the query execution process.

Speaker(s):

  • Michal Sadowski

Track and Room: Enterprise Database Administration Deployment - Room2

Title: Service Broker in action

Abstract: Service Broker is one of the interesting but not so widely known SQL Server feature. It allows processing massive workloads without need to wait until processing is done because it is asynchronous in contradiction to stored procedure. Processing of workloads and other interesting scenarios of Service Broker feature usage will be covered during the session. You will see many interesting demo scripts that allow you to start using asynchronous processing straight away after the session. There will be also information about messages, contracts, queues, services, conversations, activation and all other stuff you need to know.

Speaker(s):

  • Tomasz Libera

Track and Room: Application Database Development - Room5

Speakers

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

Michal Sadowski

Twitter: - SadowskiMichal

LinkedIn: Michal Sadowski

Contact: https://sqlplayer.net/michal-sadowski

Senior Database Platform Engineer, leader of Krakow chapter of Data Community Krakow (former Polish SQL Server User Group) - PASS Chapter. With more than 10 years of experience in Microsoft technology, helps in advisory for performance optimization on database and application levels. Active speaker on SQL Server related events like SQLSaturday, SQLDay, MCT Global Summit etc. Holds many Microsoft certificates including MCSE: Data Platform, MCSA: SQL Server 2012/2014/2016, MCSA: Windows Server 2008/2012/2016 and MCT.

Eugene Polonichko

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

LinkedIn: Eugene Polonichko

Contact: https://msolapblog.wordpress.com/

Leader of PASS Local Chapter in Donetsk (Ukraine). I work as DWH/BI architect. Responsible for designing and developing Data Warehouse and BI solutions with using Microsoft BI Stack products.

Alexander Karl

Twitter: - sqlfabrik

Alexander Karl is database-developer and certified MCT for Windows and SQL Server with .net-CDE GmbH. For more than 18 years he has been working with Database-, Datawarehouse- and Reporting-Solutions for companies from medium-sized enterprises to Group level. His spectrum includes Serversizing, Programming to optimize performances as well as Report- and Chartdesign; in trainings and seminars he conveys participants well-founded theoretical knowledge complemented with his practical.

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.

Tomasz Libera

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

LinkedIn: Tomasz Libera

MVP Data Platform, MCT, leader of Krakow Data Community Poland user group. Organizer of SQLDay and SQLSaturday conferences. SQL Server Developer and academic trainer. Speaker at group meetings and conferences.

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.

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

Tobias Koprowski

Twitter: - @KoprowskiT

LinkedIn: Tobias Koprowski

Contact: http://koprowskit.eu/geek/

Founder of Shadowland Consulting. In January 2015 decided to permanently leave Poland and discover new worlds. Actually settled in Hucknall (The Last home of The Byron Family). Community leader focused on SQL Server, SharePoint, security, collaboration and ITIL, DR, BCM, and SLA. Love licensing stuff.

Microsoft Certified Trainer, freelancer, and consultant. Subject Matter Expert at Microsoft. Member of Microsoft Terminology Community, Friends of RedGate PLUS, PASS, ISSA, ACM and more. Since 1st July 2010 Data Platform MVP. Creator of SQLDAY Conference and Conference CEO 2009-2011. Co-Leader of PASS East Midlands Group. Speaker at group meetings and conferences. STEM Ambassador.

Traveler. Coffee Addicted.

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

Satya Jayanty

Twitter: - sqlmaster

LinkedIn: Satya Jayanty

Contact: http://www.sqlserver-qa.net

My experience surrounded with high focus on the data platform with a track record of defining strategy, designing and delivering digital transformation migrations with major enhancements to current working methods. Worked in a capacity of Head of Data Engineering, Enterprise Data Architect and Solutions

Key career accomplishment recognition as an industry expert technical excellence from the Microsoft as Data Platform Most Valuable Professional (MVP) recognition since the year 2006 (13 years as MVP and counting), which recognizes exceptional technical community leaders worldwide who actively deliver, present share their extraordinary contributions, high quality, and real-world expertise. Twitter pod (http://twitter.com/sqlmast

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.

John Tunnicliffe

Twitter: - Dr_John_T

LinkedIn: John Tunnicliffe

Contact: https://devops-your-dwh.com/

Dr John Tunnicliffe is a well-respected designer and architect of business intelligence solutions who likes nothing more than getting his hands dirty with real life coding problems. John is a recognised expert in applying continuous integration techniques to data warehouse projects, thereby ensuring code is automatically built, deployed and tested as changes are made by the development team. As a regular speaker at the SQLBits conference and PASS SQLSaturday events, John has covered topics such as building an infrastructure to support real-time OLAP and continuous integration and the data warehouse.

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.

Luan Moreno Medeiros Maciel

Twitter: - @luansql

LinkedIn: Luan Moreno Medeiros Maciel

Contact: https://luanmorenodba.wordpress.com/ amp; http://www.sqlshack.com/author/luan-moreno-m-maciel/

Based out of Brazil, Luan Moreno credits his ability to solve problems to thinking critically before acting. He values working with a team because he and his clients can benefit from various perspectives and collaboration, particularly when faced with difficult issues. When Luan Moreno first became interested in technology, he didn’t have a mentor, so he made a commitment to teaching others in the community and sharing his knowledge through blogging, speaking engagements.

Luan Moreno is a addicted Brazilian blogger and speaker. SQL Server MCT, MCSE and MVP living in Brazil. Nowadays he#39;s a Database Consultant at Pythian, company based in Ottawa - Canada.#160;

Andriy Pogorelov

LinkedIn: Andriy Pogorelov

I have been dealing with database administration and development for more than 16 years. Started from SQL Server 2000

  • Active member of Data Platform community
  • Organizer of SQLSaturday Kharkiv
  • Speaker at various Data Platform related events
  • I possess Microsoft certificates: MCDBA, MCITP, MCSA.

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.

Satya Jayanty

Twitter: - sqlmaster

LinkedIn: Satya Jayanty

Contact: http://www.sqlserver-qa.net

My experience surrounded with high focus on the data platform with a track record of defining strategy, designing and delivering digital transformation migrations with major enhancements to current working methods. Worked in a capacity of Head of Data Engineering, Enterprise Data Architect and Solutions

Key career accomplishment recognition as an industry expert technical excellence from the Microsoft as Data Platform Most Valuable Professional (MVP) recognition since the year 2006 (13 years as MVP and counting), which recognizes exceptional technical community leaders worldwide who actively deliver, present share their extraordinary contributions, high quality, and real-world expertise. Twitter pod (http://twitter.com/sqlmast

Tobias Koprowski

Twitter: - @KoprowskiT

LinkedIn: Tobias Koprowski

Contact: http://koprowskit.eu/geek/

Founder of Shadowland Consulting. In January 2015 decided to permanently leave Poland and discover new worlds. Actually settled in Hucknall (The Last home of The Byron Family). Community leader focused on SQL Server, SharePoint, security, collaboration and ITIL, DR, BCM, and SLA. Love licensing stuff.

Microsoft Certified Trainer, freelancer, and consultant. Subject Matter Expert at Microsoft. Member of Microsoft Terminology Community, Friends of RedGate PLUS, PASS, ISSA, ACM and more. Since 1st July 2010 Data Platform MVP. Creator of SQLDAY Conference and Conference CEO 2009-2011. Co-Leader of PASS East Midlands Group. Speaker at group meetings and conferences. STEM Ambassador.

Traveler. Coffee Addicted.

Mihail Mateev

Twitter: - mihailmateev

LinkedIn: Mihail Mateev

Contact: https://mmateev.wordpress.com/

Mihail Mateev is a technical consultant, community enthusiast, PASS Regional Mentor for CEE, chapter lead, Microsoft Azure MVP, Microsoft Regional Director. He works as a Senior Solutions Architect at EPAM Systems, focused on Data Platform, IoT and cloud related solutions. He also worked many years like a Technical evangelist in the Infragistics. Last years Mihail was focused on various areas related to technology Microsoft: Data Platform, Visual Studio, ASP.Net, Windows client apps, Data Platform, and Microsoft Azure. Michael also has a PhD in cloud computing area. He is a university lecturer on Smart Homes and Smart Energy IoT Solutions.

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.

Mariya Shirokopetleva

Senior Lecturer, Kharkiv National University of Radio Electronics. Inrteresy: databases, artificial intelligence

Andrey Langovoy

Twitter: - langovoyandrey

LinkedIn: Andrey Langovoy

Contact: http://codingsight.com

Andrey Langovoy is a team leader at Devart. He takes part in development and testing database management tools for SQL Server, writes articles about SQL Server and contributes to open source projects, MSDN and MDN.

Andrzej Kukula

Twitter: - @andrzejkukula

LinkedIn: Andrzej Kukula

Consultant and trainer in SQLExpert.pl with more than 20 years of IT experience. Architect of HA/DR solutions, BI solutions, Data Platform solutions, cloud solutions. Solves SQL Server related problems, including performance tuning. Passionate about SQL Server and programming. Speaker at various conferences including SQLSaturday, SQLDay, SQLNexus, AzureDay, Global Azure Bootcamp and local user groups.

Andrii Zrobok

LinkedIn: Andrii Zrobok

25+ years of experience in database development: development data-centric applications from scratch, support of legacy databases/applications, data migration tasks, performance tuning, consulting, database trainer. I have experience with wide range of databases such as FoxPro for DOS (Fox Software), MS SQL Server (started from version 6.5) , Oracle, Sybase ASE, MySQL, PostgreSQL. Co-Leader of PASS Local Chapter in Lviv. Speaker at PASS SQLSaturday conferences (since 2013); PASS Lviv/Vinnitsa/Virtual SQL Server User Group, EPAM IT Week (2015-2017), AIBig Data Day 2019.

Vitalii Bondarenko

I’ve been designing data-centric systems for last 20 years and have gained huge experience in developing BI, AI and Big Data solutions. For the last 5 years I’ve mostly been focused on enterprise platform designing and implementing different innovative approaches for Fast Data Processing. At the moment I’m responsible for building Processional Services in Cloud Solutions for Enterprise Customers.

Umit Sunar

Twitter: - @umitsunar

LinkedIn: Umit Sunar

Umit Sunar has been working in IT Industry since 2000 and he is currently working as Cloud Solution Architect (Azure) at Microsoft MEA HQ. Based in Dubai and traveling a lot for business and entertainment. Formerly, he is an aeronautics engineer originally supposed to build airplanes.

In technical keywords, he received his first development certificate from Borland at 1992 and continued development in many platforms including C, PHP, Pascal Fortran, Python, Java, C#, Node.js and maybe couple more that he forgot writing this.

He is passionate about Cloud Computing for 8+ years and even created a small cloud environment in 2008

He doesn’t like the word “geek” but likes a lot traveling, cooking and smiling.

Alexey Vasiliev

Contact: http://leopard.in.ua

Ruby on Rails разработчик и Linux администратор в компании Railsware. Является автором таких продуктов как: PopCornUA, MongodbLogger, SmtRails, PIRO, Webp-ffi, Zopfli-ffi и многих других.

Алексей является автором открытого учебного пособия по PostgreSQL на русском языке и по Chef на английском языке. Активный докладчик в различных IT конференциях.

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.

Oleg Alekseev

12 years of experience with MS SQL Server. Used to work for Banks, International IT-companies, Microsoft. The main specializations - SQL core, DBA.

Sergey Syrovatchenko

DBA

Anton Boyko

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

LinkedIn: Anton Boyko

Founder and main speaker at Ukrainian Microsoft Azure Community. 15+ years in application development. Builds apps based on Microsoft Azure platform since 2011. Microsoft Azure technical expert. Microsoft Azure MVP since 2014. Owner and one of the organizers of the most popular Microsoft Azure conferences in Ukraine: Azure Day and Global Azure Bootcamp.

Sponsors

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

Back to the SQLSaturday Event List

Back to the home page