Aaron Bertrand (@AaronBertrand) explains how to get Plan Explorer to work with plans from the latest builds of Azure SQL DB and CTPs of SQL Server 2016.
The SQL Server plan cache is one of the most important architectural elements for DBAs to understand. Get the slide deck and sample scripts here.
UPDATE October 23, 2014 : We've selected a winner for our most recent SQL Sentry Plan Explorer PRO giveaway ($295 value).
Paul White (@SQL_Kiwi) talks about coercing the optimizer into avoiding sorts, reminding us that sound indexing should still be our first line of attack.
I wanted to talk about two new features in SQL Sentry Plan Explorer: Plan obfuscation, where you can hide sensitive information in your plans before sharing them, and custom layouts, a way to take complete control over the visual representation of your graphical plans.
Have you ever worked with a query plan that was so large and unwieldy that it was next to impossible to make any sense of it? It can be a frustrating endeavor, for sure.
The new version of Plan Explorer PRO 2.5 is focused on making these big plans easier to manage, and it does so using a variety of techniques that you have been asking for, which I will cover below.