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) shows DDL commands in Azure SQL Database that can now run as online operations instead of blocking, size-of-data operations.
Learn about SQL Server pagination, including what it is, best practices, and how to fetch data better by optimizing queries that use OFFSET/FETCH pagination.
Aaron Bertrand (@AaronBertrand) walks through several potential causes for different plans and/or performance for the same database on two "identical" servers.
Aaron Bertrand (@AaronBertrand) shows some tricks for getting row counts efficiently, and explains why an accurate row count for a large table is a pipe dream.
Aaron Bertrand (@AaronBertrand) demonstrates an affordable approach to readable secondaries, without the need for Availability Groups and all the licensing costs involved with Enterprise Edition and Software Assurance.
Aaron Bertrand (@AaronBertrand) discusses examples where people expect SQL Server to perform tasks that really should be performed outside the scope of the database.
Aaron Bertrand (@AaronBertrand) of SQL Sentry takes a closer look at some additional requirements for typical grouped concatenation queries in SQL Server.
