SentryOne Team Blog (blogs.sentryone.com)

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.
Sharing two T-SQL slide decks from CodeStock

Sharing two T-SQL slide decks from CodeStock

Aaron Bertrand shares his slide decks and demos from two recent presentations at CodeStock in Knoxville, TN.

Features and Fixes in SentryOne Plan Explorer 19.0.2

Features and Fixes in SentryOne Plan Explorer 19.0.2

Product Manager Aaron Bertrand talks about the three improvements in the latest version of SentryOne Plan Explorer, 19.0.2.

2018 : Community Influencer of the Year

2018 : Community Influencer of the Year

Aaron Bertrand announces the recipient of his third annual Community Influencer of the Year award.

GroupBy : New Engine Features in SQL Server 2019

GroupBy : New Engine Features in SQL Server 2019

Aaron Bertrand provides his deck and demos for a GroupBy presentation on SQL Server 2019, and makes up for some serious demo disasters.

Slides & Demos from SQLintersection Fall 2018

Slides & Demos from SQLintersection Fall 2018

Aaron Bertrand shares his slides and demos from his sessions at SQLintersection in Las Vegas.

SQL Server support for TLS 1.2 – Read This First!

SQL Server support for TLS 1.2 – Read This First!

UPDATE November 17th, 2018 – Microsoft has pulled several patches for older versions of SQL Server. If you need TLS 1.2 support and can't move to a formally supported version, your recourse is to contact Microsoft support.

Fixes in SentryOne Plan Explorer 18.5.1

Fixes in SentryOne Plan Explorer 18.5.1

Product Manager Aaron Bertrand talks about the two improvements in the latest version of SentryOne Plan Explorer, 18.5.1.

Features and Fixes in SentryOne Plan Explorer 18.5

Features and Fixes in SentryOne Plan Explorer 18.5

On October 9th, we released SentryOne Plan Explorer 18.5, with five features and fixes. Read on for more details.

What to do (or not do) about top wait stats

What to do (or not do) about top wait stats

Aaron Bertrand talks about the top 10 wait types we see among SentryOne customers, and what to do when you're experiencing one of them on your own system.

First public preview of SQL Server 2019 : CTP 2.0

First public preview of SQL Server 2019 : CTP 2.0

Today Microsoft announced the first public preview of SQL Server 2019. I've got some exclusive details over at MSSQLTips.com.

T-SQL Tuesday #106 : INSTEAD OF triggers

T-SQL Tuesday #106 : INSTEAD OF triggers

For this month's T-SQL Tuesday, Aaron Bertrand shows that when triggers are necessary, in some cases INSTEAD OF triggers can be better for performance than AFTER triggers.

Migrating from AnswerHub to WordPress : A Tale of 10 Technologies

Migrating from AnswerHub to WordPress : A Tale of 10 Technologies

Aaron Bertrand describes the process of migrating nearly 5,000 posts from the SQLPerformance.com Q&A site on AnswerHub to its new read-only home on WordPress.

Fixes in SentryOne Plan Explorer 18.4.5

Fixes in SentryOne Plan Explorer 18.4.5

Product Manager Aaron Bertrand details the four fixes included in the latest release of SentryOne Plan Explorer (18.4.5).

New Deadlock Visualizations in SQL Sentry and Plan Explorer

New Deadlock Visualizations in SQL Sentry and Plan Explorer

Product Manager Aaron Bertrand gives a brief walk-through of the new deadlock visualization options in Plan Explorer and SQL Sentry.

Features and fixes in SentryOne Plan Explorer 18.4.2

Features and fixes in SentryOne Plan Explorer 18.4.2

Product Manager Aaron Bertrand explains the fixes and enhancements in the latest release of SentryOne Plan Explorer (18.4.2).