Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

James Serra's Blog

James is currently a Senior Business Intelligence Architect/Developer and has over 20 years of IT experience. James started his career as a software developer, then became a DBA 12 years ago, and for the last five years he has been working extensively with Business Intelligence using the SQL Server BI stack (SSAS, SSRS, and SSIS). James has been at times a permanent employee, consultant, contractor, and owner of his own business. All these experiences along with continuous learning has helped James to develop many successful data warehouse and BI projects. James has earned the MCITP Business Developer 2008, MCITP Database Administrator 2008, and MCITP Database Developer 2008, and has a Bachelor of Science degree in Computer Engineering. His blog is at .

Archives: June 2012

Microsoft Data Quality Services in SQL Server 2012

SQL Server Data Quality Services (DQS) is a knowledge-driven data quality product that is new to SQL Server 2012.  The technology was from Microsoft’s acquisition of Zoomix in 2008.  DQS enables you to build a knowledge base and use it to perform a variety of critical data quality tasks, including… Read more

4 comments, 3,884 reads

Posted in James Serra's Blog on 27 June 2012

How to use a multidimensional cube with Power View

The requirements for Power View state that it can only use tabular models as data sources.  So if you want to use Power View against a multidimensional cube, you are stuck.  But there is a work-around:

Create a PowerPivot for SharePoint workbook that is using a SSAS multidimensional cube as… Read more

0 comments, 1,913 reads

Posted in James Serra's Blog on 25 June 2012

SQLBits X videos online

All the videos for this popular conference are online or will be soon (69 of them). Take a look at the recorded sessions at  All are free to watch!

Read more

0 comments, 794 reads

Posted in James Serra's Blog on 20 June 2012

Tabular query modes: DirectQuery vs In-Memory

When using the Tabular model in SSAS, the deployment options screen offers four choices for “Query Mode”: DirectQuery, DirectQuery with In-Memory, In-Memory, In-Memory with DirectQuery.  Query Mode is used to specify the source from which query results are returned when you deploy the BISM project to the SSAS tabular model… Read more

4 comments, 4,551 reads

Posted in James Serra's Blog on 18 June 2012

TechEd North America 2012 videos online

Microsoft has posted ALL the session videos for TechEd North America 2012 and they are available for free!  What a great way to learn all about SQL Server 2012.  Check them out here.  Also check out the Top 10 Lists for the database track and business intelligence track and… Read more

0 comments, 833 reads

Posted in James Serra's Blog on 15 June 2012

Presenting Tips

Having done a number of presentations, I have accumulated a list of items to go over before each presentation to make sure I am full prepared:

  • Bring my laptop that has my PowerPoint presentation, mouse, powercord
  • Bring a microphone to record the session or if it will be webcast.  A…

Read more

3 comments, 800 reads

Posted in James Serra's Blog on 6 June 2012

Microsoft Master Data Services in SQL Server 2012

Microsoft SQL Server Master Data Services (MDS) is a Master Data Management (MDM) product from Microsoft.  Master Data Services is the rebranding of the Stratature MDM product titled +EDM, which Microsoft acquired in June 2007.  Master Data Services is architecturally similar to +EDM, with increased integration with other Microsoft applications… Read more

7 comments, 17,786 reads

Posted in James Serra's Blog on 4 June 2012