Event Location:
Faculty of Computer Science
Vecna pot 113
Ljubljana, Ljubljana, Slovenia
Abstract:
Are you also sometimes lost in space? What is up and what is down, when it comes to navigation in Power BI. How much is controlled and what can you adjust yourself? This session will cover all the options we have to change and setup navigation on three different levels. (1) Inside Reports, (2) between Reports in an App and finally (3) the Power BI Web Portal to help users finding the Apps and Reports. You will be amazed how much actually can be done, to give your users a better experience. We will cover topics like, Power BI Service navigation, Linking from an Intranet, Setting up Dashboards, The new App navigation, Drillthrough, Buttons, Bookmarks and much more.
Speaker(s): Just Blindbaek,
Abstract:
Sorry to break the news but the world is not flat and neither is business data. Data modeling is an essential skill in Power BI design and hard problems require creative solutions. In this session, we will enumerate common challenges and demonstrate modeling techniques to resolve them. Session topics: implementing star and snowflake schema essentials, role-playing tables, many-to-many and bi-directional filters, working without relationships, disconnected lookup tables and calculation groups. We will also discuss the composite models and the future of BI data modeling.
Speaker(s): Paul Turley,
Abstract:
Have you ever wanted to know exactly how SQL Server stores data for temporary structures, such as for instance the spooled data in a Table Spool or Index Spool operator? No? I don’t blame you. It’s a bit like wanting to know who watered the rubber tree that produced the rubber your tires are made off before you get in the car to drive to work. You really don’t need it. But you might still WANT to know. I did. And I figured it out. Without ever touching the debugger (I’m a simple soul, that stuff is much too complex for me!), I figured out how I could look at the exact storage structures SQL Server creates and uses to store data in Table Spool and Index Spool operators. If you are willing to commit to a fast-paced and deep internals session that is guaranteed to teach you exactly zero actually useful information, then this is the session for you.
Speaker(s): Hugo Kornelis,
Abstract:
With the multitude of isolation levels, concurrency models, and specialist technologies available in SQL Server, it is no surprise that transaction throughput and correctness can be directly correlated to the ability and knowledge of the person that wrote the code. In this session, we will reveal how SQL Server concurrency and correctness often goes wrong, how we can avoid this, and how we can use our knowledge to design and develop for optimal server throughput for our applications and processes using tips and tricks gained from real-world scenarios. We will cover SQL Server’s traditional locking model, In-Memory OLTP, Columnstore, Delayed Durability, and many other technologies and techniques you can use to make your transactions more robust.
Speaker(s): Mark Broadbent,
Abstract:
Of course SQL Server (Management or Azure Data Studio) offers you a list view of the agent job history. But wouldn't it be nice to have a graphical overview of job durations and how they develop? This session is for DBAs and R newbies alike: In one hour we'll develop a dashboard-like overview of your agent jobs' and their durations with the R language. We'll work our way from finding the right system tables to use, generating one graph per job with the help of R, to adding that little trend line to every one of them. After creating it in RStudio, we'll eventually adapt our script to run in SSMS/ADS just as fine. Once finished, no additional tools are needed, no additional €€ spent.
Speaker(s): Thomas Hütter,
Abstract:
Most modern programming environments offers exception handling in some form, and SQL Server provides the popular TRY-CATCH concept. However, error handling in SQL Server is not as straightforward as one may wish, but it is marred with inconsistencies and surprises. This session starts off by displaying the some of the surprises you can encounter, both when you use TRY-CATCH and when you don't. The session presents a recipe for writing CATCH block where focus is on keeping things simple and you will learn why it is not a good idea to make your error handling "fancy", although it may seem to be a good idea in theory. The session also covers a few things to think of on client level.
Speaker(s): Erland Sommarskog,
Abstract:
Common Data Model as the foundation of Power BI Dataflows and as part of the Open Data Initiative with SAP and Adobe, seems to be a pretty good move from Microsoft. We want to take a closer look to this approach. In this session we show how the Common Data Model will allow you to combine Self-Service ETL and Corporate Data Engineering. We will show you how Power BI and more specialised tools like ADF, DataBricks etc. can work together on the Azure Data Lake with one common model. We than extend this and show, what opportunities this standard brings to you, when we unleash the possibilities you have on managing Data Quality and Governance. We also will have a look in how you integrate CDM in a DataOps Methodology.
Speaker(s): Oliver Engels,
Abstract:
In this session we will cover SQL Server running as a managed service (Paas) and will get to know it so that we can consider it as a possibility for our developments
Speaker(s): Javier Villegas,
Abstract:
Partitioning is a great feature of SQL Server and since SQL 2016 you can use it in Standard Edition, too. See in this session the benefits of partitioning for ETL, maintenance and backup / restore. The main area of application for partitioning is the optimization of load paths for complex DWH solutions and maintenance of large databases (statistics, indexes, backup, restore).After a brief introduction to partitioning, this session will focus on the key benefits of the above topics
Speaker(s): Uwe Ricken,
Abstract:
Love it or hate it, you just can't ignore DAX, the amazing language of Power BI. In this session, I'll show you it's true power and how knowing it can even make you completely rethink your data models. No more hundreds of columns and weird aggregations in the database. With the Power of DAX, you can now achieve much more sophisticated and powerful calculations, while keeping it simple at its core. I'll show you real-world applications of DAX and lots of tips and tricks that you will be able to use quickly and with little effort!
Speaker(s): Pedro Reis,
Abstract:
We were in the lucky situation to actively accompany several customers on their POCs and early developments of Data Warehouse projects using Azure Synapse Analytics. Based on those experiences we will take you with us on a journey from the first steps into this new offer to use cases and scenarios from existing projects. Let's explore the current set of features, childhood diseases left behind and potential for improvement.
Speaker(s): Gabi Münster,
Abstract:
This session will show how to create and use parameters in Power Query. From basic to advanced techniques - from static to dynamic parameters and functions.
Speaker(s): Boriana Petrova,
Abstract:
I will talk about new intelligent query processing features in SQL Server 2019. The features that will be described are adaptive joins, interleaved execution, memory grant feedback, table variable deferred execution, batch mode on rowstore, T-SQL scalar UDF inlining and approximate count distinct. The presentation will end with extensive demo.
Speaker(s): Dean Savović,
Abstract:
Have you ever wondered what makes Power BI so fast and powerful when it comes to performance? So powerful, that it performs complex calculations over millions of rows in a blink of an eye. In this session, we will dig deep to discover what is “under the hood” of Power BI, how your data is being stored, compressed, queried, and finally, brought back to your report. After the session, you will get a better understanding of the hard work happening in the background and appreciate the importance of creating an optimal data model in order to get maximum performance from the Power BI engine. Finally, you will see a real use-case demo showing how the Power BI data model was reduced by 90%!
Speaker(s): Nikola Ilic,
Abstract:
Can we store our Connectionstrings or BlobStorageKeys or other Secretvalues somewhere else then in Azure Data Factory(ADF)? Yes you can! You can store these valuable secrets in Azure Key Vault(AKV). But how can we achieve this in ADF? And finally how do we deploy our DataFactories in Azure Dev Ops to Test, Acceptance and Production environments with these Secrets ? Can this be setup dynamically? During this session I will give answers on all of these questions. You will learn how to setup your Azure Key Vault, connect these secrets in ADF and finally deploy these secrets dynamically in Azure Dev Ops. As you can see a lot to talk about during this session.
Speaker(s): Erwin De Kreuk,
Abstract:
OK, you got the message: Extended Events is the way to monitor SQL Server from now on. However, you feel overwhelmed by XML shredding and the simplest of tasks seems impossible. Fear not: in this demo intensive session I will show you how to tackle the most challenging tasks without writing a single line of code. I will use the open-source tool XESmartTarget to audit logins, find unused objects, capture and notify deadlocks and much more. Stop doing things the hard way! Join me and learn how XESmartTarget can do all the heavy lifting for you.
Speaker(s): Gianluca Sartori,
Abstract:
If you want to accelerate the testing of your BI solutions, the best strategy is the automation of your tests with the help of a dedicated framework. During this session, we’ll take a look to the features of the open-source framework named “NBi” (www.nbi.io). This framework is providing support for automated tests on the fields of databases, cubes, reports and ETLs, without the need of .Net skills. The demos will show us the best approaches to quickly and effectively assert the quality of BI developments. We'll go a step further, generating the tests by an interesting system of templates and test-cases sources.
Speaker(s): Cédric Charlier,
Abstract:
In this session, everything will be around changing your daily business from an on-premise environment to a cloud world... new challenges, new tasks, and new options... in order not to struggle too often, you need to create new knowledge and learn a lot of new stuff, so I want to show several ways to update your skills and what you really need to become cloud database admin.
Speaker(s): Björn Peters,
Abstract:
As Data is key, visualising said data is even more important. We want our message to be understood with ease, and merely with a couple of glances. Hence making sure the receiving party can do so with ease will be vital to our success. During this session, we'll go through some steps on how to maximise the potential of data visualisations. Starting at choosing the right types of visualisations, and which colour palettes are good matches for your message, we'll also make sure that our designs are as inclusive as we can possibly make them. Wrapping up with a few common use cases, you’ll definitely pick up a few new things to take home with you. Walking out of this session, you can expect to have a decent understanding on a few common design principles for your data visualisations and reports.
Speaker(s): Benni De Jagere,
Abstract:
In human brains, synapses are responsible to connect information pieces together. Over time, our knowledge increases when more and more synapses are connected together. Following that analogy, Azure Synapse Analytics wants to connect (all) information silos together and provide a single point of analytics. Join this session, if you want to hear about the building blocks of Azure Synapse Analytics, how Data Engineers and Data Scientists and even BI developer can work together in a single service and see how easy it is to start with Synapse Analytics!
Speaker(s): Wolfgang Strasser,
Abstract:
Some new object and configuration option of our databases can enhance the efficiency of our monitoring and tuning. This session will show some new object (DMO) introduced in the new platform and a couple of new options that can change our approach to the monitoring, maintenance and tuning activity.
Speaker(s): Gilberto Zampatti,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: https://www.linkedin.com/in/pturley
Contact: http://www.sqlserverbiblog.com
Paul is a Principal Consultant for Pragmatic Works, a Mentor and Microsoft Data Platform MVP. He consults, writes, speaks, teaches blogs about business intelligence and reporting solutions. He works with companies around the world to model data, visualize and deliver critical information to make informed business decisions; using the Microsoft data platform and business analytics tools. He is a Director of the Oregon Data Community PASS chapter user group, the author and lead author of Professional SQL Server 2016 Reporting Services and 14 other titles from Wrox Microsoft Press. He holds several certifications including MCSE for the Data Platform and BI.
LinkedIn: https://ar.linkedin.com/in/javiervillegas
Contact: http://sql-javier-villegas.blogspot.com.ar/
Javier Villegas is a Database Administrator Manager for Mediterranean Shipping Company. Javier has more than 20 years working with SQL Server on every version from 6.5 to SQL Server 2019, Including SQL Azure Database and SQL Azure Managed Instance. His specialization is Administration, Performance Tuning and High Availability. He is a Microsoft MVP in Data Platform. Javier is a frequent speaker in conferences and events such as SQL Saturday , PASS Virtual Groups, 24 Hours SQL PASS , vOpen(NetConf), GroupBy and DataPlatformGeeks. @sqlargentina
LinkedIn: http://be.linkedin.com/in/cedriccharlier
Contact: http://seddryck.wordpress.com
Cédric is a talented architect and Data Platform MVP active in the domain of Business Intelligence and Data warehousing. He has more than 10 years of successful experiences with SQL Server in European industrial groups and services companies. Driven by quality and reliability, he is the main developer of an open-source solution for testing BI solutions (cubes, etl, reports) named NBi (www.nbi.io). Cedric also advocates for the introduction and general usage of agile practices in BI’s world.
LinkedIn: http://www.linkedin.com/profile/view?id=270775013amp;trk=tab_pro
Contact: http://www.sqlmaster.de
Uwe Ricken is working with IT systems since the 90’s. The primary passion for developments with Microsoft SQL Server expanded in 2007 with his engagement as a DBA for Deutsche Bank AG in Frankfurt am Main. After 6 years of operational experiences as a DBA and over 14 years as a developer of complex database models he achieved the “Microsoft Certified Master – SQL Server 2008” certification which “was” the highest technical certification. In the same year he earned his first award as a Data Platform MVP for his support to the Microsoft SQL Server community in Germany and Europe. Uwe Ricken is a speaker on many international conferences and events and preferred topics are “Database Internals”, “Indexing” and “Development”.
LinkedIn: https://www.linkedin.com/in/gabimuenster/
Gabi Münster is working as a Business Intelligence consultant and team lead and brings in her experience with SQL Server, data warehousing, relational and multidimensional database design and implementation, report and dashboard design, and Master Data Services, as well as project management into the community as a regional PASS Local Group lead. She is also passionate about motivating other women to start a technical career and therefore initiates and supports "Women in Technology" events. Apart from SQLSaturdays, she also spoke at SQLBits, SQL Nexus, Tuga IT, and 2015's and 2017's PASS Summit. In October 2017 Gabi received her first Data Platform MVP award.
LinkedIn: https://www.linkedin.com/in/bennidejagere/
Contact: https://bennidejagere.com
Benni De Jagere is a Senior Data Insights Consultant at Realdolmen, with a strong focus on the Microsoft (BI) Stack. On a daily basis he turns (large amounts) of coffee into insights for customers, and references witty British comedy way too often. Overly enthusiastic about anything data related, he’s trying hard to keep up with all things new and shiny. Rumour has it that he's also involved with a ragtag band of data enthusiasts, enjoying themselves whilst organising cool community things. They go by the name of .. dataMinds!
Time ago (a lot of time ago…) an excellent IT pro brought me with him and became my Mentor in the IT wonderland…it was a world full of mainframes… I met the Relational theory when there were no commercial RDBMS, and I was spellbound by that “magic”. When Microsoft appeared in the IT market, I felt finally which trek I had to follow. I’m still walking on such road, and in my rucksack I’ve ben putting some other stuff (like SharePoint, for example). My sole regret: I’ve left the College to consecrate all my time to my job; curiously, since then, I’ve never stop learning…
LinkedIn: https://www.linkedin.com/in/pedrogoncalvesreis/
Contact: https://www.meetup.com/Power-BI-Portugal
Pedro is a Microsoft BI Stack Professional and enthusiast, with a passion for Power BI, SSAS, Excel and DAX. During his career he has coordinated multiple teams, and the development of thousands of Power BI Reports. He is the Leader of the Power BI Portugal Meetup group and the Porto Power BI User Group and an active Speaker at events like Power Platform World Tour, SQL Saturday, Porto Data, and meetups.
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: http://nl.linkedin.com/in/hugokornelis
Contact: http://sqlblog.com/blogs/hugo_kornelis/default.aspx
Hugo Kornelis is an established SQL Server community expert who spends a lot of time at various conferences. He is author of "the Execution Plan Reference" (sqlserverfast.com/epr), blogger, technical editor of Grant Fritchey's "SQL Server Execution Plans, 3rd edition" and some other books, and Pluralsight author. He was awarded SQL Server MVP and Data Platform MVP 12 times (2006 - 2016, and 2019-present). When not working for the community, he is busy at his day job: freelance database developer/consultant. Hugo has over 20 years of SQL Server experience in various roles. He loves to write and tune complex queries, but he also has a strong database design background. When not working for the community, he is busy at his day job: freelance database developer/consultant. Hugo has over 20 years of SQL Server experience in various roles. He loves to write and tune complex queries, but he also has a strong database design background.
LinkedIn: https://www.linkedin.com/in/dsavovic/
Contact: http://www.savovic.com.hr
Dean is Senior DBA practicing SQL Server since version 7.0 and main areas of interest are performance tuning and troubleshooting SQL Server database. He speaks at Microsoft Windays Croatia, ATD Croatia, SSWUG, KulenDayz Croatia, SQL Saturday events, etc... Primary focus is on OLTP databases with occasional adventures with Business Intelligence. He finished Faculty of Electrical Engineering and Computing and MBA on Faculty of Economics in Zagreb. His premise was that it is very useful to combine technical knowledge with management process knowledge that help us in our everyday work. He works in SPAN which is specialized in data management field on Microsoft SQL Server.
LinkedIn: http://www.linkedin.com/pub/wolfgang-strasser/7b/912/22b
Contact: http://workingondata.wordpress.com/
Wolfgang Strasser creates solutions based on the Microsoft Data Platform tools in his day-to-day job as Business Intelligence consultant. Either using SQL Server Database Engine, SSIS, reporting with SSAS and SSRS, implementing Power BI solutions or cloud tools for data analysis - the data-tools-landscape is broadening every day! Based on his professional careers as a software developer he likes to work on structured development processes. Wolfgang shares his knowledge with the community at many national and international events. For his community work, Wolfgang has been awarded with the Microsoft MVP Award for Data Platform in October 2015
LinkedIn: https://www.linkedin.com/in/bj%C3%B6rn-peters-b26b5813b/
Contact: http://www.sql-aus-hamburg.de
I've started with SQL Server 6.5 but only as a sys-admin and not as DBA. Later I'd worked as a full DBA with SQL Server 2000 and my love to SQL Server started. In 2015 I'd got more interested in SQL PASS and tried to speak for the first time... the main part of my job is to work as DB-Admin and solution architect but I'm trying to widen my horizons. In 2016 I've visited and volunteered at the German SQL Saturdays und SQLGrillen and since October 2016 I'm the organizer of Azure Meetup Hamburg.
LinkedIn: https://www.linkedin.com/in/borianapetrova/
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.
LinkedIn: https://de.linkedin.com/in/derfredo
Contact: https://sqlfredo.wordpress.com/
Thomas holds a degree in Business Administration, but has been a data explorer and a developer at heart ever since the days of dBase and Turbo Pascal. He touched his first SQL Server at V6.5 and used covering indexes before they became a feature. Thomas has been developing in Navision/Dynamics/Business Central systems for quite some time (since 2001, one year before MS acquired Navision), joined PASS in 2006 and got his hands on R in 2014 (the year before MS bought Revolution Analytics). He has worked for ISVs as well as end-user companies, as a developer, consultant, accidental DBA and is an author for data-related articles as well as a speaker at SQL events across Europe.
Contact: http://www.ssis-components.net
Oliver Engels is CEO of oh22data AG, a Microsoft Gold Partner in Germany specializing in CRM and BI. His special interests are Azure, Data Governance and Integration, Visualisation Tools like SSRS, Power BI, Tableau, R, and SharePoint. He has worked with SQL Server since version 6.5 and is a founder and Board member of PASS Germany, a PASS Regional Mentor, and runs the Frankfurt PASS Local Group. For more than seven years he is a Microsoft Data Platform MVP and a Microsoft pTSP.
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.
LinkedIn: https://www.linkedin.com/in/nikola-ilic-data-mozart
Contact: https://data-mozart.com
I'm making music from the data! PowerBI and SQLServer addict, MCT, Pluralsight Author, blogger, speaker...Interested in everything related to data - always eager to extract valuable info from raw data in the most effective way. Multi-year experience working with (predominantly) Microsoft Data Platform (SQL Server, SSAS, SSIS, SSRS, and Power BI). Father of 2 and true football (and Barca) fan!
LinkedIn: https://nl.linkedin.com/in/erwindekreuk
Contact: https://erwindekreuk.com
Erwin de Kreuk is a passionate and very experienced Microsoft Solution Architect. Working as a Principal Consultant/ Lead Data and AI for InSpark, #1 Microsoft Partner of the Year in the Netherlands. Speaking at different national and international data community events. He is working in the world of data on the Microsoft Platform for last 12 years and the last 4 years he has shifted his focus to the Azure Platform. Answering complex customer cases and technical issues are part of his day-to-day work. In addition to this work, he is a member of the Technology Board within InSpark and leads a team of highly experienced Data Expert in the field of Microsoft Data Platform.
LinkedIn: http://www.linkedin.com/profile/view?id=5113407
Contact: http://blog.justb.dk
Independent BI consultant with extensive experience in all phases of BI development on Microsoft SQL Server, Azure and Power BI. Founder and coordinator of Microsoft Business Intelligence Professionals Denmark (MsBIP.dk) and Power BI UG Denmark (PowerBI.dk). Is a Microsoft Certified Trainer at Orange Man.
LinkedIn: http://www.linkedin.com/in/retracement
Contact: http://tenbulls.co.uk
Mark Broadbent is a Data Platform MVP and SQL Server MCM with more than 20 years of experience working with SQL Server and principal of SQLCloud, a consultancy specializing in concurrency control and highly available solutions. He is the founder of the UK's SQLSaturday Cambridge (its first and largest), SharePoint Saturday Cambridge, the Hybrid Virtual Chapter and the East Anglia SQL User Group.
The following is a list of sponsors that helped fund the event.