Snowflake is a fully relational ANSI SQL data warehouse that was built from the ground up for the cloud. Its architecture separates compute from storage so that you can scale up and down on the fly, ...

We recently looked at the idea of the data lake, so now it’s time to head downstream and look at data warehouses. We’ll define data warehouses, look at the data types they comprise, the storage they ...

The notion of running a data warehouse in the cloud was a pretty novel thing when Amazon Web Services launched its Redshift service in November of 2012. Most on-premises data warehouse (DW) platforms ...

Hadoop has introduced a lot of agility into the world of analytics and data integration. Concepts such as schema on read and the radical flexibility of processing data stored in files have allowed ...

The first generation of Azure SQL Data Warehouse (SQL DW) was announced in 2015, and SQL DW "Gen 2" reached general availability in 2018. Today, at its Ignite confab on Orlando, Microsoft is ...

For too many companies, the data warehouse remains an unfulfilled promise. The work that was started with data warehouses to create a living, clearly defined source of truth about what is happening in ...

A new Azure SQL Data Warehouse preview offered as a counter to Amazon's Redshift headed several data-related announcements at the opening of the Microsoft Build conference today. Also being announced ...

Microsoft and its hardware partners on Monday rolled out preconfigured data warehouse reference architectures that incorporate Microsoft SQL Server 2008. Microsoft and its hardware partners on Monday ...

We’ve all heard of exciting new technologies in the data warehouse world—tools like Amazon Redshift, Google BigQuery, and more recently Azure SQL Data Warehouse. What would you call this category of ...