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

Aaron Bertrand briefs us on his upcoming session as well as two pre-conference workshops at SQL Saturday #357 in Cleveland, OH this February.
January 15, 2015 | Aaron Bertrand | SQLSaturday, Community 0
AaronBertrand reflects on his trip to a SQL Saturday #350, and the awesome after-party at Heather Curling Club in St. Boniface, in the not-quite-frozen tundra known as Winnipeg, Manitoba.
November 23, 2014 | Aaron Bertrand | SQLSaturday, SQLFamily 2
Aaron Bertrand shares his slide decks and demo files from three different November Shows - PASS Summit in Seattle, WA; SQLintersection in Las Vegas, NV; and SQL Saturday #350 in Winnipeg, Manitoba.
Aaron Bertrand blogs from the Women in Technology Luncheon, hosted by Kimberly Bryant, founder of Black Girls CODE.
Aaron Bertrand is live-blogging Thursday's keynote from the PASS Summit in Seattle, WA. The topic is Cloud Databases 101.
November 6, 2014 | Aaron Bertrand | PASS Summit, Virtualization 0
Aaron Bertrand is live-blogging Wednesday's keynote from the PASS Summit in Seattle, WA. The topic of the keynote is Evolving Microsoft's Data Platform - The Journey to Cloud Continues.
November 5, 2014 | Aaron Bertrand | SQLFamily, Cloud, PASS Summit, PASS 0
Aaron Bertrand reflects on the four years he has served so far as Senior Consultant at SQL Sentry, and looks forward to more great years ahead.
October 25, 2014 | Aaron Bertrand | SQL Sentry, Career 0
Aaron Bertrand repeats "Bad habits" advice from the past about using statement terminators and schema references to avoid debugging troubles.
October 22, 2014 | Aaron Bertrand | T-SQL 0
Aaron Bertrand points out that an often-used connection setting, AttachDBFileName, may be the source of many wasted hours of debugging and troubleshooting.
Aaron Bertrand treats a common scenario: behavior differs between two SQL Server databases that may be the same version, but different compatibility levels.
Aaron Bertrand (@AaronBertrand) discusses the NOLOCK hint in SQL Server, and why you want to avoid slapping it onto every table mentioned in every query.
September 24, 2014 | Aaron Bertrand | Bad Habits, T-SQL 26
Aaron Bertrand continues his Bad Habits series; in this installment, he discusses ten common cases of misplaced optimization.
September 16, 2014 | Aaron Bertrand | Bad Habits, T-SQL 1
Contributing to T-SQL Tuesday #58, Aaron Bertrand discusses a few of the reasons people give out the sa password, and what you should do in those cases instead.
September 9, 2014 | Aaron Bertrand | Security, SQL Server, T-SQL Tuesday 0
Aaron Bertrand continues his Bad Habits series, explaining why you should avoid helper functions and use joins against the catalog views instead.
September 4, 2014 | Aaron Bertrand | Bad Habits, T-SQL 0
Following up on Grouped Concatenation in SQL Server and Grouped Concatenation: Ordering and Removing Duplicates, Aaron Bertrand provides four real-world examples where grouped concatenation allows you to avoid the monotony of cursors and while loops.
August 29, 2014 | Aaron Bertrand | T-SQL 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