SQLSaturday #932 - Croatia Virtual 2020
Event Date: 09/19/2020 00:00:00
Event Location:
- Hotel International
- Miramarska 24
- Zagreb, , Croatia
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: Performance Tuning with SQLDiag, the best free tool you never knew you had.
Abstract: Have you ever had the need to tune the performance of a SQL Server workload and got fed up with trying to line up all the data capture you need to get a picture of what is going on? What if I said that you have had a tool all along that can do this?
SQLDiag installs with SQL Server and is capable of coordinating the capture of trace data, perfmon data, and log files for you. Sounds great, “how do I use it?” I hear you ask.
In this session we will look at how to setup and run a data capture against SQL Server. We will then look at how to process the captured data into a format that we can use to troubleshoot performance problems. I will also showcase a number of additional tools such as Diag Manager, PAL, and Relog to help make sense of the data captured.
By the end of this session you will be in a position to start using SQLDiag to perform data catpure and have the toolset to process it to solve performance problems with your SQL Server systems.
Speaker(s):
- John Martin
Track and Room: Enterprise Database Administration Deployment - Track 2
Title: Data Science in Power BI Desktop
Abstract: Two of the most popular modern topics are data science and Power BI. The nice thing is that you can easily combine both of them by including data science analyses in Power BI. You can do this in numerous ways. Many Power BI visualizations already include the Analytics tab with plethora of intermediate-level analytical functions available. For example, you can add a trend line and many other lines to the Scatter chart. You can use R and / or Python script sources. You can do the whole analysis in R or Python, and then visualize the results in Power BI. You can also use the good old SSAS Multidimensional Data Mining as the source. You can include Azure ML predictions in a Power BI model. With R and Python visuals, you can add the impressive visualizations from these two languages in a Power BI report and dashboard. You can also use R and Python in Power Query for advanced data manipulation. There are also many custom visuals that include data science analyses. This session introduces all
Speaker(s):
- Dejan Sarka
Track and Room: Analytics and Visualization - Track 2
Title: Leverage Power BI automation using APIs and Flow
Abstract:
Power BI is a cloud-based service; it means that it comes along with a standard set of APIs that provides access to its internal resources such as reports, datasets, rows.
Using APIs gives more flexibility and allows to build custom dashboard applications either for administering or query the service.
And if you combine the power of APIs with Microsoft Flow, you can automate some background processes such as adding users, granting rights, update or refresh datasets, …
The session is demo only. A complete walk-through to the process, will show you how to register an app, create a custom connector and leverage Power BI API actions by triggering a Microsoft Flow object.
Speaker(s):
- Andrea Martorana Tusa
Track and Room: BI Platform Architecture, Development Administration - Track 3
Title: FILETABLEs: What They Are and How to Use Them
Abstract: Have you ever had the need to access documents in your database as if they were files in the file system? SQL Server 2012 introduced a brand new method for managing large data objects (BLOBs) in a database. FILETABLEs provide access to data using Transact-SQL - just like any other table inside the database, while at the same time also provide access to the data using the operating system File I/O API - i.e. just like any other folder in the file system. In this session you will learn how to upgrade your document management solutions by migrating your large data to FILETABLEs. The session covers two most typical migration scenarios: migrating from a distributed data store, where files are stored outside the database, and from a homogeneous data store, where all the data is stored inside the database.
Speaker(s):
- Matija Lah
Track and Room: Application Database Development - Track 1
Title: Building a modern data warehouse and BI solution in Microsoft cloud
Abstract: Data warehouse and BI market is evolving rapidly with the appearance of new cloud born technologies. We might assume, that moving an existing Microsoft based DWH to the cloud is an easy step, but when we dig a little bit deeper, we will see, there are many-many new technological choices and aspects on how to modernize an existing dwh/bi system in the cloud. Not to mention if we start everything from scratch in a new project designed specifically to the cloud to utilize cloud flexibility and innovation as much as possible. Which ETL tool should I use? Data factory v2 with SSIS and BIML, or Azure Databricks powered Dataflows? Or Power BI Dataflow? Which is the right decision to run OLAP workloads? Azure AS? Or simply Power BI? When do I need Azure SQL DWH? In the last couple years I helped many customers to modernize their DWH landscape partially or fully in the cloud and during my presentation I will share my findings and recipes for the most common situation I met. You will have fun:)
Speaker(s):
- Gergely Csom
Track and Room: BI Platform Architecture, Development Administration - Track 3
Title: Creating Custom BI Solutions with Power BI Embedded
Abstract: Microsoft Power BI Embedded is a Microsoft Azure that enables developers to integrate Power BI reports into their web or mobile applications so they don’t need to build custom solutions to visualize data for the users. Microsoft Power BI Embedded helps Independent Software Vendors to use Power BI data experiences within their applications. Customers, who use applications with Power BI Embedded don’t need to have a Power BI account or to know anything about this Azure service. This talk is a practical session on Microsoft Power BI Embedded concept with many examples how to create custom BI solutions using this technology.
Speaker(s):
- Mihail Mateev
Track and Room: Cloud Application Development Deployment - Track 3
Title: Creating a photorealistic avatar using generative adversarial net
Abstract: Having an overview on how getting started with Microsoft Azure Machine Learning Studio we will start understanding generative deep learning algorithms. Focusing on autoencoders, will be journey from the biginning (Of the speaker experience), mistakes and tips learned along the path showcasing several convolution flows. https://www.youtube.com/watch?v=pJ7VmOOMy4kfeature=youtu.be
Speaker(s):
- Sebastiano Galazzo
Track and Room: Analytics and Visualization - Track 3
Title: Table Indexing for the .NET Developer
Abstract: In this session we will be looking at the best and worse practices for indexing tables within your SQL Server 2012+ databases. We will also be looking into the new indexing features that are available in SQL Server 2012+ (and SQL Server 2005-2008) and how you the .NET developer can make the best use of them to get your code running its best.
Speaker(s):
- Denny Cherry
Track and Room: Application Database Development - Track 1
Title: Logging Actual execution plans in SQL 2017 and 2019
Abstract: Actual execution plan gives us most comprehensive info for tuning a query, much more than estimated plan. Now it also includes wait statistics, logical reads, and actual row numbers for that execution. But there is a catch - it is traditionally very expensive to track plans for all executions, even if we filter for only slow ones. We will see how new versions of SQL Server evolved to get us actual plans without sacrificing performance. Let me introduce you to “Lightweight profiling” you can have enabled all the time on your server, with close to zero impact.
Speaker(s):
- Vedran Kesegic
Track and Room: Enterprise Database Administration Deployment - Track 2
Title: Implementing security in Azure Data Platform Solutions
Abstract: As computing environments is moving customer-controlled on premises data centers to cloud data centers, the responsibility of security also shifts. Security is nowadays a concern shared by cloud providers, organizations and individuals. For every solution, it’s important to understand what’s solution provider responsibility and what’s Azure’s responsibility.
In this presentation, attendees will see how Azure provides a multi-layered security model to protect customer data. I will show how security can range from setting up secure networks and access keys, to defining permission and to monitoring with Advanced Threat Detection across a range of data stores.
Speaker(s):
- Aleksandar Talev
Track and Room: Enterprise Database Administration Deployment - Track 1
Title: Diagnosing performance problems on Azure SQL
Abstract: Dynamic Management Views, wait sats, executions statistics, Extended Events. Those are the tools you use on SQL Server on-prem to diagnose long running queries and server weaknesses. You use more or less the same tools on Azure SQL, but there are differences: permissions, database-specific views, XEvents ring buffer reading. In this session, we will address specific queries and views, and diagnosis steps specific to Azure SQL.
Speaker(s):
- Rudi Bruchez
Track and Room: Cloud Application Development Deployment - Track 2
Title: “SQL-like” or query languages in Azure IoT
Abstract: If you are reading Azure IoT documentation you will stumble a lot on the “SQL-like query language” or “SQL-like language” syntagms. In this presentation we will explore Azure IoT places where queries are used and see how to use them. And in the process to find out more about this “SQL-like” languages and how being a DB developer cam make you a IoT hero. We will concentrate on the scenarios with the greatest impact, where a little SQL can solve you a lot of hassle. So, we will leave no SQL query unturned in Azure IoT Hub, Stream Analytics, Power Bi to name a few.
Speaker(s):
- Catalin Gheorghiu
Track and Room: Cloud Application Development Deployment - Track 2
Title: Wait Statistics
Abstract: To understand the root cause of performance problems you need to have a good understanding about SQL OS and especially how connections, sessions, requests, tasks, scheduler, threads and wait statistics are working together. In this session you will learn this understanding to identify common performance issues and find solutions to solve them.
Speaker(s):
- Torsten Strauss
Track and Room: Enterprise Database Administration Deployment - Track 1
Title: Monitoring SQL Server without breaking the bank
Abstract: Monitoring SQL Server can become a very expensive business. Sure, the market offers countless paid solutions, but what if you have a large server estate and your budget is tight? In this session we will combine multiple open source tools (InfluxDB, Telegraf , Grafana, DbaTools and many more) to collect important performance metrics, analyze the data they collect, set up alerts for the critical events, troubleshoot issues and plan for the future. Join me and you will see how monitoring is not a business for billionaires.
Speaker(s):
- Gianluca Sartori
Track and Room: Enterprise Database Administration Deployment - Track 2
Title: Useful DAX and Power BI examples for everyday usage
Abstract: Session will cover many everyday useful DAX functions, and Power BI examples, that can help you build better and cleaner (slicers, forms, formulas) reports. With help of DAX - powerful language to manipulate data in Power BI, handling hierarchies, data granulation, data aggregations and functions for date, time, text operations - session will walk you through many examples to help you prepare Power BI Reports for everyday usage.
Speaker(s):
- Tomaž Kaštrun
Track and Room: BI Information Delivery - Track 3
Title: Query Folding in Power BI
Abstract: Power Query allows you to extract and transform data from a variety of data sources. Have you ever experienced that the importing of data is slower than you expected? In most of those cases, query folding is not happening fully optimized. Query folding is important because it offloads data transformations to the source, instead of performing them in Power BI. Attend this session to learn how to ensure that you get all the performance improvements possible within your reports! As a bonus, you will also learn in which cases query folding is not your best friend.
Speaker(s):
- Nicky van Vroenhoven
Track and Room: Analytics and Visualization - Track 3
Title: Transact-SQL Performance Tips
Abstract: U ovoj populističkoj sesiji razmatraćemo kako način na koji je napisan upit može da dovede do sporog izvršenja uprkos povoljnom izvršnom okruženju (postoje dobri indeksi, server je rasterećen, nema mnogo konkurentnih sesija…) i onemogući SQL Server da ga izvrši koristeći optimalni execution plan.
Pokrićemo tipične greške koje programeri tom prilikom prave zbog nedovoljnog poznavanja funkcionisanja database engina.
Razume se, podelićemo savete u vezi sa pisanjem upita koji će svakako pomoći da se izbegnu tipične i najčešće greške u svakodnevnom radu sa SQL Serverom, a i elaboriraćemo šta bi to svaki programer trebalo da zna o SQL Serveru.
Session level: 200 - 300
Speaker(s):
- Miloš Radivojević
Track and Room: Professional Development - Track 1
Title: Statistics, an unreliable friend.
Abstract: You learned that your statistics should be regularly updated. You even implemented Ola Hallengren’s maintenance scripts. That should be enough, right? What if it’s not? Join me on some head-ache, a dive into statistics histograms, fun with flags and a praise to the evolution of SQL Server optimizer. Much of this session is about the “ascending key problem”, and how Microsoft have made shanges to the SQL Server optimizer to improve, but not completely eliminate the problem.
Speaker(s):
- Magnus Ahlkvist
Track and Room: Application Database Development - Track 1
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
John Martin
Twitter: - SQLDiplomat
LinkedIn: John Martin
Contact: https://www.mssqltips.com/sqlserverauthor/291/john-martin/
John Martin is a Data Platform Engineer working in the financial sector, as well as Vice President Marketing for the PASS organization and currently a Microsoft Data Platform MVP. Previously John has worked as a product manager for SentryOne and a Premier Field Engineer with Microsoft UK.
John has over a decade of experience working with SQL Server and the Microsoft Data Platform. Working as a DBA, developer and consultant for Microsoft, he has been lucky enough to see how best, and how not, to use SQL Server and the Data Platform effectively.
Sebastiano Galazzo
Twitter: - @galazzoseba
LinkedIn: Sebastiano Galazzo
Passionate about Artificial Intelligence, Sebastiano @galazzoseba brings over 15 years of experience in AI and machine learning to his current position as CTO at Sistem-EVO srl. Sebastiano has dedicated the last few years to designing and developing algorithms to tackle the challenges of Natural Language Processing, image recognition and predictive analysis through machine learning. He is a Microsoft MVP and his work in AI has gained commendation in numerous publications and has received several national and international awards.
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.
Magnus Ahlkvist
Twitter: - @Transmokopter
LinkedIn: Magnus Ahlkvist
Contact: http://www.tsql.nu
Independent database consultant and certified trainer with a passion for chasing that extra millisecond. 20 years of database development and administration but trying to be humble enough to understand that I’m still learning.
Miloš Radivojević
Twitter: - MilosSQL
LinkedIn: Miloš Radivojević
Contact: https://milossql.wordpress.com/
Miloš Radivojević is a database consultant located in Vienna, Austria. He is Data Platform MVP and specializes in SQL Server for application developers and performance and query tuning. Currently, he works as a principal database consultant in bwin GVC (the largest regulated online gaming company in the world). He is co-founder of the SQL Pass Austria and speaks regularly at local and international database conferences. He is also co-author of the books SQL Server 2016 Developer’s Guide, SQL Server 2017 Developer’s Guide and Mastering SQL Server 2017.
Nicky van Vroenhoven
Twitter: - https://www.twitter.com/nickyvv
LinkedIn: Nicky van Vroenhoven
Contact: https://www.nickyvv.com
Nicky van Vroenhoven is a BI professional focused at the Microsoft stack. He mainly works with Power BI, Power Platform and T-SQL. After working 9 years in BI-consultancy jobs in several industries and companies, he is currently working as a Lead BI Developer at the DWH team at Van Lanschot Kempen in The Netherlands. Nicky has spoken at several User Groups, SQLSaturday Events, and the Power BI World Tour and is the co-founder of the Power BI Days Netherlands. In addition he enjoys tweeting and blogging about topics like Power BI and Power Platform at https://nickyvv.com.
Matija Lah
Twitter: - @MatijaLah
LinkedIn: Matija Lah
Contact: http://milambda.blogspot.com
Matija Lah has more than a decade of experience working with Microsoft SQL Server, mostly architecting data-centric solutions in the legal domain. His contributions to the SQL Server community have led to the Microsoft Most Valuable Professional award in 2007 (Data Platform), which he held until 2017. In 2008 Matija joined SolidQ as a Mentor, located in Central and Eastern Europe. He spends most of his time on projects involving advanced information management, and natural language processing.
Gianluca Sartori
Twitter: - http://twitter.com/#!/spaghettidba
LinkedIn: Gianluca Sartori
Contact: http://spaghettidba.com
Gianluca Sartori is a Data Platform MVP, independent consultant and performance tuning specialist. He has been working in the software industry since 1999 and has been working with SQL Server ever since. He also works as a SQL Server trainer and in his spare time he writes technical articles and participates the SQL Server forums. Gianluca enjoys presenting SQL Server topics at conferences in Europe and in Italy in particular. He is currently working as lead DBA at a famous Formula 1 team.
Aleksandar Talev
LinkedIn: Aleksandar Talev
Contact: https://Www.sqlpass.org.mk
Aleksandar Talev is Chief Development Officer in Semos - Microsoft Gold Partner. He is professionally oriented to development of IT projects based on Microsoft technologies, primary SQL Server, Microsoft Power BI and Microsoft Azure. He has been working with SQL Server 6.5 since 1996. As a Microsoft trainer he is holding a Microsoft Curriculum courses focused on SQL Server as well as Power BI. As one of the founders of SQL Server User Group (PASS) Macedonia his free time he is engaged in developing the SQL Server community in Macedonia. He is a regular speaker on Microsoft conferences as well as local and global community events. In 2005 Microsoft awarded him with SQL Server MVP award.
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.
Denny Cherry
Twitter: - mrdenny
LinkedIn: Denny Cherry
Contact: https://www.dcac.com
Denny Cherry is the owner and principal consultant for Denny Cherry Associates Consulting and has over a decade of experience working with platforms such as Microsoft Azure, Amazon AWS, Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server 2000 through 2019, including being a Microsoft Certified Master, Microsoft MVP and VMware vExpert Award.
Tomaž Kaštrun
Twitter: - @tomaz_tsql
LinkedIn: Tomaž Kaštrun
Contact: http://www.tomaztsql.wordpress.com
Tomaž Kaštrun is BI developer and data analyst. His main focus are data mining, T-SQL development, programming and query optimization. He has been working with SQL server since version 2000. He is Microsoft Certified Professional, Microsoft MVP for data platform and Microsoft trainer.
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).
Dejan Sarka
Twitter: - DejanSarka
Contact: http://blogs.solidq.com/dsarka/Home.aspx
Dejan Sarka, MCT and Data Platform MVP, is an independent trainer and consultant that focuses on development of database and business intelligence applications. Besides projects, he spends about half of his time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or co-author of eighteen books about databases and SQL Server. Dejan Sarka has also developed many courses and seminars for Microsoft, Radacad, SolidQ, and Pluralsight.
Gergely Csom
Twitter: - https://twitter.com/CsomGergely
LinkedIn: Gergely Csom
Data and AI expert with 15+ years of experience in various data warehousing, BI and AI projects in FSI, OilGas, Energy and Transportation. Experienced trainer, mentor, regular public speaker in various events. Nowadays building the best in class data team for helping our customers in their digital transformation journey in the super exciting Data AI driven revolution. Running cloud IoT pet projects nowadays in his free time:)
Vedran Kesegic
Twitter: - @VedranKesegic
LinkedIn: Vedran Kesegic
Contact: http://blog.sqlxdetails.com
Vedran Kesegic is a Microsoft Certified Master for SQL Server, with Oracle background. With 14+ years enjoyed in exploration of SQL Server depths, developing smart algorithms, optimizing SQL Servers and SANs. He is the author of XDetails, Addin for SQL Management Studio that shows detailed info about indexes and other objects. He likes to hang out, share knowledge, and talk about more or less important things in life.
Rudi Bruchez
Twitter: - nepasderanger
LinkedIn: Rudi Bruchez
Contact: http://www.babaluga.com/
(same as before)
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.
Sponsors
The following is a list of sponsors that helped fund the event: