Aaron Bertrand - SentryOne Team Blog

Aaron Bertrand

Aaron (@AaronBertrand) is a Product Evangelist 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 moderator for Q & A sites answers.SQLPerformance.com and dba.stackexchange.com. 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.
SQLBits 2017 : We Have Disco

SQLBits 2017 : We Have Disco

Aaron Bertrand (@AaronBertrand) reminds everyone about the amazing lineup, learning, and fun to be had at SQLBits 2017 in Telford, UK.

Books Online Consolidation

Books Online Consolidation

Aaron Bertrand (@AaronBertrand) explains the ups and downs of a cohesive, consolidated, version-agnostic Books Online for SQL Server.

T-SQL Tuesday #87 : Shiny New Toys

T-SQL Tuesday #87 : Shiny New Toys

For T-SQL Tuesday #87, Aaron Bertrand (@AaronBertrand) talks about two shiny new toys used for disassembling and reassembling strings: STRING_SPLIT() and STRING_AGG().

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

T-SQL Tuesday #86 : My Favorite Connect Items

T-SQL Tuesday #86 : My Favorite Connect Items

For T-SQL Tuesday #86, Aaron Bertrand (@AaronBertrand) highlights a few of his favorite bugs and feature requests on Microsoft's improvement site, Connect.

2016 : Community Influencer of the Year

2016 : Community Influencer of the Year

Aaron Bertrand looks back on the past year, and hands out his first Community Influencer of the Year award.

#BackToBasics / T-SQL Tuesday : Are your backups worthless?

#BackToBasics / T-SQL Tuesday : Are your backups worthless?

For both T-SQL Tuesday and his #BackToBasics challenge, Aaron Bertrand (@AaronBertrand) provides some fundamental information about SQL Server backups, and why your restores can be just as important.

VS Code on Mac meets SQL Server on Linux (in Docker)

VS Code on Mac meets SQL Server on Linux (in Docker)

Aaron Bertrand describes his steps for setting up a development stack, with VS Code on Mac, managing SQL Server on Ubuntu, inside a Docker container.

#BackToBasics : CAST vs. CONVERT

#BackToBasics : CAST vs. CONVERT

Aaron Bertrand (@AaronBertrand) explains why he always opts for one of these options over the other, even in cases where it shouldn't matter.

Slides and Demos from SQLintersection

Slides and Demos from SQLintersection

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

Plan Explorer 3.0 Demo Kit

Last month we released the new, all-free, Plan Explorer 3.0, and now seemed the right time to follow that up with the 3rd version of the demo kit, too. Please consider earlier versions of the demo kit deprecated; I won't remove them, but I will add a note to those pages soon. Now, you might

#BackToBasics : Why I use lower case for data type names (now)

Aaron Bertrand (@AaronBertrand) explains why he codes defensively – matching the case of data type names, even in scenarios where it isn't strictly necessary.

#BackToBasics : Naming Stored Procedures

Naming conventions for stored procedures is the topic for Aaron Bertrand's 9th post for his #EntryLevel series.

SSMS is starting to look better…

Aaron Bertrand (@AaronBertrand) uses several examples to show the progress the SSMS team is making on enabling full support for HiDPI / 4K screens.