SQLSaturday #753 - Lviv 2018
Event Date: 09/29/2018 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: Predictive Reporting Services Performance Monitoring
Abstract: Every user wants to have his/hers reports generated quickly. But reality isn’t so cute. Sometimes you have to wait and wait, and wait again while looking at the rotating green circle. During my session you will learn how to monitor Reporting Services with the Execution Log. I will show the structure of the log and some useful queries to get precise insights into report generating process. Analysing the log gives you a quick way to find bottlenecks and sources of your problems. Especially when you use a tool like Power BI or Excel to create a functional dashboard. You also will learn how to use R powered models in Power BI to predict problems with your reports execution.
Speaker(s):
- Grzegorz Stolecki
Track and Room: BI Platform Architecture, Development Administration - Room C
Title: SQL Server Performance Tuning Nowadays
Abstract: Nothing is perfect, which means that your database may be not perfect as well. And one day you may decide that your database is slow and it’s time to optimize it. But.. Where to start? When to end? What to look at? Which queries are slow? How to identify the real bottleneck? And so on, and so on. There are a lot of questions that should be answered in a process of performance tuning.
In this session, we will find answers to all these questions going from collecting data for analysis, through identifying bottlenecks to optimization of the particular queries. On this way, we will learn performance tuning practical techniques and solve a bunch of issues in real-time. And despite I’m a big fan of Profiler and old-fashioned tools and technics, new, more interesting and useful instruments are available nowadays, so will use them to find the bottleneck and tune performance. Minimum of theory and a lot of practice.
Speaker(s):
- Denis Reznik
Track and Room: Application Database Development - Room A
Title: Data Migration Project for over 200 TB: Pre-sale, Architecture, PoC and Delivery
Abstract: We would like to describe a data migration project for Law Company from UK. 500M documents in more than 20 offices around the world were migrated from a legacy Document Management System to a new one. As the result, in total, over 200 TB of data were extracted, transferred, reshaped and loaded. The session will start from specifics of a pre-sale process, than cover in details “As Is” and “To Be” architecture, show the results of a PoC, which was done in Azure Cloud and finally describe delivery and results. During the presentation we will focus on specific aspects of Data Migration projects, scalability, security, etc. Also will discus several difficulties we dialed with. The session contains lots of architectural diagrams and examples of code.
Speaker(s):
- Vitalii Bondarenko
Track and Room: Strategy and Architecture - Room A
Title: ДБА мимоволі – що робити? (українською)
Abstract: Часто роль адміністратора баз даних закріплюється за принципом «може розібратися і має на це час», а іноді і просто ігнорується. На жаль, це призводить до проблем з продуктивністю, необгрунтованих витрат на обладнання, ризику втрати даних і простою основної діяльності.
Доповідач, в стислій, але доступній формі на прикладі СУБД Microsoft SQL Server розповість і покаже, що необхідно робити новоспеченим адміністраторам баз даних, навіть якщо ця роль дісталася їм мимоволі.
У цій сесії:
- Планування
- Інсталяція і налаштування
- Регулярне обслуговування
- Проблеми з продуктивністю і як їх вирішити
- Масштабування
- Побудова стратегії відновлення від збоїв
- Сторонні утиліти і інструменти
Доповідь призначений для широкої кола в тому числі і для тих, хто не має досвіду в адмініструванні баз даних, а також тим, кому роль ДБА дісталася за сумісництвом.
Українською мовою.
Speaker(s):
- Yevhen Nedashkivskyi
Track and Room: Enterprise Database Administration Deployment - Room B
Title: Create Stunning Visualizations with The Help of R
Abstract: R is the first choice for data scientists for a good reason: besides accessing and transforming data and applying statistical methods and models to it, it has a wide variety of possibilities to visualize data. As visual perception of data is the key to understanding data, this capability is crucial. This session will give you a broad overview over available packages and diagram types you can build with them on the one hand, and a deep dive into common visualizations and their possibilities on the other hand. Impress yourself and your peers with stunning visualizations which will give you insights into data you could not achieve with other tools of Microsoft’s BI stack.
Speaker(s):
- Markus Ehrenmueller-Jensen
Track and Room: Analytics and Visualization - Room C
Title: MS SQL: Worst Practices
Abstract: Real project experience: Causes and how to avoid Sunstroke. Butterfly effect (How optimizer allocates memory for different operations? Is it possible to change allocated memory in-fly (without query recompilation)? Some data types save disk space and what about memory?) Sequence (is it good or bad), Silver bullet (not only SQ-92)
Speaker(s):
- Andrii Zrobok
Track and Room: Application Database Development - Room A
Title: Hacking? Mission Possible!
Abstract: Everthing is connected. Everything is accessible. Everything is hackable. This is a security “worst” practices session for developers (yes, yes, the boring “best” practices are also included). As always, should you or any of your colleagues be hacked or exploited, the Demo Gods will disavow any knowledge of the speakers’ actions. This session will self-destruct in 60 minutes. Luck has nothing to do with it, Jim…
Speaker(s):
- André Melancia
Track and Room: Application Database Development - Room A
Title: Azure Cosmos DB - What you need to know to build globally distributed apps?
Abstract: In this session let us find about (technical overview)what are the foundations and design goals of Azure CosmosDB. There are many benefits which will fit for web, mobile and globally distributed applications that need elastic scaling, high availability with a predictable performance which can elevate ease of development with NoSQL capabilities that every developer/architect/DBA should know about.
Speaker(s):
- Satya Jayanty
Track and Room: Cloud Application Development Deployment - Room B
Title: Practical SQL Server Machine Learning Services
Abstract: Admit to yourself that you’ve seen enough basic “R is coming to SQL Server” sessions with the same old examples! Enough of that, in this session we’ll walk through a real SQL Server Machine Learning Services scenario from idea to code and from deployment to monitoring maintenance. Learn how you can easily roll out your own Data Science projects or support the data scientists and analysts at your company.
Speaker(s):
- Jan Mulkens
Track and Room: Advanced Analysis Techniques - Room C
Title: Azure Databricks for Data Engineering
Abstract: How you know companies set their sights on making data-driven decisions. Mastering data engineering is a business necessity. So they need tool which can be simply and powerfull at the same times. Now it’s Azure Databricks. Built on Apache Spark™, Azure Databricks provides the scale, compatibility and reliability to expand your data engineering capabilities. Come to my session and I show you how you can scale mission-critical data cleansing, transformations, and manipulations to make business use cases such as real-time dashboards or fraud detection possible with Azure Databricks.
Speaker(s):
- Eugene Polonichko
Track and Room: Cloud Application Development Deployment - Room B
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 - Room C
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 - Room B
Title: AWS Redshift Introduction
Abstract: This session is Intro to AWS Redshift. Will give the overview of the architecture and important details
Speaker(s):
- Maryna Popova
Track and Room: BI Platform Architecture, Development Administration - Room C
Title: A Masters view on Query plans and indexing
Abstract: Do you find query optimization a mystery? This session will straighten out your question marks. You will se how queries are run, how indexes are used and get an insight into what query plans tell you. Further on you’ll be introduced to In-Memory and Column Store indexing to get a fair chance of selecting appropriate indexing for your query load.
Speaker(s):
- Mikael Wedham
Track and Room: Application Database Development - Room A
Title: Dynamic Search Conditions
Abstract: A common requirement in database applications is that users want a function to search a set of data from a large set of possible search conditions. The challenge is to implement such searches in a way that is both maintenanble and efficient in terms of performance. This session looks at the two main techniques to implement such searches and highlights their strengths and limitaitons.
Speaker(s):
- Erland Sommarskog
Track and Room: Application Database Development - Room B
Title: 10 Alerts that you should have it running in your SQL Server!
Abstract: Did you not get budget for that cool monitoring tool, but you still want to monitor your SQL Server? In this session I am going to show you 10 alerts that you should setup in your SQL Server instance. Going from CPU, IO, Corruption and Backups.
By the end of this session, your life as a DBA will be much easier with those alerts in place!
Speaker(s):
- Marcos Freccia
Track and Room: Enterprise Database Administration Deployment - Room B
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 - Room B
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 - Room C
Title: Database tuning advisor vs. dynamic management views
Abstract: Query tuning is a challenging task for a developer and database administrator - so how can we achieve this?
SQL Server mainly offers two different tools we can use for this purpose: DTA Database Tuning Advisor and Missing Index Dynamic Management Views. But what are the differences in terms of reliability, usage, limitations and tuning recommendations? So, we will try to answer these questions in this deep dive session (300-400).
Speaker(s):
- Torsten Strauss
Track and Room: Enterprise Database Administration Deployment - Room A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Grzegorz Stolecki
Twitter: - gstolecki
LinkedIn: Grzegorz Stolecki
Business Intelligence expert with 20+ years of experience. Grzegorz worked as architect, developer and trainer. Currently he focuses on developing specialized analytical and reporting solutions using machine learning models for large and mid-size enterprises. He also works on financial planning, consolidation and budgeting applications. Grzegorz is one of the leaders of Polish Data Community (former Polish SQL Server User Group PLSSUG). You can meet him very often at community meetings, conferences and other events. He is an active speaker and ATE member. Microsoft MVP in Data Platform Area since 2010.
Maryna Popova
I am a Big Data Engineer in a BI team. I have around 4 years of professional expertise in the Information Technologies industry, mainly all around data Engineering and Data Warehousing. I am working on my 3rd BI Project now. All of them are in different business areas and are using different technologies. What is common between them is the willingness to find the most proper development methodology as it is not a canonical development team and no development methodology works “out of the box” . In my talk I would like to share my experience in this area.
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.
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.
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.
Torsten Strauss
Torsten Strauß (MVP, MCSE Data Platform, MCSE Data Management and Analytics, MCT) has been working with Microsoft SQL Server since the turn of the millennium. He currently works as Database Engineer and Microsoft SQL Server Evangelist for BP Europe SE and as Principal Consultant for Sarpedon Quality Lab. Torsten has delivered more than 100 presentations about Microsoft SQL Server at national and international conferences and user groups in recent years.
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.
Satya Jayanty
Twitter: - sqlmaster
LinkedIn: Satya Jayanty
Contact: http://www.sqlserver-qa.net
My experience surrounded with high focus on the data platform with a track record of defining strategy, designing and delivering digital transformation migrations with major enhancements to current working methods. Worked in a capacity of Head of Data Engineering, Enterprise Data Architect and Solutions
Key career accomplishment recognition as an industry expert technical excellence from the Microsoft as Data Platform Most Valuable Professional (MVP) recognition since the year 2006 (13 years as MVP and counting), which recognizes exceptional technical community leaders worldwide who actively deliver, present share their extraordinary contributions, high quality, and real-world expertise. Twitter pod (http://twitter.com/sqlmast
Marcos Freccia
Twitter: - @sqlfreccia
LinkedIn: Marcos Freccia
Contact: http://marcosfreccia.wordpress.com
Currently working as a Microsoft SQL Server DBA at Zalando SE, Marcos has over 9 years of SQL Server experience, working from small to enterprise environments with High Availability, Disaster Recovery, Database Optimization, etc.. Holding several Microsoft certifications such as: MCITP DBA DEV, MCSE Data Plataform and his last certification on Microsoft Azure Design and Implement Cloud Data Platform Solutions. In 2013 Marcos was awarded as a Microsoft MVP by his contributions in the Brazilian SQL Server community. Marcos is a frequent speaker in the SQL Server Community and he was the organizer of the first SQLSaturday in South Brazil.
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.
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…
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.
Mikael Wedham
Twitter: - @wedham
Contact: http://www.wedham.com
Mikael Wedham is the first SQL Server MCM in Sweden and the only one who also is a Microsoft Certified Trainer. He has been paid to do things in SQL Server since 1993. His long experience makes him an appreciated speaker at events and conferences all over Europe. To be prepared for deep dives, he is also certified as an Open Water Scuba Instructor.
Vitalii Bondarenko
I’ve been designing data-centric systems for last 20 years and have gained huge experience in developing BI, AI and Big Data solutions. For the last 5 years I’ve mostly been focused on enterprise platform designing and implementing different innovative approaches for Fast Data Processing. At the moment I’m responsible for building Processional Services in Cloud Solutions for Enterprise Customers.
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.
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).
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.
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.
Sponsors
The following is a list of sponsors that helped fund the event: