|
|
-
|
|
In the multidimensional model in SSAS, there is a storage mode called relational OLAP (ROLAP), which is the multidimensional solution for allowing real-time access to relational data sources. In the tabular model in SSAS, the solution for real-time access...
|
|
-
|
|
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 v...
|
|
-
|
|
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 us...
|
|
-
|
|
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!
...
|
|
-
|
|
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...
|
|
-
|
|
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.
...
|
|
-
|
|
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 o...
|
|
-
|
|
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 arc...
|
|
-
|
|
I have a desktop computer, a laptop, and a iPhone. I frequently add meetings to my Outlook calender on my desktop computer, but sometimes enter them on my laptop. And I frequently use my iPhone to alert me about upcoming meetings. These leads to a major...
|
|
-
|
|
Columnstore indexes are built and processed completely in memory. You will receive an out-of-memory error if you do not have enough memory to build the columnstore index. Column store processing is optimized for in-memory processing, however, they do not...
|
|