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.

SQL Server support for TLS 1.2 – Read This First!

Updated March 2, 2016 – Microsoft has announced support for TLS 1.2 in SQL Server 2008, 2008 R2, 2012, and 2014. However, there are a few issues right now.

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).

T-SQL Tuesday #104 : Code I Would Hate to Live Without

T-SQL Tuesday #104 : Code I Would Hate to Live Without

For this month's T-SQL Tuesday, Aaron Bertrand talks about his methods for metadata discovery in new versions of SQL Server.

Features and fixes in SentryOne Plan Explorer 18.4

Features and fixes in SentryOne Plan Explorer 18.4

The latest build of SentryOne Plan Explorer – 18.4.0 – is now available. Get a little insight behind the release notes from Product Manager, Aaron Bertrand.

T-SQL Tuesday #102 : Giving Back

T-SQL Tuesday #102 : Giving Back

Aaron Bertrand gives some scattered thoughts about how he has contributed to the SQL Server community throughout his career.

Bad Habits Revival

Bad Habits Revival

Aaron Bertrand (@AaronBertrand) breathes some new life into his long-running SQL Server series on bad habits and best practices. The latest installment discusses the various impacts of choosing GUIDs over numeric types for keys.

Photo credit: badgreeb_records

2017 : Community Influencer of the Year

2017 : Community Influencer of the Year

Aaron Bertrand (@AaronBertrand) announces the second recipient of his Community Influencer of the Year award.