CROSS and OUTER APPLY are the Swiss Army knives of joins.
This session will show you how to apply these two join types to your code not just for table valued functions but to make your queries faster, shorter, easier to read or simply to help to sweep those data quality gremlins under the carpet and avoid errors.
Examples will be taken from situations the speaker has encountered within Business Intelligence work but will be equally applicable elsewhere.
Barney Lawrence has over a decade's experience on the Microsoft data platform having moved from the guy who knows Excel, to Data Analyst, to Accidental BI Developer and finally to Actual BI Developer. He currently works as a Senior BI Developer for Jet2.com