Aaron Bertrand

Aaron is a senior consultant for SQL Sentry, makers of performance monitoring and event management software for SQL Server, Analysis Services, and Windows. 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.sqlsentry.com and sqlblog.com; 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.

Can ColumnStore Help Pagination Workloads?

Posted by Aaron Bertrand on January 15, 2016 1 Response »

Jan 152016

Aaron Bertrand (@AaronBertrand) revisits an older post about SQL Server pagination to see if any implementation of ColumnStore indexes can improve performance.

SQL Server 2016 : Availability Group Enhancements

Posted by Aaron Bertrand on December 17, 2015 14 Responses »

Dec 172015

Aaron Bertrand (@AaronBertrand) reveals details about the changes to Availability Groups that will ship in the next major version: SQL Server 2016.

More showplan improvements? Yes, please!

Posted by Aaron Bertrand on December 8, 2015 No Responses »

Dec 082015

Aaron Bertrand (@AaronBertrand) highlights a handful of Connect items aimed at improving SQL Server showplan diagnostics and query tuning in general.

Partitioning on a Budget

Posted by Aaron Bertrand on December 4, 2015 5 Responses »

Dec 042015

Aaron Bertrand (@AaronBertrand) walks through a solution that allows you to achieve some of the benefits of partitioning without the Enterprise Edition price tag.

SQL Server 2016 : In-Memory OLTP Enhancements

Posted by Aaron Bertrand on November 30, 2015 25 Responses »

Nov 302015

Aaron Bertrand (@AaronBertrand) lists out the changes to In-Memory OLTP ("Hekaton") that will make the feature even more appealing in SQL Server 2016.

Please help improve SQL Server statistics!

Posted by Aaron Bertrand on November 12, 2015 1 Response »

Nov 122015

Aaron Bertrand (@AaronBertrand) highlights three Connect items that will address some pretty important shortcomings in SQL Server statistics.

Service Broker Enhancements in SQL Server 2016

Posted by Aaron Bertrand on October 26, 2015 No Responses »

Oct 262015

Aaron Bertrand (@AaronBertrand) shows some interesting maintenance opportunities for Service Broker queues available in the next version of SQL Server.

1 2 3 … 14 15