Microsoft is keeping pace in the cloud data warehouse race with the release of its next-generation Azure SQL data warehouse which it promotes as an optimized computing tier. Microsoft said its massively-parallel processing engine for cloud data warehousing boosts query performance over the previous generation platform by a factor of five. It also serves up to 128 concurrent queries on a single cluster.
Microsoft (NASDAQ: MSFT) and a growing list of cloud data warehouse providers such as Amazon Redshift, Google BigQuery and Oracle’s (NYSE: ORCL) AI-powered “autonomous data warehouse” are upgrading computing and storage components to deliver data where it is needed as quickly as possible. With an emphasis on petabyte-scale analytics, the upgraded Azure SQL platform uses adaptive caching techniques along with a “blended approach” that includes remote storage and fast SSD caching running on NVM Express connections.
Author: George Leopold