Aaron Bertrand

Aaron (@AaronBertrand) is a Product Manager 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 community moderator for the Database Administrators Stack Exchange. Aaron's blog focuses on T-SQL bad habits and best practices, as well as coverage of updates and new features in Plan Explorer, SentryOne, and SQL Server.

Articles by Aaron Bertrand

Following up on Grouped Concatenation in SQL Server and Grouped Concatenation: Ordering and Removing Duplicates, Aaron Bertrand provides four real-world examples where grouped concatenation allows you to avoid the monotony of cursors and while loops.
August 29, 2014 | Aaron Bertrand | grouped concatenation, T-SQL 0
Aaron Bertrand & Grant Fritchey share an ice cold video for the #iceBucketChallenge, trying to help raise awareness for #ALS, and challenge some colleagues to follow our lead.
August 21, 2014 | Aaron Bertrand | SQLFamily, SQL Sentry, ALS 0
Aaron Bertrand uses a T-SQL Tuesday theme to demonstrate a use case for the SQL_VARIANT data type that you may not have considered: Conditional ORDER BY.
August 12, 2014 | Aaron Bertrand | SQLFamily, T-SQL, Transact-SQL 1
Aaron Bertrand reveals that the Books Online content for SQL Server 2014 is finally fully available, and shows two ways to perform installation.
Aaron Bertrand provides links to his recent presentations (one with colleague Kevin Kline) at SQL Bits XII.
This month's T-SQL Tuesday deals with SQL Server assumptions, and there is certainly no shortage of those to talk about. In this post, Aaron Bertrand lays out his five favorite assumptions people make about SQL Server.
Back in 2010, we first released SQL Sentry Plan Explorer, a free application for query tuning through deep but intuitive execution plan analysis. This post was created to provide a series of sample plans to help you learn the tool or to demonstrate it to others.
I wanted to talk about two new features in SQL Sentry Plan Explorer: Plan obfuscation, where you can hide sensitive information in your plans before sharing them, and custom layouts, a way to take complete control over the visual representation of your graphical plans.

Get the best SQL query analysis and optimization tool – free!

Plan-Explorer-logo-RGB-800px
  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More

Get a Free 2-Week Trial

Start your free trial of any of our products today.

Free Trial

2-Week Trial