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 posts the slide deck and sample code from his recent 24HOP presentation, and addresses audience questions from the session.
September 18, 2015 | Aaron Bertrand | Community, PASS Summit 0
Aaron Bertrand explains how he worked around a recent problem with Windows 10 and its not-so-administrator administrator account.
For this month's T-SQL Tuesday, Aaron Bertrand (@AaronBertrand) talks about a few of the limitations of a new SQL Server 2016 feature, Always Encrypted.
August 11, 2015 | Aaron Bertrand | Security, T-SQL Tuesday 11
Aaron Bertrand discusses a couple of potential problems that can occur when you are inconsistent about case sensitivity.
August 7, 2015 | Aaron Bertrand | T-SQL 3
Aaron Bertrand talks about two things that force him to stop in his tracks when he tries to install SQL Server on a new VM.
Aaron Bertrand suggests a different approach to providing more data about service packs and cumulative updates than messing with @@VERSION.
There is a fix to address a remote code execution vulnerability for all supported SQL Server versions. @AaronBertrand shows which build you should install.
July 20, 2015 | Aaron Bertrand | Security, SQL Server Builds 14
Aaron Bertrand (@AaronBertrand) looks at SQL Server's tempting All Features With Defaults installation choice for this month's T-SQL Tuesday.
Aaron Bertrand (@AaronBertrand) shares the settings file for the dark theme he uses for presentations in SQL Server Management Studio (SSMS).
June 30, 2015 | Aaron Bertrand | Management Studio, SSMS 79
Aaron Bertrand talks about the recent release of SQL Server 2016 CTP 2.1 and what changes you should expect.
After a presentation at SQLintersection, Aaron Bertrand shows how to monitor when users are turning trace flags on and off.
For T-SQL Tuesday, @AaronBertrand discusses undocumented trace flags that provide additional diagnostics to troubleshoot slow backup or restore operations.
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.

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