Sammy Deprez Henk Boelman Opis warsztatu: Azure ML is more than just a studio. It’s a way to manage your computing, datasets, ML models, and code. In the full-day workshop, we will review the three different ways of building ML models (Designer, AutoML, and Notebooks). You will learn how to build and train pipelines that…
Denny Cherry Opis warsztatu: In this all day session on Microsoft SQL Server we will be learning about how Microsoft SQL Server works and what needs to be done to keep it up and running smoothly when you don’t have a full-time database administrator on staff to help you keep it running. In this session,…
Alberto Ferrari Opis warsztatu: When you create a Power BI report, you might hit some performance issues when you have a large amount of data, complex data models, or complex DAX expression in your measures. The first goal of this tutorial is to discover possible bottlenecks analyzing the execution of DAX calculations using tools such…
Brent Ozar Opis warsztatu: You’ve downloaded sp_Blitz, sp_BlitzIndex, and sp_BlitzCache from the First Responder Kit,and you’ve run them a few times. You know there’s a ton of advice in there, but…it’s kindaoverwhelming. Where should you even start? What should you tackle first? Are thereparameters that would help diagnose your specific situation? In this one-day course,…
Mikey Bronowski Opis warsztatu: Czy jesteś administratorem baz danych, który większość czasu spędza na naprawianiu niespodziewanych incydentów? Czy chciałbyś mieć więcej czasu, by móc skupić się na swoim środowisku, tak aby ograniczyć nieplanowane zadania? Być może nie masz czasu na znalezienie wrażliwych punktów w swojej infrastrukturze. Byliśmy w tej sytuacji i dlatego chcemy podzielić się…
Dejan Sarka Opis warsztatu: 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 search the…
Just Blindbæk Opis warsztatu: Big data, Databricks and now also Synapse Analytics. Microsoft really focuses on how to put together BI and DWH solutions that can handle huge volumes of data. But what about the „ordinary” solutions in the SME market? How do we put together a sensible and affordable Azure solution for them? Where…
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…
