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.
Aaron Bertrand (@AaronBertrand) follows up on his Always Encrypted posts from T-SQL Tuesday with improved code and more information on performance and space usage.
We have launched a new, bi-weekly newsletter to offer you the freshest content from our blogs and beyond. Subscribe at: https://sentryone.com/community.
Aaron Bertrand (@AaronBertrand) compares multiple date formatting techniques, demonstrating again that SQL Server's FORMAT() is not worth the convenience.
Aaron Bertrand (@AaronBertrand) shows the ins and outs of a new function that appeared in SQL Server 2016 CTP 2.1 this week: sys.dm_exec_function_stats.
For T-SQL Tuesday #67, Aaron Bertrand (@AaronBertrand) describes a new way to track backup and restore operations using Extended Events in SQL Server 2016.
Aaron Bertrand (@AaronBertrand) takes a quick look at a couple of things you should be careful about when calling natively-compiled Hekaton stored procedures in SQL Server 2014.
Aaron Bertrand (@AaronBertrand) follows up on a question from his triggers presentation at SQLBits, addressing the impact of trigger overhead for T-SQL Tuesday.
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.
