Microsoft Business Intelligence and Data Warehousing
Archives: March 2012
Building the Enterprise DW/BI System with SQL Server PDW
Building the Enterprise DW/BI System with SQL Server PDW
Most readers considering a Parallel Data Warehouse already have a data warehouse in place and are looking for ways to help handle growing data and performance demands. Many of these next-generation, large-scale data warehouse/business intelligence systems are evolving from existing DW/BI… Read more
3 comments, 3,861 reads
Posted in Microsoft Business Intelligence and Data Warehousing on 25 March 2012
Columnstore Indexs
Columnstore Indexes for Fast DW
The SQL Server 11.0 release (2012) introduces a new data warehouse query acceleration feature based on a new type of index called the columnstore. This new index, combined with enhanced query optimization and execution features, improves data warehouse query performance by hundreds to thousands of… Read more
0 comments, 3,646 reads
Posted in Microsoft Business Intelligence and Data Warehousing on 15 March 2012
SSAS Tabular Model – Query Modes
One of the most compelling features of the new SSAS Tabular Model is the ability to set the model’s Query Mode to In-memory (aka Vertipaq), DirectQuery or both!
QueryMode can be set to one of the following:
- DirectQuery – This setting specifies all queries to the model should use…
4 comments, 2,692 reads
Posted in Microsoft Business Intelligence and Data Warehousing on 9 March 2012
MDX SSRS Parameter Values
<rant> One of the most frustrating things about working with the Microsoft BI Stack is after you go through all of the hard work of developing an ETL, Relational Data Warehouse and Cube you are confronted with creating MDX SSRS reports. Developing SQL SSRS reports can be frustrating but add… Read more
1 comments, 8,416 reads
Posted in Microsoft Business Intelligence and Data Warehousing on 2 March 2012