Alright, I've been working heavily with SQL Data Services as of late, and I figured I'd go ahead and compile a list of things that I have not been able to do that are causing me problems...
- SELECT DISTINCT
- WHERE Value LIKE '%string' or WHERE Value LIKE 'string%' (Starts With, Ends With)
- GROUP BY
- Any sort of reporting using Aggregate data such as sums, trending, etc.
This is, by no means, a complete list of things that you cannot do with SQL Data Services, but it's a good starting point for my complaining. And, there are other ways around some of the above problems, so scrutinize this list with your own discretion.
Microsoft, the CTP is going to come to an end soon [I hope, for the sake of my project]. There's still several things that need to be addressed.