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 looks back on the past year, and hands out his first Community Influencer of the Year award.
December 31, 2016 | Aaron Bertrand | Community 3
For both T-SQL Tuesday and #BackToBasics, Aaron Bertrand provides information about SQL Server backups, and why your restores can be just as important.
In every month of 2016, Aaron Bertrand will attempt to publish an introductory blog post about SQL Server.
December 13, 2016 | Aaron Bertrand | Community, SQL Server 3
Aaron Bertrand describes his steps for setting up a development stack, with VS Code on Mac, managing SQL Server on Ubuntu, inside a Docker container.
November 16, 2016 | Aaron Bertrand | SQL Server, Docker 7
Aaron Bertrand explains why he always opts for one of these options over the other, even in cases where it shouldn't matter.
November 2, 2016 | Aaron Bertrand | #BackToBasics, T-SQL 7
Last month we released the new, all-free, Plan Explorer 3.0, and now seemed the right time to follow that up with the 3rd version of the demo kit, too.
October 7, 2016 | Aaron Bertrand | Plan Explorer 1
Aaron Bertrand explains why he codes defensively - matching the case of data type names, even when it isn't strictly necessary.
October 4, 2016 | Aaron Bertrand | #BackToBasics, T-SQL 0
Microsoft MVP Aaron Bertrand goes back to the basics with this post on the two core issues to consider when choosing a standard for stored procedure names.
September 1, 2016 | Aaron Bertrand | #BackToBasics 1
Aaron Bertrand uses several examples to show the progress the SSMS team is making on enabling full support for HiDPI / 4K screens.
August 24, 2016 | Aaron Bertrand | Management Studio, 4K 0
In his 8th #BackToBasics post, Aaron Bertrand takes a look at one of the classic debates in SQL Server: whether to support Unicode.
Aaron Bertrand shows a few different ways to download SQL Server 2016 Developer Edition, which is a bit harder to obtain than it should be.
Aaron Bertrand submits a wish list item for the 80th T-SQL Tuesday: CREATE OR REPLACE, a cleaner way to deploy objects without losing permissions.
July 12, 2016 | Aaron Bertrand | SQL Server, T-SQL Tuesday 10
Aaron Bertrand continues his #EntryLevel challenge, discussing DATEFROMPARTS() and similar functions introduced in SQL Server 2012.
Today I presented at Discovery Day New England, a SQL Server 2016 event (sponsored in part by SQL Sentry) held at the Microsoft office in Cambridge, MA. Attached are demos and slide decks.
Aaron Bertrand enters June's T-SQL Tuesday, talking about a feature long missing from SQL Server: The ability for Developer Edition to act like Standard.

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