Aaron is a Product Manager for SentryOne. 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 blogs here at sqlperformance.com as well as over at blogs.sentryone.com and sqlblog.org; has been a Microsoft MVP since 1997-98; wrote chapters for two charity-driven books, SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2; and speaks frequently at conferences, user group meetings, and SQL Saturday events around the world.
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.
Aaron Bertrand (@AaronBertrand) explains a few details about the memory limits in SQL Server 2016 Service Pack 1 that make this upgrade even more compelling.
