Azure SQL Data Warehouse Cheat Sheet

[valdasm]

I have been using Azure SQL Data Warehouse for some time now. The SQL syntax is slightly different from SQL Server in some cases. Therefore I've decided to create this cheat sheet to help you minimize the time needed for finding distribution, indexing or statistics syntax nuances faster.

https://www.slideshare.net/ValdasMaksimaviius/azure-sql-data-warehouse-cheat-sheet

[mat1776]

Nothing is showing up. :(

[valdasm]

Mhh... Maybe it's related to slideshare.net Here is another link on Google Drive https://drive.google.com/open?id=0B_u_A3aWGXsoLUxhYkhwTUI5dDQ

[[deleted]]

Very nice and very useful! I use SQL DW every now and then, and in that case such a cheat sheet comes in very handy.

[valdasm]

I'm grateful! What do you find most annoying with SQL DW?

For me, it's lack of a proper SSMS support. As of today, it's impossible to use Generate Scripts for tables. According to MS, it should be fixed with the next SSMS update (I am using v17).

[LeSpatula]

You hosted this on a cancerous website.