Archives: March 2014
All PASS Summit 2012 recordings are now available for free to all PASS members (201 of them!). To view, log on to your myPASS account, and watch the sessions from myRecordings. While there, check out mine: Building an Effective Data Warehouse Architecture
I am happy to say I have published my first book! It is called Reporting with Microsoft SQL Server 2012 (order). Much thanks goes to my co-author and friend Bill Anton. Below is a brief overview or check out the listing on the Packt Publishing site for… Read more
I have heard people say that the Parallel Data Warehouse (PDW) is Microsoft’s best kept secret. So let me give a 10,000 foot overview on what PDW is and its benefits. Keep in mind the purpose for a PDW is for data warehouses, not OLTP systems.
As opposed to a… Read more
The Parallel Data Warehouse (PDW) officially supports Analysis Services as a data source, both the Multidimensional model (ROLAP and MOLAP modes) and the Tabular model (In-Memory and DirectQuery modes). The big benefit of using ROLAP or DirectQuery is you get real-time query access to the relational data source in PDW… Read more
Those of you who use SQL Server Analysis Services (SSAS) are likely familiar with the “bible” for designing cubes: Expert Cube Development with Microsoft SQL Server 2008 Analysis Services by Marco Russo, Alberto Ferrari , and Chris Webb. Well, a new edition has just been published, with a changed name… Read more