Aaron Bertrand

In this full-day seminar, you will gain core knowledge about how SQL Server works, along with a host of information covering memory usage, the optimizer, indexes, statistics, and table design.

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.

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.

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.

Come to this session to learn how bad habits develop, the problems they lead to, and how you can avoid them.

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.

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.