SQLSaturday #780 - Kharkiv 2018
Event Date: 09/22/2018 00:00:00
Event Location:
- Fabrika
- Blagovischenska str. 1
- Kharkiv, Kharkiv 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: Dealing with CosmosDB
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
Track and Room: Cloud Application Development Deployment - Blue room
Title: ДБА поневоле – что делать? (ru)
Abstract: Часто роль администратора баз данных закрепляется по принципу «может разобраться и имеет на это время», а иногда и просто игнорируется. К сожалению, это приводит к проблемам с производительностью, необоснованным затратам на оборудование, риску потери данных и простою основной деятельности.
Докладчик, в сжатой, но доступной форме на примере СУБД Microsoft SQL Server расскажет и покажет, что необходимо делать новоиспечённым администраторам баз данных, даже если эта роль досталась им поневоле.
В этой сессии:
- Планирование
- Инсталляция и настройка
- Регулярное обслуживание
- Проблемы с производительностью и как их решить
- Масштабирование
- Построение стратегии восстановления от сбоев
- Сторонние утилиты и инструменты
Доклад предназначен для широкой публики не имеющей опыта в администрировании баз данных, а также тем, кому роль ДБА досталась по совместительству.
На русском языке.
Speaker(s):
- Yevhen Nedashkivskyi
Track and Room: Enterprise Database Administration Deployment - Green room
Title: The Road to The Autonomous Databases
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
Track and Room: Strategy and Architecture - Red room
Title: SQL Server Transaction Log: internals
Abstract: Подробно рассмотрим важнейший компонент базы данных - лог транзакций. Для чего он нужен, в каких процессах участвует. Облако затрагиваемых терминов: Backup, Recovery, Shrink, VLF, Replication, AlwaysOn, CDC, Best Practices.
Speaker(s):
- Andriy Pogorelov
Track and Room: Enterprise Database Administration Deployment - Blue room
Title: Back to the future - Migrating our SQL Server OnPremise Database to Azure
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
Track and Room: Cloud Application Development Deployment - Red room
Title: Database corruption
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
Track and Room: Enterprise Database Administration Deployment - Blue room
Title: Сбой? Не страшен! (ru)
Abstract: Данный доклад будет посвящен построению стратегии восстановления информации после сбоя любого уровня. В качестве примера будет использован Microsoft SQL Server и сопутсвующие технологии.
Обсуждаемые вопросы:
- SLA, RTO, RPO
- Модели восстановления в SQL Server
- Виды резервного копирования
- Автоматизация
- Документация
- Человеческий фактор
- Сторонние решения
Сессия будет интересна всем, кто потенциально может пострадать от потери информации и может повлиять на подготовку к подобным событиям, а также администраторам баз данных, которые хотят больше узнать о резервном копировании.
На русском языке.
Speaker(s):
- Yevhen Nedashkivskyi
Track and Room: Enterprise Database Administration Deployment - Red room
Title: Azure IoT Solution Architecture Best Practices
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
Track and Room: Strategy and Architecture - Green room
Title: Encryption in SQL Server
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
Track and Room: Enterprise Database Administration Deployment - Green room
Title: Azure Data Factory v2: What’s new?
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
Track and Room: BI Platform Architecture, Development Administration - Blue room
Title: MS SQL 2016/2017 – New in query processing
Abstract: До 2016 версії Microsoft практично не вносив кардинальних змін в оптимізатор запитів. Таким чином движок з 7 версії (1988 рік) використовувавя з косметичними змінами без малого 20 років. В 2016 версії були анансовані певні напрямки змін, котрі повноцінно запрацювали в 2017 версії. Це Batch Mode Adaptive Query Processing, Query Store Automatic Query Tunig. Ці зміни і будуть розглянуті в презентації.
Speaker(s):
- Andrii Zrobok
Track and Room: Application Database Development - Blue room
Title: Azure Data Catalog: Your enterprise information repository
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
Track and Room: Cloud Application Development Deployment - Green room
Title: MS SQL Server: JSON
Abstract: Долгое время на Microsoft Connect поддержка работы с JSON была одной из самых востребованных фич, которую добавили в SQL Server 2016. Забегая вперед скажу, что вышло очень даже хорошо, но Microsoft не остановилась на этом и в SQL Server 2017 существенно улучшили производительность и без того быстрого JSON парсера. В рамках сессии мы рассмотрим нюансы работы с JSON и сравним по эффективности с олдскульным XML.
Speaker(s):
- Sergey Syrovatchenko
Track and Room: Application Database Development - Red room
Title: MS SQL Server: XML, XQuery and Performance Issues
Abstract: При работе с XML существует большое число подводных камней, которые могут приводить к каверзным проблемам с производительностью. В рамках доклада, мы рассмотрим общие рекомендации о том, как можно эффективно хранить, парсить и генерировать XML. Узнаем, когда выгодно использовать XQuery, а в каких случаях лучше проявляет себя OpenXML. Как лучше передавать массивы значений как параметры в хранимки. Научимся парсить огромные XML файлы с помощью XMLBulkLoad. Отдельно рассмотрим баги связанные с парсингом XML, которые Microsoft бережно переносит из версии в версию.
Speaker(s):
- Sergey Syrovatchenko
Track and Room: Application Database Development - Red room
Title: Analyzing 100 billion rows in 30 seconds with Google BigQuery
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
Track and Room: BI Platform Architecture, Development Administration - Green room
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.
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.
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.
Jose Manuel Jurado Diaz
Twitter: - jmjuradodiaz
LinkedIn: Jose Manuel Jurado Diaz
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.
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.
Sergey Syrovatchenko
DBA
Sergey Syrovatchenko
DBA
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.
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.
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.
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.
Janusz Rokicki
Twitter: - DataSic
LinkedIn: Janusz Rokicki
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 SQLSaturday events (Tel-Aviv, Kiev, Paris, Tallinn, Bonn, Bratislava, Goteborg, Kharkiv, Bucharest, Sofia, Ljubljana) and user groups.
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.
Taras Kloba
Twitter: - klioba
LinkedIn: Taras 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.
Sponsors
The following is a list of sponsors that helped fund the event: