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

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.

#BackToBasics : A Challenge for 2016

#BackToBasics : A Challenge for 2016

In every month of 2016, Aaron Bertrand (@AaronBertrand) will attempt to publish an introductory blog post about SQL Server.

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

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.

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

#BackToBasics : Great Debates : Unicode

In his 8th #EntryLevel post, Aaron Bertrand (@AaronBertrand) takes a look at one of the classic debates in SQL Server : whether to support Unicode.