My last two articles on SSIS have been related to bugs. That’s not because I am […]
This is Part 2 of the Hybrid Mode in Tabular BI Semantic Model series, where we will learn more about the design tips, a few factors to consider on Hybrid mode implementation and a summarised advantages and limitations of Hybrid Mode.
Package parameter that is to be mapped to an environment variable should be use with caution. Deleting an environment variable that is mapped to a previous deployed version and running the properly mapped parameter of a new version will cause an unexpected error.
Basic walk-through of Hybrid Mode in SSAS Tabular. Tabular databases with Hybrid mode are designed in DirectQuery, but published with either of the two available hybrid Query Modes.
Performing "Process Full" on the Tabular Model database would incorrectly show "Process Recalc" instead via SQL Server Management Studio.
SSISDB.catalog.get_any_parameter_values is an alternative to SSISDB.catalog.get_parameter_values to get all Project and Package parameter values.
Slide deck for Direct Query vs Vertipaq modes in SSAS Tabular Model delivered at PASS DW/BI VC on May 3rd, 2012
A few steps to upgrade SQL Server 2012 RC0 to RTM for Sharepoint 2010
How to undo misconfigured and non-startable Analysis Server Propeties by editing the msmdsrv.ini file
So you've heard SQL Server 2012 release is coming very soon, with its Virtual Launch Event on 7 March 2012. Have you tried SQL Server 2012 RC0 yet?