SQLSaturday #426 - Lviv 2015
Event Date: 12/05/2015 00:00:00
Event Location:
- Hotel Volter
- 60A Lypynskoho str.
- Lviv, L’vivs’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: Complex Event Processing with Azure Stream Analytics
Abstract: Azure Stream Analytics targets complex event streams (CEP’s) to deduce meaningful patterns. Most of the typical use cases for this product is when various devices and sensors are sending data for further processing.
This technology uses a T-SQL like syntax to express its intents. A language that most data-power users will be familiar with.
The biggest advantage of Stream Analytics is when events are being published to the Stream Analytics, the only thing that event publishers needs to know is which Event Bus or Blob storage to place the data. Stream Analytics will then fetch the data.
This talk is about the main concepts and solution architecture when using Azure Stream Analytics, and also how to use this technology together with MS SQL Server, Azure SQL Database and Power BI.
Speaker(s):
- Mihail Mateev
Track and Room: Cloud Application Development Deployment - Room 1
Title: Инструменты резервирования и репликации реляционных баз данных
Abstract: Будут освещены две темы: 1) Способы разгрузки продуктивных серверов баз данных при построении кроссплатформенной репликации. В примере будет затронута связка Oracle gt; SQL Server. Построение репликации с помощью Dell SharePlex. 2) Основные проблемы и нюансы, на которые стоит обратить внимание при построении резервного копирования SQL Server. Например, влияние компрессии на производительность сервера БД и методика оптимизации - построение динамических заданий, которые в зависимости от нагрузки на сервер БД будут определять необходимый уровень компрессии без потери производительности. Автоматизация проверки резервных копий и т.д. Инструментом анализа и оптимизации заданий резервного копирования рассматривается Dell LiteSpeed for SQL Server.
Speaker(s):
- Ivan Rudnytskyi
Track and Room: Enterprise Database Administration Deployment - Room 2
Title: SSAS Multidimensional Databases optimization
Abstract: We will talk about processing optimization (partitioning, parallel processing, attribute keys, indexes etc), work on users queries performance (playing with rigid and flexible attributes relations, aggregations and scopes) and try to figure out how to improve MDX code readability.
Speaker(s):
- Alex Peshekhonov
Track and Room: BI Platform Architecture, Development Administration - Room 3
Title: Metadata-driven Automatic Package Creation with Biml - Notes From The Field
Abstract: We already know what Biml is. But how do we leverage its power to create next generation ETL? In this session we want to show you different approaches to package creation with Biml, based on user-specified metadata. We’d like to show you advanced scenarios, some lightweight metadata storages, and MDS. We’ll also cover live database discovery, automatic database object creation, automatic data type normalization, flexible incremental stage loading, and more.
Speaker(s):
- Marcin Szeliga
Track and Room: BI Platform Architecture, Development Administration - Room 1
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: Application Database Development - Room 1
Title: Practical X: ML, Path, Query
Abstract: Small session about your friend XML - why, when and how to use it without being hurt.
Speaker(s):
- Oleksii Kovalov
Track and Room: Application Database Development - Room 1
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: Cloud Application Development Deployment - Room 3
Title: Failover Clustering та High Availability
Abstract: Під час даної доповіді ми поговоримо про Windows Failover Clustering у взаємодії з СУБД Microsoft SQL Server. Також буде розкрито тему масштабування та забезпечення доступності баз даних за допомогою механізму AlwaysOn High Availability. Розуміння матеріалу потребує володіння базовими знаннями з побудови компютерних мереж, механізму роботи SQL-транзакцій та реплікації. Доповідь буде в першу чергу цікава адміністраторам та архітекторам баз даних, та ІТ-керівникам. Також вона буде корисною проектувальникам сховищ даних, BI-аналітикам та розробникам високонавантажених систем. Мова: українська
Speaker(s):
- Yevhen Nedashkivskyi
Track and Room: Enterprise Database Administration Deployment - Room 3
Title: @Table vs #Table: шаблони використання, спільні характеристики, міфи
Abstract: MS SQL Server надає дві можливості для зберігання тимчасових наборів даних: тимчасові табиці та табличні змінні. Вважається, що табличні треба використовувати для маленьких об’ємів даних (бо вони живуть в оперативній пам’яті), а тимчасові таблиці - для великих. Подивимося, чи дійсно це так; чи можна за такими характеристиками порівнювати ці об’єкти.
Speaker(s):
- Andrii Zrobok
Track and Room: Application Database Development - Room 2
Title: SQL Server 2016 CTP 3 review
Abstract: SQL Server 2016 is coming bringing a lot of new innovations. During this session we will have a look at some of them, including: always encrypted (great think if you want to keep sensitive data encrypted at all times with ability to query), row-level security (finally, DBAs can apply fine-grained access control to table rows), temporal database support (yes, you can query data as points in time), and operational analytics (architecture to run analytics queries concurrently with operational workloads using the same schema). Stay ahead of the game!
Speaker(s):
- Marcin Szeliga
Track and Room: Enterprise Database Administration Deployment - Room 1
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 valid changes and 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 - Room 3
Title: MDX: а давайте взорвем мозг?
Abstract: Что это за зверь MDX? Как с ним работать? Как писать запросы? Вы думаете он похож на Transact Sql, ошибаетесь. Он сам по себе - язык многомерных данных. Некоторые запросы на нем пишутся в течении минуты, некоторые пишутся в течении месяцев. В общем, хотите взорвать мозг - приходите будем взрывать вместе. Доклад начнется с level 100, а закончится level 300
Speaker(s):
- Eugene Polonichko
Track and Room: BI Platform Architecture, Development Administration - Room 3
Title: Database monitoring, tuning and optimization using Dell Software tools
Abstract: Ensure optimal database performance with non-stop data collection and instant metric-sensitive alerts. Speed through your work with intuitive interfaces, built-in expert guidance and easy-to-follow workflows. Get an enterprise-level view of database health and automated performance analysis to quickly identify and fix problem servers and resource areas. Maximize database performance and availability with these robust SQL Server monitoring and optimization tools.
Speaker(s):
- Vladislav Samoylenko
Track and Room: Enterprise Database Administration Deployment - Room 2
Title: SQL Server Query Store
Abstract: В докладе мы поговорим о SQL Server Query Store
Speaker(s):
- Vitaliy Popovych
Track and Room: Enterprise Database Administration Deployment - Room 2
Title: Database corruption
Abstract: In this sessions you will learn how to detect and avoid common problems related to database corruption. There will be description of the data structures in SQL Server and how it can affect avaialbility of SQL Server during curruption. On the session there will be not only theoretical knowledge but many real life examples with demos.
Speaker(s):
- Michal Sadowski
Track and Room: Enterprise Database Administration Deployment - Room 2
Title: Inside Transaction Logging
Abstract: This session covers the main principles and internals of transaction logging mechanism and focuses on different factors, which influence the process of transaction logging. It also contains several general recommendations for Developers, Application Support engineers and DBA’s on dealing with different transaction log issues and, possibly, avoiding them.
Speaker(s):
- Taras Bobrovytskyi
Track and Room: Application Database Development - Room 1
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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.
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.
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
Vitaliy Popovych
Twitter: - https://twitter.com/PopovychVitaliy
LinkedIn: Vitaliy Popovych
Senior Database Developer at TFG an Intapp Company. Опыт работы с MS SQL Server — более 5 лет.
Ivan Rudnytskyi
Ivan Rudnytskyi has more than 8 years of experience in IT. He has been working as the Sales Engineer at BAKOTECH Group since 2012. Ivan is the expert in Dell Software database solutions. Prior to joining BAKOTECH team, Ivan worked as the Lead Engineer of the Development and Implementation Department at one of the largest system integrators in Ukraine, and was responsible for infrastructure systems architecture.
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.
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.
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.
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.
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.
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.
Alex Peshekhonov
LinkedIn: Alex Peshekhonov
Programmer, guitar player
Vladislav Samoylenko
More than 10 years in IT working with Microsoft products, all around data migration and Application Performance Management (APM)
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.
Oleksii Kovalov
DBA and DB developer with more than 10 year expirience. SQLSat/SSUG speaker. MCTS, MCITP. Author of pet-projects ExpressProfiler and SQL Code Guard
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.
Sponsors
The following is a list of sponsors that helped fund the event: