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.