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…
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…
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…
