Continuing his series on row goals, Paul White explains how they can impact certain types of semi joins, and how you can spot these effects in showplan and trace flag output.
Erin Stellato gives an overview of Automatic Plan Correction in SQL Server 2017 and Azure SQL Database, and assures us that Microsoft is not trying to code us out of jobs.
Paul White provides some great information about row goals, explaining why they're important to understand when examining why the query optimizer made a certain choice.
Tim Radney of SQLskills gives an overview of Managed Instances and explains how they bridge the gap between on-premises SQL Server and Azure SQL Database.