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.
#BackToBasics : An Updated

#BackToBasics : An Updated "Kitchen Sink" Example

Continuing the #EntryLevel challenge, Aaron Bertrand (@AaronBertrand) talks about optimizing the "kitchen sink" procedure using dynamic SQL and, optionally, OPTION (RECOMPILE).

Slide decks and demos from #SQLDay Poland

Aaron Bertrand (@AaronBertrand) shares his PowerPoint files and SQL samples from his Bad Habits and tempdb sessions at SQLDay in Wrocław, Poland.

Slide Decks & Demos from SQLBits

Slide Decks & Demos from SQLBits

Aaron Bertrand (@AaronBertrand) shares his slides and demos from T-SQL and SQL Server 2016 sessions at SQLBits XV in Liverpool, UK.

#BackToBasics : Definitions of SQL Server release acronyms

Aaron Bertrand (@AaronBertrand) explains some of the more common acronyms you may see flung around in blog posts, Connect items, and Knowledge Base articles.

A "drop column" fix you'll want for SQL Server 2012 / 2014

Aaron Bertrand (@AaronBertrand) cautions about using DROP COLUMN without immediately rebuilding the table. Wasted space is a concern; data loss is worse.

Slide Decks & Demos from SQLintersection

Aaron Bertrand (@AaronBertrand) shares his slides and demos from his two SQL Server 2016 sessions at SQLintersection in Orlando this week.

#BackToBasics : Dating Responsibly

As part of his #BackToBasics series, Aaron Bertrand (@AaronBertrand) gives four quick tips on using date and time values effectively in SQL Server.

What might the SSMS changes mean to you?

After the first Visual Studio 2015-based SSMS build is released, Aaron Bertrand (@AaronBertrand) talks about the changes you'll notice, and the changes you won't (yet).

An Interview with Microsoft's Ken Van Hyning

Ken Van Hyning (@sqltoolsguy), Microsoft's new Engineering Manager for SQL Server Client Tools, fields a few questions from SQL Sentry's Aaron Bertrand.

On telemetry and other data collected by SQL Server

Aaron Bertrand (@AaronBertrand) talks about some of the upcoming changes to telemetry and other privacy settings in SQL Server 2016.

SQL Sentry v10 : Index Analysis

Aaron Bertrand (@AaronBertrand) provides some insight into a new feature in SQL Sentry v10, and coming soon to Plan Explorer : Index Analysis.

Management Studio February Preview : An Illustrated Guide

Aaron Bertrand (@AaronBertrand) explains some of the nuances of the latest Management Studio preview, with a visual tour through installation.

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.

#BackToBasics : The Beauty of the Synonym

Aaron Bertrand (@AaronBertrand) continues his "Back to Basics" series, this time discussing SQL Server's synonym and how it can be used.