Search

Data Analytics Junkie

Analytics and AI on the Microsoft platform – Marcel Franke –

Category

Data Warehouse

SQL Server Parallel Data Warehouse Part 3 – Hardware Components

In order to not write the same story again…Joe Chang posted a very good blog entry about the different hardware components of PDW: http://sqlblog.com/blogs/joe_chang/archive/2011/03/10/parallel-data-warehouse.aspx So please read his blog entry for the details…

Database Backup Consistency

For all of you how had the challenge to get backups of different databases in sync there is a nice solution by marking transactions. Let’s have a look at the initial situation. We have three databases used for the Data... Continue Reading →

SQL Server Parallel Data Warehouse Part 2 – Architecture Components

In my second post about SQL Server Parallel Data Warehouse (PDW) I will dig into the architecture components of the appliance. The smallest PDW configuration consist of two racks: the Control Rack and the Data Rack as shown in the... Continue Reading →

SQL Server Parallel Data Warehouse

I’m currently on a PDW training and I’d like to share some of the concepts when building a Data Warehouse on PDW. For those who are not familiar with PDW this is Microsoft's first step into the MPP architecture. SQL... Continue Reading →

Data Warehouse Architecture

When I think of a data warehouse architecture I have this typical picture in mind: Data in or Staging Area On the lefthand side there are a bunch of source files or source systems which are staged in the "Data... Continue Reading →

Blog at WordPress.com.

Up ↑