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, 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

Last week's Visual Studio outage has been largely blamed on the cardinality estimator, but Aaron Bertrand says the query itself has a share of the blame.
February 9, 2016 | Aaron Bertrand | Cloud, SQL Server, Visual Studio 5
Aaron Bertrand shows why and how you should upgrade your SSMS 2016 client from 13.0.11000.48 to 13.0.11000.78.
Aaron Bertrand describes a few different causes for a symptom you might describe as a "runaway" query in SQL Server.
We will be part of the SQLintersection event at the Walt Disney World Swan in Florida in April. Read on to see why you should be there too!
January 25, 2016 | Aaron Bertrand | Community 0
Aaron Bertrand discusses a few counterpoints to a very thorough and useful post on database naming standards.
January 18, 2016 | Aaron Bertrand | T-SQL 45
Aaron Bertrand presents his first BackToBasics post of 2016, giving an introduction to common table expressions (CTEs).
January 6, 2016 | Aaron Bertrand | #BackToBasics, SQL Server 7
Aaron Bertrand explains that cumulative updates are not to be feared and that the cautionary text accompanying them will soon be a thing of the past.
Aaron Bertrand shares a few of the queries he uses to quickly hone in on changes that have been implemented between SQL Server CTPs.
Aaron Bertrand provides a bit of commentary on the recent revelation of multiple harassment incidents that occurred at this year's PASS Summit in Seattle.
November 25, 2015 | Aaron Bertrand | Community, PASS Summit, PASS 0
Aaron Bertrand explains how to get Plan Explorer to work with plans from the latest builds of Azure SQL DB and CTPs of SQL Server 2016.
Aaron Bertrand highlights three Connect items that will address some pretty important shortcomings in SQL Server statistics.
November 12, 2015 | Aaron Bertrand | Statistics 0
For this month's T-SQL Tuesday, @AaronBertrand treats some of the most memorable data modeling sins that he's seen over his career working with SQL Server.
November 10, 2015 | Aaron Bertrand | SQL Server, T-SQL Tuesday 0
Aaron Bertrand talks about new arguments to SERVERPROPERTY() that make @@VERSION even more obsolete (and changes that make @@VERSION problematic).
Aaron Bertrand explains how SQL Server 2016 improves tempdb configuration and performance.
Aaron Bertrand shares his PowerPoint deck and sample code from his most recent SQL Saturday appearance.
September 26, 2015 | Aaron Bertrand | SQLSaturday, T-SQL, Community 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