Rock your data with SQL Server 2012 Parallel Data Warehouse (PDW) – What’s new?
As I already stated out in my first post I want share some insights about the new SQL Server 2012 …
Category Archives: Data Warehouse
Parallel Data Warehouse – POC lessons learned Part 3
The first part of the PDW lessons learned series gave an introduction about the goals of the POC, a customer …
Parallel Data Warehouse (PDW) POC – lessons learned Part 2
After the introduction of the POC itself and the high level test cases I will now go into more detail …
Design SSIS for Performance and Scale
I’d like to start a new series about SSIS design pattern for performance and scale. I already introduced the general …
Fast Track: improving performance through correct LUN Mapping and Storage Enclosure configuration
During a customer POC with FastTrack we recognized that the correct LUN Mapping is essentially to use the maximum throughput …
SQL Server 2012: Analysis Services tabular model memory consumption
With SQL Server 2012 Microsoft introduces the new in-memory analytics engine “xVelocity”. This new engine is delivered within the following …
Parallel Data Warehouse (PDW) POC – lessons learned
The first version of Microsoft’s Parallel Data Warehouse is out for a while, now I had the chance to get …
SSIS Performance Tuning – Methodology and general approach
Performance tuning is the improvement of system performance. The motivation for such activity is called a performance problem, which can …
PASS SQLRally 2011 Nordics – delivered
This was my first session for the PASS Community. I presented together with my friend Alexei from SQLCAT about “High …
Data Warehouse reference architecture – Staging & Archive
In my last post I presented the Data Warehouse reference architecture that I use to explain design principles and ETL …
