Opinions, tips, and news orbiting Microsoft
First published on MSDN on May 28, 2018
After upgrading to SSRS 2016 SP1 CU8, or S… Continue reading Connecting from SSRS 2016 to SSAS using HTTP/MSMDPump and Basic Authentication – “Object reference not set to an instance of an object”
First published on MSDN on May 14, 2018
In this blog, we will be addressing the problem with CDC implementation in SSIS package which goes with the error
‘invalid column name __$command_id’
.
CDC stands f… Continue reading Invalid Column __$command_id issue during CDC implementation in SSIS package
First published on MSDN on Apr 09, 2018
Recently we encountered an issue using a Multidimensional Model where ROLAP and proactive caching were enabled on one of the partition. The notification was set to SQL Server table to track… Continue reading Proactive caching with in-Memory tables as notification
First published on MSDN on Apr 09, 2018
Tested on
: SQL Server Analysis Service 2016 Tabular, Azure Analysis Service.
Hello everyone, I am sure that whenever you wanted to implement Row Level Security(RLS) for An… Continue reading Dynamic RLS support for Analysis Service Tabular Model based on multiple roles for each user
First published on MSDN on Apr 06, 2018
Tested on
: Excel 2013, Excel 2016, Reporting Services 2012/2014/2016.
Hello Everyone, in this blog I will discuss on how to view SSAS translation in different client Appli… Continue reading SSAS translation for client application
First published on MSDN on Apr 05, 2018
Writer: Simon Su
Technical Reviewer: Pam
Lahoud
, Sourabh Agarwal, Tejas Shah
Problem description
One of my customers implemented a ver… Continue reading Lesson learned from an Availability Group performance case
A whole new world is available now in Train Sim World’s latest route add-on! The Northern Trans-Pennine: Manchester – Leeds route unleashes our players on the hills and mountains that make up the backbone of England in a route filled with new challenges and features. The Route The Northern Trans-Pennine route takes on the mountains directly – facing the challenge of running through and over them. This will give you a set of unique challenges as you battle steep gradients to bring passengers home on time. We’ve also set this route in the 1980s and gone to great lengths to… Continue reading Train Sim World: The Northern Trans-Pennine is Available Now on Xbox One
First published on MSDN on Apr 05, 2018
Writer: Simon Su
Technical Reviewer: Pam
Lahoud
, Sourabh Agarwal, Tejas Shah
Scheduling and
Y
ielding
Knowledge R
… Continue reading Troubleshooting SQL Server Scheduling and Yielding