4th - 7th May 2016

Liverpool

hugo_kornelis.jpg

Hugo Kornelis

Hugo Kornelis is an established SQL Server communiity expert who spends a lot of time at various conferences. He is also a blogger, technical editor of a variety of books, and Pluralsight author. He is a SQL Server MVP since 2006.

 

When not working for the community, he is busy at his day job: freelance database developer/consultant.

 

Hugo has over 18 years of SQL Server experience in various roles. He has a strong database design background, but also loves to write and tune complex queries.

http://sqlblog.com/blogs/hugo_kornelis/default.aspx
Hugo Kornelis has submitted 4 sessions for SQLBits XV, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

Have you ever looked at estimated rowcounts in an execution plan in utter amazement, wondering where on earth that estimate was coming from? If so, this is the right session for you. Attend this session and learn exactly how those estimates work.
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.
Contrary to popular belief, Third Normal Form is NOT good enough, and higher Normal Forms are NOT hard. This session gives a clear and easy to understand overview of higher Normal Forms. No serious database developer can afford to miss this session.
Learn to easily create running totals, moving aggregates, paging schemes, and much more. This demo-rich session will show you how to exploit all that SQL Server 2012’s fantastic set of windowing function enhancements have to offer.

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.
Contrary to popular belief, Third Normal Form is NOT good enough, and higher Normal Forms are NOT hard. This session gives a clear and easy to understand overview of higher Normal Forms. No serious database developer can afford to miss this session.