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

Posted in DQS, SQL Server 2012, SQLServerPedia Syndication | 4 Comments

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

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

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!

Posted in SQLServerPedia Syndication, Videos | Leave a comment

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

Posted in SQLServerPedia Syndication, Tabular | 4 Comments

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

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

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 If the in-person session … Continue reading

Posted in Presentation, SQLServerPedia Syndication | 3 Comments

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

Posted in DQS, MDS/MDM, SQL Server 2012, SQLServerPedia Syndication | 7 Comments