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

Aaron Bertrand walks through some of the new JSON-related Transact-SQL functionality that will be available in SQL Server 2016.
May 11, 2015 | Aaron Bertrand | SQL Server 2016, T-SQL, CTPs 10
Aaron Bertrand shows a workaround for an obscure error you might receive while patching SQL Server: "No room is available to display rows."
Aaron Bertrand gives detail about an important enhancement in the latest release of SQL Sentry Plan Explorer, v2.7: better anonymization.
Aaron Bertrand tries to raise awareness of a significant security issue when creating or altering logins using a password hash. Please vote!
April 20, 2015 | Aaron Bertrand | Security 9
Updated April 17, 2015: SQL Server 2014 Service Pack 1 has been released, but was quickly pulled. This post explains why and shows how to fix any affected instances.
Aaron Bertrand lists out some of the new bloggers providing fresh content to the SQL Server community via #SQLNewBlogger.
April 9, 2015 | Aaron Bertrand | SQLFamily, Community 1
Aaron Bertrand continues his series on Bad Habits and Best Practices, this time focusing on the use of MDF/LDF files for backups.
April 7, 2015 | Aaron Bertrand | #BackToBasics, Backups 9
Aaron Bertrand shows how to pull Top SQL data from the SQL Sentry database, in case you don't have client access or have more grueling and complex filters.
Aaron Bertrand shows how to use the RunAs command to connect the SQL Sentry Client, Plan Explorer, or SSMS to a database in another domain.
Aaron Bertrand talks about two ways you can finally make that community splash that will help you strengthen your knowledge and further your career.
March 25, 2015 | Aaron Bertrand | Community 2
Aaron Bertrand shows a few tricks for visualizing and comparing "service offline" alerts to help validate and troubleshoot network blips.
Aaron Bertrand explains why he keeps going back to SQL Cruise events, and why you should consider going, too.
Aaron Bertrand continues his series on bad habits and best practices, this time focusing on the benefits of referencing columns in a query.
Aaron Bertrand addresses a popular theory that NOLOCK can substantially reduce locking overhead against #temp tables.
February 26, 2015 | Aaron Bertrand | T-SQL 5
Aaron Bertrand discusses why developers and DBAs should work together and not consider each other's craft an impenetrable silo.
February 19, 2015 | Aaron Bertrand | SQL Server 2

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