SQLSaturday #853 - Plovdiv 2019
Event Date: 06/22/2019 00:00:00
Event Location:
- Culture Centre “Boris Hristov”
- 15 Gladston Str., 4000 Plovdiv, Bulgaria
- Plovdiv, Plovdiv, Bulgaria
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: Custom maps in Power BI
Abstract: Let’s go beyond the standard visuals available in Power BI for making maps. In this session we won’t talk about Bing or ArcGIS services. We want to explore all the available features for creating custom maps without having to rely on existing ones. Do you know what is a shapefile? Do you know how to create your own choropleth and import it into Power BI? What else? R support into Power BI opened the doors to the huge number of packages for spatial data analysis and statistical calculations included in the environment. Do you want to draw multi-layered interactive maps, or perform spatial analytics? With R in Power BI, now you can. Discover some custom visuals to overcome simple cartography: MapBox, IconMap, FlowMap. Last but not least, learn how to use Synoptic Panel, an awesome component that connects areas in a custom image with attributes in the data model and draws the data on a map. There are endless possibilities; the only limit is your imagination!
Speaker(s):
- Andrea Martorana Tusa
Track and Room: Analytics and Visualization - Room 1
Title: T-SQL advanced: Grouping and Windowing
Abstract: This session aims to explore all the features offered by the language T-SQL for aggregating and calculating data. There’s much more of the clause GROUP BY. With grouping and ranking functions you can calculate in your query grandtotal, running totals, find islands in intervals, select the last-not-null value, etc. Windows functions apply directly on a set of rows defined by the OVER clause (“a window”). Windows function do not perform aggregation on group level and do not hide row details. So they allow mixing detail and total elements in the same query. The session is mainly based on a copious array of demos, to make explicit every concept introduced taking into account the impact on performances for every solution.
Speaker(s):
- Andrea Martorana Tusa
Track and Room: Application Database Development - Room 3
Title: Making sense of Storage modes and Connection types in PowerBI
Abstract: If you’ve been around PowerBI you should already know what Import, Direct Query and Live Query are. Probably you’ve looked for the differences, you’ve read for something called Query Folding and if you’ve been following the news - you should have heard about composite models and the Dual storage mode and its partner in crime - the Aggregation table. But how to make sense of all of those? How to choose between them? When one is better than the other? Well, I am trying to find that out myself, and I have some facts to share with you. In the session we will compare Import with DQ and LQ, I’ll show you the usage of Aggregations, we will talk about Dual mode and most importantly, I will share some real-life scenarios to wrap things up.
Speaker(s):
- Ivan Donev
Track and Room: BI Platform Architecture, Development Administration - Room 1
Title: T-SQL Performance Guidelines for the optimal DB stress powers
Abstract: To reach your desired business functionalities, it can be easy using some common T-SQL practices like MTVF , scalar functions , Temp tables, Union…etc and they might perform pretty well on development server coz neither adequate stress of users nor adequate volume of data exist there but actually they seem totally strange once going to live where they become performing badly ending up eventually with and sharp skew of performance and standstill cases sometimes , this is due to the lack of stress powers of T-SQL codes which should be considered largely for critical mission DBs in particular more therefore I am going to talk to you about How to capture expensive queries using different techniques ..?and How to optimize them in the shortest time using scientific ways ..? (10 different T-SQL Practices will be explained within this session)
Speaker(s):
- Shehab El-Najjar
Track and Room: Application Database Development - Room 3
Title: The intelligent Firing Range (Building Server-less python applications)
Abstract:
How to build an automatic score calculator for a nerf gun firing range using various Microsoft technologies.
In this session we will explore how to implement an end to end solution to detect nerf darts fired at a target, the challenges involved and how to overcome them.
The technologies involved will range from Power Apps for user interaction and orchestration, Azure SQL DB for information storage, Azure Storage for file storage, Azure functions to ensure automation and provide a server-less environment for the python script and, last but not least, PowerBI to display the results.
At the end of the session you’ll have an understanding of how to set up these different technologies to work together seamlessly.
Speaker(s):
- Francesco Sbrescia
Track and Room: Advanced Analysis Techniques - Room 3
Title: The Maths Behind Machine Learning
Abstract: The new world of Machine Learning can sound quite overwhelming! Do I need a PhD in Machine Learning to get involved? The answer, thankfully, is no. But what you do need, which is often neglected, is a solid understanding of the theory behind the models.
This session will look to do just that, looking at some of the most popular algorithms used today, we will explore the maths involved, to help us understand our problems and get the best results possible. We will be also diving into practical examples, using Databricks to consume a dataset and to visualise results, with R Python scripts to execute the Machine Learning models.
If you would like an introduction to the world of Machine Learning and to acquire a solid grounding that will help you develop the skill, then this is the session for you.
Speaker(s):
- Matt Willis
Track and Room: BI Platform Architecture, Development Administration - Room 1
Title: IoT Circus – deathmatch oops, datematch :) Power Bi vs Time Series Insights
Abstract: Or how to visualize your data and find insights for beginner IoT developer If you create an IoT solution today, you have a variety of components available to mix and match to make your solution, akin LEGO. You get your hardware and firmware right and you get data from the sensors, now what? Of course, you would like to have, some data visualization easy and fast, and of course you would like to learn something from that data easy and fast. And it would be nice to have the results available on mobile devices, yes, yes easy and fast. Now enter our two titan technologies in a match to the death oops data trying to achieve these goals, you guess it easy fast (and cheap). And we will see them clash, from real hardware, to the big Azure cloud, to mobile devices, trying to outmatch each other.
Speaker(s):
- Catalin Gheorghiu
Track and Room: Cloud Application Development Deployment - Room 3
Title: Parallel Query Processing in SQL Server
Abstract: Depending on a query plan SQL Server may choose to process a query in a serial or a parallel way. With a parallel query processing a server may utilize more CPUs and complete a query faster, however, managing parallel execution is not simple and demands additional resources, so for some quires a serial execution is better. The balance is important.
In this session we will look at the balance from the Query Processor prospective. We will learn the reasons: how and why does a server choose a parallel or a serial plan. We will learn how to read and interpret parallel plans and look at some important aspects of a parallel plan analysis. After this session you will know what to look at, when the next time you have to deal with parallelism in SQL Server.
Speaker(s):
- Dmitry Pilugin
Track and Room: Application Database Development - Room 3
Title: Enterprise Deployment of Power BI
Abstract: Many enterprise organisations bought into the self-service gold rush and rolled PowerBI out to their users and let them loose. They now find themselves with a mass of uncontrolled workspaces, hundreds of duplicated reports and the kind of conflicting KPI definitions that started the whole warehousing movement in the first place.
A self service environment for most organisations, is a big cultural and business shift, this session looks to address how Power BI should be deployed and managed in an Enterprise scenario, along with how to manage business change and what we can do with Power BI to ensure a smooth transition into a the new world of self-service reporting.
Speaker(s):
- Scott Hudson
Track and Room: Analytics and Visualization - Room 1
Title: If a computer can understand, why can’t YOU understand Azure Cognitive Services?
Abstract: Cognitive services can recognise objects, faces, describe images, understand speech, perform advanced searches and so much more. If you are a developer and know nothing about Azure Cognitive Services for free, this is a good place to start. Disclaimer: Cognitive services will never guess a doctor’s handwriting. That’s just impossible.
Speaker(s):
- André Melancia
Track and Room: Advanced Analysis Techniques - Room 1
Title: Possiblities and Limitations of System-Versioned Temporal Tables beyond the Basics
Abstract: This technical presentation shows how to manipulate data with versioning switched off, what to consider when building queries referencing multiple temporal tables and building views.
Speaker(s):
- Reinhard Flügel
Track and Room: Application Database Development - Room 3
Title: Monitoring Microsoft SQL Server using the Elastic Stack
Abstract: Monitoring SQL Server for Performance, Up-time and other crucial stats is one of the most important tasks you can do in order to keep your database server software running smoothly and efficiently. In this session, you will learn how use Metricbeat to monitor Monitoring SQL Server, shipping performance and transaction log metrics data to Elasticsearch, visualize them in Kibana dashboards and create watchs to detect changes or anomalies in your data and perform the necessary actions in response.
Speaker(s):
- Miroslav Lessev
Track and Room: Enterprise Database Administration Deployment - Room 2
Title: Discovering the full power of parameters in Power BI
Abstract: We all use parameters to filter the data included in our reports. But do you know they can do more than that? In this session I will show you how you can use parameters in many different ways, like changing the data source, or even to change the logic of your reports!
Speaker(s):
- Andrey Nikolov
Track and Room: Analytics and Visualization - Room 1
Title: Architecting SQL Server environments for Mission Critical and High Performance
Abstract: Mission critical SQL Servers require right architecture to satisfy SLAs, high availability, and disaster recovery requirements for your critical IT operational data environment. The ability to scale up these environments, to provide the level of performance required by OLTP and provide adequate resources is a significant operational challenge.
Speaker(s):
- Marcelo Fernandes
Track and Room: Enterprise Database Administration Deployment - Room 3
Title: Data Mining from A to Z
Abstract: Understanding the business case and the data? Preparing the data? Model, evaluate and deploy it?
These are answers that we can approach with Data Mining. Let’s see together why this matters, and how can we do it with Azure Machine Learning Studio and PowerBI.
Speaker(s):
- Ekaterina Marinova
Track and Room: Analytics and Visualization - Room 2
Title: Provisioning the IoT Devices - Best Practices
Abstract: Initial configuration of many devices is one of the biggest challenges in modern IoT solutions, managing many client devices. It is very difficult to configure indivisually so many devices and industry is looking for modern approaches to have a zero-touch automated initial provisioning in the modern Internet of Things system.
This talk is about the real-life cases and best practices when need to design and implement zero-touch provisioning like general concepts and specific implementations using Microsoft Azure.
Speaker(s):
- Mihail Mateev
Track and Room: Cloud Application Development Deployment - Room 2
Title: Full text search in digital and scanned documents with Elasticsearch and Tesseract
Abstract: In this session I will show how to implement full text search not only in standard documents, such as Word, Pdf, TXT etc., but also in scanned documents. I will use Elasticsearch and Tesseract to OCR, create index and search in documents and images.
Speaker(s):
- Stamo Petkov
Track and Room: Other - Room 2
Title: SQL Server partitioning - Why, What and How
Abstract: Partitioning is process which divides very large tables into multiple smaller physical parts. The main of goal of partitioning is to aid in maintenance of large tables and to reduce the overall response time to read and load data. But it doesn’t mean whenever you see a big table you need to partition it. There is more than to take into account and even more to consider when you implement partitioning. Come to this session to get familiar with partition internals and to understand when and how to implement it.
Speaker(s):
- Rozalina Zaharieva
Track and Room: Enterprise Database Administration Deployment - Room 2
Title: NotADBTalk
Abstract: You might not need a database… Let’s go over some of the problem with databases and what they mean about our software. DBs are implementation detail. If we choose them before we design our software we are going to make mistakes that are costly to correct. In this opinionated talk I am going to cover some of the pitfalls of popular DBs. I am also going to cover how and when to choose a database.
Speaker(s):
- Martin Chaov
Track and Room: Strategy and Architecture - Room 1
Title: All you need to know about Microsoft Power Platform
Abstract: PowerBI is the most famous product in the Power Platform suite. But Flow and PowerApps can solve some very interesting problem and help you speed up app creation, increase productivity and help you in automating pretty much everything in your daily work life. This is going to be a demo intensive session that will showcase all three products.
Speaker(s):
- Ivan Donev
Track and Room: BI Platform Architecture, Development Administration - Room 2
Title: Time intelligence function in DAX
Abstract: This session provide data using time periods and explain some tips and tricks with custom periods, build and compare calculations over those periods.
Speaker(s):
- Boriana Petrova
Track and Room: BI Platform Architecture, Development Administration - Room 3
Title: Power BI as a highway for your AI
Abstract: Everybody talks about AI, many pretend they are using AI but how many people have you really seen doing it? Although AI is at its hype usually if you want to gain a benefit from its adoption you have to invest extensive resources and plan ahead at least several weeks. However the new AI features of Power BI offer extensive analytical capabilities which are easily applicable to a custom scenario even by a casual business user. In this session we will see how Power BI helps us get important insights via AI in a matter of minutes and without a necessity for a serious plunge in the field of statistics.
Speaker(s):
- Diana Tisheva
Track and Room: BI Information Delivery - Room 2
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Dmitry Pilugin
Twitter: - https://twitter.com/SomewereSomehow
LinkedIn: Dmitry Pilugin
Contact: http://www.queryprocessor.com/
Dmitry Pilugin, is a SQL Server DB developer from Russia, Moscow. He works with SQL Server for more than ten years. Currently he works as a database developer lead, responsible for the development of production databases in the media research company.
Dmitry holds a blog about SQL Server query processing: QueryProcessor.com, where he writes about a query optimization and execution, and also likes to share his knowledge about it speaking at various community events and tech conferences. Data Platform Microsoft MVP since 2014.
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.
Martin Chaov
Twitter: - raziel_pld
LinkedIn: Martin Chaov
I’m is a design and software enthusiast. Attention to detail and pedantry are part of my day-to-day work. I am maintaining an open mind and am always on the lookout for new technologies and opportunities to use them. Currently I am in the role of software architect at SBTech’s Digital unit. The focus of my work is improving our end user software.
Boriana Petrova
Twitter: - borianapetrova
LinkedIn: Boriana Petrova
Contact: http://itraining.bg/category/itraining-blog/
Microsoft Certified Trainer with over 10 years experience as an IT instructor and Consultant. She has many qualifications and professional certifications, including: Excel MVP, MCT, MCITP, MCTS, MOS Master. In 2008 she is among the TOP 25 of the best instructors in Microsoft World Company business evaluation and measurement - Knowledge Advisors.
Marcelo Fernandes
Twitter: - marcelodba
LinkedIn: Marcelo Fernandes
Contact: http://marcelodba.wordpress.com
Marcelo Fernandes is SQL Server MVP and has 12+ years experience with databases, specialized in High Availability, critical missions and very large databases. He holds the MCP / MCDBA / MCSA / MCTS / MCITP and MCT certifications, he lives and works in Berlin for an American e-commerce company that sells home goods. He share their knowledge through webcasts, presentations and articles on Microsoft technologies and can be cantacted by email fernandes_dba@hotmail.com or twitter @ marcelodba
Diana Tisheva
LinkedIn: Diana Tisheva
Diana Tisheva is an university lecturer and a data professional with an extensive experience in the IT industry, working for enterprise clients from different sectors using versatile technologies in the area of Datawarehousing and Business Intelligence.
Shehab El-Najjar
Twitter: - https://twitter.com/MSQLPerformance
LinkedIn: Shehab El-Najjar
Contact: http://sqlserver-performance-tuning.net/
Shehab El-Najjar was the ONLY Microsoft SQL Server MVP in Gulf for the past 6 years and the 2nd one all over the Middle East , he is the founder of SQL Gulf events series (SQL Gulf #1 , #2 and #3 ) where he spent so much time and efforts to broadcast Microsoft SQL Server technologies all over the Gulf such as KSA and Emirates and other Gulf cities ahead ..)
He is now Professional Services Manager at Saudi Emircom
He was previously COO and business leader in KSA market through his startup WAJA IT for 3 years
He is an influencing Database community leader all over the region A senior Database Consultant (SQL Server MVP for 6 years in row) -The 2nd MVP awardee SQL Server all over Middle East and Arabic region
Rozalina Zaharieva
Twitter: - RozenceZ
LinkedIn: Rozalina Zaharieva
SQL expert in Microsoft’s Data Platform Solution. Enthusiast with more than 10 years of experience in support, implementation, design and architecture of small and large projects for SQL Core – Consolidations and Migrations. Passionate speaker in SQL Master Academy and events like SQLSaturday and community events. Experience in Financial Sector Data platform Operations.
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.
Scott Hudson
8 years delviery Microsoft BI Solutions, primarily focussed on Power BI the last few years delivery solutions from small teams to 70,000 users base.
Ekaterina Marinova
Starting with predicting customer behavior and sales, I was excited to explore the world of Big Data in my Master’s degree in Rotterdam School of Management. There, I had the opportunity to work with companies in developing predictive analytics models, marketing retargeting strategy and the analytics process from A-Z using R, Alteryx, R Studio, and Tableau. By exploring different statistical models, visualization tools, and starting a project from scratch I could ensure that this was already a passion and a thing to work on in the future.
Currently, as part of the team of TELELINK, I ensure that we as a company provide our customers with the opportunity to take advantage of the best data platform and technology to digitally transform. A
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…
Ivan Donev
Twitter: - https://twitter.com/ikdonev
LinkedIn: Ivan Donev
I am a Data platform MVP with more than 10 years of real-life experience with SQL Server and its stack of services. Besides the support and project work, I am also a trainer, conference speaker and user group organizer (and volunteer).
Francesco Sbrescia
LinkedIn: Francesco Sbrescia
Contact: http://blogs.adatis.co.uk/francescosbrescia/
I’m a BI consultant with experience in both data visualization using D3 and data warehousing using Microsoft BI Stack.
Ivan Donev
Twitter: - https://twitter.com/ikdonev
LinkedIn: Ivan Donev
I am a Data platform MVP with more than 10 years of real-life experience with SQL Server and its stack of services. Besides the support and project work, I am also a trainer, conference speaker and user group organizer (and volunteer).
Andrea Martorana Tusa
Twitter: - bruco441
Andrea Martorana Tusa is a Business Intelligence Team Manager at Würth Phoenix, the IT and consulting company of the Würth-Group. He is awarded as MVP in the Data Platform category
Former BI Specialist at Widex, a Danish manufacturing company, and BI Developer in the IT department of an Italian banking group. 20+ years of experience working with data. He is focused on the entire BI stack: database development, data warehousing, data analysis, reporting, etc. Andrea is a usual speaker at many events: SQLSaturdays, conferences in Europe and PASS Summit, and for PASS Virtual Groups.
Andrea is an author for sqlshack.com, sqlservercentral.com, and UGISS (User Group Italiano SQL Server).
Matt Willis
LinkedIn: Matt Willis
Matt Willis is the Head of People at Adatis as well as a Senior Data Analytics Consultant. Matt has 9 years of experience in data analytics and Machine Learning and 6 years delivering data analytics solutions using the Microsoft BI stack in both on-prem and cloud based solutions.
Matt is a prolific speaker, presenting all over Europe including SQLBits. Matt is also lecturing at universities and has provided insight and industry experience in addition to helping to run a module.
Matt is passionate about machine learning and data, and has a love of communicating ideas. In his spare time he enjoys listening to music, attempting to keep fit and exploring the world.
Reinhard Flügel
Started as an application developer in the early 90’s using C++, Access and SQL-Server. Since around 2010 focusing on Database Development mainly SQL-Server. Holding several Microsoft certifications such as: MCSE Data Platform, Business Intelligence and Data Management and Analytics (Charter).
Miroslav Lessev
LinkedIn: Miroslav Lessev
I am a PhD candidate at Faculty of Economics and Business Administration, University of Sofia quot;St. Kliment Ohridskiquot; in Implementation of modern computer engineering in economic studies at. I have study on cloud computing and its effect on economics and people. I have more than 20 years of experience in designing, developing, implementing and supporting databases. At the moment I#39;m a Big Data Developer in DataCore Software.
Andrea Martorana Tusa
Twitter: - bruco441
Andrea Martorana Tusa is a Business Intelligence Team Manager at Würth Phoenix, the IT and consulting company of the Würth-Group. He is awarded as MVP in the Data Platform category
Former BI Specialist at Widex, a Danish manufacturing company, and BI Developer in the IT department of an Italian banking group. 20+ years of experience working with data. He is focused on the entire BI stack: database development, data warehousing, data analysis, reporting, etc. Andrea is a usual speaker at many events: SQLSaturdays, conferences in Europe and PASS Summit, and for PASS Virtual Groups.
Andrea is an author for sqlshack.com, sqlservercentral.com, and UGISS (User Group Italiano SQL Server).
Stamo Petkov
Twitter: - https://twitter.com/stamo_petkov
LinkedIn: Stamo Petkov
My name is Stamo Petkov and I have been professionally engaged in programming for more than 17 years. I’ve gone through a variety of technologies - BASIC, Pascal, Object Pascal, PHP, and I finally discovered .NET and C #. For me, education is a cause, and I myself always strive to learn new and interesting things. I really want to believe that I manage to convey a bit of this aspiration to the people I talk to. I have been a lecturer in JavaScript and Software Architectures in the InfoStart initiative, led C # Basics and ASP.NET MVC courses in Softuni, as well as several courses at the New Bulgarian University, I have lectured at various conferences and events in the field of software technologies. My current position is head of Microsoft T
Andrey Nikolov
Andrey is MCSA for SQL Server 2012/2014 with almost 20 years of experience in designing and implementing applications for Windows. He is working with various database platforms, but SQL Server is his favorite. He is also a leader of Plovdiv Power BI User Group and active member of local .NET, Power BI and SQL Server communities.
Sponsors
The following is a list of sponsors that helped fund the event: