Experiments, tutorials and ideas on developing business intelligence solutions
Hi, Recently an issue attracted my attention where we needed to tame the runaway SQL jobs, where the step in the job to import a file from the FTP source at times would run up to 2 days (which would normally complete in ~2 minutes). Well at times ftp downloads by scripts are affected by Read More …
Hi, Recently in one of our systems, we started experiencing that the cube which were hosted out by the use of MSMDPUMP.DLL, on some occasions responded with failed request during the high load by multiple users. And researching for the same, provided us with the following steps with which we were able to restore the Read More …
Ohhh… Well the above words can only describe the pain which I encountered again on a different combination of multi server components authentication of MSBI using windows authentication. Well the set up, I worked with is as follows: So as it goes, I had a chart on SSRS, which sources the data from the SQL Read More …