Aaron is an architect at Wayfair. We don't want to say he's old, but his experience dates back to a time when SQL Server 6.5 was considered "modern." He writes here at sqlperformance.com, over at sqlblog.org, and at MSSQLTips.
For this month's T-SQL Tuesday, Aaron Bertrand shows that when triggers are necessary, in some cases INSTEAD OF triggers can be better for performance than AFTER triggers.
Aaron Bertrand describes the process of migrating nearly 5,000 posts from the SQLPerformance.com Q&A site on AnswerHub to its new read-only home on WordPress.
Aaron Bertrand (@AaronBertrand) kicks off his "Performance Myths" series, showing a "redundant" non-clustered index outperforming the clustered index with the same key.
In an effort to make leading wildcard searches sargable, Aaron Bertrand (@AaronBertrand) plays around with a trigram-type implementation in SQL Server.
Aaron Bertrand acknowledges that DISTINCT and GROUP BY are usually interchangeable, but shows there are cases where one performs better than the other.
