Aaron (@AaronBertrand) is a Product Evangelist at SentryOne with industry experience dating back to Classic ASP and SQL Server 6.5. He is editor-in-chief of the performance-related blog, SQLPerformance.com, and serves as a moderator for Q & A sites answers.SQLPerformance.com and dba.stackexchange.com.

Sessions

This presentation will cover all of the new engine and tools features coming our way in the next major version of SQL Server.
This session will explore a handful of T-SQL practices - why they happen, why they're bad, and how we can work around them.
An overview of the engine and tools changes coming in SQL Server "Denali" - including some of the features that will stop working.
This session will cover a collection of minor bad habits that can occasionally lead to major problems, and a set of best practices that you should always have in mind.
Come to this session to learn how bad habits develop, the problems they lead to, and how you can avoid them.
Come learn how bad habits develop, what kind of problems they can lead to, and how you can avoid them - leading to more efficient code, a more productive work environment, and - in a lot of cases – both.
Many triggers are inefficient and violate best practices, but it doesn't have to be this way. Join this session and learn how to improve your triggers and keep them off the list of potential scapegoats for your SQL Server performance woes.
Discover the ins and outs of some of the newest capabilities of our favorite data language. From JSON to COMPRESS/DECOMPRESS, from SESSION_CONTEXT() to DATEDIFF_BIG(), and new query hints.
In this session, you will learn about various anti-patterns and why they can be bad for performance or maintainability. You will also learn about best practices that will help you avoid falling into some of these bad habits.
Discover the ins and outs of some of the newest capabilities of our favorite data language, and walk away with a long list of reasons to consider upgrading to the latest version - or the next version.
In this demo-packed session, you’ll learn practical tips and tricks for SQL code tuning from experienced SQL Server MVPs Aaron Bertrand and Kevin Kline as they walk you through some of the most problematic and troublesome SQL coding problems.