Aaron Bertrand - SentryOne Team Blog

Aaron Bertrand

Aaron (@AaronBertrand) is a Product Manager at SentryOne, with industry experience dating back to Classic ASP and SQL Server 6.5. He is editor-in-chief of the performance-related blog, SQLPerformance.com, and serves as a community moderator for the Database Administrators Stack Exchange. Aaron's blog focuses on T-SQL bad habits and best practices, as well as coverage of updates and new features in Plan Explorer, SentryOne, and SQL Server.

Subjectivity : Naming Standards

Aaron Bertrand (@AaronBertrand) discusses a few counterpoints to a very thorough and useful post on database naming standards.

#BackToBasics : Common Table Expressions (CTEs)

Aaron Bertrand (@AaronBertrand) presents his first "BackToBasics" post of 2016, giving an introduction to common table expressions (CTEs).

How I learned to stop worrying and love cumulative updates

Aaron Bertrand (@AaronBertrand) explains that cumulative updates are not to be feared and that the cautionary text accompanying them will soon be a thing of the past.

Preview Support for SQL Server 2016

With the latest build of SQL Sentry software, v9.0.36.0, you will now be able to watch SQL Server 2016 instances. Read on for more details…

On the PASS e-mail about harassment

Aaron Bertrand (@AaronBertrand) provides a bit of commentary on the recent revelation of multiple harassment incidents that occurred at this year's PASS Summit in Seattle.

Plan Explorer Support for SQL Server 2016

Aaron Bertrand (@AaronBertrand) explains how to get Plan Explorer to work with plans from the latest builds of Azure SQL DB and CTPs of SQL Server 2016.

Aaron Bertrand : Please help improve SQL Server statistics!

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

T-SQL Tuesday #72 : Models Gone Wild!

For this month's T-SQL Tuesday, @AaronBertrand treats some of the most memorable data modeling sins that he's seen over his career working with SQL Server.

Blogging from the PASS Keynote, Day 2

Aaron Bertrand (@AaronBertrand) recaps all of the announcements from the second keynote at the PASS Summit in Seattle.

Blogging from the PASS Keynote, Day 1

Aaron Bertrand (@AaronBertrand) recaps all of the announcements from today's keynote at the PASS Summit in Seattle.

New SERVERPROPERTY Options to Help Phase Out @@VERSION

Aaron Bertrand (@AaronBertrand) talks about new arguments to SERVERPROPERTY() that make @@VERSION even more obsolete (and changes that make @@VERSION problematic).

SQL Server 2016 : Getting tempdb a little more right

Aaron Bertrand (@AaronBertrand) explains how SQL Server 2016 improves tempdb configuration and performance, and how there is still room for improvement.

24 Hours of PASS : Summit Preview Edition

Aaron Bertrand (@AaronBertrand) posts the slide deck and sample code from his recent 24HOP presentation, and addresses audience questions from the session.