Aaron Bertrand

Aaron (@AaronBertrand) is a Data Platform MVP 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. 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

Aaron Bertrand reveals a new build of SQL Sentry Plan Explorer, updated to support the new add-in model introduced with the latest SSMS.
Continuing the EntryLevel challenge, Aaron Bertrand discusses optimizing the kitchen sink procedure with dynamic SQL and, optionally, OPTION (RECOMPILE).
Aaron Bertrand shares his PowerPoint files and SQL samples from his Bad Habits and tempdb sessions at SQLDay in Wrocław, Poland.
May 18, 2016 | Aaron Bertrand | Community, Slide Decks 3
Aaron Bertrand explains some of the more common acronyms you might see flung around in blog posts, Connect items, and Knowledge Base articles.
Aaron Bertrand cautions about using DROP COLUMN without immediately rebuilding the table. Wasted space is a concern; data loss is worse.
April 25, 2016 | Aaron Bertrand | SQL Server 19
Aaron Bertrand shares his slides and demos from his two SQL Intersection.
As part of his #BackToBasics series, Aaron Bertrand gives four quick tips on using date and time values effectively in SQL Server.
April 6, 2016 | Aaron Bertrand | #BackToBasics 4
After the first Visual Studio 2015-based SSMS build is released, Aaron Bertrand talks about the changes you'll notice, and the changes you won't (yet).
Ken Van Hyning, Microsoft's new Engineering Manager for SQL Server Client Tools, fields a few questions from SQL Sentry's Aaron Bertrand.
Aaron Bertrand talks about some of the upcoming changes to telemetry and other privacy settings in SQL Server 2016.
Following up on an earlier post about metadata, Aaron Bertrand reveals a few more of his sources for discovering changes in SQL Server.
Aaron Bertrand provides some insight into a new feature in SQL Sentry v10, and coming soon to Plan Explorer: Index Analysis.
Aaron Bertrand explains some of the nuances of the latest Management Studio preview, with a visual tour through installation.
Aaron Bertrand continues his Back to Basics series, this time discussing SQL Server's synonym and how it can be used.
March 2, 2016 | Aaron Bertrand | #BackToBasics, T-SQL, SQL Server 10
Aaron Bertrand talks about the sessions he'll be giving at several SQL Server events around the world in the first half of 2016.
February 16, 2016 | Aaron Bertrand | SQLSaturday, SQLintersection 0

Top Categories

See all

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