Hugo Kornelis

Information & Communications Technology

SQL Server Azure SQL Azure SQL Database Azure SQL DB SQL SQL Server DBA performance tuning Indexing

Zeewolde, Flevoland, Netherlands

Powerful T-SQL improvements that reduce query complexity

We’ve all dealt with nightmare queries: huge, twisted monsters that somehow work, despite being ugly and unmanageable. The time has come to tame these beasts, and the solution is available now, in SQL Server 2012.
New T-SQL functions offer out-of-the-box solutions for many problems that previously required complex workarounds. Paging, Running totals, Moving aggregates, YTD, and much more comes at the power of your fingertips in SQL Server 2012. The only thing you need to do is learn the syntax. And that is exactly what this session is all about: a thorough description and explanation of the syntax, and loads of demos to demonstrate how you can use all these new features.
Attend this session to boldly take SQL Server where it has never gone before!


Hugo Kornelis

I make SQL Server fast (.com)

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 was awarded SQL Server MVP and Data Platform MVP 12 times (2006 - 2016 / 2019 - now).

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

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

Hugo's full speaker profile