July 2010 - Posts

• SSAS Backup and other useful PowerShell scripts

  Today I was looking for a Powershell script to automatize the backup of Analysis Services database also capable to manage retention. In such search I stubled upon the SSASBackp PowerShell script created by Idera which is also released for free. There’s Read More... Posted Friday, July 30, 2010 7:34 PM by Davide Mauri | 5 Comments Filed under: Analysis Services, PowerShell, SSAS, XMLA

• PowerPivot not visibile in Excel

  Yesterday I had to install PowerPivot on my new machine since I would have liked to use it to process some data, but after having succesfully run the installation package, the PowerPivot menu wasn’t visibile in Excel . Looking in the Event Log for errors Read More... Posted Friday, July 30, 2010 10:49 AM by Davide Mauri | 26 Comments Filed under: 2008 R2, PowerPivot

• Viewing how much memory is used by not reused query plan

  One interesting observation that may help developers get convinced that they should parametrize query and that they must check that the ORM they use does it correctly is show how much memory can be wasted by plans that cannot be effectively reused. The Read More... Posted Friday, July 23, 2010 11:48 AM by Davide Mauri | 9 Comments Filed under: Caching, DMV, Scripts, sys2