SQLSaturday #868 - Kharkiv 2019
Event Date: 09/28/2019 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: What is CI/CD for databases or how to automate DB changes
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
Track and Room: Enterprise Database Administration Deployment - Green room
Title: Don’t Bite Off More Than You Can Chew - Take It in Chunks
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
Track and Room: Application Database Development - Blue room
Title: Architecture of modern data warehouse
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
Track and Room: BI Platform Architecture, Development Administration - Red room
Title: Don’t Use Cursors or Why You Maybe Should Use a Cursor After All
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
Track and Room: Application Database Development - Blue room
Title: SQL database on IoT devices, could you? should you? would you?
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
Track and Room: Application Database Development - Green room
Title: Power BI. Benefits and Pitfalls of DAX.
Abstract: В докладе Я расскажу о преимуществах использования DAX, и том какие сложности могут возникнуть при работе с этим языком.
Speaker(s):
- Artur Konstantynov
Track and Room: Analytics and Visualization - Green room
Title: Узгодженість, паралелізм та блокування в сучасних базах даних
Abstract: Давайте поговоримо про теорію та практичну реалізацію багатопоточної обробки даних в сучасних СУБД та розберемо кілька практичних прикладів. Спробуємо розібратися та обійти потенційні проблеми та на прикладі Microsoft SQL Server. Під час доповіді ми торкнемось тем паралелізму, затримок, блокувань та взаємоблокувань, а також різних рівнів ізоляції.
Speaker(s):
- Yevhen Nedashkivskyi
Track and Room: Application Database Development - Red room
Title: Hidden force of the PowerQuery. Powerful ETL AI integration
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
Track and Room: Advanced Analysis Techniques - Red room
Title: SQL Server Columnstore Indexes: Practical recipes
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
Track and Room: Professional Development - Blue room
Title: SQL Curiosities: Цікавість згубила кішку
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
Track and Room: Enterprise Database Administration Deployment - Red room
Title: Slowly Changing Dimensions types 0 through 7 and their ETL implementation (SSIS exmples)
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
Track and Room: BI Platform Architecture, Development Administration - Green room
Title: Build Modern Cloud Applications with Net Core 3.0, entity framework and CosmosDB.
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
Track and Room: Application Database Development - Green room
Title: MS SQLServer 2019 Intelligent Query Processing
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
Track and Room: Application Database Development - Blue room
Title: Hidden gems of SQL Server 2017
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
Track and Room: Application Database Development - Blue room
Title: Hacking SQL Server Is Not Enough
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
Track and Room: Enterprise Database Administration Deployment - Red 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.
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.
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.
Ruslan Zolotukhin
Twitter: - zoloturu
LinkedIn: Ruslan Zolotukhin
Contact: https://www.zoloturu.com
BI Engineer at Jabil Software Services Power BI Consultant MCT, MSCA: BI Reporting Speaker at SQLSaturday, 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
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.
Erland Sommarskog
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.
André Melancia
Twitter: - AndyPT
LinkedIn: André Melancia
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…
Catalin Gheorghiu
Twitter: - MrSmersh
LinkedIn: Catalin Gheorghiu
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.
Erland Sommarskog
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.
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.
Sergey Syrovatchenko
DBA
Dmytro Polishchuk
LinkedIn: Dmytro Polishchuk
Highly motivated BI Developer
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.
Artur Konstantynov
Power BI developer
André Melancia
Twitter: - AndyPT
LinkedIn: André Melancia
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…
Sponsors
The following is a list of sponsors that helped fund the event: