Itzik Ben-Gan Itzik-BenGan Workshop description This seminar covers advanced T-SQL querying and query tuning topics. It covers powerful querying tools like window functions, APPLY, OFFSET FETCH, and others; describing how they are optimized, and how you can use them to solve common practical T-SQL querying tasks. The seminar covers both classic query tuning topics like…
Bob Ward Anna Hoffman Workshop description In this one day, demo-heavy, scenario-driven workshop, members of the SQL engineering team will help you translate your existing SQL Server expertise to Azure SQL including Azure SQL Database and Azure SQL managed instance. At the end of the day, you should have a foundational knowledge of what to use…
Amit Bansal Workshop description One fine day you realize that you have to start tuning SQL Server for better performance. The need might have arisen from a recent performance issue, or the barrage of support tickets that are filling your inbox, or maybe your boss assigned this to you after realizing that SQL Server performance…
Greg Low Workshop description Power BI is an amazing tool. It’s so easy to get started with. But when you need to implement it in an enterprise, it’s not so obvious how it should fit in. There are many ways to do this but in this workshop, Greg will show you how he implements these…
Kamil Słomka Jakub Bilski Jakub Bilski Opis warsztatu W pracy z miarami kalkulowanymi w języku DAX oraz Power BI często dochodzimy do momentu w którym liczba miar w naszym modelu zaczyna gwałtownie rosnąć, a co gorsza zmuszeni jesteśmy wielokrotnie powielać tę samą logikę, co utrudnia utrzymanie rozwiązania. Na szczęście z pomocą przychodzą nam Calculation groups…
Rob Farley Rob Farley Workshop description I can’t be there in person this time to explain internals using flip charts, so I’ll write on the computer screen instead, drawing diagrams to explain what’s going on with inside your indexes and query plans, and what I look for to make queries run faster. We’ll explore a…
Markus Ehrenmueller-Jensen Markus Ehrenmueller-Jensen Workshop description Power BI Desktop is Microsoft’s free tool for self-service BI. It’s updated every single month with exciting new features and Gartner declared it since 2019 to THE leading BI Tool (which led Tableau and Qlik behind). In this full day workshop, we take a look on Power BI Desktop’s…
Michał Gołoś Michał Gołoś Opis warsztatu Snowflake to analityczna platforma dostarczana jako usługa (SaaS/DWaaS) w chmurze (Azure, AWS, GCP). Snowflake ma na celu zapewnienie hurtowni danych, która jest szybsza, łatwiejsza w użyciu i znacznie bardziej elastyczna niż tradycyjne podejścia. W przeciwieństwie do innych ofert, to zupełnie nowa hurtownia danych zbudowana od podstaw z myślą o…
Dejan Sarka Dejan Sarka Workshop description Many times, you wish you could have some more powerful tool than the Transact-SQL (T-SQL) language for working with data. You might need to enable your users to use word search in your string columns or in Office documents to give them similar experience like they get when they…
Hugo Kornelis Workshop description For troubleshooting slow queries, looking at the execution plan is a good starting point. But sometimes, just looking at the plan does not help. Sometimes you need to dig deeper. In this full-day workshop, you will learn everything you need to be take your understanding of execution plans to the next…
