Query Dynamics 365 / CDS Data With SQL

So fairly recently Microsoft announced the ability (in preview) to query CDs data with SQL – as opposed to Fetchxml as we have been used to with online.

I will write up a fuller discussion of this, once I have had a proper play, but there were some issues with setting this up, so I put together a short (ish) video to walk through the steps.