Monthly Archives: March 2014

PASS Summit 2012 session videos online

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 … Continue reading

Posted in PASS, SQLServerPedia Syndication, Videos | Leave a comment

Book: Reporting with Microsoft SQL Server 2012

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 … Continue reading

Posted in Power View/Project Crescent, SQLServerPedia Syndication, SSRS | Leave a comment

SQL Server 2014 released April 1st!

SQL Server 2014 has been released to manufacturers (RTM) and will be generally available April 1.  Here is the official announcement.  Here are my blog posts about some of the new features. More info: SQL Server 2014 RTM Announced for … Continue reading

Posted in SQL Server 2014, SQLServerPedia Syndication | Leave a comment

Parallel Data Warehouse (PDW) benefits made simple

[Note: The Parallel Data Warehouse has been renamed the Analytics Platform System (details)] 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 … Continue reading

Posted in PDW/APS, SQLServerPedia Syndication | 21 Comments

Real-time query access with PDW

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 … Continue reading

Posted in PDW/APS, SQLServerPedia Syndication, SSAS | 4 Comments

Book: Expert Cube Development with SSAS Multidimensional Models

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 … Continue reading

Posted in SQLServerPedia Syndication, SSAS | Leave a comment