It also ships with the latest firmware/driver updates containing security updates and fixes.The latest APS update is an addition to already existing data warehouse portfolio from Microsoft, covering a range of technology and deployment options that help customers get to insights faster.For greater analysis flexibility, APS supports full window frame syntax for ROWS or RANGE and additional windowing functions like FIRST_VALUE, LAST_VALUE, CUME_DIST and PERCENT_RANK.Additional functions like NEWID() and RAND() work with new data type support for UNIQUEIDENTIFIER and NUMERIC.More info: Native database backup in Azure SQL Managed Instance Top Questions from New Users of Azure SQL Database Managed Instances versus Azure SQL Database—What’s the Right Solution for You?There were so many good presentations at Microsoft Ignite, all of which can be viewed on-demand.SQL Server 2016 allows APS to offer features such as secondary index support for CCI tables and Poly Base Kerberos support.APS 2016 supports a broader set of T-SQL compatibility, including support for wider rows and a large number of rows, VARCHAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX).
active geo-replication, high availability, automatic backups, database advisor, threat detection, intelligent insights, vulnerability assessment, etc) but adds support for databases up to 35TB, VNET, SQL Agent, cross-database querying, replication, etc.
Customers exploring data warehouse products can also consider SQL Server with Fast Track for Data Warehouse or Azure SQL Data Warehouse, a cloud based fully managed service.
For more details about these features, please visit our online documentation or download the client tools.
Better late than never: The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), released an appliance update (AU6) about a year ago, and I missed the announcement.
Below is what is new in this release, also called APS 2016.