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 →
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 →
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!
Continue reading →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 →
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 →
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 →
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 →