SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

James Serra's Blog

James is a big data and data warehousing technology specialist at Microsoft. He is a thought leader in the use and application of Big Data technologies, including MPP solutions involving hybrid technologies of relational data, Hadoop, and private and public cloud. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 30 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker, having presented at dozens of PASS events including the PASS Business Analytics conference and the PASS Summit. He is the author of the book “Reporting with Microsoft SQL Server 2012”. He received a Bachelor of Science degree in Computer Engineering from the University of Nevada-Las Vegas.

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, 5,106 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, 2,297 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 http://sqlbits.com/content/Event10.  All are free to watch!

Read more

0 comments, 1,113 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, 12,197 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, 1,035 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, 1,150 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, 20,449 reads

Posted in James Serra's Blog on 4 June 2012