SQLSaturday #860 - Lviv 2019
Event Date: 09/21/2019 00:00:00
Event Location:
- Hotel Taurus
- 5, Kn. Sviatoslava Sq., Lviv, Ukraine
- 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: The Haberdashery of Machine Learning
Abstract: Haberdasheries are various small goods such as buttons, thread and similar sewing goods. When used together correctly, they provide the basis for making good clothes. Building good Machine Learning solutions is similar, you’ll need various small things in your toolkit that you will then leverage build production ready predictive solutions.
In our little Machine Learning shop, you’ll receive tips on collaborative data science, automating data pipelines, automated machine learning and will learn how to apply agile methodologies operationalize your experiments in a fast way. We’ll even consider the maintenance of your machine learning models afterwards as that often gets overlooked. Using Azure and SQL Server Machine Learning Services during our examples, you’ll be able to take these tips home and apply them yourself.
Speaker(s):
- Jan Mulkens
Track and Room: Advanced Analysis Techniques - RoomC
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 - RoomC
Title: A Game of Hierarchies: Graph Processing with SQL Server 2019
Abstract: Hierarchies and graphs are the bread and butter of most business applications and you find them almost everywhere:
- Product Categories
- Sales Territories
- Bill of Material
- Networks Even when there is a big need from a business perspective, the solutions in relational databases are mostly sort of awkward. The most flexible hierarchies are usually modeled as self-referenced tables. If you want to successfully query such self-referenced hierarchies, you will need either loops or recursive Common Table Expressions. SQL Server 2017 came with a different approach: Graph Database, which are further improved in SQL 2019. Join this session for a journey through best practices to transform your hierarchies and graphs into useful information. We will have fun playing around with a sample database based on G. R. R. Martin’s famous “Game of Thrones”.
Speaker(s):
- Markus Ehrenmueller-Jensen
Track and Room: Application Database Development - RoomB
Title: The future of serverless computing
Abstract: Are you still planning your servers capacity in CPU and RAM? Do you enjoy answering questions like “what amount of servers we need to buy to serve 10K and 10M users”? Do you enjoy paying for those servers while they are sitting idle?
In my session I will talk about the current state and the future of serverless computing. I will show several demos that show how to start using serverless computing, what are the application scenarios for it, how it can scale, what it will cost, etc.
This session will be useful for developers and architects who are seeking a way to create an app utilizing all your previous skills, but make it scalable, reliable, fast and cost efficient.
Speaker(s):
- Illia Lubenets
Track and Room: Cloud Application Development Deployment - RoomA
Title: SQL Server: Поради для непрофільних розробників
Abstract: Ви не є розробником баз даних і знаєте тільки основи SQL, проте постійно змушені виконувати все більше пов’язаних задач? Дозвольте поділитися з вами низкою порад, що значно полегшать вашу роботу та дозволять прискорити ваші запити. Оптимізація швидкодії, корисні функції про які мало хто знає, спрощення та автоматизація задач адміністрування та багато іншого.
Speaker(s):
- Yevhen Nedashkivskyi
Track and Room: Application Database Development - RoomB
Title: The future of serverless computing
Abstract: Are you still planning your servers capacity in CPU and RAM? Do you enjoy answering questions like “what amount of servers we need to buy to serve 10K and 10M users”? Do you enjoy paying for those servers while they are sitting idle?
In my session I will talk about the current state and the future of serverless computing. I will show several demos that show how to start using serverless computing, what are the application scenarios for it, how it can scale, what it will cost, etc.
This session will be useful for developers and architects who are seeking a way to create an app utilizing all your previous skills, but make it scalable, reliable, fast and cost efficient.
Speaker(s):
- Anton Boyko
Track and Room: Cloud Application Development Deployment - RoomA
Title: If a machine can learn, why can’t YOU learn Azure Machine Learning?
Abstract: Are you a DBA or Developer and would like to get started with AzureML the EASY WAY? AzureML isn’t just for “data scientists”… Anyone can use it! And after this session you’ll be using it too… Disclaimer: Sadly, AzureML still can’t predict what’s on your girlfriend’s mind. Nothing ever will.
Speaker(s):
- André Melancia
Track and Room: Advanced Analysis Techniques - RoomB
Title: Docker for data amateur
Abstract: Even tough it’s nothing new, Docker is a thing nowadays. I’ve decided to check containers out as well and learn how they can help me. Although I’m a BI consultant and not really using Docker and containers in the current projects, I’ve already found them to be very helpful on my daily basis learning and other activities. If you are also passionate about data and still experimenting with SQL Server and/or Python and/or any other technology, please join the session and see how Docker can change your life. I will show you my journey, my thoughts and my findings regarding the usage of SQL Server and Python together with Docker. And there will be a lot, a lot of demos.
Speaker(s):
- Sławomir Drzymała
Track and Room: BI Platform Architecture, Development Administration - RoomB
Title: Report optimization techniques in both Desktop and Service. Vertipaq Engine in Power BI
Abstract: Power BI is using In-memory technology, which allows reports to be loaded and presented fast. But here you are limited by CPU and RAM characteristics. Similar behaviour will be when your report is placed at Power BI Service.
At current session I will describe possible performance issues and how to handle them. We will talk about columnar storage and Vertipaq engine as well. During the session different practice advices will be presented.
Speaker(s):
- Ruslan Zolotukhin
Track and Room: BI Platform Architecture, Development Administration - RoomC
Title: Tuning SQL Server for mere mortals (українською)
Abstract: Are you new begining database developer ? Are you .Net developer and often work with database? I think this session special for you! In this session I would like to show common mistakes, connected with DB development which I saw in my projects and tell audience how we could avoid it . How we can improve performance of SQL Server.
Speaker(s):
- Mykola Pobyivovk
Track and Room: Application Database Development - RoomC
Title: Polybase in MS SQL Server 2019
Abstract: Microsoft is enhancing Polybase in 2019 with the ability to connect to more data sources. You can now use PolyBase to connect to other SQL Server instances, Oracle and it’s easy to set up with a wizard. I explains what’s new in PolyBase and walk you through setting it up and connecting to an external table. Will explain difference between PolyBase and SQL Server Linked Server.
Speaker(s):
- Andrii Zrobok
Track and Room: Application Database Development - RoomA
Title: SQL Server PowerShell. How to become a true senior DBA (на русском)
Abstract: В этом докладе я расскажу об автоматизации административных задач с помощью PowerShell. Затрону некоторые community решения и их имплементацию.
Speaker(s):
- Andriy Pogorelov
Track and Room: Enterprise Database Administration Deployment - RoomB
Title: Узгодженість, паралелізм та блокування в сучасних базах даних
Abstract: Давайте поговоримо про теорію та практичну реалізацію багатопоточної обробки даних в сучасних СУБД та розберемо кілька практичних прикладів. Спробуємо розібратися та обійти потенційні проблеми та на прикладі Microsoft SQL Server. Під час доповіді ми торкнемось тем паралелізму, затримок, блокувань та взаємоблокувань, а також різних рівнів ізоляції.
Speaker(s):
- Yevhen Nedashkivskyi
Track and Room: Application Database Development - RoomA
Title: Attention Contention!!!
Abstract: In this session we will discuss about tempdb contention in SQL Server on-premises, Azure SQL Managed Instance and Azure SQL Database. We will analyze both, Allocation Contention and Metadata contention, describing in detail WHEN and HOW it occurs, How to diagnose it, Best Practices and how to prevent it. The session will have both approaches in on-premisses and in Azure Managed Instance: - Theoretical, to understand what and why it occurs. - Practical, with examples causing it, offering alternatives to solve it and to prevent it.
Speaker(s):
- Jose Manuel Jurado Diaz
Track and Room: Enterprise Database Administration Deployment - RoomB
Title: AI Capabilities for Power BI
Abstract: Power BI makes it possible for every employee in an organization to make better decisions based on data with beautiful reports and dashboards. But data scientists, who are crucial to deploying AI solutions, don’t have the bandwidth to provide custom solutions to all users at an organization. Businesses need ways to surface the valuable work of data scientists and empower more users to leverage AI in easy and intuitive ways. Power BI can easily help with this problem.
Speaker(s):
- Eugene Polonichko
Track and Room: Analytics and Visualization - RoomC
Title: Data Insight Ecosystem Today
Abstract: I am going to cover different aspects: implementation stages, system components, technologies, required skill set, roles, etc. Everything needed to build such ecosystem.
Speaker(s):
- Taras Bachynskyy
Track and Room: Strategy and Architecture - RoomA
Title: ML on the Edge
Abstract: Or options in running TensorFlow on Pi or similar class devices. My idea was (a bit born from need), to run TensorFlow on Pi class device. And this presentation is born from my adventures, showing pro and cons of each approach. From running directly on Pi to Azure IoT Edge on to Intel Neural Stick, and the list most probably is in “works” you will see the challenges and results of implementing TensorFlow using these technologies. Remark: Kinder chocolates have nothing to do with ML but will be present.
Speaker(s):
- Catalin Gheorghiu
Track and Room: BI Platform Architecture, Development Administration - RoomA
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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…
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.
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 Bachynskyy
Taras has more than 15 years of experience in consulting, RD, design and implementation of enterprise-scale solutions for a different range of companies from startups to enterprises, including Fortune 100 companies. Together with his team of Senior Architects and top-notch Experts in Big Data, BI, Analytics, IoT and other technology areas, he drives innovations, architecture design and adoption of cutting-edge technologies and approaches for organizations from different business domains.
Sławomir Drzymała
Twitter: - https://twitter.com/SDrzymala
LinkedIn: Sławomir Drzymała
Contact: http://seequality.net/
Slawomir Drzymala is a Data Warehouse Developer and a big enthusiast of the Microsoft technologies, which is still playing with data, the .NET technologies and Microsoft’s data products. Big fan of the data mining/data science, but also of the self-service BI. Speaker at many different events including the biggest Microsoft SQL Server conference in Poland. Organizer of the meetings, conferences and hackathon dedicated to the Microsoft Data Platform. President of Malta Microsoft Data Platform User Group.
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.
Mykola Pobyivovk
Contact: https://www.facebook.com/nick.pobiyvovk
Mykola Pobyivovk is a senior Database developer, Tech Lead at Ciklum. He has about 10 years experience in IT industry. He has been working with SQL Server since 2010. He is co-orginizer of events SQLSaturday Kyiv 2016, 2017, 2018 and Ukraine Data Community Kyiv. In his talk he would like to share his experience connected with develpment of DataBase.
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.
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.
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
Anton Boyko
Twitter: - https://twitter.com/BoykoAnt
LinkedIn: Anton Boyko
Founder and main speaker at Ukrainian Microsoft Azure Community. 15+ years in application development. Builds apps based on Microsoft Azure platform since 2011. Microsoft Azure technical expert. Microsoft Azure MVP since 2014. Owner and one of the organizers of the most popular Microsoft Azure conferences in Ukraine: Azure Day and Global Azure Bootcamp.
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.
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.
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.
Illia Lubenets
Twitter: - L0ndra_
LinkedIn: Illia Lubenets
Lead Software Engineer in EPAM. Microsoft Azure MVP. Co-founder of .NET Core Ukrainian User Group. He is interested in distributed systems development mainly based on Microsoft Azure. Active meetup and conferences organizer and speaker.
Markus Ehrenmueller-Jensen
Twitter: - MEhrenmueller
LinkedIn: Markus Ehrenmueller-Jensen
Contact: http://www.savorydata.com
Markus Ehrenmueller-Jensen, as the founder of Savory Data, has a long history of providing customer solutions in the areas of data engineering, data science, and Business Intelligence. He is a certified software engineer, a graduated business educator, and professor of Databases Project Management at HTL Leonding, and is certified as an MCSE MCT. He is a published author and writes articles for well-known journals. He co-founded PASS Austria and organizes SQLSaturdays in Austria. Markus is a founding member of Power BI Usergroup Austria. Since 2017 Markus was awarded as an Microsoft Data Platform MVP.
Jan Mulkens
Twitter: - https://twitter.com/JanMulkens
LinkedIn: Jan Mulkens
Contact: http://www.janmulkens.be
Jan Mulkens is a Microsoft MVP in AI, a Solution Expert at Ordina Belgium, and a Microsoft Data Platform BI Consultant. In his spare time, he is a speaker at conferences and user groups in Europe and he organizes two user groups and a conference in Belgium. Power BI Days conference (www.powerbidays.com), Belgium Microsoft Advanced Analytics User Group (bit.ly/msaaug), and Flemish Power BI User Group (meetup.powerbibelgium.com).
Sponsors
The following is a list of sponsors that helped fund the event: