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

Where do I get SQL Server 2016 Developer Edition?

Aaron Bertrand (@AaronBertrand) shows a few different ways to download SQL Server 2016 Developer Edition, which is a bit harder to obtain than it should be.

T-SQL Tuesday #080 : CREATE OR REPLACE

Aaron Bertrand (@AaronBertrand) submits a wish list item for the 80th T-SQL Tuesday : CREATE OR REPLACE, a cleaner way to deploy objects without losing permissions.

#BackToBasics : DATEFROMPARTS()

Aaron Bertrand (@AaronBertrand) continues his #EntryLevel challenge with July's entry, a treatment of DATEFROMPARTS() and similar functions introduced in SQL Server 2012.

Slides and Demos from Discovery Day New England

Today I presented at Discovery Day New England, a SQL Server 2016 event (sponsored in part by SQL Sentry) held at the Microsoft office in Cambridge, MA. Attached are demos and slide decks.

This Weird Trick Still Missing From SQL Server 2016

Aaron Bertrand (@AaronBertrand) enters June's T-SQL Tuesday, talking about a feature long missing from SQL Server : The ability for Developer Edition to act like Standard.

Announcing Plan Explorer Add-In Support for SSMS 2016

Aaron Bertrand (@AaronBertrand) reveals a new build of SQL Sentry Plan Explorer, updated to support the new add-in model introduced with the latest SSMS.

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