Data Analytics Junkie

Analytics and AI on the Microsoft platform – Marcel Franke –


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: 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

Up ↑