SQLSaturday #406 - Kharkiv 2015
Event Date: 09/19/2015 00:00:00
Event Location:
- Sun City Premium
- Moskovskiy ave, 199-B
- Kharkiv, Kharkivs’ka Oblast’, Ukraine
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: 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: BIPrograming - Room C
Title: Создание аналитических приложений с использованием PowerQuery
Abstract: PowerQuery - это пользовательский инструмент обработки, комбинирования и очистки данных для дальнейшего их анализа прямо из Excel, самого популярно инструмента для анализа данных. Хотя все его возможности и проявляются совместно с подпиской PowerBI, но он вполне применим и для локального использования. Например для создания аналитических приложений в Excel ) Простой, удобный интерфейс и вся мощь встроенного языка M позволяет создавать вполне функциональные и полезные приложения, а главное Вам не понадобится ничего кроме Excel.
В докладе мы рассмотрим как использовать PowerQuery и Excel чтобы:
- Подключиться к источникам данных
- Обработка и очистка данных
- Создания динамических фильтров и таблиц параметров
- Обработка ошибок
- Создание красивых графических отчётов
Speaker(s):
- Sergiy Lunyakin
Track and Room: BIPrograming - Room B
Title: SQL Server Security Best Practices
Abstract: Зачастую даже при жёстких требованиях заказчика многими интеграторами и разработчиками вопрос безопасности баз данных игнорируется в угоду упрощения разработки и развёртывания. Бывают и обратные ситуации, когда в довольно глубоко продуманной и защищённой системе начинают появляться пробелы в безопасности вследствие расширения инфраструктуры и дальнейшей эволюции продукта.
Во время данной сессии мы ознакомимся и обсудим основные практики по обеспечению безопасности SQL Server, попытаемся разобраться, чем действительно можно пожертвовать, а от чего отказываться не стоит ни в коме случае.
Доклад будет интересен разработчикам, администраторам, специалистам по безопасности, а также руководителям, которых волнует вопрос сохранности данных и безопасности доступа к ним.
Speaker(s):
- Yevhen Nedashkivskyi
Track and Room: Database administration - Room C
Title: Unit Testing SQL Server
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
Track and Room: Database development - Room A
Title: SQL Server 2016 and new possibilities to unlock insights of any data
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
Track and Room: BIPrograming - Room D
Title: Case study on real test data generation for web application
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
Track and Room: Database development - Room A
Title: Key-Range Locking — Все тайное становится явным
Abstract: Доклад будет посвящен блокировкам диапазона ключей (Key-Range Locking). Вначале будет рассказано о базовых механизмах, после чего, мы поговорим о некоторых аспектах которые не описаны в MSDN. Дополнительно рассмотрим неявное использование блокировок диапазона ключей в уровне изоляции READ COMMITTED.
Speaker(s):
- Vitaliy Popovych
Track and Room: Database development - Room C
Title: Tabular SSAS - очень быстрая аналитика
Abstract: На докладе посмотрим на Tabular модель. Как строить решение на основе данной модели, зачем она вообще нужна, как настраивать ее, как оптимизировать. Что такое DAX и как на нем писать запросы.
Speaker(s):
- Eugene Polonichko
Track and Room: BIPrograming - Room B
Title: Hidden gems of SQL Server 2014
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
Track and Room: Database development - N/A
Title: Database Normalization - 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: Database development - Room B
Title: Common TSQL Mistakes
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
Track and Room: Database development - Room A
Title: Introduction to columnstore
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
Track and Room: Database development - Room D
Title: “Magic numbers”, local variable and performance
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
Track and Room: Database development - Room B
Title: Использование динамического sql в MS SQL Server
Abstract: В докладе я расскажу что такое динамический sql, какие способы его построения, рассмотрены примеры использования “exec” и “sp_executesql”.
Speaker(s):
- Alesya Zhuk
Track and Room: Database development - Room D
Title: Dive into HDInsight: common Big Data analysis scenarios on Microsoft Azure
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
Track and Room: BIPrograming - Room C
Title: SQL 2014. InMemory OLTP
Abstract: • Implementing InMemory OLTP • In-Memory OLTP Performance • In-Memory OLTP Migration • In-Memory OLTP Interoperability
Speaker(s):
- Oleg Alekseev
Track and Room: Database administration - Room A
Title: SQL vs. NoSQL. It’s always a hard choice.
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
Track and Room: Database development - Room D
Title: Database version control
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
Track and Room: Database development - Room B
Title: Introduction to Datazen: it’s all about Zen
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
Track and Room: BIPrograming - Room A
Title: T-SQL Cookbook: TipsTricks
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
Track and Room: Database development - Room D
Title: HDInsight: Big Data solutions on Microsoft Azure
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
Track and Room: BIPrograming - Room C
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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.
Kevin Boles
Twitter: - @TheSQLGuru
LinkedIn: Kevin Boles
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.
Vitaliy Popovych
Twitter: - https://twitter.com/PopovychVitaliy
LinkedIn: Vitaliy Popovych
Senior Database Developer at TFG an Intapp Company. Опыт работы с MS SQL Server — более 5 лет.
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.
Alesya Zhuk
LinkedIn: Alesya Zhuk
Contact: http://dneprsqlusergroup.blogspot.com
работаю SQL/BI Developer . Опыт работы с MS SQL Server — 6 лет.
Valentyn Yeliseyev
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.
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.
Kevin Boles
Twitter: - @TheSQLGuru
LinkedIn: Kevin Boles
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.
Yevhen Nedashkivskyi
LinkedIn: Yevhen Nedashkivskyi
Yevhen Nedashkivskyi is a professional DBA and a database developer with more than 10 years of experience. MSCP, MSCA, MSCE, MVP.
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.
Mariya Shirokopetleva
Senior Lecturer, Kharkiv National University of Radio Electronics. Inrteresy: databases, artificial intelligence
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.
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.
Konstantin Proskurdin
.NET developer with more than 10 years of experience, experience with MS SQL Server - 8 years.
Yan Roginevich
10 years of expirience in software development
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.
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.
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.
Olena Smoliak
LinkedIn: Olena Smoliak
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)
Taras Bobrovytskyi
LinkedIn: Taras Bobrovytskyi
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
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.
Sponsors
The following is a list of sponsors that helped fund the event: