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.

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.

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.