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 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 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
Aaron Bertrand talks about a couple of subtleties of SQL Server's THROW statement, and how to avoid frustrating bouts of troubleshooting.
February 13, 2015 | Aaron Bertrand | T-SQL 1
Aaron Bertrand posts the slide deck and links from his recent presentation on SQL Sentry Plan Explorer at SQL Saturday #357 in Cleveland.
Aaron Bertrand shares one of the most insightful pieces of feedback he's received from a session attendee. Who happens to be a 6th grader.
February 7, 2015 | Aaron Bertrand | SQLSaturday, Community, Slide Decks 4
Aaron Bertrand describes a scenario where Common Criteria compliance was deemed the cause of high LCK_M_SCH_M waits for multiple customers.
January 26, 2015 | Aaron Bertrand | Wait Stats 2

Top Categories

See all

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

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