Azure SQL Data Warehouse: October 2015 update

This post summarizes the new features released in Azure SQL Data Warehouse in October 2015\. To read more, see the [October update for Azure SQL Data Warehouse](https://azure.microsoft.com/blog/october-update-for-azure-sql-data-warehouse/) blog post. * **Parallelized data export** \- The addition of the CREATE EXTERNAL TABLE AS SELECT (CETAS) statement to bulk export data for cold data storage to Azure Blob Storage via PolyBase. * **Data load performance improvements** \- Additional CREATE STATISTICS options on external tables to improve performance for all external table operations. Also resource class management improves load times when connecting via BCP. * **Expanded function support -** Support for functions in schemas other than the default (dbo). * **Additional improvements** \- Simplified syntax for creating a temporary table, added support for the [sys.dm\_exec\_dms\_services](https://msdn.microsoft.com/library/mt146374.aspx), [sys.dm\_exec\_dms\_workers](https://msdn.microsoft.com/library/mt146392.aspx), [sys.dm\_exec\_external\_work](https://msdn.microsoft.com/library/mt146375.aspx), and [sys.dm\_exec\_external\_operations](https://msdn.microsoft.com/library/mt146391.aspx) DMVs, and improved error messages for data loading and other error conditions. To learn more, see: * [Azure SQL Data Warehouse](https://aka.ms/sqldw) * [What is Azure SQL Data Warehouse?](https://azure.microsoft.com/documentation/articles/sql-data-warehouse-overview-what-is/) * [Get an Azure subscription: Develop and test cloud solutions](https://aka.ms/newsqldw) * Azure Synapse Analytics