Monthly Archives: September 2013

PDW, Integration Services and Resource Classes

PDW v1 | PDW 2012 | SQL Server 2008-2012 When using the Parallel Data Warehouse (PDW) as a data source for SSIS (Integration Services) packages, some pitfalls have to be avoided. This post is about one of them that I … Continue reading

Posted in Allgemein | Leave a comment

Power Query data loading example

Power Query Preview| Hadoop In order to make the common task of data acquisition and preparation available to end users, Microsoft developed a very powerful enhancement for Excel: Power Query. Actually Power Query is part of the new Power BI … Continue reading

Posted in Allgemein | Leave a comment

Distributed Partitioned Views: MPP light?

SQL Server 2010/2012 In the MPP approach we distribute data over multiple servers, so that a complex query can be divided into several queries that need to handle less data and that run in parallel. This gives the speed for … Continue reading

Posted in Allgemein | Leave a comment