Aaron is a Staff Database Reliability Engineer at Stack Overflow. 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.
Following the recent release of SQL Server 2012 Service Pack 2 and SQL Server 2014 Cumulative Update #3, SQL Sentry's Aaron Bertrand (@AaronBertrand) takes a first look at a new performance enhancement and trace flag (2453) aimed at improving cardinality estimates for table variables and table-valued parameters.
Updated July 23, 2014 : Aaron Bertrand (@AaronBertrand) of SQL Sentry warns about a parallelism bug in SQL Server 2012 and 2014 that could lead to data loss following online index rebuilds.
SQL Sentry's Aaron Bertrand (@AaronBertrand) shows how you can use Extended Events to track temp table creation and identify which session created which #temp table.
Aaron Bertrand (@AaronBertrand) talks about SQL Server 2014 Standard Edition and a couple of little carrots that might make this upgrade more compelling than SQL Server 2012.
