Event Location:
Fabrika
Blagovischenska str. 1
Kharkiv, Kharkiv Oblast, Ukraine
Abstract:
CosmosDB service is a NoSQL is a globally distributed, multi-model database database service designed for scalable and high performance modern applications. CosmosDB is delivered as a fully managed service with an enterprise grade SLA. It supports querying of documents using a familiar SQL over hierarchical JSON documents. Azure Cosmos DB is a superset of the DocumentDB service. It allows you to store and query noSQL data, regardless of schema. In this presentation, you will learn: • How to get started with DocumentDB you provision a new database account. • How to index documents • How to create applications using CosmosDb (using REST API or programming libraries for several popular language) • Best practices designing applications with CosmosDB • Best practices creating queries.
Speaker(s): Mihail Mateev,
Abstract:
Часто роль администратора баз данных закрепляется по принципу «может разобраться и имеет на это время», а иногда и просто игнорируется. К сожалению, это приводит к проблемам с производительностью, необоснованным затратам на оборудование, риску потери данных и простою основной деятельности. Докладчик, в сжатой, но доступной форме на примере СУБД Microsoft SQL Server расскажет и покажет, что необходимо делать новоиспечённым администраторам баз данных, даже если эта роль досталась им поневоле. В этой сессии: 1. Планирование 2. Инсталляция и настройка 3. Регулярное обслуживание 4. Проблемы с производительностью и как их решить 5. Масштабирование 6. Построение стратегии восстановления от сбоев 7. Сторонние утилиты и инструменты Доклад предназначен для широкой публики не имеющей опыта в администрировании баз данных, а также тем, кому роль ДБА досталась по совместительству. На русском языке.
Speaker(s): Yevhen Nedashkivskyi,
Abstract:
Autonomous means capable of existing independently. Think maintenance free, self-healing, auto-tuning databases able to detect and automatically mitigate security risks. Sounds like impossible dream, but here is the best part - Azure is gradually making that next level of automation possible. Cloud economy of scale combined with unique features of Azure Sql PaaS resources transform and enhance the way we collect, store and process data. And that also affects our professional lives. Find out where we are on The Road to The Autonomous Databases, what are main building blocks, what kind of obstacles we still have to overcome and how to turn these challenges into opportunities.
Speaker(s): Janusz Rokicki,
Abstract:
Подробно рассмотрим важнейший компонент базы данных - лог транзакций. Для чего он нужен, в каких процессах участвует. Облако затрагиваемых терминов: Backup, Recovery, Shrink, VLF, Replication, AlwaysOn, CDC, Best Practices.
Speaker(s): Andriy Pogorelov,
Abstract:
We will cover the main aspects to migrate to one of the three architectures available in SQL Server in Azure from SQL Server On Premise. This session consists of: -> What is the best platform for my environment? IaaS, PaaS, or SQL Datawarehouse. -> Best Practices and best tools for our migration process depending on the platform chosen. -> After the migration, we have several outstanding questions: Can I keep both environments synchronized? How is the performance of my database?
Speaker(s): Jose Manuel Jurado Diaz,
Abstract:
In this session, you will learn how to detect and avoid common problems related to database corruption. There will be a description of the data structures in SQL Server and how it can affect the availability of SQL Server during corruption. On the session, there will be not only theoretical knowledge but many real life examples with demos.
Speaker(s): Michal Sadowski,
Abstract:
Данный доклад будет посвящен построению стратегии восстановления информации после сбоя любого уровня. В качестве примера будет использован Microsoft SQL Server и сопутсвующие технологии. Обсуждаемые вопросы: 1. SLA, RTO, RPO 2. Модели восстановления в SQL Server 3. Виды резервного копирования 4. Автоматизация 5. Документация 6. Человеческий фактор 7. Сторонние решения Сессия будет интересна всем, кто потенциально может пострадать от потери информации и может повлиять на подготовку к подобным событиям, а также администраторам баз данных, которые хотят больше узнать о резервном копировании. На русском языке.
Speaker(s): Yevhen Nedashkivskyi,
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 a wide range of services, used in the Internet of Things solutions. This presentation provides a deeper architecture implementation overview of the Microsoft Azure services and Microsoft Data Platform components for IoT that you can use for solution development. In this session we will cover architectural considerations, best practices (common concepts and the context of Microsoft Azure) and implementation guidance for your IoT solution.
Speaker(s): Mihail Mateev,
Abstract:
An application that you administer stores sensitive data in the database and you would like to keep them safe in Microsoft SQL Server - how to approach this issue? What type of encryption should you use in your environment? On the session I will walk through available options in Microsoft SQL Server and show when to use encryption, how to identify threats, and countermeasure them by using options like Transparent Data Encryption, SSL certificates, Always Encrypted, etc. After this session, you will know a set of best practices that you can apply in your environment.
Speaker(s): Michal Sadowski,
Abstract:
Azure Data Factory v2 is the new version of ADF. This version has the power of the first version and is more flexibility and new opportunities. First, we can use SSIS packages in our data factory, second, we have more opportunities for security our data and etc. If you want to know more just come to my session and I'll speak you about it
Speaker(s): Eugene Polonichko,
Abstract:
До 2016 версії Microsoft практично не вносив кардинальних змін в оптимізатор запитів. Таким чином движок з 7 версії (1988 рік) використовувавя з косметичними змінами без малого 20 років. В 2016 версії були анансовані певні напрямки змін, котрі повноцінно запрацювали в 2017 версії. Це Batch Mode Adaptive Query Processing, Query Store Automatic Query Tunig. Ці зміни і будуть розглянуті в презентації.
Speaker(s): Andrii Zrobok,
Abstract:
How long do you look for information in your company? Do you have information repository in your company? Do you know what software tools need for that? if I said that tool is free you would believe me? Ok, come to my session and I'll show you this tool and will speak you about it
Speaker(s): Eugene Polonichko,
Abstract:
Долгое время на Microsoft Connect поддержка работы с JSON была одной из самых востребованных фич, которую добавили в SQL Server 2016. Забегая вперед скажу, что вышло очень даже хорошо, но Microsoft не остановилась на этом и в SQL Server 2017 существенно улучшили производительность и без того быстрого JSON парсера. В рамках сессии мы рассмотрим нюансы работы с JSON и сравним по эффективности с олдскульным XML.
Speaker(s): Sergey Syrovatchenko,
Abstract:
При работе с XML существует большое число подводных камней, которые могут приводить к каверзным проблемам с производительностью. В рамках доклада, мы рассмотрим общие рекомендации о том, как можно эффективно хранить, парсить и генерировать XML. Узнаем, когда выгодно использовать XQuery, а в каких случаях лучше проявляет себя OpenXML. Как лучше передавать массивы значений как параметры в хранимки. Научимся парсить огромные XML файлы с помощью XMLBulkLoad. Отдельно рассмотрим баги связанные с парсингом XML, которые Microsoft бережно переносит из версии в версию.
Speaker(s): Sergey Syrovatchenko,
Abstract:
This session is Intro to Google BigQuery. Will give the overview of the architecture and important details Google BigQuery is a very unique analytics data warehousing service. BigQuery is often described as serverless, no-ops, seamlessly scalable, and fully managed. Since BigQuery truly has no equivalent, it bears mentioning some of the less obvious aspects of what makes BigQuery so amazing!
Speaker(s): Taras Kloba,
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://pl.linkedin.com/pub/michal-sadowski/4/b33/717
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.
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://ua.linkedin.com/in/pogorelovandrey
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.
LinkedIn: https://www.linkedin.com/in/jose-manuel-jurado-diaz-5a586014/
José Manuel Jurado currently works as SQL Escalation Engineer and Subject Matter Expert in Azure SQL Database at Microsoft Spain. With over 20+ years of experience in SQL Server environments (administration and database development), he is a speaker for internal events at Microsoft and for public events such as SQLSaturday, SQL Nexus, SQLBits, Pass Summit, SQL Server Konferenze, TechReady, DotNetConference, and Azure BootCamp. In the past, he worked as Project Manager for large global retail company for more than 10 years developing projects using different Microsoft Technologies.
LinkedIn: https://pl.linkedin.com/pub/michal-sadowski/4/b33/717
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.
DBA
DBA
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.
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.
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.
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: 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/in/jrokicki/
Contact: https://www.datasic.com/
Microsoft Data Platform Expert and certified Azure Solutions Architect with over 12 years’ experience working in the City of London in the Financial Services Industry (retail and investment banking, multi-asset class trading systems). He has passion for secure, high-performance, maintainable data-driven applications that can be deployed with confidence on-premises and in-cloud. With educational background in intelligent sensor networks and machine learning he is always in search of automation and optimisation opportunities. Has presented at SqlBits, PASS Summit, SqlDay and multiple Sql Saturday events (Tel-Aviv, Kiev, Paris, Tallinn, Bonn, Bratislava, Goteborg, Kharkiv, Bucharest, Sofia, Ljubljana) and user groups.
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/kloba/
Contact: http://sql.ua
✅ Senior DBA and developer; ✅ Senior database architect; ✅ Business solutions expert; ✅ 9+ years of experience. Senior database administrator and programmer. Consultant and certified database administrator and developer with 9+ years of experience working with SQL Server 2016, 2014, 2012, 2008, 2005, 2000 and SQL Azure. MySQL, PostgreSQL and MS SQL database performance tuning expert. Business solutions consultant and implementer. With many years of extensive experience in the IT and other business industries in a variety of roles. My objective is to use my experience to bring creative and top-level solutions to businesses that require SQL Databases.
The following is a list of sponsors that helped fund the event.