Event Location:
Fabrika
Blagovischenska str. 1
Kharkiv, Kharkiv Oblast, Ukraine
Abstract:
In the world of agile software development, the database development process introduces some challenges to the application development process. The delivery of changes at database level tends to be a different and separated process of the application delivery process or even an entirely manual process. This contributes to the perspective that the database is a bottleneck in the agile process. In this session, I will show how to build a deployment pipeline capable of delivering database and application changes. The pipeline includes the following steps: source control, continuous integration and continuous delivery. I will share methods and strategies that allow bringing together databases and applications in the delivery process reducing the delivery pain. The main goal is to understand that applications and databases can and should share the same deployment pipeline and that this pipeline will allow you not be afraid of making database changes.
Speaker(s): Taras Kloba,
Abstract:
Any SQL programmer with some experience knows that loops are bad and that you should work with all data at once in set-based statements. However, you may have experienced situations where this strategy did not work out well and you ran into problems like out-growing the transaction log or blocking other users. You can solve this by operating on the data in chunks. Implementing chunking is not that difficult, but there are still pitfalls you can run into. In this session, I will discuss in what situations you may want to use chunking. I will give some best practices for how to implement chunking for good performance and I will highlight some things you need keep in mind, for instance, recovering from interruptions. I will also look at how you can use chunking for error handling: You want process many rows and you want the good rows to succeed even if some rows yield errors – something you cannot do in a single set-based statement.
Speaker(s): Erland Sommarskog,
Abstract:
The modern DWH brings together all kinds of data, at any scale, without much effort and time, to get insight through operational reports, analytical dashboards, and advanced analytics for all users. Microsoft Azure provides a set of fully managed services, which allow you to build modern DWH in a few minutes. All Azure services support a fully cloud based solution, or a mix of cloud and on-premise based solutions, to meet the business need. A modern Data Warehouse can be designed to meet business need and accommodate change in data behavior using the latest technology components such as cloud based scalable data storage for big data, real time analytics, predictive analysis and machine learning, global distribution of data, high availability, etc.
Speaker(s): Eugene Polonichko,
Abstract:
You might have heard "don't use cursors, they are slow!". In this presentation, you will learn what it actually means: you should normally write set-based statements instead and I will explain why they generally are faster than writing your own loops. But I will also look at situations where using a loop for one reason or another is preferable, and you will learn that the best way to run a loop in most cases is exactly a cursor, provided that you implement it properly. The presentation also gives some tips how you can troubleshoot performance problems with loops.
Speaker(s): Erland Sommarskog,
Abstract:
The current IoT devices are pretty powerful, so could very well run a version of SQL engine. It would be a good idea? What will be the use of it? How to make it work and make the most of it? How does all fit with the field gateway concept? During the presentation, we will take a real word scenario, real hardware, and together we will try to answer these questions
Speaker(s): Catalin Gheorghiu,
Abstract:
В докладе Я расскажу о преимуществах использования DAX, и том какие сложности могут возникнуть при работе с этим языком.
Speaker(s): Artur Konstantynov,
Abstract:
Давайте поговоримо про теорію та практичну реалізацію багатопоточної обробки даних в сучасних СУБД та розберемо кілька практичних прикладів. Спробуємо розібратися та обійти потенційні проблеми та на прикладі Microsoft SQL Server. Під час доповіді ми торкнемось тем паралелізму, затримок, блокувань та взаємоблокувань, а також різних рівнів ізоляції.
Speaker(s): Yevhen Nedashkivskyi,
Abstract:
PowerQuery is widespread tool with own language in Microsoft BI stack. Namely Power BI reports, Excel, SSAS Tabular, SSIS, Microsoft Flow, Power BI dataflows. ETL of this tool is powerful but you are not limited by it, because you can expand it in different ways. I will show you several examples, which may be unexpected for you, including AI integration.
Speaker(s): Ruslan Zolotukhin,
Abstract:
Columnstore is a special type of index first introduced in SQL Server 2012 and greatly improved in SQL Server 2016/2017. It's a column-based index geared toward increasing query performance for workloads that involve large amounts of data, typically found in data warehouse fact tables. In this session, we will look at several tips how to improve performance of our work scenarios with using columnstore indexes. Also will discover in this session how to make incredible magics with data storage.
Speaker(s): Sergey Syrovatchenko,
Abstract:
There are weird things in life. Even weirder for developers... "It should work!"... What you see is NOT what you get... There's a bug, a feature, a workaround... Disclaimer: No feline was harmed in the making of this session. Please do not report it to the Kyiv Society for the Protection of Animals...
Speaker(s): André Melancia,
Abstract:
Slowly Changing Dimensions types 0 through 7 and their ETL implementation (SSIS exmples) Explanation of every SCD type. Analytical value, pros and cons of each will be investigated, SSIS package examples provided. Power BI will be used as a client application to demonstrate the results.
Speaker(s): Dmytro Polishchuk,
Abstract:
Net Core 3.0 will bring entity framework for CosmosDB. What this will bring us? Let's look the possible architectures of modern cloud applications and the impact of the different database solutions.
Speaker(s): Mihail Mateev,
Abstract:
The Intelligent query processing feature family includes features with broad impact that improve the performance of existing workloads with minimal implementation effort.
Speaker(s): Andrii Zrobok,
Abstract:
SQL Server 2017 is full of new features and improvements. The main "Killer" feature of SQL Server 2017 is SQL Server on Linux, but there are some more big and interesting features: Adaptive Query Processing, Graph Processing, Automatic Tuning and many others which you are aware of. And in this session we will not talk about them. We will not do that just because there are a lot of cool features in SQL Server 2017, which are more hidden from our sight and have not get enough attention. In this session, we will learn a lot about these features and improvements. Which features? This is a secret :) Come to the session and discover them with me!
Speaker(s): Denis Reznik,
Abstract:
You already know how easy it is to hack SQL Server… But how do you protect your local and cloud servers against enemy agent attacks? This is a demo-driven session, suited for DBAs, developers and security consultants. Both exploits and security recommendations to avoid them will be covered. Disclaimer: No actual crimes will be committed. Please do not send agents to my house again.
Speaker(s): André Melancia,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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://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/zoloturu/
Contact: https://www.zoloturu.com
BI Engineer at Jabil Software Services Power BI Consultant MCT, MSCA: BI Reporting Speaker at SQL Saturday, Data Monsters and UNETA, PUG and PASS UG Meetups Advisor at Power BI Community Forum Leader of Kharkiv Power BI User Group Former DAX, Excel VBA trainer Blog: www.zoloturu.com My passion is: * to learn new technologies in data management, analytics and science * to wrangle data and provide meaningful output * to automate routine processes and to build reporting systems * to share my experience and knowledge in all these areas
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.
Contact: http://www.sommarskog.se
Erland Sommarskog is an independent consultant based in Stockholm, working with SQL Server since 1991. He was first awarded SQL Server MVP in 2001, and has been re-awarded every year since. His focus is on systems development with the SQL Server Database Engine and his passion is to help people to write better SQL Server applications.
LinkedIn: http://LinkedIn.COM/in/AndreMelancia
Contact: http://Andy.PT
Owner / Principal Consultant at LunarCat.PT Microsoft Certified Trainer (MCT) focusing on SQL Server, Azure, IoT and Security. 19+ years' fun developing information and multimedia systems, DBA, project and IT management. Data Community Portugal, IT Pro Portugal and PowerShell Portugal communities organiser. IPv6 Portugal, DNSSec Portugal and Windows Development Portugal online communities moderator. Actively volunteering, organising, speaking or just participating at community meetings and events around the world. Proud uncle and food devouring expert, with dangerous рuϧϧy cat as companion. Go to http://Andy.PT and you'll know the same as the NSA...
LinkedIn: ?https://ro.linkedin.com/in/catalingheorghiu?
Contact: http://ronua.ro/author/catalin/
Catalin Gheorghiu is a solution architect from Romania. He has more than 15 years of experience in developing solutions, especially on Microsoft technologies in very demanding environments. Is contributing articles and blogs to several user groups (MrSmersh), lecturing all over Romania and abroad, is also RONUA Timisoara (PASS Chapter) user group leader. Since 2011, every year he was awarded the Microsoft MVP Award.
Contact: http://www.sommarskog.se
Erland Sommarskog is an independent consultant based in Stockholm, working with SQL Server since 1991. He was first awarded SQL Server MVP in 2001, and has been re-awarded every year since. His focus is on systems development with the SQL Server Database Engine and his passion is to help people to write better SQL Server applications.
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.
DBA
LinkedIn: https://www.linkedin.com/in/dmytro-polishchuk-166908b1/
Highly motivated BI Developer
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.
Power BI developer
LinkedIn: http://LinkedIn.COM/in/AndreMelancia
Contact: http://Andy.PT
Owner / Principal Consultant at LunarCat.PT Microsoft Certified Trainer (MCT) focusing on SQL Server, Azure, IoT and Security. 19+ years' fun developing information and multimedia systems, DBA, project and IT management. Data Community Portugal, IT Pro Portugal and PowerShell Portugal communities organiser. IPv6 Portugal, DNSSec Portugal and Windows Development Portugal online communities moderator. Actively volunteering, organising, speaking or just participating at community meetings and events around the world. Proud uncle and food devouring expert, with dangerous рuϧϧy cat as companion. Go to http://Andy.PT and you'll know the same as the NSA...
The following is a list of sponsors that helped fund the event.