To get to the next level of understanding your database, to reach an intimacy with query plans so that you really know what’s going on, to be able to address performance issues with confidence, you need to picture things differently. This workshop will demonstrate database internals without a computer, helping you learn what happens when…
Query tuning within SQL Server can be a tough skill to master. The new tooling released with SQL Server 2016 and 2017 changes how you identify poorly performing queries, troubleshoot their behavior, and tune the queries, all a little easier. This workshop teaches new techniques for tuning queries using all the new tools introduced in…
I’ve been immersed in the world of our favorite data platform as an end user, developer, DBA, and performance analyst since 1997. I have observed, developed, and broken countless bad habits and discovered many best practices through numerous experiments, trial and error, community interaction, and direct access to the product team at Microsoft. In this…
Itzik-BenGan This seminar covers advanced aspects of T-SQL querying and programming with a performance-centric focus. The seminar demonstrates practical uses of T-SQL features, with optimized and polished solutions, many of which were developed by the speaker. The seminar also covers the newest additions to T-SQL in SQL Server 2016 and 2017, and some of the…
Kalen Delaney We all know that the answer to almost any SQL Server tuning question is “It Depends!” In this seminar, I’ll tell you what you need to know in order to figure out what it actually depends on! How can you answer these “It Depends” questions in your own environment? We’ll look at what…
Niko Neugebauer Learn practical Columnstore Indexes tips and tricks such as which type to use, how and when to use Disk-Based vs. In-Memory or Clustered vs. Nonclustered, how to load data into Columnstore in the most efficient way, and how to get the best performance possible out of the Batch Execution Mode. With a nod…
