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]…


Lesson Learned #11: Connect from Azure SQL DB using an external table where the source of the data is a SQL Datawarehouse

One of our customer tries to connect from Azure SQL DB using an external table where the source of the data is a SQL Datawarehouse database. This first question was if there is supported or not and I received the confirmation from Azure Product Team that there is not supported and they are working on…


Azure Support Academy (Spanish): SQL Server, Next Station Azure

Welcome to our session delivered in 24Hours Pass Virtual Chapter – Global Spanish, covering the main aspects to start or migrate from an OnPremise model  to one of the two architectures available in SQL Server on Azure, providing the keys to select the more suitable environment  for our requirements. Watch:  SQL Server, Next Station Azure We covered: Red…


Azure SQL DW – column name is case sensitive with hash distribution

Symptoms:  When using PolyBase bulk operation to load data into Azure SQL DW (Data Warehouse)  and using the HASH distribution you may receive this error message: [OLE DB Destination [471]]: The source and target columns must be in the same order in the INSERT BULK statement An OLE DB record is available.  Source: “Microsoft SQL…