Category Archives: Data warehouse

Azure SQL Data Warehouse

Analytics Platform System (APS) is Microsoft’s massively parallel processing (MPP) data warehouse technology.  This has only been available as an on-prem solution (see video Overview of Microsoft Analytics Platform System).  Until now.  At the recent Microsoft Build Developer Conference, Executive Vice … Continue reading

Posted in Data warehouse, PDW/APS, SQLServerPedia Syndication | 6 Comments

What is a data lake?

A “data lake” is a storage repository, usually in Hadoop, that holds a vast amount of raw data in its native format until it is needed.  It’s a great place for investigating, exploring, experimenting, and refining data, in addition to archiving … Continue reading

Posted in Data warehouse, Hadoop, SQLServerPedia Syndication | 4 Comments

Creating a large data warehouse in Azure

Microsoft Azure provides you two options when hosting your SQL Server-based data warehouse: Microsoft Azure SQL Database and SQL Server in Azure Virtual Machine.  Which one is appropriate based on the size of the data warehouse?  What are some hardware features to … Continue reading

Posted in Azure, Data warehouse, SQLServerPedia Syndication | 6 Comments

Operational Data Store (ODS) Defined

I see a lot of confusion on what exactly is an Operational Data Store (ODS).  While it can mean different things to different people, I’ll explain what I see as the most common definition.  First let me mention that an … Continue reading

Posted in Data warehouse, SQLServerPedia Syndication | 5 Comments

Presentation slides for “Building a Big Data Solution”

Thanks to everyone who attended my session “Building a Big Data Solution” (Building an Effective Data Warehouse Architecture with Hadoop, Cloud and MPP) for Pragmatic Works today.  The abstract for my session is below and the recording will be available here tomorrow.  I hope you enjoyed it! … Continue reading

Posted in Data warehouse, Presentation, Session, SQLServerPedia Syndication | Leave a comment

The Modern Data Warehouse

The traditional data warehouse has served us well for many years, but new trends are causing it to break in four different ways: data growth, fast query expectations from users, non-relational/unstructured data, and cloud-born data.  How can you prevent this … Continue reading

Posted in Big Data, Data warehouse, Hadoop, PDW/APS, SQLServerPedia Syndication | 5 Comments

Fast Track Data Warehouse Reference Architecture for SQL Server 2014

I have previously blogged about the Fast Track Data Warehouse, a reference configuration optimized for data warehousing (see Microsoft SQL Server Reference Architecture and Appliances).  That was version 3.0 of the reference configuration that was for SQL Server 2008 R2.  Released a couple … Continue reading

Posted in Data warehouse, Fast Track, SQLServerPedia Syndication | 3 Comments

Presentation slides for Modern Data Warehousing

Thanks to everyone who attended my session “Modern Data Warehousing” at the Central New Jersey SQL User Group yesterday.  The abstract for my session is below.  I hope you enjoyed it! Here is the PowerPoint presentation: Modern Data Warehousing Modern Data Warehousing … Continue reading

Posted in Data warehouse, Presentation, Session, SQLServerPedia Syndication | 1 Comment

Modern Data Warehousing Presentation

I will be presenting the session “Modern Data Warehousing” tomorrow (Wednesday, August 13th) at the Central New Jersey SQL User Group at 6:30pm.  The abstract for my session is below.  I hope you can make it! Modern Data Warehousing The traditional … Continue reading

Posted in Data warehouse, Presentation, Session, SQLServerPedia Syndication | Leave a comment

Presentation slides for Modern Data Warehousing

Thanks to everyone who attended my session “Modern Data Warehousing” for Pragmatic Works last Thursday.  The abstract for my session is below and the recording is available here.  I hope you enjoyed it. Here is the PowerPoint presentation: Modern Data Warehousing Modern Data Warehousing The … Continue reading

Posted in Data warehouse, Presentation, Session, SQLServerPedia Syndication | Leave a comment