Hugo Kornelis is an established SQL Server Community expert. He writes, blogs, speaks, tech edits, and researches, focusing mostly on SQL Server perofmrance and execution plans. He was the technical editor for the third edition of Grant Fritchey's "SQL Server Execution Plans". In 2018 he started a project to document all behaviour of SQL Server execution plans at his website, "the SQL Server Execution Plan Reference" (https://sqlserverfast.com/epr)

When not working for the community, Hugo is busy at his day job: freelance database developer./consultant. Hugo has 20 years of experience on SQL Server in various roles. He has a strong database design background but has since specialized into query tuning and execution plans.
Hugo Kornelis has submitted 3 sessions for SQLBits 2019, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

Hash Match - the most versatile operator in execution plans. In this deep-dive session you will learn how Hash Match performs its many logical operations; how it uses memory, what happens when it spills and much more.
SQL Server 2019 includes new query processing features such as batch mode on rowstore, memory grant feedback, approximate query processing, and more. How do these work? Are they as good as Microsoft wants us to believe?
Execution plans can reveal why a query is slow. But they can be hard to read, especially for complex queries. In this session you will learn how to obtain execution plans, and how to start reading and understanding them.

Sessions

Previous Sessions

This session will present you with a fascinating behind-the-scenes deep-dive view of the new column store index feature. How do column store indexes work? How are they built? And how can they yield such enormous performance boosts to some workloads?
In this demo-rich session, Hugo Kornelis shows how the full syntax of MERGE enables more than just synchronizing data. You'll get an overview of all the available options, plus a few surprising pitfalls you may not be aware of.
Indexes are the best instrument for query optimization. But what kind of indexes and on what columns? The key to answering those questions is understanding how indexes are stored and used by SQL Server. And that is exactly what this session is about.
T-SQL user-defined functions may appear to be a good tool for code encapsulation and reuse, but they can have a dramatic impact on performance. In this session, you'll see why they slow down your queries, and how you can avoid this performance hit.
Many people think that normalization stops at Third Normal Form. But there are lots of higher normal forms. And they are not as complex or as irrelevant as often claimed. If you want to design better databases, then come attend this session!
Hugo_Kornelis251001.jpg