Toggle navigation
Home
SQLBits 2023
Sponsors
Sponsors
Sponsorship
FAQ
Videos on Demand
It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript,
click here for a page that doesn't require javascript
.
Aaron Bertrand
Home
Sessions & Content
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
Whats new in SQL Server "Denali"?
This presentation will cover all of the new engine and tools features coming our way in the next major version of SQL Server.
T-SQL : Bad Habits to Kick
This session will explore a handful of T-SQL practices - why they happen, why they're bad, and how we can work around them.
Whats New in Denali-DB engine and client tools
An overview of the engine and tools changes coming in SQL Server "Denali" - including some of the features that will stop working.
T-SQL : Bad Habits & Best Practices
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.
T-SQL : Bad Habits & Best Practices
Come to this session to learn how bad habits develop, the problems they lead to, and how you can avoid them.
T-SQL : Bad Habits & Best Practices
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.
Five Ways to Write More Effective Triggers
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.
New T-SQL capabilities in SQL Server 2016 & Azure
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.
T-SQL : Bad Habits & Best Practices
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.
T-SQL : Bad Habits and Best Practices
In this session, you will learn about several bad habits, how they develop, and how you can avoid them.
New T-SQL Capabilities in SQL Server 2016 & v.Next
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.
Practical T-SQL Tips & Tricks to coding problems
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.