Lesson Learned #15: Securing our Azure SQL Datawarehouse

Hello Everyone, Nowdays, the security is a key element for all databases, for this reason, in Azure SQL we have several options depending on our needs. In this picture you could see the different available options that we have right now. In this post, I would like to share some points about two important topics…


Lesson Learned #12: What types of temporary tables can I use in Azure SQL Datawarehouse?

In SQL Datawarehouse we are able just to create tables with #, so, that means that this temporal table will be available during the session that create this table. Other calls, for example, ## ( Global Temporal Tables ) or tempdb..name will return an syntax error like this one. URL: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-tables-temporary CREATE TABLE tempdb..Temporal([OrderArticleId] [int]…