In this video, you'll see the latest cool Common Data Services (CDS) feature that allows you to connect to CDS using Management Studio. After you connect, you're able to query CDS and perform much of the same queries you do in T-SQL against CDS.
Pragmatic Works Training and Consulting : https://www.pragmaticworks.com