I will continue my blog series about SQL Server 2012 Parallel Data Warehouse. If you missed my earlier posts of this series you can find them here: Rock your data with SQL Server 2012 Parallel Data Warehouse (PDW) Rock your... Continue Reading →
As I already stated out in my first post I want share some insights about the new SQL Server 2012 version of Parallel Data Warehouse. In this post I will talk about some new features as well as architecture changes.... Continue Reading →
I had the chance to do a customer POC on a very early version of SQL Server 2012 Parallel Data Warehouse and like to share the new features for PDW as well as the impressive results we got. The good... Continue Reading →
The first part of the PDW lessons learned series gave an introduction about the goals of the POC, a customer introduction, an overview of the requirements and the test cases. Within the second part I gave some more insights on... Continue Reading →
After the introduction of the POC itself and the high level test cases I will now go into more detail of every test case. But let’s start with the migration first. Database and SSIS Package migration to PDW In order... Continue Reading →
During a customer POC with FastTrack we recognized that the correct LUN Mapping is essentially to use the maximum throughput of the storage. So together with Alexei Khalyako from SQL CAT we wrote a white paper about this topic: http://sqlcat.com/sqlcat/b/msdnmirror/archive/2012/05/03/fast-track-improving-performance-through-correct-lun-mapping-and-storage-enclosure-configuration.aspx
With SQL Server 2012 Microsoft introduces the new in-memory analytics engine “xVelocity”. This new engine is delivered within the following modules: xVelocity for Data Warehousing: is a memory optimized columnstore index for high speed data querying (relational queries). xVelocity for... Continue Reading →
The first version of Microsoft's Parallel Data Warehouse is out for a while, now I had the chance to get my hands on it during a customer POC. Because PDW is an appliance solution the software is hardware bounded. You... Continue Reading →
Today I found a really nice video how the future of digital information could look like: http://www.microsoft.com/office/vision/ Hopefully we have not to wait too long, it would make our life a lot easier.