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.
SQL Sentry's Aaron Bertrand (@AaronBertrand) talks a little more about in-memory table-valued parameters, and explains why some scenarios you test may not demonstrate the power of this technology.
Aaron Bertrand (@AaronBertrand) explains how he could justify purchasing a new Mac Pro, and shows that it is very tough to order a comparable PC at similar price points.
SQL Sentry's Aaron Bertrand (@AaronBertrand) highlights a couple of potential problems discovered in various AdventureWorks-based In-Memory OLTP samples out there, and how to work around them.
SQL Sentry's Aaron Bertrand (@AaronBertrand) investigates a new possibility in SQL Server 2014: creating and using memory-optimized table-valued parameters.
SQL Sentry's Aaron Bertrand (@AaronBertrand) investigates a deadlock issue with alias types and table-valued parameters, and the Connect items that have sprung up about this issue.
SQL Sentry's Aaron Bertrand (@AaronBertrand) takes a quick look at performance of encrypted backups in SQL Server 2014, and points out a couple of other things you'll want to know before implementing the feature.
Aaron Bertrand (@AaronBertrand) discusses a common requirement, generating random numbers to serve as surrogate keys, and shows how you can avoid the incremental cost of preventing collisions.
