Azure SQL Data Warehouse: May 2016 update

Several features have been added to Azure SQL Data Warehouse in our most recent update: * ​[Azure Active Directory](https://azure.microsoft.com/services/active-directory/) authentication * Large-row support * Transaction size limits * Improved Visual Studio support * Support for [varchar(max)](https://msdn.microsoft.com/library/ms176089.aspx), [nvarchar(max)](https://msdn.microsoft.com/library/ms186939.aspx), [varbinary(max)](https://msdn.microsoft.com/library/ms188362.aspx), [numeric](https://msdn.microsoft.com/library/ms187746.aspx), and [uniqueidentifier](https://msdn.microsoft.com/library/ms187942.aspx) data types * Support for [RAND()](https://technet.microsoft.com/library/ms177610.aspx), [CHECKSUM()](https://msdn.microsoft.com/library/ms189788.aspx), [BINARY\_CHECKSUM()](https://msdn.microsoft.com/library/ms173784.aspx), [NEWID()](https://msdn.microsoft.com/library/ms190348.aspx), and [IS\_SRVROLEMEMBER()](https://msdn.microsoft.com/library/ms176015.aspx) functions * Support for the [sys.database\_service\_objectives](https://msdn.microsoft.com/en-US/library/mt712619%28SQL.130%29.aspx?f=255&MSPPError=-2147217396) dynamic management view (DMV) for Azure SQL Data Warehouse databases * [Archival compression](https://msdn.microsoft.com/library/cc280449.aspx) for clustered columnstore tables To learn more about these updates, see [Azure SQL Data Warehouse now supports Azure Active Directory, large rows, and additional T-SQL features](https://azure.microsoft.com/en-us/blog/azure-sql-data-warehouse-now-supports-aad-large-rows-and-additional-t-sql-features/). * Azure Synapse Analytics * Services