Event Location:
Hotel International
Miramarska 24
Zagreb, , Croatia
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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ć,
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,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: http://uk.linkedin.com/in/johnqmartin/
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.
LinkedIn: https://it.linkedin.com/in/sebastianogalazzo
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.
LinkedIn: http://www.linkedin.com/pub/mihail-mateev/1/6b3/4b1
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.
LinkedIn: http://se.linkedin.com/in/magnusahlkvist
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.
LinkedIn: http://at.linkedin.com/pub/milos-radivojevic/1b/7bb/290/de
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.
LinkedIn: https://www.linkedin.com/in/nickyvanvroenhoven/
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, SQL Saturday 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.
LinkedIn: http://si.linkedin.com/in/matijalah/
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.
LinkedIn: http://it.linkedin.com/pub/gianluca-sartori/23/50b/a12
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.
LinkedIn: https://www.linkedin.com/in/aleksandar-talev-95159187
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 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.
LinkedIn: https://www.linkedin.com/in/mrdenny
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.
LinkedIn: http://www.linkedin.com/tomaz.kastrun
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 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).
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.
LinkedIn: https://www.linkedin.com/in/gergely-csom-27171670/
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:)
LinkedIn: https://hr.linkedin.com/in/vedrankesegic
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.
LinkedIn: https://fr.linkedin.com/in/rudibruchez
Contact: http://www.babaluga.com/
(same as before)
LinkedIn: ?https://ro.linkedin.com/in/catalingheorghiu?
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.
The following is a list of sponsors that helped fund the event.