Event Location:
Sun City Premium
Moskovskiy ave, 199-B
Kharkiv, Kharkivs'ka Oblast', Ukraine
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,
Abstract:
PowerQuery - это пользовательский инструмент обработки, комбинирования и очистки данных для дальнейшего их анализа прямо из Excel, самого популярно инструмента для анализа данных. Хотя все его возможности и проявляются совместно с подпиской PowerBI, но он вполне применим и для локального использования. Например для создания аналитических приложений в Excel ) Простой, удобный интерфейс и вся мощь встроенного языка M позволяет создавать вполне функциональные и полезные приложения, а главное Вам не понадобится ничего кроме Excel. В докладе мы рассмотрим как использовать PowerQuery и Excel чтобы: - Подключиться к источникам данных - Обработка и очистка данных - Создания динамических фильтров и таблиц параметров - Обработка ошибок - Создание красивых графических отчётов
Speaker(s): Sergiy Lunyakin,
Abstract:
Зачастую даже при жёстких требованиях заказчика многими интеграторами и разработчиками вопрос безопасности баз данных игнорируется в угоду упрощения разработки и развёртывания. Бывают и обратные ситуации, когда в довольно глубоко продуманной и защищённой системе начинают появляться пробелы в безопасности вследствие расширения инфраструктуры и дальнейшей эволюции продукта. Во время данной сессии мы ознакомимся и обсудим основные практики по обеспечению безопасности SQL Server, попытаемся разобраться, чем действительно можно пожертвовать, а от чего отказываться не стоит ни в коме случае. Доклад будет интересен разработчикам, администраторам, специалистам по безопасности, а также руководителям, которых волнует вопрос сохранности данных и безопасности доступа к ним.
Speaker(s): Yevhen Nedashkivskyi,
Abstract:
In the nearly 20 years I have been working with SQL Server, most of that as an independent consultant, I can count on two hands the number of clients I have come across that had ANY database tests constructed. I can count on TWO FINGERS the number of them that had repeatable database tests. Even the most ardent Agile/Scrum/pick-your-new-and-shiny-development-mantra shops hardly ever do anything more than wave a magic wand at testing the database, because it can be REALLY HARD to do and do correctly. In this session we will cover examples of why repeatable database testing is CRITICALLY important and then examine both a free and a low-cost commercial product to ease the pain and improve developer efficiency.
Speaker(s): Kevin Boles,
Abstract:
What's new in SQL Server 2016 and what new directions in data analysis and data processing are now at the top of Microsoft's strategy.
Speaker(s): Valentyn Yeliseyev,
Abstract:
While developing a web application, you need to make sure you are testing it under conditions that closely simulate production environment. Without meaningful test data in test environment, it is quite impossible to predict the way the application will behave after the release. During this session, we will talk about how to generate real test data to be used in the test environment.
Speaker(s): Andrey Langovoy,
Abstract:
Доклад будет посвящен блокировкам диапазона ключей (Key-Range Locking). Вначале будет рассказано о базовых механизмах, после чего, мы поговорим о некоторых аспектах которые не описаны в MSDN. Дополнительно рассмотрим неявное использование блокировок диапазона ключей в уровне изоляции READ COMMITTED.
Speaker(s): Vitaliy Popovych,
Abstract:
На докладе посмотрим на Tabular модель. Как строить решение на основе данной модели, зачем она вообще нужна, как настраивать ее, как оптимизировать. Что такое DAX и как на нем писать запросы.
Speaker(s): Eugene Polonichko,
Abstract:
SQL Server 2014 is full of new features and improvements. Some of them are "Killer" features like InMemory OLTP, Clustered Columnstore Indexes, Buffer Pool Extensions, etc., which are discussed a lot and we always can get a lot of information about them. And in the same time, SQL Server 2014 have several fantastic features and improvements, which are more hidden from our sight. In this session we will talk in details about these features and improvements. Query Fingerprints, Cardinality Estimator, Tempdb improvements, and more features will be covered in this session.
Speaker(s): Denis Reznik,
Abstract:
During the session we will talk about how to avoid modification anomalies and improve the performance of your DBMS.
Speaker(s): Mariya Shirokopetleva,
Abstract:
We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance. I have given this talk over SEVENTY times now and it is always very highly rated!
Speaker(s): Kevin Boles,
Abstract:
Get deeply familiar with columnstore indexes. This session includes the columnstore technology overview with a deeper look inside the physical structure of columnstore indexes and will cover the practical aspects of utilizing columnstore indexes in different versions of SQL Server. Additionaly includes the features that are expected in upcoming version of SQL Server: introduction to operational analytics - overview of new data indexing approach introduced in SQLServer 2016; columnstore for memory-optimized data - some notes on how the the columnstore behaves in-memory; columnstore enchancements for data warehousing At the end it covers the introduction to Vertipaq encoding
Speaker(s): Taras Bobrovytskyi,
Abstract:
About dependency between query syntax (adhoc query, query with local variables, stored procedures, local variable ) and query execution plan; deep dive into OPTION (RECOMPILE)
Speaker(s): Andrii Zrobok,
Abstract:
В докладе я расскажу что такое динамический sql, какие способы его построения, рассмотрены примеры использования "exec" и "sp_executesql".
Speaker(s): Alesya Zhuk,
Abstract:
Microsoft Azure HDInsight is a big data solution based on the open-source Apache Hadoop framework, and is an integral part of the Microsoft Business Intelligence (BI) and Analytics product range. We will review the various methods of programming with HDInsight, including how to use the HDInsight cmdlets in Windows PowerShell to work with the HDInsight cluster, how to use the HDInsight Software Development Kit (SDK) to develop applications, how to use Hive, Pig, Excel Power Query, Sqoop to work with data. We will explore common Big Data analysis scenarios and their implementations with Azure HDInsight.
Speaker(s): Vitalii Bondarenko,
Abstract:
• Implementing InMemory OLTP • In-Memory OLTP Performance • In-Memory OLTP Migration • In-Memory OLTP Interoperability
Speaker(s): Oleg Alekseev,
Abstract:
This will be an interesting and sometimes fun session with a small demo. This session will answer some of your questions and force you to think about new questions. It will not be very technical, so it's ok for choose another more technical session from the schedule :) But if will decide to come, I can assure you, that you will not be disspointed.
Speaker(s): Denis Reznik,
Abstract:
The session will describe the typical schemes of the developers work with database and methods how to maintain the database up to date with the history of changes. There will be a demonstration of some methods.
Speaker(s): Konstantin Proskurdin,
Abstract:
Launched about three years ago and acquired by Microsoft this spring Datazen is a business intelligence and data visualization service, available on Windows, Windows Phone, iOS, Android and the web. During the session we will go through the product basics and of course do some demos.
Speaker(s): Yan Roginevich,
Abstract:
In this session you will learn about unusual uses of the coalesce() function, different methods to pivot table, how to store hierarchies and many-many other interesting things that can be done with T-SQL!
Speaker(s): Olena Smoliak,
Abstract:
Microsoft Azure HDInsight is a big data solution based on the open-source Apache Hadoop framework, and is an integral part of the Microsoft Business Intelligence (BI) and Analytics product range. We will explore the use of HDInsight in a range of use cases and scenarios such as a data warehouse, for ETL processes, and integration into existing BI systems. We will review the concepts of big data, planning and designing big data solutions, and implementing these solutions.
Speaker(s): Vitalii Bondarenko,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: https://www.linkedin.com/in/slunyakin
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.
LinkedIn: http://www.linkedin.com/in/thesqlguru
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
LinkedIn: https://ua.linkedin.com/in/vitaliipopovych
Senior Database Developer at TFG an Intapp Company. Опыт работы с MS SQL Server — более 5 лет.
LinkedIn: http://www.linkedin.com/pub/mihail-mateev/1/6b3/4b1
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.
LinkedIn: https://www.linkedin.com/profile/view?id=300853242amp;trk=nav_responsive_tab_profile
Contact: http://dneprsqlusergroup.blogspot.com
работаю SQL/BI Developer . Опыт работы с MS SQL Server — 6 лет.
17 years of experience in IT. Has worked as a developer, analyst, project manager and product manager in banks and software companies. Experience in the creation of bank systems, billing systems for telcos and operational support systems.
LinkedIn: http://www.linkedin.com/pub/denis-reznik/3/502/234
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.
LinkedIn: http://www.linkedin.com/in/thesqlguru
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
LinkedIn: https://ua.linkedin.com/in/nedash
Yevhen Nedashkivskyi is a professional DBA and a database developer with more than 10 years of experience. MSCP, MSCA, MSCE, MVP.
LinkedIn: https://www.linkedin.com/in/eugenepolonichko/
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.
Senior Lecturer, Kharkiv National University of Radio Electronics. Inrteresy: databases, artificial intelligence
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.
LinkedIn: https://www.linkedin.com/in/azrobok/
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.
.NET developer with more than 10 years of experience, experience with MS SQL Server - 8 years.
10 years of expirience in software development
LinkedIn: http://www.linkedin.com/pub/denis-reznik/3/502/234
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.
LinkedIn: https://ua.linkedin.com/in/andreylangovoy
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.
12 years of experience with MS SQL Server. Used to work for Banks, International IT-companies, Microsoft. The main specializations - SQL core, DBA.
LinkedIn: https://www.linkedin.com/in/olenasmoliak
Senior Software Engineer at Adver-Online Microsoft Certified Solution Associate (MCSA): SQL Server 2012 Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development Vinnitsa Data Platform User Group Leader (#vssug) Speaker at local user group meetings in Kyiv, L#39;viv, Dnipropetrovsk, SQLSaturday #290 (Kyiv, 2014), Global Russian Virtual Chapter Participated in organization of Kyiv SQLSaturdays #377, #290 (2014, 2015)
LinkedIn: https://ua.linkedin.com/in/tbobrovytskyi
Started working with SQL Server in 2007 as consultant, eventually becoming a MIcrosoft Certified Trainer. Participated in consulting projects in Ukraine, Belarus, Georgia, Kazakhstan Since 2012 working as a database developer/data architect at DieboldNixdorf SSI team
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.
The following is a list of sponsors that helped fund the event.